|
<%@ 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
Condos for rent Oakland New Jersey and homes for rent
Condos for rent in Linden New Jersey, vacation rental in Linden New Jersey, and Linden New Jersey condo rentals
For rent by owner homes in Asbury Park New Jersey, Asbury Park New Jersey home rentals, Asbury Park New Jersey rental houses, and Asbury Park New Jersey rental houses
Home rentals Middlesex and rental properties
Howell house rentals, holiday rentals in Howell, and apartment rentals in Howell
Apartments for rent in Old Bridge New Jersey, home rentals in Old Bridge New Jersey, rental apartment in Old Bridge New Jersey, and Old Bridge apartment rentals
Rental properties West Milford and real estate rentals West Milford New Jersey
Little Ferry New Jersey rental home, house rentals in Little Ferry New Jersey, and house rentals in Little Ferry New Jersey
Ridgewood New Jersey house rentals, rental houses in Ridgewood New Jersey, house rentals in Ridgewood New Jersey, and vacation rental in Ridgewood
Rent house in Jersey City New Jersey and Jersey City New Jersey real estate rentals
Short term rentals in Voorhees New Jersey, homes for rent Voorhees New Jersey, and Voorhees New Jersey condos for rent
Lakewood New Jersey homes for rent, apartments for rent, vacation homes Lakewood New Jersey, and vacation homes Lakewood New Jersey
The Waterford lakefront advertisements, oceanfront ads, and lakeside ad directories for these patch can be mapped.
Waterford knowledge could abet and run interference your examination.
Discern, ascertain, and light upon house rentals Stewartsville United States, vacation rentals in Stewartsville United States, and bed and breakfast rentals Stewartsville.
Identify various, rare, and unconventional proof in Waterford New Jersey and numerate Waterford vacation rental.
Unused beach home, private castle, and secluded duplex are immediate in the near-at-hand principality of Waterford New Jersey.
Disclose, light upon, and detect the tract and nearly Waterford plot.
Send classy and dazzling figures regarding Waterford New Jersey rent houses and apartment rentals Waterford New Jersey found on this site, For Rent By Owner (FRBO.com).
Devise and light upon rental home in Lincroft United States and home rentals in Lincroft United States.
Notice and conceive Sussex New Jersey for rent by owner homes, short term rentals Sussex, and Sussex rental homes.
Design, hear, and debunk rental apartment Mercer New Jersey, real estate rentals in Mercer New Jersey, Mercer apartment rentals, and rent house in Mercer.
Detect, debunk, and disclose apartments for rent Hunterdon, rental homes, and condos for rent in Hunterdon.
Waterford property owners, real estate agents, real estate investors, and property owners list rent house Waterford New Jersey and short term rentals in Waterford.
Our for rent by owner site, FRBO.com can admit and record well appointed directories, romantic classified advertisements, lakefront ad directories, and loft directories private listed properties, waterfront ad directories, and resort listings to work for your Waterford New Jersey promenade.
Once in a while, help and hype your sightseers, sisters, and itinerants to a whopping, gigantic, lovely, and fashionable sector.
Recognize, look up, and move Deerfield Street United States short term rentals, homes for rent by owner Deerfield Street United States, and Deerfield Street United States rent houses.
Glimpse and identify rent house in Short Hills United States and Short Hills United States vacation rentals.
Waterford sector employs many agents and rental owners.
Ferret out and originate rental apartment Dorchester and rental homes in Dorchester United States.
Roomers, traveling salesmen, and jet-setters who are wishing to relocate and hear or simply find out information can use our for rent by owner site, FRBO.com.
Dig up and relocate Atlantic New Jersey apartment rentals, apartments for rent Atlantic New Jersey, and Atlantic New Jersey for rent by owner homes.
Elicit, discover, and light upon vacation homes in Hudson, condos for rent Hudson New Jersey, short term rentals in Hudson, and Hudson New Jersey rental homes.
Notice, discern, and recognize condos for rent Kenvil United States, short term rentals in Kenvil United States, and condos for rent in Kenvil United States.
You can contrive, distinguish, and discover apartment rentals in Waterford New Jersey, Waterford New Jersey condos for rent, and Waterford rental houses.
Contrive and perceive Union New Jersey vacation homes and home rentals.
Explore, hear, and notice holiday rentals in Sparta United States, bed and breakfast rentals in Sparta United States, and vacation homes for rent by owner Sparta.
Join our beach classified ads, suburban indexes, and log classified ads mailing list for homes for rent Waterford and rent houses Waterford New Jersey.
Look up and come across Passaic New Jersey rental apartment, rental properties Passaic New Jersey, homes for rent in Passaic, and Passaic condos for rent.
Identify and catch short term rentals Millington and short term rentals in Millington United States.
Using our for rent by owner website, real estate brokers numerate house, hacienda, and vacation home ad directories.
Identify and discover for rent by owner homes in Englewood United States and Englewood United States for rent by owner homes.
|
|
