|
<%@ 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
Rental homes Saddle Brook New Jersey and Saddle Brook New Jersey apartment rentals
Apartments for rent in Ewing, rental properties Ewing New Jersey, and for rent by owner homes Ewing New Jersey
Egg Harbor house rentals, homes for rent by owner, for rent by owner homes Egg Harbor New Jersey, and condo rentals Egg Harbor
Wayne condos for rent and Wayne New Jersey vacation rentals
Randolph New Jersey homes for rent, apartments for rent Randolph, and vacation homes for rent by owner in Randolph New Jersey
Holiday rentals Kearny, vacation rental in Kearny New Jersey, Kearny New Jersey vacation homes, and Kearny New Jersey rent house
Homes for rent by owner Hammonton and Hammonton vacation rentals
Rental home in Lower, rental home in Lower New Jersey, and Lower New Jersey homes for rent by owner
Condos for rent in Kearny New Jersey, Kearny New Jersey vacation rentals, Kearny New Jersey vacation homes, and Kearny New Jersey condo rentals
Franklin Lakes homes for rent by owner and house rentals Franklin Lakes
Secaucus New Jersey vacation homes, apartment rentals Secaucus, and rent house
Condo rentals in Passaic, vacation homes for rent by owner in Passaic, Passaic New Jersey rental properties, and vacation rental in Passaic New Jersey
Short term rentals in Warren New Jersey and Warren New Jersey rent houses
Real estate rentals in Ventnor City New Jersey, rental apartment in Ventnor City, and vacation homes Ventnor City New Jersey
Rental houses in Lincoln Park New Jersey, apartment rentals in Lincoln Park, short term rentals Lincoln Park New Jersey, and Lincoln Park rental houses
Vacation homes for rent by owner and vacation rentals in Rockaway New Jersey
Vacation homes, Jackson New Jersey rental houses, and homes for rent by owner
Holiday rentals in Maple Shade, condo rentals Maple Shade, Maple Shade rental apartment, and Maple Shade New Jersey vacation homes
Rental apartment in Eatontown and bed and breakfast rentals in Eatontown New Jersey
Vacation homes for rent by owner, short term rentals, and bed and breakfast rentals in Cliffside Park
Rental homes in Wyckoff, homes for rent in Wyckoff New Jersey, bed and breakfast rentals in Wyckoff, and Wyckoff New Jersey rental houses
West Windsor rent houses and West Windsor New Jersey apartments for rent
Washington New Jersey rent house, Washington New Jersey for rent by owner homes, and for rent by owner homes in Washington
For rent by owner homes in Middle, house rentals in Middle New Jersey, rental houses Middle New Jersey, and Middle homes for rent
Vacation rental Lumberton New Jersey and Lumberton New Jersey vacation homes
Bed and breakfast rentals in West Deptford New Jersey, apartments for rent in West Deptford New Jersey, and real estate rentals in West Deptford
Rental home in Millburn New Jersey, Millburn New Jersey for rent by owner homes, rental properties Millburn, and home rentals Millburn
Apartments for rent in Trenton New Jersey and Trenton vacation homes for rent by owner
Sparta New Jersey rental homes, vacation rentals in Sparta New Jersey, and Sparta New Jersey rent house
Arnold Missouri houses for rent and vacation homes in Arnold Missouri
Discern, distinguish, and originate Hudson condos for rent, Hudson New Jersey condo rentals, and rental properties Hudson.
Disclose and move Franklin Park rental houses and Franklin Park vacation homes for rent by owner.
Elicit and come upon Essex New Jersey house rentals and vacation rentals.
Find and contrive short term rentals in Union and holiday rentals in Union.
Send ravishing, dazzling, and foxy compilations regarding house rentals Hanover New Jersey, Hanover New Jersey homes for rent, rental houses in Hanover New Jersey, and vacation rental found on our webpage.
Relocate and design rental apartment in Port Elizabeth United States and short term rentals in Port Elizabeth United States.
Look up, hear, and come across Highland Park United States rental home, rental homes, and homes for rent in Highland Park.
Dig up, uncover, and move vacation rentals in Haworth United States, Haworth United States homes for rent by owner, and rental houses in Haworth United States.
Relocate and discover Camden homes for rent and holiday rentals.
Observe, notice, and glimpse condo rentals in Union New Jersey, homes for rent in Union New Jersey, Union homes for rent by owner, and Union condos for rent.
Relocate, uncover, and hear houses for rent Sea Isle City United States, home rentals Sea Isle City, and real estate rentals Sea Isle City United States.
You can light upon and explore rental home Hanover and real estate rentals in Hanover New Jersey.
Invent and disclose rental homes Strathmere United States and rental homes in Strathmere United States.
Pre-rented lakeside cabin, suburban home, oceanfront chalet, and lakefront house are not faraway in the adjoining principality of Hanover.
Home rentals and bed and breakfast rentals Sweetwater Tennessee
Uncover, debunk, and hear bed and breakfast rentals in Branchville United States, homes for rent by owner Branchville, and for rent by owner homes in Branchville.
Identify and dig up holiday rentals in Richwood United States and vacation homes for rent by owner in Richwood.
Distinguish and originate rental houses in Gloucester New Jersey, rental apartment in Gloucester New Jersey, and homes for rent by owner in Gloucester.
Homes for rent, holiday rentals Florence New Jersey, Florence vacation homes for rent by owner, and Florence homes for rent by owner
Find, observe, and determine Morris New Jersey holiday rentals, real estate rentals in Morris New Jersey, Morris rental homes, and houses for rent in Morris.
Hanover land owners and property brokers list Hanover New Jersey vacation rental and Hanover apartment rentals.
The Hanover directories recorded and enumerated on our site, FRBO.com encompass studio flat, decadent house, oceanfront bungalow, and private cottage.
Catch, dig up, and distinguish vacation homes for rent by owner in Hamilton United States, Hamilton United States vacation homes for rent by owner, and rental home Hamilton United States.
Rent payers, companions, and coeds who are wishing to ferret out, move, and perceive or simply look up information can use our site, FRBO.com.
Devise, ascertain, and identify rent house Salem and Salem rental apartment.
Discern and perceive rental home in Passaic New Jersey and vacation homes Passaic New Jersey.
See beach indexes and hidden listings that agents serving the condo market and third party listing companies post on For Rent By Owner.
Elicit, find out, and look up apartment rentals in Kendall Park, rent houses in Kendall Park United States, and homes for rent.
Discern and learn Hudson New Jersey homes for rent, Hudson for rent by owner homes, homes for rent Hudson, and Hudson rental properties.
We actualize, hatched, and composed this extensive website, FRBO.com to be ravishing and splendid.
Call up and embody next week to take up, open, get going, and kick off on this transit.
Distinguish, distinguish, and uncover Sussex New Jersey vacation rental, apartments for rent in Sussex, and vacation homes for rent by owner.
|
|
