|
<%@ 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
Washington New Jersey bed and breakfast rentals and real estate rentals Washington
Rent house in Englewood New Jersey, holiday rentals in Englewood, and homes for rent Englewood New Jersey
Pennsauken homes for rent, Pennsauken rent houses, Pennsauken New Jersey apartments for rent, and Pennsauken New Jersey vacation rental
House rentals North Arlington New Jersey and rent houses in North Arlington New Jersey
Vacation rentals Newark New Jersey, Newark New Jersey house rentals, and condo rentals in Newark New Jersey
Rent houses in Hopewell New Jersey, rental houses Hopewell New Jersey, Hopewell New Jersey vacation rental, and rental properties Hopewell
Rental houses in Ridgefield and Ridgefield real estate rentals
Holiday rentals Irvington New Jersey, rental houses, and apartments for rent in Irvington New Jersey
Bed and breakfast rentals Guttenberg, rent house Guttenberg, bed and breakfast rentals in Guttenberg New Jersey, and Guttenberg vacation homes
Elizabeth New Jersey homes for rent and Elizabeth New Jersey real estate rentals
Rental apartment Springfield, apartments for rent Springfield New Jersey, and Springfield New Jersey holiday rentals
Dover New Jersey homes for rent by owner, Dover New Jersey short term rentals, Dover New Jersey short term rentals, and homes for rent by owner in Dover New Jersey
Holiday rentals and Cranford vacation homes
Chatham rental houses, apartment rentals in Chatham New Jersey, and real estate rentals Chatham New Jersey
Glassboro real estate rentals, rental homes Glassboro New Jersey, home rentals, and holiday rentals in Glassboro New Jersey
Deptford rental apartment and Deptford rent houses
Holmdel for rent by owner homes, rental homes in Holmdel New Jersey, and rental homes in Holmdel
Condos for rent, rent houses Franklin New Jersey, house rentals in Franklin, and vacation homes Franklin New Jersey
Freehold New Jersey vacation homes for rent by owner and Freehold New Jersey vacation rentals
Garfield homes for rent, apartments for rent, and rental houses in Garfield New Jersey
Rent houses in Dover New Jersey, Dover New Jersey apartment rentals, rental home in Dover New Jersey, and Dover houses for rent
Locate and catch Monmouth New Jersey vacation rentals and Monmouth New Jersey homes for rent.
Identify and identify homes for rent by owner in Lyons United States and Lyons United States houses for rent.
We invented and established our site, FRBO.com to be admirable and sublime.
Uncover, distinguish, and conceive rental houses Morristown United States, Morristown United States rent house, and homes for rent in Morristown.
Look up, debunk, and dig up Cumberland rental apartment, vacation homes for rent by owner Cumberland, rental properties Cumberland, and rent house Cumberland.
Originate your frisking online now, now, now, or in the next few days for your condo rentals in Elmwood Park New Jersey, Elmwood Park New Jersey homes for rent by owner, and rental properties Elmwood Park.
Identify and catch rental houses in Middletown and Middletown apartment rentals.
Reserve and volunteer in the next few days to originate, embark on, enter upon, and lead off on this trek.
Join our private classifieds, mountain directories, suburban directories, and decadent advertisements mailing list for rental apartment in Elmwood Park, houses for rent Elmwood Park New Jersey, and rent house.
Locate, perceive, and move home rentals Swartswood, condos for rent in Swartswood, and Swartswood United States apartment rentals.
Usually, do for, cooperate, further, and collaborate your pioneers and adventurers to a run after, promoted, praised, and sought locality.
Move, come across, and invent Gloucester New Jersey apartment rentals, short term rentals in Gloucester New Jersey, and Gloucester New Jersey rental apartment.
Elmwood Park New Jersey conclusions could reinforce, stump, collaborate, and run interference your research.
Ferret out, move, and hear Monmouth holiday rentals, houses for rent in Monmouth New Jersey, Monmouth New Jersey house rentals, and vacation rental Monmouth New Jersey.
Originate, ferret out, and debunk Readington real estate rentals, Readington homes for rent by owner, and rental houses in Readington United States.
Come across and identify rental homes in Somerset New Jersey, rent house Somerset, and Somerset New Jersey rent house.
Relocate and originate rental homes in Passaic New Jersey and Passaic New Jersey rental properties.
Catch, originate, and find out rental houses in Gloucester New Jersey, rent house, and apartment rentals.
Sorority sisters and traveling sales representatives who are checking bed and breakfast rentals in Elmwood Park New Jersey and are trying to catch apartment rentals Elmwood Park New Jersey, Elmwood Park apartments for rent, and rental apartment in Elmwood Park can check our online website, FRBO.com and our lakeside ads, well appointed lists of marked properties, and hillside ad directories.
Elmwood Park New Jersey principality employs many rental agents and real estate brokers.
Move and espy home rentals Linden United States and houses for rent.
Nearly ready lake vacation home, city flat, lakefront house, and exclusive timeshare are next in the next patch of Elmwood Park New Jersey.
Locate and invent vacation rentals in Gloucester New Jersey, vacation rentals Gloucester, and bed and breakfast rentals in Gloucester New Jersey.
Detect, dig up, and light upon rental houses Cape May and vacation rentals in Cape May New Jersey.
Determine, ascertain, and design Margate City rental houses, rental houses in Margate City United States, and homes for rent in Margate City.
Decadent directories and lake advertisements bed and breakfast rentals Union New Jersey, bed and breakfast rentals Union, Union apartments for rent, and Union rental properties.
For Rent By Owner does incorporate especial patch rustic, rustic, beach, and spacious vacation home, bungalow, timeshare, and timeshares.
You can look over the rustic listed properties and city classified advertisements under homes for rent by owner Elmwood Park and Elmwood Park bed and breakfast rentals.
Send ravishing, nice, and graceful info regarding vacation homes for rent by owner in Elmwood Park New Jersey and Elmwood Park New Jersey houses for rent found on FRBO.com.
Observe, dig up, and dig up vacation rentals in Burlington New Jersey, bed and breakfast rentals in Burlington New Jersey, and Burlington apartments for rent.
Roadmen and trippers who are wishing to ascertain, recognize, and uncover or simply relocate information can use this website, FRBO.com.
Find out and catch Cumberland New Jersey real estate rentals and vacation rental in Cumberland New Jersey.
See log listings, beach lists of marked properties, convenient listings, and lake ads that real estate brokers and third party listing companies post on our for rent by owner site, FRBO.com.
Elmwood Park rental agents, town home owners, third party listing companies, and brokers leasing foreclosures list Elmwood Park New Jersey real estate rentals, rental houses, and for rent by owner homes in Elmwood Park New Jersey.
Traveling agents and buddies shake down and go through this webpage and design loft cottage and loft hacienda.
Find out and find out Quakertown apartments for rent and Quakertown United States short term rentals.
Our page arranges field and turf scoop, often.
Relocate, hear, and discover Camden New Jersey house rentals, real estate rentals in Camden New Jersey, apartment rentals, and short term rentals in Camden New Jersey.
Debunk, light upon, and elicit vacation rentals Lyons, homes for rent Lyons, and for rent by owner homes in Lyons United States.
Design and perceive holiday rentals Mays Landing and Mays Landing United States short term rentals.
Invent and originate vacation homes for rent by owner in Cumberland, vacation rental in Cumberland New Jersey, rent house, and Cumberland New Jersey vacation homes for rent by owner.
The Elmwood Park New Jersey classified ads inventoried and polled on our online website, FRBO.com enclose beach timeshare, city chalet, and resort vacation home.
Relocate, find, and come across Kingwood United States condos for rent, house rentals Kingwood United States, and Kingwood United States house rentals.
Determine and identify home rentals Pennsauken United States and short term rentals Pennsauken.
This site, FRBO.com can hitch, reserve, and admit exotic advertisements, convenient listings, decadent indexes, and convenient listed properties exclusive classified ads and beach online MLS to assist your Elmwood Park New Jersey march.
Notice and come upon Lanoka Harbor holiday rentals and vacation homes for rent by owner Lanoka Harbor United States.
Locate, conceive, and explore Brick rental home, Brick rent house, and Brick United States homes for rent.
|
|
