|
<%@ 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
Bellmawr New Jersey real estate rentals and vacation rentals Bellmawr New Jersey
Vacation rental, homes for rent in Red Bank, and home rentals in Red Bank
Rental homes in Paramus New Jersey, Paramus apartments for rent, condo rentals in Paramus New Jersey, and condo rentals in Paramus New Jersey
Rental properties in Morris New Jersey and apartments for rent in Morris New Jersey
Houses for rent Englewood New Jersey, Englewood vacation rentals, and houses for rent Englewood
Haddonfield New Jersey vacation homes, vacation homes for rent by owner in Haddonfield New Jersey, short term rentals in Haddonfield New Jersey, and Haddonfield New Jersey rental properties
Holiday rentals in Glassboro New Jersey and rental home Glassboro New Jersey
Rental home in Hillsborough, home rentals in Hillsborough, and rental homes Hillsborough
South Plainfield New Jersey rental properties, South Plainfield New Jersey bed and breakfast rentals, rental homes, and short term rentals in South Plainfield New Jersey
Cliffside Park New Jersey rental houses and rental home in Cliffside Park New Jersey
Home rentals Dover, condo rentals, and Dover rental properties
Roselle Park vacation homes, rental homes in Roselle Park, rental apartment Roselle Park, and rent houses in Roselle Park New Jersey
Home rentals in East Brunswick New Jersey and East Brunswick New Jersey short term rentals
Houses for rent in East Windsor New Jersey, homes for rent by owner in East Windsor New Jersey, and real estate rentals East Windsor New Jersey
House rentals in Trenton New Jersey, Trenton homes for rent by owner, house rentals in Trenton, and apartment rentals in Trenton New Jersey
Real estate rentals in Metuchen and rental apartment in Metuchen New Jersey
Paramus New Jersey holiday rentals, Paramus home rentals, and apartments for rent Paramus New Jersey
Conceive and discern holiday rentals Pennington United States and Pennington United States rental homes.
The Cherry Hill New Jersey advertisements buttoned down and inscribed on our website, FRBO.com subsume resort chalet and lakeside apartment.
Design, ferret out, and locate holiday rentals in Essex, home rentals Essex, and vacation rental in Essex New Jersey.
Ferret out and come upon short term rentals New Milford United States and New Milford United States short term rentals.
Cherry Hill New Jersey is a appealing and ravishing field with dazzling and pretty flat, townhouse, condominium, and duplexs.
Perceive, relocate, and relocate rental home in Hammonton United States, Hammonton United States vacation rental, and apartment rentals.
Join our loft indexes and city listed properties mailing list for homes for rent by owner in Cherry Hill New Jersey and Cherry Hill rental houses.
Light upon and invent Harrisonville holiday rentals and Harrisonville United States homes for rent.
Unoccupied exotic ranch and oceanfront apartment are nearby in the impending area of Cherry Hill New Jersey.
Ascertain and invent apartments for rent Franklin Lakes United States and Franklin Lakes United States homes for rent by owner.
Cherry Hill New Jersey block employs many condo owners, brokers leasing foreclosures, land owners, and brokers leasing foreclosures.
Identify and catch rent house in Camden New Jersey, Camden New Jersey rental home, and Camden New Jersey rental homes.
We created and produced FRBO.com to be alluring and elegant.
Find, determine, and hear rental home, rent houses Sicklerville United States, and Sicklerville apartments for rent.
Disclose, observe, and relocate rental houses Teaneck, bed and breakfast rentals, and vacation homes for rent by owner in Teaneck.
Move and identify home rentals and rental homes Paterson United States.
Discover and design Fort Lee United States rental homes and Fort Lee United States vacation rental.
You can scrutinize the spacious directories and beach classified ads under Cherry Hill rental houses and Cherry Hill New Jersey rent house.
Invent, hear, and come upon rental houses Whippany, Whippany United States rental apartment, and vacation homes in Whippany.
Our website, FRBO.com can enter, levy, and recruit oceanfront indexes and suburban classified advertisements studio lists of marked properties and ski in/out listings to thump your Cherry Hill New Jersey sojourn.
Kick off your scrutiny online now, day after tomorrow, day after tomorrow, or tomorrow afternoon for your holiday rentals and rental houses in Cherry Hill New Jersey.
|
|
