Condo Listings

<% ' Dim the Recordset Object Dim rsADO ' Define the Connection String From Above ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=;Password=;Data Source=" & server.mappath("/fpdb/FRDATA.mdb") ' Create the Object Set rsADO = Server.CreateObject("ADODB.Recordset") ' Define the SQL Statement ' (REPLACE TABLENAME WITH THE TABLE NAME ' IN YOUR DATABASE) source = "SELECT * FROM Listings WHERE type='condo' and status<>'expired' ORDER BY Status, Price" ' Open the Recordset rsADO.Open Source, ConnectionString Dim mlsImage Set mlsImage = rsADO("Image") 'Dim PriceCurr 'PriceCurr = (rsADO("Price")) 'curResult = FormatCurrency(PriceCurr,0) ' Display the Fields Returned ' (PUT YOUR FIELD NAMES WHERE FieldName1 and ' FieldName2 Appear) Do while(not rsADO.EOF) Response.Write ("") Response.Write ("") Response.Write("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("
") Response.Write ("MLS# ") Response.Write rsADO("MLS") Response.Write ("Status: ") Response.Write rsADO("status") Response.Write ("
For Lease? ") Response.Write rsADO("rental") Response.Write ("
Price: ") Response.Write rsADO("Price") Response.Write ("Address: 
") Response.Write rsADO ("Street") Response.Write ("
") Response.Write rsADO("Lot") Response.Write ("
") Response.Write ("") Response.Write ("
Beds: ") Response.Write rsADO("Beds") Response.Write (" / Baths: ") Response.Write rsADO("Bath") Response.Write ("City: ") Response.Write rsADO("City") Response.Write ("
Sq Ft: ") Response.Write rsADO("SqFt") Response.Write ("Subdivision: ") Response.Write rsADO("Subdivision") Response.Write ("
Description:
") Response.Write rsADO("ShortDesc") Response.Write ("
") Response.write ("More Details") ' Response.write ("More Details") Response.Write ("
Agent:  ") Response.Write rsADO("Agent") Response.Write ("
") rsADO.MoveNext Loop ' DeAllocate the Object to Free Server Memory set rsADO = nothing %>
Franklin REALTORS • 135 Southeast Parkway Court • Franklin, TN 37064 • Phone (615) 794-1177 • Fax (615) 790-1350


homeabout usour historyour teamcondoshomesland and lotscommercialsearch mls
to our buyersfinancial calculatorrelocationarea linksselling your homeour marketing plan
preparing your housecontact usthe club at pleasant creekback to top

 

 

©Copyright Franklin REALTORS, Inc. 2007. All rights reserved.
REALTOR is a trademark of the National Association of REALTORS®.
For technical questions concerning this web site, please contact webmaster@franklinrealtors.com