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


Organized by Price/Brand/Age.  All Prices.
(Please Scroll Down to see results)

Back to Index


Brand " size="20">  
(Enter a brand if you want to refine the search
  For custom order options on pre-owned Kawai and Yamaha Grands, click on photo to the left.   For custom order vintage pianos click on photo to right.

For private party and dealer pianos listed for sale on our site, scroll down to see pianos listed. To refine search: enter brand above, click on "submit" and scroll down.
<% if 0 then %> <% end if %> <% fp_sQry="SELECT * FROM Testofquery WHERE (SoldCalc <> 'SOLD' 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=20 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.

<% if 0 then %> <% end if %> <% 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




Privacy Seal


 Privacy Policy

Building Trust in Transactions (tm)

Copyright 1999, 2001, 2004 Karen E. Lile.  All Rights Reserved.  Use of this Web site constitutes 
acceptance of the
 Piano Finders Member Agreement and Privacy Policy