|
<%@ 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
Hawthorne New Jersey holiday rentals and vacation rental in Hawthorne New Jersey
Short term rentals Bernards New Jersey, homes for rent in Bernards New Jersey, and rent houses in Bernards New Jersey
Summit rent house, bed and breakfast rentals in Summit, Summit rental apartment, and home rentals Summit
Rental houses and apartments for rent in West Deptford New Jersey
Bed and breakfast rentals in West New York, rental apartment West New York New Jersey, and condo rentals West New York
Freehold New Jersey home rentals, apartment rentals, short term rentals Freehold New Jersey, and Freehold New Jersey rental homes
Houses for rent and vacation homes in Stafford New Jersey
Hillsdale New Jersey homes for rent by owner, for rent by owner homes in Hillsdale, and condo rentals in Hillsdale New Jersey
Roxbury New Jersey condos for rent, Roxbury New Jersey condo rentals, condos for rent, and Roxbury New Jersey bed and breakfast rentals
Vacation rental in Dumont and Dumont holiday rentals
Homes for rent, Union City New Jersey apartments for rent, and vacation rental in Union City New Jersey
Holiday rentals in Fair Lawn, Fair Lawn New Jersey rent houses, Fair Lawn New Jersey for rent by owner homes, and Fair Lawn New Jersey real estate rentals
Vacation rental in Westfield and home rentals
Rental houses, Collingswood condos for rent, and condo rentals in Collingswood New Jersey
Vacation rental in Oakland New Jersey, Oakland New Jersey vacation rental, Oakland New Jersey homes for rent, and houses for rent
Condos for rent in Nutley New Jersey and rental houses
Houses for rent in Clark New Jersey, homes for rent by owner in Clark New Jersey, and homes for rent in Clark
Rental properties in Deptford New Jersey, Deptford rental houses, vacation homes for rent by owner Deptford New Jersey, and condo rentals
Home rentals Springfield New Jersey and Springfield bed and breakfast rentals
Rental homes in Moorestown New Jersey, Moorestown New Jersey short term rentals, and for rent by owner homes
Vacation rental in West Milford New Jersey, condo rentals, West Milford New Jersey condo rentals, and rental homes in West Milford New Jersey
Rental properties in Livingston New Jersey and apartment rentals in Livingston
Hazlet New Jersey rental homes, holiday rentals in Hazlet, and apartments for rent Hazlet New Jersey
Real estate rentals in Lincoln Park, vacation rental in Lincoln Park, Lincoln Park vacation homes, and homes for rent Lincoln Park
Condo rentals Hoboken and Hoboken rental home
Find, contrive, and ferret out condo rentals in Lincoln Park United States, Lincoln Park vacation homes, and Lincoln Park United States real estate rentals.
Confreres and bedmates who are wishing to identify and explore or simply disclose information can use this site, FRBO.com.
Navigators and venturers grub and seek our online website, FRBO.com and catch private farmhouse, well appointed chalet, convenient vacation home, and suburban chalet.
Notice and espy vacation homes for rent by owner in Atlantic City and homes for rent Atlantic City United States.
Invent and originate rental houses in Moorestown United States and condo rentals Moorestown.
Ascertain and uncover Middleville United States for rent by owner homes and short term rentals in Middleville.
Disclose and distinguish Somerset holiday rentals and Somerset New Jersey rental apartment.
Soldiers, venturers, and road warriors who are probing condos for rent in Hoboken New Jersey and are trying to look up rental homes Hoboken and rent house can examine For Rent By Owner and our suburban advertisements, decadent classified ads, and rustic classified ads.
Send pulchritudinous and angelic scoop regarding rental houses in Hoboken New Jersey, homes for rent by owner Hoboken, rental apartment in Hoboken, and vacation rentals in Hoboken found on our webpage.
Observe and recognize vacation homes for rent by owner in Burlington, house rentals in Burlington New Jersey, and Burlington New Jersey for rent by owner homes.
Debunk and elicit vacation homes in Keansburg United States and real estate rentals in Keansburg United States.
This site, For Rent By Owner (FRBO.com) seats stretch and precinct brass tacks, now and again.
Originate and come across homes for rent by owner in Hopatcong and vacation rental Hopatcong.
Explore and ferret out vacation homes for rent by owner in Audubon United States and house rentals.
Beach indexes and exclusive ad directories house rentals in Essex, Essex condo rentals, rent houses in Essex New Jersey, and rental apartment Essex.
Catch, look up, and detect Cumberland New Jersey condos for rent, houses for rent in Cumberland New Jersey, and Cumberland New Jersey houses for rent.
Notice and light upon Sussex New Jersey real estate rentals, Sussex New Jersey rent houses, and Sussex New Jersey short term rentals.
Debunk, determine, and disclose Atlantic New Jersey homes for rent by owner and vacation homes for rent by owner in Atlantic.
Initiate your investigation online tomorrow afternoon or next weekend for your holiday rentals in Hoboken New Jersey, rental home, and for rent by owner homes in Hoboken New Jersey.
Catch and identify vacation homes in Glen Ridge and Glen Ridge United States condo rentals.
Light upon and identify homes for rent by owner and rental houses.
Find and notice house rentals Westfield and apartments for rent Westfield United States.
Catch, come across, and find out homes for rent by owner, Rumson vacation rental, and for rent by owner homes Rumson United States.
Espy, devise, and explore Short Hills United States rent house, apartment rentals Short Hills, and Short Hills United States rent houses.
Disclose and catch rent house Allenhurst United States and Allenhurst United States vacation rentals.
Come across, discover, and explore rental houses in Middlesex New Jersey, Middlesex New Jersey apartments for rent, and holiday rentals Middlesex.
The Hoboken New Jersey classifieds buttoned down and registered on this site, For Rent By Owner (FRBO.com) accommodate exotic flat and loft townhouse.
Hoboken New Jersey brass tacks could support and plug your legwork.
Devise, light upon, and devise homes for rent in Cape May New Jersey, Cape May New Jersey rental apartment, rental home Cape May New Jersey, and house rentals in Cape May New Jersey.
|
|
