 |
|
 |
|
|
|
 |
 Find a house easily with the world’s largest database of homes for sale.
|
|
 |
Learn about the home buying process with our informative Home Buyer Toolbox.
|
|
|
Sign up to be automatically notified by e-mail the moment a property matching your needs is listed.
|
|
 |
See how Realty Works can sell your home quickly and at the maximum market price.
|
|
<% set rs = conn.execute("select * from listings where showable='y' and active='y' order by firstdate desc")
sql = "select * from pictures where houseID = " & rs("id") & " order by [default] desc"
set rspic = server.createobject("adodb.recordset")
rspic.open sql,conn,3
if not rsPic.eof then %>
![](pix/houseImages/<%= replace(rsPic("picLocation"),".jpg","") %>md.jpg)
|
|
<% else %>
<% end if %>
<%= rs("city") %>, <%= rs("state") %>
<%= formatcurrency(rs("price"),0) %>
<%= rs("description") %>
<% if rspic.recordcount > 1 then %>
&image=<%= rsPic("id") %>' ,'slide',300,340)"> &image=<%= rsPic("id") %>' ,'slide',300,340)" class=body>Click here to view slide show.
<% end if %>
|
|
|
|
|
|
|
