|
<%@ 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
Home rentals Hopatcong New Jersey and vacation homes Hopatcong
Real estate rentals in Plainfield, vacation rentals in Plainfield New Jersey, and Plainfield New Jersey houses for rent
Homes for rent Lawrence, Lawrence New Jersey rental home, for rent by owner homes Lawrence New Jersey, and apartment rentals Lawrence
Bed and breakfast rentals in Cliffside Park New Jersey and bed and breakfast rentals Cliffside Park New Jersey
Ramsey New Jersey home rentals, rental apartment Ramsey, and Ramsey short term rentals
Highland Park rent house, Highland Park homes for rent by owner, rental houses in Highland Park New Jersey, and Highland Park rent houses
Cinnaminson New Jersey rental properties and homes for rent
Short term rentals in East Orange New Jersey, East Orange bed and breakfast rentals, and East Orange for rent by owner homes
New Milford rental homes, rental apartment in New Milford, bed and breakfast rentals New Milford, and New Milford houses for rent
Middletown New Jersey apartments for rent and Middletown New Jersey condos for rent
Real estate rentals in Piscataway New Jersey, home rentals in Piscataway New Jersey, and Piscataway vacation rentals
Rental homes, Wallington holiday rentals, Wallington condo rentals, and rental home in Wallington
Find, recognize, and learn bed and breakfast rentals in Ocean New Jersey and rental apartment Ocean.
This site, For Rent By Owner (FRBO.com) does have original township loft and log farmhouse, cottage, duplex, and farmhouses.
Unoccupied suburban lodge and lakefront duplex are adjoining in the near-at-hand stretch of West Orange New Jersey.
Espy, relocate, and determine vacation homes for rent by owner in Deal United States, apartments for rent Deal, and vacation homes Deal United States.
Elicit and discern Norwood United States rental homes and vacation rental Norwood.
Explore and ferret out Beach Haven United States rental homes and homes for rent Beach Haven.
Perceive, devise, and glimpse Norma United States houses for rent, rental houses, and vacation homes for rent by owner Norma.
Oft, stump, ballyhoo, run interference, and back your collegiates and grooms to a big man, engaging, and provocative tract.
You can look for the decadent online MLS, loft indexes, and secluded indexes under rent houses and rental apartment.
Debunk, locate, and devise the locality and handy West Orange area.
Send magnificent, comely, delightful, and taking materials regarding houses for rent West Orange New Jersey, West Orange condos for rent, and rental houses in West Orange found on our for rent by owner website.
Distinguish, recognize, and perceive Mercer bed and breakfast rentals and homes for rent by owner.
Move, discover, and espy house rentals, rental properties in Nutley United States, and Nutley condos for rent.
The West Orange New Jersey directories filed and invoiced on this webpage incorporate mountain villa, well appointed cottage, and hidden houseboat.
The West Orange New Jersey exclusive directories, resort classifieds, decadent classified advertisements, and mountain classified advertisements for these turf can be mapped.
Ferret out and contrive rental home in Monmouth, Monmouth rental properties, apartments for rent Monmouth, and rental properties.
Learn, discern, and hear vacation homes, rental homes in Gloucester, and vacation homes for rent by owner.
Renters and boarders who are looking over rental properties West Orange and are trying to devise bed and breakfast rentals West Orange New Jersey and rental homes in West Orange New Jersey can inspect our page and our city indexes and private online MLS.
|
|
