<%@LANGUAGE="VBSCRIPT"%> <% Dim Recordset1__MMColParam Recordset1__MMColParam = "1" If (Request.QueryString("form1") <> "") Then Recordset1__MMColParam = Request.QueryString("form1") End If %> <% Dim Recordset1 Dim Recordset1_numRows 'Response.write MM_mmh03_STRING & "<<<" Set Recordset1 = Server.CreateObject("ADODB.Recordset") Recordset1.ActiveConnection = MM_mmh03_STRING Recordset1.Source = "SELECT * FROM Table1 WHERE Listing = '" + Replace(Recordset1__MMColParam, "'", "''") + "'" Recordset1.CursorType = 0 Recordset1.CursorLocation = 2 Recordset1.LockType = 1 Recordset1.Open() Recordset1_numRows = 0 %> main
Home Search
  1
Property #
<%=(Recordset1.Fields.Item("Listing").Value)%>
<% If Not Recordset1.Eof Then Response.write "
" If Len(Recordset1.Fields.Item("Picture").Value) > 0 Then %> " width="270" height="219" align="right"> <% Else Response.write "
No Image Available.

" End If Response.write "
" %>
Property # :  
Asking Price
<%=(Recordset1.Fields.Item("Asking_Price").Value)%>
Family
<%=(Recordset1.Fields.Item("Family").Value)%>
State / City:  
Style
<%=(Recordset1.Fields.Item("Style").Value)%>
Buyer Section
Bedrooms
<%=(Recordset1.Fields.Item("Bedrooms").Value)%>
Bathrooms
<%=(Recordset1.Fields.Item("Bathrooms").Value)%>
 
Kitchen
<%=(Recordset1.Fields.Item("Kitchens").Value)%>
Basement
<%=(Recordset1.Fields.Item("Basement").Value)%>
Garage
<%=(Recordset1.Fields.Item("Garage").Value)%>
Taxes
<%=(Recordset1.Fields.Item("Taxes").Value)%>
Lot Size
<%=(Recordset1.Fields.Item("Lot_Size").Value)%>
Seller Section
Town
<%=(Recordset1.Fields.Item("Town").Value)%>
 
State
<%=(Recordset1.Fields.Item("State").Value)%>
Contact Person
<%=(Recordset1.Fields.Item("Contact_Person").Value)%>
 <%=(Recordset1.Fields.Item("Email").Value)%>
Description
Call Today:
 <%=(Recordset1.Fields.Item("Phone_Number").Value)%>
<%=(Recordset1.Fields.Item("Description").Value)%>
<% Else %>

Listing "<%=Replace(Recordset1__MMColParam, "'", "''")%>" not found.

<% End IF %>

 
Home : Buying : Selling : Home Search : Mortgage : Contact Us
Marketing Your Home Realty © 2004 • Privacy Policy • Terms Of Use
<% Recordset1.Close() Set Recordset1 = Nothing %>