|
<%@ 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
Parsippany-Troy Hills homes for rent and Parsippany-Troy Hills New Jersey house rentals
Holiday rentals in Holmdel New Jersey, rental apartment in Holmdel New Jersey, and vacation homes for rent by owner in Holmdel New Jersey
Voorhees New Jersey home rentals, Voorhees New Jersey holiday rentals, holiday rentals Voorhees New Jersey, and Voorhees real estate rentals
Highland Park New Jersey holiday rentals and Highland Park New Jersey vacation rentals
Condo rentals, vacation rentals in City of Orange, and for rent by owner homes
Condo rentals in Readington New Jersey, rental houses in Readington New Jersey, Readington for rent by owner homes, and houses for rent in Readington New Jersey
Holiday rentals Roxbury and rental houses in Roxbury New Jersey
Rent house Dover, Dover New Jersey real estate rentals, and condos for rent in Dover New Jersey
West Windsor New Jersey apartment rentals, West Windsor homes for rent, West Windsor New Jersey real estate rentals, and West Windsor New Jersey vacation rental
For rent by owner homes Eatontown and vacation rentals in Eatontown New Jersey
Moorestown New Jersey vacation homes for rent by owner, short term rentals in Moorestown, and vacation rental
Rental homes Neptune, real estate rentals Neptune New Jersey, rental home in Neptune, and Neptune New Jersey holiday rentals
Discover and come across Sussex houses for rent, real estate rentals in Sussex New Jersey, and condo rentals in Sussex.
Espy, ascertain, and notice vacation homes for rent by owner Schooleys Mountain United States, houses for rent in Schooleys Mountain United States, and rent house in Schooleys Mountain United States.
Eatontown New Jersey figures could hype and boost your pursuit.
Eatontown real estate investors, real estate brokers, rental agents, and property owners list short term rentals Eatontown New Jersey, apartment rentals Eatontown New Jersey, for rent by owner homes in Eatontown New Jersey, and Eatontown New Jersey rental home.
Traveling men and gypsies who are rifling through Eatontown New Jersey houses for rent and are trying to perceive rent houses Eatontown New Jersey, rental homes Eatontown, and vacation rental in Eatontown New Jersey can root our webpage and our ski in/out classified advertisements, city advertisements, and hidden listed properties.
Recently available romantic villa and rustic vacation home are nearly in the not far locality of Eatontown New Jersey.
Now and again, ballyhoo, push, expedite, and cooperate your comrades, pioneers, and globetrotters to a attractive and pretty kingdom.
We designed and procreated our site, FRBO.com to be handsome, exquisite, and delightful.
Dig up, discern, and ferret out Mays Landing house rentals, Mays Landing United States condos for rent, and vacation rentals Mays Landing United States.
Locate, distinguish, and learn Norma rental apartment, rental houses in Norma United States, and rent houses in Norma United States.
The Eatontown New Jersey directories specialized and entered on FRBO.com arrange decadent cottage, beach lodge, and exclusive houseboat.
Recognize and devise the quarter and not far away Eatontown New Jersey block.
You can seek the hidden classified ads, penthouse classified ads, romantic ad directories, and private online MLS under rent houses, Eatontown rent houses, and condos for rent in Eatontown.
You can catch, design, and disclose rental houses in Eatontown New Jersey, apartments for rent in Eatontown New Jersey, and bed and breakfast rentals in Eatontown New Jersey.
Discern, dig up, and find rental apartment Camden and houses for rent.
Dig up distinct, express, original, and unconventional figures in Eatontown and inscribe condo rentals Eatontown New Jersey.
Eatontown dominion employs many property brokers, rental owners, rental property owners, and property agents.
|
|
