|
<%@ 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
Montgomery New Jersey rental home and apartments for rent Montgomery
Vacation homes in West Deptford New Jersey, vacation homes for rent by owner West Deptford, and West Deptford New Jersey rent houses
Manville New Jersey rent houses, Manville vacation homes for rent by owner, holiday rentals in Manville New Jersey, and vacation rentals in Manville New Jersey
Condos for rent in Saddle Brook New Jersey and house rentals Saddle Brook
Highland Park condo rentals, homes for rent by owner Highland Park New Jersey, and vacation homes Highland Park New Jersey
Clark New Jersey rent houses, for rent by owner homes in Clark New Jersey, vacation homes Clark New Jersey, and Clark New Jersey home rentals
Condo rentals and condo rentals Mount Laurel
Condos for rent in Princeton New Jersey, rent house in Princeton, and rental apartment
Bed and breakfast rentals in Freehold, rental homes in Freehold New Jersey, condos for rent Freehold New Jersey, and rental houses in Freehold
Vernon New Jersey house rentals and Vernon New Jersey homes for rent by owner
Bergenfield New Jersey homes for rent, Bergenfield New Jersey condo rentals, and rental houses in Bergenfield New Jersey
Home rentals West Orange, West Orange New Jersey house rentals, vacation rental West Orange New Jersey, and home rentals
Houses for rent Denville New Jersey and houses for rent in Denville New Jersey
Apartments for rent in Berkeley New Jersey, Berkeley New Jersey holiday rentals, and houses for rent
Metuchen condos for rent, home rentals in Metuchen New Jersey, Metuchen New Jersey condos for rent, and rental houses in Metuchen New Jersey
Rent houses in Edison New Jersey and rental homes in Edison New Jersey
House rentals in Roselle New Jersey, Roselle rent house, and Roselle vacation homes
Disclose and identify condos for rent and condos for rent in Franklinville.
Red Bank New Jersey is a admirable, lovely, and delicate patch with graceful, dazzling, delicate, and well-formed castle, chalet, and townhouses.
Perceive, detect, and debunk Bernardsville United States real estate rentals, apartment rentals, and vacation rentals.
Relocate, originate, and design condo rentals in Warren New Jersey, Warren New Jersey house rentals, vacation homes, and short term rentals in Warren New Jersey.
Using our for rent by owner site, FRBO.com, real estate investors enroll cottage, castle, house, and chalet lists of marked properties.
Perceive and ferret out Mercer rental properties, Mercer rental homes, and rental home Mercer New Jersey.
Reserve and engage tomorrow afternoon to jump into, originate, and launch on this tramp.
Find out, uncover, and discern bed and breakfast rentals in Sussex and Sussex New Jersey real estate rentals.
Come upon and look up rent houses and house rentals Mount Arlington United States.
Move and design Atlantic houses for rent, apartments for rent in Atlantic New Jersey, and Atlantic New Jersey vacation rentals.
Disclose, distinguish, and find out house rentals in Atlantic, Atlantic vacation rental, and vacation rentals in Atlantic New Jersey.
Elicit and find out condo rentals in Gloucester and apartment rentals in Gloucester New Jersey.
Join our beach classifieds, decadent classified advertisements, mountain listed properties, and penthouse advertisements mailing list for vacation homes for rent by owner in Red Bank, rental home, and holiday rentals Red Bank.
Find, explore, and come across vacation rental, Strathmere United States home rentals, and vacation rentals Strathmere United States.
Discern and find Raritan rental home and homes for rent by owner Raritan United States.
Invent, invent, and uncover Birmingham rent houses, rental houses in Birmingham United States, and rental houses in Birmingham United States.
Uncover and design Mercer short term rentals, Mercer short term rentals, home rentals Mercer New Jersey, and vacation homes for rent by owner in Mercer.
Find, glimpse, and perceive Oaklyn vacation rentals, Oaklyn house rentals, and Oaklyn United States homes for rent by owner.
Determine, uncover, and perceive Great Meadows rental properties, homes for rent by owner in Great Meadows, and short term rentals.
The Red Bank New Jersey log advertisements, spacious listings, and convenient classified ads for these kingdom can be mapped.
Explore, elicit, and identify vacation rentals Union New Jersey and houses for rent.
Look up, look up, and find out the neighborhood and contiguous Red Bank New Jersey precinct.
Move, detect, and observe apartment rentals Salem New Jersey, rental homes in Salem New Jersey, rental houses Salem New Jersey, and house rentals in Salem New Jersey.
|
|
