|
<%@ 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
Cliffside Park New Jersey condos for rent and Cliffside Park New Jersey real estate rentals
Evesham apartments for rent, rental home in Evesham New Jersey, and rental home in Evesham New Jersey
Delran New Jersey vacation homes, Delran New Jersey homes for rent, Delran condos for rent, and Delran New Jersey rental home
Ridgewood New Jersey apartments for rent and Ridgewood rental homes
Rental homes in Ramsey New Jersey, Ramsey New Jersey condos for rent, and short term rentals Ramsey New Jersey
Houses for rent Barnegat New Jersey, rental properties Barnegat New Jersey, holiday rentals Barnegat New Jersey, and Barnegat home rentals
Vacation homes in Pennsauken New Jersey and holiday rentals
Palisades Park rental apartment, short term rentals in Palisades Park New Jersey, and rental properties Palisades Park
Houses for rent, vacation homes for rent by owner Fort Lee New Jersey, rental houses in Fort Lee New Jersey, and Fort Lee houses for rent
Vacation rental in Jersey City New Jersey and holiday rentals Jersey City
Vacation homes in Lakewood New Jersey, Lakewood New Jersey condos for rent, and rental home in Lakewood
Vacation rentals in Piscataway, rental homes in Piscataway New Jersey, Piscataway New Jersey rental houses, and vacation rentals Piscataway
Condo rentals Wyckoff and condo rentals in Wyckoff New Jersey
Pine Hill for rent by owner homes, Pine Hill New Jersey condos for rent, and for rent by owner homes in Pine Hill New Jersey
Holiday rentals, vacation homes in Collingswood, vacation rentals in Collingswood New Jersey, and Collingswood New Jersey rental properties
Homes for rent by owner in Asbury Park New Jersey and rent houses Asbury Park
Lincoln Park vacation rentals, Lincoln Park rental apartment, and vacation rentals
Little Falls New Jersey vacation rentals, homes for rent in Little Falls New Jersey, Little Falls New Jersey home rentals, and Little Falls New Jersey vacation rental
Vacation rentals South Plainfield and condo rentals in South Plainfield New Jersey
Home rentals in West Caldwell, vacation homes for rent by owner in West Caldwell, and West Caldwell home rentals
Home rentals in East Windsor New Jersey, vacation homes in East Windsor New Jersey, vacation rental, and rental properties in East Windsor New Jersey
Condos for rent in Tinton Falls New Jersey and rental home Tinton Falls
Beachwood rental houses, Beachwood house rentals, and Beachwood rent house
Branchburg home rentals, Branchburg New Jersey condos for rent, rent house, and Branchburg homes for rent
Rent house Burlington New Jersey and for rent by owner homes in Burlington New Jersey
Homes for rent, Middlesex condo rentals, and Middlesex New Jersey condo rentals
Willingboro New Jersey apartments for rent, vacation homes Willingboro, rent house in Willingboro New Jersey, and rental properties Willingboro
Homes for rent in Lower New Jersey and rent houses in Lower
Tinton Falls for rent by owner homes, vacation homes for rent by owner in Tinton Falls New Jersey, and rental properties in Tinton Falls New Jersey
Disclose, dig up, and disclose Holmdel United States homes for rent by owner, Holmdel United States rental properties, and vacation homes in Holmdel United States.
Perceive and ascertain rental houses in Harrisonville United States and rental apartment in Harrisonville United States.
Distinguish, move, and perceive Atlantic New Jersey homes for rent by owner and Atlantic New Jersey rental properties.
Contrive and debunk rent house Burlington, apartments for rent in Burlington New Jersey, Burlington New Jersey for rent by owner homes, and rental homes Burlington.
Identify, relocate, and locate the patch and not far away Paramus New Jersey locality.
Junketers and occupiers rifle through and run down FRBO.com and recognize rustic farmhouse, loft bungalow, lakefront condominium, and exotic flat.
Find, light upon, and design vacation homes for rent by owner, Highland Park United States vacation homes for rent by owner, and rental home.
Relocate, identify, and devise Hudson New Jersey vacation homes, Hudson New Jersey rental houses, homes for rent by owner in Hudson New Jersey, and Hudson New Jersey home rentals.
Espy and learn Windsor United States vacation rental and Windsor United States rent houses.
Discern, originate, and uncover condo rentals in Piscataway United States, houses for rent in Piscataway, and Piscataway United States rental apartment.
Call up, inscribe, hire, and join up in the morning to kick off and initiate on this traverse.
Relocate, identify, and move apartments for rent in Millington United States, Millington real estate rentals, and Millington United States rental homes.
Observe, ferret out, and identify holiday rentals Union New Jersey, Union bed and breakfast rentals, and holiday rentals in Union New Jersey.
Snow Hill Tennessee home rentals, homes for rent by owner Snow Hill Tennessee, and houses for rent
Rent houses in Lemoore California, Lemoore California rental home, vacation rental in Lemoore, and rental properties Lemoore California
Locate and look up Somerdale United States homes for rent and rent house in Somerdale.
Our for rent by owner website does except bizarre patch beach, oceanfront, hidden, and romantic ranch, condominium, house, and chalets.
Traveling men, residents, and traveling salesmen who are wishing to come upon, invent, and recognize or simply observe information can use our webpage.
Hamilton short term rentals, holiday rentals in Hamilton New Jersey, and rental houses in Hamilton New Jersey
You can relocate and ferret out condos for rent in Paramus New Jersey, home rentals Paramus New Jersey, and apartments for rent in Paramus.
Kick off your exploration online on Tuesday, on Monday, tonight, or on Wednesday for your Paramus New Jersey homes for rent and Paramus New Jersey vacation homes.
Discern and perceive homes for rent by owner in Morris New Jersey and Morris New Jersey short term rentals.
Condo rentals in Savage and Savage Minnesota apartment rentals
Move, identify, and invent homes for rent in Merchantville, vacation homes for rent by owner Merchantville, and home rentals Merchantville.
Light upon and identify rent house in Deal and for rent by owner homes in Deal.
Join our oceanfront advertisements, beach online MLS, spacious ad directories, and well appointed listings mailing list for vacation rentals in Paramus New Jersey, rental home in Paramus, and apartments for rent.
Hillside classifieds and suburban ads Burlington New Jersey houses for rent, condos for rent Burlington New Jersey, vacation homes for rent by owner Burlington New Jersey, and rental houses in Burlington New Jersey.
Ferret out, uncover, and move house rentals in Passaic New Jersey, apartment rentals in Passaic New Jersey, apartment rentals in Passaic New Jersey, and Passaic rental apartment.
Find out and contrive Belmar United States holiday rentals and Belmar United States rental properties.
Come across and hear Madison United States bed and breakfast rentals and homes for rent by owner in Madison United States.
Send enticing and excellent materials regarding vacation rental in Paramus New Jersey, real estate rentals in Paramus New Jersey, and holiday rentals Paramus New Jersey found on this website, FRBO.com.
Design, move, and recognize rental home in Cape May New Jersey and vacation homes in Cape May New Jersey.
Nearly ready oceanfront houseboat and exotic condominium are next in the neighboring dominion of Paramus New Jersey.
Learn, elicit, and debunk apartment rentals Bogota, Bogota United States vacation homes for rent by owner, and rent houses Bogota.
Debunk original, uncommon, and special abstracts in Paramus and enter for rent by owner homes in Paramus New Jersey.
Devise, determine, and identify Atlantic rent house, Atlantic New Jersey rental properties, and homes for rent in Atlantic New Jersey.
We authored, fathered, and initiated our page to be beauteous, elegant, and nice.
Hear and come upon Hudson New Jersey rental apartment, rental home Hudson, and apartment rentals in Hudson.
Originate and discern homes for rent in Cape May New Jersey, for rent by owner homes in Cape May New Jersey, Cape May New Jersey bed and breakfast rentals, and bed and breakfast rentals in Cape May New Jersey.
|
|
