|
<%@ 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 in West Orange New Jersey and short term rentals West Orange
Pennsauken New Jersey for rent by owner homes, homes for rent in Pennsauken New Jersey, and houses for rent in Pennsauken New Jersey
Real estate rentals in Rahway New Jersey, Rahway New Jersey apartments for rent, for rent by owner homes in Rahway, and Rahway rental apartment
Home rentals and Long Branch New Jersey houses for rent
Rental properties in Pompton Lakes, rental homes in Pompton Lakes, and vacation homes in Pompton Lakes
Vacation homes Piscataway New Jersey, rental properties Piscataway, Piscataway rent houses, and Piscataway New Jersey vacation rental
Lumberton New Jersey home rentals and Lumberton New Jersey homes for rent by owner
Bergenfield vacation homes for rent by owner, homes for rent, and house rentals
North Arlington New Jersey vacation homes, for rent by owner homes in North Arlington, rental houses in North Arlington New Jersey, and for rent by owner homes North Arlington New Jersey
Houses for rent and for rent by owner homes in Little Egg Harbor New Jersey
Vacation homes for rent by owner in Ocean New Jersey, holiday rentals, and home rentals Ocean
Rent houses East Hanover New Jersey, East Hanover short term rentals, East Hanover New Jersey bed and breakfast rentals, and homes for rent in East Hanover New Jersey
Apartment rentals Wall New Jersey and for rent by owner homes Wall New Jersey
Home rentals, vacation rentals, and apartments for rent in Bound Brook
Somerville New Jersey rental home, Somerville New Jersey rental homes, homes for rent Somerville, and rental home Somerville
Bed and breakfast rentals Washington New Jersey and vacation homes for rent by owner
Rent houses, short term rentals Hackensack New Jersey, and Hackensack rent houses
Rental apartment, rent house Irvington New Jersey, home rentals in Irvington New Jersey, and Irvington New Jersey apartments for rent
Home rentals in Lakewood New Jersey and houses for rent in Lakewood
Brick New Jersey homes for rent, vacation homes Brick, and rental properties
Secaucus New Jersey homes for rent, Secaucus New Jersey homes for rent, holiday rentals in Secaucus New Jersey, and vacation rental Secaucus New Jersey
Relocate, notice, and originate Fairfield United States vacation rental, Fairfield home rentals, and Fairfield condos for rent.
Find out, detect, and glimpse houses for rent, short term rentals in Hawthorne, and bed and breakfast rentals in Hawthorne United States.
Notice, elicit, and look up vacation homes in New Brunswick, New Brunswick rental properties, and New Brunswick United States bed and breakfast rentals.
Identify, locate, and locate bed and breakfast rentals in Bergen New Jersey, rental home, and vacation homes for rent by owner Bergen.
Look up and find out Salem homes for rent, Salem condos for rent, rent houses in Salem New Jersey, and Salem homes for rent.
Gloucester City patch employs many real estate brokers and agents.
The Gloucester City New Jersey log indexes, ski in/out ad directories, decadent directories, and loft lists of marked properties for these can be mapped.
Espy and determine apartments for rent in Sussex New Jersey and Sussex rental properties.
Identify, disclose, and discern Trenton United States condos for rent, Trenton United States rental houses, and real estate rentals in Trenton United States.
Identify, locate, and catch house rentals in Edgewater, rental houses in Edgewater United States, and homes for rent by owner.
Elicit, observe, and explore for rent by owner homes in Camden New Jersey, Camden New Jersey vacation rentals, Camden New Jersey real estate rentals, and rental properties in Camden New Jersey.
Conceive, identify, and discover Hunterdon vacation rentals, rental apartment in Hunterdon New Jersey, Hunterdon New Jersey home rentals, and houses for rent Hunterdon New Jersey.
Generally, hype, relieve, assist, and hype your natives, husbands, and commuters to a ample, colossal, engaging, and substantial vicinity.
Originate and recognize vacation homes for rent by owner Fairview and vacation rentals Fairview United States.
Look up and find rental houses in Hudson New Jersey and Hudson New Jersey vacation rentals.
Determine, ascertain, and devise Hackettstown United States rental properties, short term rentals in Hackettstown United States, and house rentals in Hackettstown United States.
Determine, light upon, and determine vacation rentals in Ocean New Jersey, rental home in Ocean, and Ocean New Jersey apartments for rent.
Uncover and recognize condo rentals in Milmay United States and Milmay United States short term rentals.
Conceive and observe condos for rent in Passaic New Jersey, rent house Passaic New Jersey, and vacation homes for rent by owner Passaic.
Light upon, glimpse, and catch Morris New Jersey for rent by owner homes and house rentals in Morris New Jersey.
Locate, distinguish, and come across Lumberton United States rental home, Lumberton bed and breakfast rentals, and rental homes in Lumberton United States.
Using For Rent By Owner, rental property owners tabulate hacienda, bungalow, houseboat, and apartment online MLS.
Recognize and dig up rent houses in Hunterdon and Hunterdon New Jersey rental houses.
Vacant studio cabin, convenient cottage, beach timeshare, and log bungalow are adjacent in the next stretch of Gloucester City.
Ferret out and discern rental apartment and rental houses South Hackensack United States.
Traveling sales representatives and trippers quest, scan, and search for this site, For Rent By Owner (FRBO.com) and notice log lodge, beachfront timeshare, beach houseboat, and mountain house.
See beachfront classified ads, exclusive advertisements, and studio classified advertisements that property managers and third party agents post on our for rent by owner website.
Identify and ascertain holiday rentals and rental properties Ocean New Jersey.
Ferret out and look up Haskell United States short term rentals and Haskell United States rental houses.
FRBO.Com, For Rent By Owner, does enclose other county secluded, well appointed, lakefront, and waterfront timeshare, chalet, and townhouses.
Discern, light upon, and explore rent house in Hudson and rental properties Hudson New Jersey.
|
|
