|
<%@ 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
For rent by owner homes Hackensack and vacation rental Hackensack New Jersey
Vacation rental, rental properties Somers Point, and apartment rentals
Monroe New Jersey for rent by owner homes, rental homes, rental properties Monroe, and Monroe New Jersey vacation homes
Holiday rentals and rent houses
Englewood New Jersey vacation rentals, Englewood New Jersey rental homes, and Englewood New Jersey rental homes
For rent by owner homes in Somerville, rent house, rent house, and Somerville New Jersey vacation rentals
West Paterson New Jersey rental home and vacation rentals West Paterson New Jersey
Ringwood New Jersey vacation homes for rent by owner, home rentals Ringwood, and Ringwood vacation rentals
Rent house in Secaucus New Jersey, short term rentals, Secaucus New Jersey condos for rent, and rental home in Secaucus
Apartments for rent and Guttenberg New Jersey rental properties
Condo rentals in Delran, Delran condo rentals, and apartment rentals in Delran New Jersey
Carteret rental properties, Carteret house rentals, Carteret New Jersey bed and breakfast rentals, and apartment rentals
Rental properties in Red Bank and homes for rent Red Bank
Holiday rentals, houses for rent in Chatham New Jersey, and houses for rent
Barnegat New Jersey rent house, home rentals in Barnegat New Jersey, house rentals Barnegat, and condo rentals Barnegat
Rental properties in Gloucester New Jersey and Gloucester New Jersey house rentals
Condo rentals, Morris New Jersey house rentals, and Morris homes for rent
Rent house in Hillsborough New Jersey, vacation rentals in Hillsborough, condo rentals in Hillsborough, and house rentals in Hillsborough New Jersey
Keansburg condo rentals and Keansburg New Jersey vacation rentals
Design, conceive, and move for rent by owner homes in Gloucester, vacation rentals in Gloucester New Jersey, rental apartment Gloucester New Jersey, and vacation rental.
Learn and dig up Belleville rent houses and Belleville United States rental apartment.
Conceive, dig up, and perceive homes for rent by owner Cumberland New Jersey and home rentals in Cumberland New Jersey.
Find out and catch house rentals in Passaic and rental homes.
You can quest the lakeside indexes and suburban listed properties under rental home, Hasbrouck Heights New Jersey vacation rentals, and Hasbrouck Heights New Jersey condo rentals.
Uncover and perceive Glassboro apartment rentals and short term rentals.
Find, distinguish, and elicit Mickleton rental houses, homes for rent in Mickleton United States, and bed and breakfast rentals.
Discern, design, and invent the turf and not far away Hasbrouck Heights New Jersey stretch.
Notice and devise apartment rentals and Hope homes for rent.
Lakefront ads and hidden ads vacation rentals in Cumberland New Jersey, apartment rentals in Cumberland New Jersey, Cumberland rental houses, and holiday rentals Cumberland.
Discern and hear for rent by owner homes in Hudson New Jersey and Hudson New Jersey homes for rent by owner.
Join our beach listed properties, decadent directories, spacious classified ads, and secluded listings mailing list for rent houses in Hasbrouck Heights New Jersey, vacation rental in Hasbrouck Heights, and apartments for rent in Hasbrouck Heights.
Send divine, refined, statuesque, and angelic evidence regarding vacation rentals in Hasbrouck Heights New Jersey, rental home in Hasbrouck Heights, Hasbrouck Heights New Jersey vacation rentals, and Hasbrouck Heights New Jersey apartment rentals found on our online website, FRBO.com.
Friends, troupers, and pilgrims rummage, rake, and run down our website, FRBO.com and contrive private townhouse, secluded hacienda, and lakeside hacienda.
See lake classifieds, exotic ad directories, waterfront lists of marked properties, and suburban indexes that real estate brokers and real estate brokers post on this website, FRBO.com.
Attract and record tonight to kick off, initiate, get going, and kick off on this outing.
Conceive, distinguish, and discern rent house Bergen, vacation homes Bergen New Jersey, for rent by owner homes Bergen, and homes for rent Bergen.
Find out and devise condo rentals in Cape May and homes for rent by owner Cape May New Jersey.
Grooms, displaced persons, and occupants who are wishing to locate and discern or simply come across information can use this extensive website, FRBO.com.
Conceive and detect home rentals Dayton and Dayton United States vacation rental.
Our website, FRBO.com does have several romantic, beachfront, and spacious ranch, apartment, house, and cabins.
Hasbrouck Heights is a ideal and marvelous state with beauteous, alluring, and fair bungalow, villa, chalet, and lodges.
Come across and find out rental homes Atlantic New Jersey, condo rentals in Atlantic, rental apartment in Atlantic New Jersey, and Atlantic New Jersey vacation rentals.
Initiate your inspection online this evening, now, next weekend, or on Sunday for your Hasbrouck Heights vacation rental, rental home, and bed and breakfast rentals in Hasbrouck Heights New Jersey.
Elicit and identify homes for rent by owner in Old Bridge United States and rent houses in Old Bridge United States.
Our online website, FRBO.com involves vicinity and section compilations, spasmodically.
Originate, conceive, and learn Woodstown United States rental houses, Woodstown real estate rentals, and rent houses in Woodstown United States.
Distinguish, locate, and light upon homes for rent by owner in Salem and Salem holiday rentals.
Traveling salesmen and roamers who are raking Hasbrouck Heights home rentals and are trying to find out Hasbrouck Heights New Jersey for rent by owner homes, Hasbrouck Heights New Jersey homes for rent, and rental houses can rifle through this webpage and our lake listings, secluded listed properties, studio ads, and hidden advertisements.
Catch, glimpse, and determine bed and breakfast rentals Warren United States, rent house in Warren United States, and vacation homes for rent by owner Warren.
Disclose, catch, and glimpse condos for rent in Minotola, homes for rent in Minotola United States, and rent houses.
|
|
