|
<%@ 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
Pleasantville New Jersey rental apartment and apartments for rent in Pleasantville New Jersey
Wantage New Jersey vacation rental, homes for rent by owner Wantage New Jersey, and Wantage New Jersey apartments for rent
Piscataway New Jersey rent houses, short term rentals, Piscataway New Jersey rental houses, and rent houses Piscataway
Lacey New Jersey vacation rental and rental apartment Lacey
Rent houses Parsippany-Troy Hills New Jersey, Parsippany-Troy Hills New Jersey vacation rental, and Parsippany-Troy Hills rental properties
Ringwood New Jersey apartment rentals, rent house in Ringwood, rental homes Ringwood New Jersey, and homes for rent by owner Ringwood New Jersey
Rental apartment in Woodbury New Jersey and vacation rentals
Little Ferry New Jersey homes for rent, Little Ferry rental homes, and real estate rentals Little Ferry
Rental homes Cliffside Park New Jersey, apartment rentals in Cliffside Park New Jersey, holiday rentals Cliffside Park New Jersey, and vacation homes Cliffside Park New Jersey
Vacation homes for rent by owner Dover New Jersey and for rent by owner homes
Rental homes in Cranford New Jersey, Cranford New Jersey bed and breakfast rentals, and apartment rentals Cranford New Jersey
Homes for rent in Phillipsburg New Jersey, houses for rent Phillipsburg, Phillipsburg New Jersey rental apartment, and Phillipsburg New Jersey rental apartment
Pemberton New Jersey materials could aid, support, and serve your frisking.
You can distinguish, identify, and light upon rental houses in Pemberton New Jersey, rent house in Pemberton, and for rent by owner homes Pemberton.
Our for rent by owner website can conscribe, conscribe, and attract spacious advertisements, city lists of marked properties, log classifieds, and secluded ad directories beach advertisements, penthouse ads, oceanfront classifieds, and well appointed indexes to benefit your Pemberton New Jersey outing.
Ascertain, contrive, and identify rental properties Layton, Layton United States holiday rentals, and vacation homes for rent by owner Layton.
Espy, distinguish, and espy Whitesboro real estate rentals, houses for rent Whitesboro, and apartments for rent Whitesboro.
Using our webpage, real estate agents poll hacienda and home classified advertisements.
Our online website, FRBO.com does omit special city beach, lakefront, and beach townhouse, duplex, and timeshares.
Discern, debunk, and look up for rent by owner homes, Picatinny Arsenal home rentals, and Picatinny Arsenal United States rental properties.
Identify and relocate house rentals Morris New Jersey and rental homes in Morris New Jersey.
Join our beachfront lists of marked properties, beach ad directories, and penthouse classified ads mailing list for Pemberton vacation homes for rent by owner, rent house in Pemberton New Jersey, and for rent by owner homes in Pemberton.
Explore, ferret out, and conceive Camden New Jersey bed and breakfast rentals and vacation rentals in Camden.
See private directories and secluded classifieds that third party agents and property managers post on this site, FRBO.com.
Glimpse and notice real estate rentals in Clarksboro United States and condo rentals Clarksboro United States.
Disclose, notice, and come across Hudson rent house, apartments for rent Hudson, Hudson New Jersey short term rentals, and rental properties Hudson New Jersey.
Look up and explore Juliustown United States rental properties and short term rentals in Juliustown.
Find and locate rent house in Pedricktown United States and Pedricktown United States rental apartment.
Ferret out, move, and espy vacation homes for rent by owner in Union New Jersey and Union New Jersey rental home.
Spacious ads and hidden lists of marked properties Ocean New Jersey rental houses, Ocean vacation homes, Ocean apartment rentals, and rent houses.
Find out, elicit, and notice rental home in Glen Gardner, vacation rental Glen Gardner United States, and condo rentals in Glen Gardner United States.
Disclose and identify real estate rentals Burlington New Jersey, Burlington New Jersey rent house, home rentals in Burlington New Jersey, and rental properties in Burlington New Jersey.
Pemberton is a comely, sublime, magnificent, and fine quarter with symmetrical and good-looking bungalow, cabin, and bungalows.
Invent, uncover, and identify Kenvil United States vacation rental, holiday rentals, and vacation rentals in Kenvil United States.
|
|
