Below are some very special properties currently available in Central Oregon. For more information, contact
Mary Gillen. You may also search for listings that meet your specific needs.
<%
sql = "Select * From Listings Order by PropertyType, Price Desc;"
Set rsLst = MGI.Execute(sql)
While Not rsLst.EOF
ID = rsLst("ID")
MLS = rsLst("MLS")
Title = rsLst("Title")
LongDescription = rsLst("LongDescription")
City = rsLst("City")
State = rsLst("State")
SqFeet = rsLst("SqFeet")
LotSize = rsLst("LotSize")
Price = rsLst("Price")
Photo = rsLst("Photo")
sqla = "Select Description From PropertyType Where ID = " & rsLst("PropertyType")
Set rsLsta = MGI.Execute(sqla)
If Not rsLsta.EOF Then PropertyType = rsLsta("Description") Else PropertyType = ""
sqlc = "Select Description From Bedrooms Where ID = " & rsLst("Bedrooms")
Set rsLstc = MGI.Execute(sqlc)
If Not rsLstc.EOF Then Bedrooms = rsLstc("Description") Else Bedrooms = ""
sqld = "Select Description From Bathrooms Where ID = " & rsLst("Bathrooms")
Set rsLstd = MGI.Execute(sqld)
If Not rsLstd.EOF Then Bathrooms = rsLstd("Description") Else Bathrooms = ""
%>
<%If Photo > 0 Then %>
Photo Gallery
<%Else%>
<%End If%>
|
<%=Title%> |
<%=FormatCurrency(Price,0)%> |
<%=City%>, <%=State%> |
<%=LongDescription%> |
|
| Property type: |
<%=PropertyType%> |
Bedrooms: |
<%=Bedrooms%> |
| Acreage/lot size: |
<%=LotSize%> |
Bathrooms: |
<%=Bathrooms%> |
| Square feet: |
<%=FormatNumber(SqFeet,0)%> |
MLS #: |
<%=MLS%> |
|
<%
rsLst.MoveNext
Wend
rsLst.Close
SET rsLst = nothing
%>
