<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit. FP_CharSet = "windows-1252" FP_CodePage = 1252 %>


 

 

Organized by Price/Brand/Age.  Price Range $10,001-$15,000
(Scroll down to see results)
Back to Index

 
 
Brand " size="20">

(Enter a brand name if you want to refine the search)

<% fp_sQry="SELECT * FROM Testofquery WHERE (SoldCalc <> 'SOLD' AND SalesPrice > 10000 AND SalesPrice < 15001 AND Brand LIKE '%::Brand::%') ORDER BY SalesPrice ASC,Brand ASC,Age DESC,Type DESC" fp_sDefault="Brand=" fp_sNoRecords="" fp_sDataConn="pfdbtest9" fp_iMaxRecords=0 fp_iCommandType=1 fp_iPageSize=10 fp_fTableFormat=True fp_fMenuFormat=False fp_sMenuChoice="ID" fp_sMenuValue="ID" fp_iDisplayCols=9 fp_fCustomQuery=False BOTID=0 fp_iRegion=BOTID %>
ID Sales Price Brand Age Feet Inches
No records returned.
"> <%=FP_FieldVal(fp_rs,"ID")%> <%=FP_FieldVal(fp_rs,"SalesPrice")%> <%=FP_FieldVal(fp_rs,"Brand")%> <%=FP_FieldVal(fp_rs,"Age")%> <%=FP_FieldVal(fp_rs,"Feet")%> <%=FP_FieldVal(fp_rs,"Inches")%>

The directional arrows above take you take you forward and backwards through the list, 10 pianos at a time.  The number next to the arrows (i.e. [1/5] ) tells you the following:  the first number is the page you are on, the second number tells you how many pages are in this particular listing. If you wish more details on a piano, click on the ID number.  It will be highlighted if there is more info available.

<% fp_sQry="SELECT * FROM DateLastUpdate" fp_sDefault="" fp_sNoRecords="No records returned." fp_sDataConn="pfdbtest9" fp_iMaxRecords=256 fp_iCommandType=1 fp_iPageSize=0 fp_fTableFormat=False fp_fMenuFormat=False fp_sMenuChoice="" fp_sMenuValue="" fp_iDisplayCols=5 fp_fCustomQuery=False BOTID=1 fp_iRegion=BOTID %>

Date of last update: <%=FP_FieldVal(fp_rs,"DateLastUpdate")%>
Time of last update: <%=FP_FieldVal(fp_rs,"TimeLastUpdate")%> Pacific Standard Time
Number of pianos sold: <%=FP_FieldVal(fp_rs,"PianosSold")%> since list began on 11-30-99.  
Number of pianos added: <%=FP_FieldVal(fp_rs,"PianosAdded")%> since last update
Total pianos: <%=FP_FieldVal(fp_rs,"Totalpianos")%> pianos listed in the entire Piano Finders database

 
   

BBBOnLine 
Privacy Seal

 

 

Privacy Policy

 

Building Trust in Transactions (tm)

 

Copyright 1998 to 2004 Piano Finders.   All Rights Reserved.  Use of this Web site constitutes 
acceptance of the
 Piano Finders Member Agreement and Privacy Policy