<% Dim Connect, Data SET objConn = Server.CreateObject("ADODB.Connection") ' You must use this type of connection string to make it work. objConn.connectionstring="DRIVER={MySQL ODBC 3.51 Driver};" & _ "SERVER=mysql89.secureserver.net;" & _ "DATABASE=ruthvela;" & _ "DSN=mysql_ruthvela.dsn;" &_ "User Id=ruthvela;" & _ "Password=ruthvela;" objConn.open %> <% find_case = request("OPTION") house_type_id = request("house_type_id") per_page = request("PER_PAGE") if len(per_page) > 0 then set_rowcount = " LIMIT " & per_page end if if len(house_type_id) > 0 then and_sql = " WHERE house_type_id = " & house_type_id end if if find_case = "HPRICE" then and_sql = " Order by price desc" end if if find_case = "LPRICE" then and_sql = " Order by price asc " end if if find_case = "AREA" then and_sql = " Order by area desc " end if if find_case = "CITY" then and_sql = " Order by city desc " end if if find_case = "BEDS" then and_sql = " Order by bedrooms desc " end if if find_case = "BATHS" then and_sql = " Order by baths desc " end if if find_case = "SFEET" then and_sql = " Order by feet desc " end if Set objrst = Server.CreateObject("ADODB.Recordset") SQL = " SELECT * FROM listing " & and_sql & set_rowcount 'response.write SQL 'response.end objrst.Open SQL, objConn, adOpenStatic, adLockPessimistic, adCmdText if len(da_count) = 0 then da_count = objrst.recordcount end if %> Ruth Vela: Austin Realtor: Ruth Vela Current Listings

Ruth E. Vela

MBA, ABR, REALTOR

Your Key to Austin Real Estate

512.476.1591 (office) * 512.964.3434 (mobile)
1701 West Koenig Lane * Austin, Texas 78756
rvrealtor (at) earthlink (dot) net

Ruth E. Vela Logo

Available Homes Listed with Ruth E. Vela

 

 Property Type:
<% Set objrst1 = Server.CreateObject("ADODB.Recordset") SQL1 = "SELECT * FROM house_type" 'response.write SQL 'response.end objrst1.Open SQL1, objConn, adOpenforwardonly, adLockPessimistic, adCmdText %>     

Listings Per Page:     5   |  10  |  20  |  50
Shortcut: View all Open Houses

Sort By: 
Highest Price  |  Lowest Price  |  Area  |  City/State  |  Beds  |  Baths  |  Square Feet
<% Do while not objrst.EOF %> <% end if %> <% objrst.movenext Loop%>
    Description   Location   Price

<% if len(objrst("listing_photo_path")) > 0 then %> ','','height=500,width=325,menubar=0,resizable=1,scrollbars=0,status=0,titlebar=0,toolbar=0');">< <%=objrst(" border="0" src="http://www.ruthvela.com/admin/<%=objrst("listing_photo_path")%>" width="125" height="108">

  <%=objrst("title")%> 
<% Shorten = Left(objrst("description"),75) %>

<%=Shorten%>....
">[Read More]

  <% if len(objrst("bedrooms")) > 0 then %> <%=objrst("bedrooms")%> Bedrooms
<% end if %> <% if len(objrst("baths")) > 0 then %> <%=objrst("baths")%> Baths
<% end if %> <% if len(objrst("feet")) > 0 then %> <%=objrst("feet")%> Sq. Ft.
<% end if %>
<% if len(objrst("address")) > 0 then %> <%=objrst("address")%>
<% end if %> <% if len(objrst("city")) > 0 then %> <%=objrst("city")%>,<%=objrst("state")%> <%=objrst("zip")%> <% end if %> 		 

<%=FormatCurrency(objrst("price"), 2)%>

Relocating to Austin?

Visit our relocation center where you'll find a wealth of information to help make your move to Austin a snap.

Industry Links

We've compiled a list of recommended Title companies and mortgage brokers in Austin.

Home Search

Start your dream home search. For more advanced searching, please visit our search homes page.

 


Presidio Group