Register Online
Download Applications
Home
Find A Rental
How It Works
List Your Rental
Our Areas
SIGN UP!
Rental Listings
<%If request("Search") = 1 Then%>
Town
Price
BR
BA
Type
Pets
Utilities
Lease
<% Set objConn = Server.CreateObject("ADODB.Connection") objConn.ConnectionString = "DRIVER={SQL Server};Server=mssql.plesklogin.net;UID=gcoluni;PWD=mohegan01;DATABASE=Rentals" Dim max, marker If request("max_price") = 0 Then max = "20000" End If objConn.Open Set rs = Server.CreateObject("ADODB.Recordset") SQL = "exec getRentals '" & request("area") & "','" & request("min_price") & "','" & max & "','" & request("bedrooms") & "','" & request("pets") & "'" rs.open SQL, objConn If rs.EOF Then %>
Sorry No Matching Rentals
<% Else marker = "0" While Not rs.EOF If marker = "0" Then %>
<%response.write(rs("Town"))%>
<%response.write(rs("Price"))%>
<%response.write(rs("BR"))%>
<%response.write(rs("BA"))%>
<%response.write(rs("Type"))%>
<%response.write(rs("Pets"))%>
<%response.write(rs("Utilities"))%>
<%response.write(rs("Lease"))%>
<%response.write(rs("Misc"))%>
<%response.write(rs("Comments"))%>
<% marker = "1" Else %>
<%response.write(rs("Town"))%>
<%response.write(rs("Price"))%>
<%response.write(rs("BR"))%>
<%response.write(rs("BA"))%>
<%response.write(rs("Type"))%>
<%response.write(rs("Pets"))%>
<%response.write(rs("Utilities"))%>
<%response.write(rs("Lease"))%>
<%response.write(rs("Misc"))%>
<%response.write(rs("Comments"))%>
<% marker = "0" End If rs.MoveNext Wend End If %>
<%Else%>
Property Search
Area:
ALL
Monmouth County
Ocean County
Price:
to
Bedrooms:
ALL
Studio
1 Bedroom
2 Bedrooms
3 Bedrooms
4 Bedrooms
5 Bedrooms
6+ Bedrooms
Pets:
ALL
Negotiable
No Dogs
No Pets
Pets Ok
<%End If%>
Sell My Property
|
Employment Opportunities
|
Contact Us
©2005 The Rental Network INC.®