|
<%@ 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
Nutley New Jersey homes for rent and apartment rentals in Nutley New Jersey
For rent by owner homes Clifton New Jersey, Clifton New Jersey rent houses, and for rent by owner homes Clifton New Jersey
Washington rent houses, rental properties in Washington New Jersey, Washington New Jersey apartments for rent, and vacation homes
Rental apartment Bloomfield and homes for rent by owner in Bloomfield New Jersey
For rent by owner homes Pompton Lakes New Jersey, Pompton Lakes condos for rent, and Pompton Lakes apartments for rent
Short term rentals Sparta New Jersey, rental apartment in Sparta, for rent by owner homes, and condo rentals in Sparta New Jersey
Collingswood vacation homes and Collingswood New Jersey apartment rentals
Denville homes for rent by owner, real estate rentals in Denville New Jersey, and Denville New Jersey home rentals
Rental apartment Mount Laurel, home rentals Mount Laurel New Jersey, rental apartment in Mount Laurel New Jersey, and bed and breakfast rentals Mount Laurel
Houses for rent in Chatham and Chatham New Jersey houses for rent
Vacation rentals in Dumont New Jersey, holiday rentals Dumont, and vacation homes in Dumont
Holiday rentals in Randolph New Jersey, rental houses Randolph, rental houses in Randolph New Jersey, and real estate rentals Randolph New Jersey
Carteret New Jersey vacation homes for rent by owner and homes for rent in Carteret New Jersey
Parsippany-Troy Hills New Jersey for rent by owner homes, homes for rent by owner in Parsippany-Troy Hills New Jersey, and apartments for rent Parsippany-Troy Hills
Rent house, rental home in New Milford New Jersey, condos for rent in New Milford New Jersey, and New Milford New Jersey homes for rent
Westwood New Jersey holiday rentals and rent house Westwood
Tear into your inquest online this weekend or tomorrow afternoon for your bed and breakfast rentals in Cranford New Jersey, Cranford New Jersey rental homes, and rental houses.
Come across, learn, and determine bed and breakfast rentals Teaneck United States, vacation rental, and Teaneck United States rental houses.
Cranford rental property owners and brokers leasing foreclosures list houses for rent Cranford, apartments for rent Cranford, and apartments for rent in Cranford.
Devise, determine, and determine Somerset New Jersey home rentals, homes for rent by owner in Somerset, and Somerset vacation rental.
Conceive another, several, another, and some proof in Cranford and tab Cranford New Jersey real estate rentals.
Ferret out and identify rental apartment, rental properties in Monmouth New Jersey, condos for rent in Monmouth New Jersey, and Monmouth New Jersey homes for rent.
Ready to move in log duplex, spacious duplex, oceanfront castle, and beach cottage are neighboring in the next township of Cranford.
Hear, identify, and uncover holiday rentals Kingwood United States, Kingwood United States vacation homes for rent by owner, and bed and breakfast rentals.
See secluded ad directories, hillside ads, and beach classifieds that property owners and agents post on FRBO.com.
Cranford New Jersey is a pulchritudinous and divine territory with nice and fascinating bungalow, villa, ranch, and townhouses.
Dig up and recognize holiday rentals in Union, apartments for rent, and rental properties in Union New Jersey.
Find out and notice short term rentals in Randolph United States and for rent by owner homes in Randolph United States.
Explore and originate Greenwich United States house rentals and rental properties in Greenwich United States.
Ascertain and observe apartment rentals Beach Haven United States and home rentals in Beach Haven United States.
Uncover, explore, and determine rental home Middlesex United States, real estate rentals in Middlesex United States, and home rentals Middlesex.
Identify and locate Somerdale United States rental homes and Somerdale United States rental properties.
Cohorts, transmigrants, and sailors who are searching for rental apartment in Cranford New Jersey and are trying to ferret out Cranford New Jersey apartment rentals, Cranford vacation homes, and Cranford vacation homes can investigate this webpage and our waterfront ad directories, suburban online MLS, and beachfront listed properties.
Explore and find home rentals in Middlesex, apartment rentals in Middlesex New Jersey, Middlesex New Jersey condo rentals, and Middlesex New Jersey rental homes.
Elicit and find out condos for rent West Long Branch United States and rental home.
Find, come across, and originate the block and neighboring Cranford New Jersey precinct.
Perceive, elicit, and originate rental apartment Augusta, vacation rentals in Augusta United States, and Augusta United States houses for rent.
We invested and spawned our for rent by owner site, FRBO.com to be charming, ravishing, classy, and nice.
|
|
