|
<%@ 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
Apartment rentals Long Branch and home rentals in Long Branch New Jersey
Homes for rent in Union, Union New Jersey bed and breakfast rentals, and condo rentals
Rental properties in Hackettstown New Jersey, rental houses in Hackettstown, Hackettstown New Jersey short term rentals, and rental properties in Hackettstown New Jersey
For rent by owner homes and for rent by owner homes in Teaneck
Millburn New Jersey apartment rentals, Millburn homes for rent, and homes for rent by owner in Millburn New Jersey
Short term rentals in Hamilton New Jersey, rent houses Hamilton New Jersey, home rentals, and bed and breakfast rentals Hamilton New Jersey
Bed and breakfast rentals Colts Neck New Jersey and bed and breakfast rentals in Colts Neck
Holiday rentals in Atlantic City New Jersey, Atlantic City bed and breakfast rentals, and vacation rentals Atlantic City
Vacation rentals Beachwood New Jersey, Beachwood New Jersey rental houses, house rentals Beachwood New Jersey, and rental properties
Rental apartment Galloway New Jersey and Galloway New Jersey vacation rentals
For rent by owner homes Plainsboro New Jersey, rental houses, and holiday rentals in Plainsboro New Jersey
Real estate rentals South Brunswick, apartment rentals in South Brunswick, apartment rentals in South Brunswick New Jersey, and rental houses in South Brunswick New Jersey
Apartments for rent Chatham New Jersey and vacation rentals Chatham New Jersey
Houses for rent, Stafford New Jersey rent house, and short term rentals Stafford
Rent house in Jefferson, condos for rent in Jefferson, rent houses Jefferson New Jersey, and vacation homes for rent by owner in Jefferson New Jersey
Middletown New Jersey houses for rent and vacation homes
North Brunswick New Jersey rental home, rental properties in North Brunswick New Jersey, and rent house in North Brunswick New Jersey
Apartments for rent in Washington, Washington rental home, Washington New Jersey condos for rent, and home rentals in Washington New Jersey
Gloucester real estate rentals and apartment rentals Gloucester New Jersey
Saddle Brook rental properties, rental properties, and Saddle Brook New Jersey homes for rent
Find out and dig up Atlantic New Jersey rent houses, Atlantic rental homes, vacation homes Atlantic New Jersey, and Atlantic holiday rentals.
Pilgrims and professors who are scouting Fair Lawn New Jersey condos for rent and are trying to conceive Fair Lawn New Jersey condos for rent and rental homes Fair Lawn can root this webpage and our oceanfront classifieds, hillside classified ads, and waterfront ad directories.
Lakefront listed properties and convenient online MLS Hunterdon New Jersey house rentals, houses for rent in Hunterdon New Jersey, Hunterdon New Jersey condos for rent, and rent houses in Hunterdon New Jersey.
The Fair Lawn ad directories posted and tabulated on our site, FRBO.com hold waterfront timeshare and lakefront villa.
Look up individual, discrete, and particular abstracts in Fair Lawn and particularize rental apartment in Fair Lawn New Jersey.
Detect, elicit, and distinguish Somerset New Jersey homes for rent by owner, rental properties, and Somerset New Jersey house rentals.
Observe, catch, and distinguish Union New Jersey holiday rentals, bed and breakfast rentals in Union New Jersey, bed and breakfast rentals in Union, and apartment rentals.
Voyagers and professors scrutinize, scan, and root FRBO.com and locate resort flat and city condominium.
Uncover, light upon, and determine rent house in Mercer and Mercer New Jersey homes for rent.
Learn, explore, and catch Dividing Creek homes for rent, real estate rentals in Dividing Creek United States, and house rentals Dividing Creek.
Espy and disclose rental homes in Burlington New Jersey and Burlington New Jersey vacation homes.
Send refined, well-formed, and classy statistics regarding vacation homes Fair Lawn New Jersey, Fair Lawn New Jersey houses for rent, and bed and breakfast rentals in Fair Lawn New Jersey found on our webpage.
Elicit and perceive Wildwood home rentals and vacation homes in Wildwood United States.
Disclose, debunk, and ferret out rental homes Strathmere United States, Strathmere rent houses, and Strathmere United States home rentals.
Come upon, catch, and find out Somerset New Jersey rental houses, Somerset New Jersey real estate rentals, Somerset New Jersey rent houses, and condos for rent in Somerset.
Light upon and detect Ocean Grove United States vacation homes for rent by owner and rental home in Ocean Grove United States.
Notice and hear rent house Glendora and condos for rent in Glendora.
Join our oceanfront classified advertisements and resort classified ads mailing list for Fair Lawn New Jersey rental home, rent houses Fair Lawn New Jersey, and home rentals in Fair Lawn New Jersey.
Relocate, distinguish, and catch rent house in Middleville United States, rental homes in Middleville, and Middleville for rent by owner homes.
Relocate and relocate rental properties in Cumberland New Jersey and Cumberland New Jersey bed and breakfast rentals.
Catch, hear, and relocate Allenhurst for rent by owner homes, Allenhurst United States rental homes, and holiday rentals in Allenhurst United States.
Determine, notice, and ferret out for rent by owner homes in Brookside United States, rent houses, and Brookside houses for rent.
Perceive and light upon rental homes Essex, Essex real estate rentals, and home rentals.
Detect and glimpse Mantua short term rentals and vacation rentals in Mantua United States.
Devise, glimpse, and come upon real estate rentals, for rent by owner homes, and condos for rent in Rio Grande United States.
Pre-rented suburban bungalow and waterfront castle are adjoining in the abutting plot of Fair Lawn New Jersey.
Notice, uncover, and find rental home Belle Mead United States, Belle Mead rental apartment, and for rent by owner homes Belle Mead United States.
See hidden classified advertisements, secluded ad directories, and waterfront advertisements that rental property owners and home owners post on For Rent By Owner.
You can relocate, design, and design vacation rental in Fair Lawn New Jersey, rent house, and Fair Lawn homes for rent by owner.
Come across, recognize, and distinguish apartments for rent, houses for rent, and bed and breakfast rentals in Bergenfield United States.
Determine, determine, and glimpse Sussex New Jersey condos for rent and vacation homes for rent by owner in Sussex.
Explore and observe apartments for rent Keasbey and bed and breakfast rentals in Keasbey United States.
Look up and disclose rent houses and Maywood United States apartment rentals.
Observe, design, and look up Essex New Jersey rental homes, rental houses in Essex, and homes for rent in Essex New Jersey.
Mobilize, call up, and inscribe in the morning to begin, open, get cracking, and get going on this vagabondage.
Using our online website, FRBO.com, condo owners specialize chalet, home, and castle ads.
This site, FRBO.com does embrace atypical field lakeside, exclusive, well appointed, and romantic house and cabins.
Relocate and look up apartments for rent Monmouth, rental homes in Monmouth New Jersey, and Monmouth apartment rentals.
Disclose and identify Vincentown United States rental home and apartment rentals Vincentown United States.
|
|
