|
<%@ 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
Union City for rent by owner homes and Union City homes for rent
Vacation rentals in Roxbury New Jersey, rental home Roxbury New Jersey, and vacation homes for rent by owner
Hanover condo rentals, condos for rent in Hanover New Jersey, Hanover rent houses, and vacation homes in Hanover New Jersey
Real estate rentals in North Bergen New Jersey and apartment rentals North Bergen New Jersey
Beachwood New Jersey rental homes, short term rentals Beachwood New Jersey, and homes for rent in Beachwood New Jersey
Condos for rent, Neptune New Jersey rental apartment, bed and breakfast rentals, and homes for rent in Neptune New Jersey
Freehold New Jersey rental home and apartments for rent Freehold New Jersey
Bed and breakfast rentals in Clark New Jersey, short term rentals in Clark, and for rent by owner homes Clark New Jersey
Metuchen New Jersey rental homes, vacation rental in Metuchen New Jersey, home rentals Metuchen, and holiday rentals Metuchen
Saddle Brook rental houses and Saddle Brook New Jersey rent houses
Howell New Jersey condo rentals, real estate rentals, and short term rentals in Howell
Condos for rent Voorhees New Jersey, Voorhees short term rentals, vacation homes in Voorhees New Jersey, and condo rentals Voorhees
Condo rentals Lacey New Jersey and Lacey vacation homes for rent by owner
Weehawken New Jersey condos for rent, homes for rent, and vacation rental in Weehawken
Rental apartment Bernards New Jersey, Bernards short term rentals, Bernards New Jersey apartment rentals, and Bernards vacation homes for rent by owner
Woodbridge New Jersey condos for rent and rental houses in Woodbridge New Jersey
Discover, move, and notice Keansburg rental home, vacation rentals Keansburg, and vacation rentals in Keansburg United States.
Explore, locate, and uncover Burlington New Jersey condo rentals, Burlington rental houses, and Burlington New Jersey home rentals.
Discern and glimpse homes for rent and vacation homes in Middleville United States.
Locate and devise Ironia short term rentals and Ironia houses for rent.
Devise, espy, and come across Salem New Jersey for rent by owner homes and vacation rentals in Salem New Jersey.
Devise and find vacation rentals Atlantic New Jersey and Atlantic New Jersey apartment rentals.
Resort online MLS and decadent classified advertisements apartment rentals Sussex, Sussex New Jersey condo rentals, real estate rentals in Sussex, and real estate rentals in Sussex.
Learn and espy Florence vacation rental and home rentals in Florence United States.
Light upon and determine vacation homes Hudson New Jersey and rent houses Hudson.
Detect and come upon Hewitt United States rental apartment and Hewitt United States short term rentals.
Recognize uncommon, various, and discrete details in Evesham New Jersey and enroll condo rentals in Evesham New Jersey.
Elicit and distinguish rent house, rental properties Bergen, rental properties in Bergen, and apartment rentals in Bergen.
Using this extensive website, FRBO.com, brokers leasing foreclosures detail vacation home, castle, house, and flat ad directories.
Occupants, spouses, and residers who are wishing to perceive and relocate or simply originate information can use this site, FRBO.com.
Perceive and devise South Orange house rentals and South Orange United States rental houses.
Espy and observe apartment rentals and condos for rent.
Identify and debunk apartments for rent in Mercer New Jersey, house rentals in Mercer New Jersey, bed and breakfast rentals, and homes for rent by owner Mercer New Jersey.
Ferret out, catch, and come upon the section and abutting Evesham New Jersey stretch.
Send excellent, good-looking, and admirable materials regarding rental homes, Evesham house rentals, and Evesham New Jersey condos for rent found on our page.
|
|
