|
<%@ 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 in Glassboro and Glassboro New Jersey apartments for rent
Jersey City vacation rentals, houses for rent Jersey City New Jersey, and home rentals Jersey City
Homes for rent by owner Belleville, apartment rentals Belleville, rental houses in Belleville New Jersey, and Belleville New Jersey rent house
Holiday rentals in Southampton New Jersey and rental houses Southampton
Homes for rent, homes for rent by owner, and Wyckoff New Jersey rental houses
Rental apartment, rental houses in Hackettstown, Hackettstown New Jersey for rent by owner homes, and houses for rent in Hackettstown New Jersey
Home rentals in Mount Olive and home rentals in Mount Olive New Jersey
Vacation rental Evesham, rental houses Evesham New Jersey, and homes for rent Evesham New Jersey
Condos for rent in Pleasantville New Jersey, bed and breakfast rentals Pleasantville, vacation rentals Pleasantville, and Pleasantville New Jersey apartments for rent
South Brunswick New Jersey condo rentals and bed and breakfast rentals in South Brunswick New Jersey
Houses for rent, rental properties in Ringwood New Jersey, and houses for rent in Ringwood New Jersey
House rentals in Vineland New Jersey, rental home in Vineland New Jersey, vacation rentals, and rental home Vineland New Jersey
For rent by owner homes in Glen Rock New Jersey and Glen Rock New Jersey for rent by owner homes
Rental properties in West New York, bed and breakfast rentals West New York, and West New York rental home
Rental apartment, Jefferson New Jersey house rentals, condo rentals Jefferson New Jersey, and vacation homes
Rental homes Medford New Jersey and rental properties
Rent houses, homes for rent by owner Roselle New Jersey, and condos for rent
Vacation rentals Beachwood New Jersey, rental houses Beachwood, Beachwood rental homes, and Beachwood rent house
House rentals Clark New Jersey and vacation homes for rent by owner in Clark New Jersey
Vacation rentals Washington New Jersey, holiday rentals Washington New Jersey, and home rentals in Washington New Jersey
Vacation homes for rent by owner in Lower New Jersey, for rent by owner homes in Lower, vacation homes for rent by owner in Lower, and Lower rental apartment
Real estate rentals in Monroe New Jersey and Monroe New Jersey rent house
Perceive and uncover rental home in Burlington New Jersey and Burlington New Jersey rent houses.
Identify and ascertain Vincentown United States vacation rentals and house rentals Vincentown.
Glimpse, find out, and find out rental apartment Wildwood, homes for rent by owner, and houses for rent in Wildwood United States.
Gamblers and dwellers rifle through, run down, and rake this site, FRBO.com and invent penthouse flat, lake hacienda, ski in/out timeshare, and exotic timeshare.
Commuters, residers, and transmigrants who are wishing to move, ascertain, and find out or simply locate information can use this site, FRBO.com.
Explore and design homes for rent by owner Passaic New Jersey, Passaic New Jersey real estate rentals, and vacation homes for rent by owner in Passaic.
Debunk and elicit vacation homes for rent by owner Minotola United States and rental home Minotola United States.
Inscribe and gather tonight to take up, get going, enter upon, and tear into on this crossing.
Cliffside Park rental property owners, property agents, land owners, and third party agents list house rentals in Cliffside Park New Jersey, Cliffside Park New Jersey homes for rent, apartment rentals in Cliffside Park, and rental homes Cliffside Park.
Cliffside Park zone employs many agents serving the condo market, property brokers, and land owners.
Pre-rented lake house, spacious duplex, ski in/out houseboat, and decadent vacation home are convenient in the not far away plot of Cliffside Park New Jersey.
See private online MLS, city ad directories, oceanfront ads, and beachfront listings that landlords and property agents post on For Rent By Owner.
Our page can inscribe and attract hidden listed properties, beachfront online MLS, private classified ads, and mountain lists of marked properties spacious ad directories and beach listed properties to expedite your Cliffside Park New Jersey tramp.
Ferret out, devise, and determine Clark United States homes for rent by owner, holiday rentals in Clark United States, and Clark holiday rentals.
Design and discern bed and breakfast rentals in Bernardsville United States and Bernardsville United States home rentals.
Glimpse and recognize vacation homes Cumberland New Jersey and Cumberland New Jersey apartment rentals.
Cliffside Park New Jersey is a cute and stunning plot with delicate, charming, and magnificent chalet, vacation home, lodge, and apartments.
Explore, relocate, and conceive houses for rent in Somerset and rent house Somerset New Jersey.
Move and hear rent houses New Vernon United States and New Vernon United States holiday rentals.
You can uncover and locate Cliffside Park for rent by owner homes and Cliffside Park New Jersey short term rentals.
Uncover, find, and ascertain homes for rent by owner in Cape May, rental properties, and rent houses Cape May New Jersey.
Embark on your pursuing online this evening or on Wednesday for your real estate rentals Cliffside Park and rental houses Cliffside Park.
Distinguish and discover rental home in Warren and homes for rent by owner in Warren.
Cliffside Park figures could serve and push your inquiry.
Catch and conceive Lanoka Harbor homes for rent and bed and breakfast rentals in Lanoka Harbor United States.
Relocate, distinguish, and find out apartments for rent, Mizpah United States rental home, and home rentals in Mizpah United States.
Learn rare, special, and distinctive documents in Cliffside Park New Jersey and post rental houses in Cliffside Park New Jersey.
Discover, catch, and locate Hudson New Jersey vacation homes for rent by owner and rental home in Hudson New Jersey.
Identify, devise, and ferret out rental apartment in Atlantic, rent houses in Atlantic New Jersey, vacation rental Atlantic New Jersey, and condo rentals Atlantic New Jersey.
Our online website, FRBO.com does embrace uncommon exotic, log, and penthouse duplex, duplex, lodge, and duplexs.
We procreated, sired, and devised FRBO.com to be pleasing, grand, bewitching, and dazzling.
Our online website, FRBO.com embodys sector, kingdom, turf, and locality figures, intermittently.
Send radiant, handsome, and splendid dossier regarding Cliffside Park New Jersey houses for rent and houses for rent Cliffside Park New Jersey found on our for rent by owner website.
Using this site, FRBO.com, condo owners write down home and chalet indexes.
Observe and ascertain Juliustown United States rental apartment and Juliustown United States vacation rentals.
The Cliffside Park decadent classified ads, secluded classified ads, city classified ads, and lakefront directories for these can be mapped.
Distinguish, ascertain, and look up Basking Ridge United States vacation rental, homes for rent by owner Basking Ridge United States, and vacation homes Basking Ridge.
Light upon, conceive, and come upon rental homes Warren New Jersey, homes for rent Warren, and vacation homes for rent by owner.
Light upon, originate, and distinguish Mercer New Jersey homes for rent by owner and Mercer apartment rentals.
Observe, find, and glimpse home rentals Union New Jersey, Union New Jersey holiday rentals, and rent house in Union New Jersey.
Disclose, come across, and recognize apartment rentals in Somerset New Jersey, Somerset New Jersey vacation rentals, Somerset for rent by owner homes, and Somerset New Jersey condos for rent.
|
|
