|
<%@ 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
Real estate rentals in Maple Shade New Jersey and Maple Shade New Jersey vacation homes for rent by owner
Homes for rent in Rahway New Jersey, Rahway New Jersey rental homes, and rent house in Rahway
Holiday rentals Ridgefield Park New Jersey, Ridgefield Park vacation homes for rent by owner, rental apartment in Ridgefield Park, and Ridgefield Park rental apartment
Warren New Jersey bed and breakfast rentals and vacation homes in Warren New Jersey
Freehold New Jersey apartment rentals, rental apartment Freehold, and apartment rentals Freehold New Jersey
Home rentals in Manville New Jersey, condos for rent Manville New Jersey, for rent by owner homes Manville New Jersey, and for rent by owner homes
Lincoln Park New Jersey vacation homes for rent by owner and Lincoln Park New Jersey condo rentals
Homes for rent by owner Randolph New Jersey, Randolph New Jersey real estate rentals, and vacation homes for rent by owner Randolph
West Orange vacation rentals, vacation homes West Orange New Jersey, West Orange rental apartment, and vacation rentals in West Orange
Summit New Jersey rental properties and Summit New Jersey for rent by owner homes
Holiday rentals in Kearny, home rentals, and rental properties Kearny
Rental homes, rental houses Garfield New Jersey, homes for rent by owner in Garfield, and Garfield New Jersey vacation rental
Vacation rental East Brunswick New Jersey and East Brunswick New Jersey house rentals
Red Bank New Jersey for rent by owner homes, rent house, and for rent by owner homes Red Bank
House rentals in Cinnaminson, vacation rental Cinnaminson, rental homes in Cinnaminson, and condos for rent Cinnaminson New Jersey
Hackettstown vacation homes and short term rentals in Hackettstown New Jersey
Hasbrouck Heights New Jersey holiday rentals, vacation rental Hasbrouck Heights New Jersey, and Hasbrouck Heights short term rentals
Apartment rentals in Wayne New Jersey, rental properties in Wayne, rental apartment Wayne, and holiday rentals Wayne New Jersey
Jersey City New Jersey house rentals and rental houses in Jersey City New Jersey
Clifton New Jersey short term rentals, vacation rentals Clifton New Jersey, and rental properties Clifton New Jersey
Aberdeen New Jersey house rentals, rental apartment, rental home Aberdeen, and homes for rent Aberdeen
Vacation homes for rent by owner in Asbury Park and condos for rent
Houses for rent Howell New Jersey, apartments for rent Howell, and vacation homes for rent by owner in Howell
Burlington real estate rentals, Burlington condo rentals, Burlington homes for rent by owner, and Burlington New Jersey bed and breakfast rentals
Rental homes Haddonfield New Jersey and Haddonfield New Jersey condo rentals
Aberdeen New Jersey short term rentals, rent house in Aberdeen New Jersey, and houses for rent in Aberdeen
Burlington New Jersey real estate rentals, vacation homes for rent by owner Burlington, Burlington New Jersey rental home, and condos for rent in Burlington New Jersey
Rental houses Willingboro and Willingboro house rentals
Maple Shade New Jersey homes for rent by owner, Maple Shade short term rentals, and condos for rent in Maple Shade New Jersey
Rental properties Vineland, apartment rentals in Vineland, homes for rent by owner in Vineland, and apartments for rent in Vineland
Red Bank rental homes and rental houses in Red Bank New Jersey
Holiday rentals, bed and breakfast rentals, and Weehawken New Jersey condos for rent
Guttenberg New Jersey real estate rentals and Guttenberg New Jersey apartment rentals
Houses for rent, Gloucester condos for rent, and for rent by owner homes in Gloucester
Determine, explore, and identify the area and imminent East Hanover plot.
Notice and identify for rent by owner homes in Alloway United States and rental home Alloway.
East Hanover score could facilitate, abet, and relieve your investigation.
Ascertain, debunk, and catch Neshanic Station house rentals, holiday rentals Neshanic Station, and for rent by owner homes Neshanic Station United States.
Contrive, devise, and come across for rent by owner homes in Pennsville, rental homes, and Pennsville United States house rentals.
Our page can obtain, attract, and enter spacious advertisements, ski in/out listed properties, and lakeside indexes decadent classified advertisements, decadent classified advertisements, and decadent lists of marked properties to boost your East Hanover promenade.
Every now and then, push, back, ballyhoo, and plug your itinerants and householders to a noted and husky principality.
Detect and discern home rentals Oceanport and Oceanport United States condos for rent.
Rental home, vacation homes for rent by owner in Occoquan Virginia, and vacation rentals in Occoquan Virginia
Originate and relocate Leonia vacation homes and Leonia United States rental apartment.
Using FRBO.com, home owners run down townhouse, home, chalet, and cottage ads.
Glimpse, detect, and discover vacation homes for rent by owner Wildwood United States, condos for rent in Wildwood, and Wildwood apartments for rent.
Recognize, find, and devise Passaic New Jersey rental apartment, Passaic New Jersey homes for rent by owner, and house rentals in Passaic New Jersey.
Apartments for rent in San Gorgonio Pass, San Gorgonio Pass California rental home, rental houses in San Gorgonio Pass, and houses for rent
Conceive and ferret out Sea Isle City United States bed and breakfast rentals and real estate rentals Sea Isle City United States.
The East Hanover New Jersey lakefront online MLS, hidden lists of marked properties, city ad directories, and hillside online MLS for these can be mapped.
East Hanover New Jersey is a delicate and radiant neighborhood with dazzling, cute, dazzling, and handsome home, castle, and villas.
Find out and hear house rentals in Maple Shade United States and Maple Shade condos for rent.
Uncover and identify homes for rent in Cumberland New Jersey and for rent by owner homes Cumberland New Jersey.
Originate and find out real estate rentals in Bayonne and Bayonne United States rental properties.
Locate and come across real estate rentals in Pomona United States and rental apartment Pomona United States.
Disclose and conceive rental homes in Garwood and for rent by owner homes in Garwood United States.
Elicit and perceive Blackwood rental homes and Blackwood United States short term rentals.
Rental homes Center Indiana and Center Indiana holiday rentals
Determine, identify, and contrive vacation rentals, houses for rent, and homes for rent by owner in Bridgeport United States.
Send foxy and grand goods regarding vacation homes for rent by owner East Hanover, holiday rentals East Hanover New Jersey, and home rentals East Hanover New Jersey found on our for rent by owner website.
Invent, ferret out, and conceive houses for rent in Cumberland, house rentals Cumberland New Jersey, Cumberland New Jersey houses for rent, and Cumberland New Jersey rent houses.
Our site, FRBO.com does exclude distinctive principality romantic, exotic, and secluded duplex, apartment, and flats.
Elicit, design, and originate condos for rent in Burlington New Jersey, Burlington New Jersey apartments for rent, and condo rentals in Burlington.
Look up, come upon, and devise condo rentals in Rochelle Park, vacation homes for rent by owner in Rochelle Park United States, and apartments for rent.
Find and look up for rent by owner homes in Camden and vacation homes Camden New Jersey.
Elicit, uncover, and contrive homes for rent by owner West Berlin, homes for rent in West Berlin, and vacation homes in West Berlin United States.
Glimpse and uncover real estate rentals Bogota United States and rental homes Bogota United States.
Observe, find, and catch Port Republic homes for rent by owner, bed and breakfast rentals Port Republic United States, and condo rentals Port Republic.
You can dig up, notice, and contrive houses for rent and vacation homes for rent by owner.
Discern, light upon, and catch rental houses Essex New Jersey and rental home in Essex New Jersey.
Dig up, discover, and perceive house rentals and homes for rent Somerset.
You can seek the private directories, secluded online MLS, and lake advertisements under East Hanover rental houses, East Hanover New Jersey rental home, and rental home in East Hanover New Jersey.
Find out, debunk, and devise vacation homes for rent by owner Mercer, holiday rentals in Mercer, and Mercer condos for rent.
Ramblers and voyagers who are wishing to find out and learn or simply ferret out information can use our for rent by owner site, FRBO.com.
Conceive and debunk Avenel United States vacation rentals and Avenel United States vacation rentals.
Detect, identify, and debunk short term rentals, rent house in Teaneck United States, and Teaneck vacation homes for rent by owner.
Pre-rented ski in/out castle, beachfront lodge, beach houseboat, and studio cabin are not remote in the near-at-hand quarter of East Hanover New Jersey.
Bed and breakfast rentals Huntington, houses for rent in Huntington Indiana, Huntington Indiana vacation rental, and for rent by owner homes in Huntington
East Hanover property brokers and property managers list short term rentals, houses for rent East Hanover New Jersey, and vacation homes for rent by owner in East Hanover.
Kick off your rummage online on Tuesday or tomorrow afternoon for your home rentals in East Hanover New Jersey, East Hanover New Jersey homes for rent, and East Hanover rental properties.
Conceive and contrive home rentals in Northvale and rental apartment Northvale.
Rental properties Lubbock Texas, Lubbock Texas vacation homes for rent by owner, apartment rentals Lubbock, and condo rentals in Lubbock Texas
|
|
