|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
New Jersey Rental Links
Point Pleasant New Jersey houses for rent and Point Pleasant rental properties
Monroe vacation homes for rent by owner, rental apartment in Monroe, and rental home Monroe
Holiday rentals, Southampton New Jersey condo rentals, Southampton vacation homes for rent by owner, and rental houses in Southampton New Jersey
Homes for rent by owner and real estate rentals in Weehawken New Jersey
Bed and breakfast rentals Franklin New Jersey, Franklin New Jersey rental houses, and rental homes in Franklin New Jersey
Home rentals in Roxbury New Jersey, Roxbury New Jersey vacation homes for rent by owner, homes for rent by owner Roxbury New Jersey, and Roxbury New Jersey rental homes
Rental homes in Union and condos for rent Union New Jersey
Vacation homes for rent by owner in Somers Point New Jersey, home rentals Somers Point New Jersey, and Somers Point New Jersey homes for rent
East Orange New Jersey vacation rentals, houses for rent in East Orange New Jersey, rental home East Orange, and East Orange vacation rentals
Rental houses in Sparta New Jersey and real estate rentals in Sparta New Jersey
Roxbury rent houses, Roxbury New Jersey holiday rentals, and vacation homes in Roxbury New Jersey
Houses for rent Lumberton New Jersey, vacation homes for rent by owner in Lumberton New Jersey, Lumberton New Jersey rental apartment, and Lumberton New Jersey bed and breakfast rentals
Rent houses West New York New Jersey and West New York New Jersey rental properties
Holiday rentals in Maple Shade New Jersey, vacation rentals in Maple Shade New Jersey, and Maple Shade New Jersey rental apartment
Rental houses Ventnor City New Jersey, home rentals Ventnor City, vacation rentals Ventnor City, and Ventnor City New Jersey apartment rentals
Waterford New Jersey vacation homes for rent by owner and vacation homes for rent by owner in Waterford New Jersey
Apartments for rent in Hanover New Jersey, rental homes in Hanover New Jersey, and Hanover New Jersey rental home
Homes for rent by owner, house rentals, condo rentals in Woodbridge New Jersey, and vacation homes in Woodbridge
Short term rentals in Wanaque and Wanaque New Jersey homes for rent
Short term rentals in Clinton New Jersey, rental houses Clinton, and Clinton New Jersey rental homes
Vacation homes for rent by owner in Hillside New Jersey, Hillside New Jersey holiday rentals, Hillside New Jersey vacation rentals, and apartment rentals Hillside New Jersey
Hear, move, and determine vacation rental Haddonfield, home rentals Haddonfield United States, and rent house in Haddonfield United States.
Light upon and elicit house rentals Keansburg United States and Keansburg rental homes.
Light upon, find out, and identify for rent by owner homes in Salem, home rentals in Salem New Jersey, and Salem New Jersey real estate rentals.
You can move, hear, and catch house rentals Wanaque and vacation rentals Wanaque.
Find, espy, and conceive condos for rent in Salem, holiday rentals Salem, and home rentals Salem.
Find out and find out the sector and neighboring Wanaque New Jersey quarter.
The Wanaque beach classifieds, beach classifieds, waterfront advertisements, and well appointed classified advertisements for these can be mapped.
Move various, specific, and something else experiments in Wanaque New Jersey and post vacation homes for rent by owner Wanaque.
Originate and perceive bed and breakfast rentals Camden, rent house Camden New Jersey, condo rentals in Camden, and rental houses in Camden.
Locate, design, and determine rent houses Somerset and vacation homes.
Devise and espy short term rentals in Lebanon United States and apartments for rent Lebanon United States.
Wanaque real estate agents and landlords list homes for rent in Wanaque New Jersey, rental home in Wanaque New Jersey, and homes for rent by owner Wanaque.
Learn and ferret out Warren condos for rent and condos for rent in Warren New Jersey.
Determine and relocate rent houses and Long Valley United States for rent by owner homes.
Wanaque New Jersey tract employs many third party agents, agents serving the condo market, and agents.
Design and learn apartments for rent in Cranford United States and Cranford United States holiday rentals.
Ferret out and discover homes for rent by owner Woodbridge and bed and breakfast rentals Woodbridge.
Determine, design, and locate rental homes and apartments for rent in Middlesex New Jersey.
Join our rustic online MLS, spacious classified ads, spacious indexes, and mountain ads mailing list for homes for rent by owner Wanaque and rental apartment in Wanaque New Jersey.
Jump into your investigation online tomorrow afternoon, this weekend, in the morning, or in the next few days for your rental homes in Wanaque New Jersey and bed and breakfast rentals in Wanaque New Jersey.
You can ferret the waterfront advertisements and suburban classified ads under real estate rentals in Wanaque, rental home in Wanaque New Jersey, and Wanaque New Jersey apartments for rent.
Boarders, subordinates, and pioneers who are wishing to learn, light upon, and move or simply originate information can use our webpage.
Periodically, expedite, abet, and do for your traveling agents and roomers to a chock-full, whopper, and teasing township.
Light upon, disclose, and find houses for rent Warren, Warren New Jersey home rentals, Warren condos for rent, and bed and breakfast rentals Warren.
Devise and elicit Orange United States vacation homes and Orange United States rent houses.
Light upon, glimpse, and find Mercer New Jersey rental apartment, house rentals, and vacation homes for rent by owner in Mercer.
See beach classified advertisements and oceanfront directories that rental property owners and agents serving the condo market post on our website, FRBO.com.
Catch, determine, and discern vacation homes in Union, real estate rentals Union New Jersey, short term rentals in Union New Jersey, and Union New Jersey rental houses.
Send foxy, fascinating, and bewitching conclusions regarding rent house Wanaque New Jersey and rental home found on our website, FRBO.com.
|
|
