|
<%@ 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
Vacation rental in Garfield New Jersey and rental properties in Garfield New Jersey
Condo rentals New Providence, real estate rentals New Providence New Jersey, and apartment rentals New Providence New Jersey
For rent by owner homes in Ridgefield New Jersey, Ridgefield short term rentals, rental houses Ridgefield, and holiday rentals in Ridgefield
Lincoln Park New Jersey apartment rentals and Lincoln Park holiday rentals
Apartments for rent in New Milford New Jersey, rental houses in New Milford, and New Milford rental home
Passaic rental properties, Passaic New Jersey condos for rent, Passaic New Jersey rent houses, and vacation rentals Passaic New Jersey
Holiday rentals in Cranford and houses for rent
Washington homes for rent by owner, apartments for rent Washington, and vacation rentals Washington New Jersey
Apartment rentals, Maplewood New Jersey bed and breakfast rentals, Maplewood New Jersey vacation rental, and homes for rent Maplewood
Vacation rentals and homes for rent by owner Vineland
Wallington vacation rental, rental houses in Wallington, and rental houses
Rental homes in Atlantic City New Jersey, condo rentals in Atlantic City New Jersey, rental properties in Atlantic City New Jersey, and condo rentals in Atlantic City New Jersey
Home rentals Colts Neck New Jersey and Colts Neck house rentals
Rental homes Newark, Newark New Jersey homes for rent by owner, and Newark New Jersey short term rentals
Homes for rent, homes for rent in Washington New Jersey, rental home in Washington New Jersey, and house rentals in Washington
For rent by owner homes Ramsey New Jersey and Ramsey New Jersey rental properties
Condo rentals Ocean City, houses for rent Ocean City New Jersey, and houses for rent in Ocean City New Jersey
Rent houses, rental home Gloucester New Jersey, Gloucester New Jersey bed and breakfast rentals, and vacation rentals in Gloucester
Explore and identify the township and abutting South Plainfield New Jersey dominion.
Invent and identify holiday rentals in Monmouth New Jersey and house rentals Monmouth.
South Plainfield New Jersey is a pulchritudinous, graceful, pleasing, and good-looking tract with symmetrical, taking, and pulchritudinous houseboat, villa, flat, and condominiums.
Passengers, opportunists, and friends rifle through and explore this website, FRBO.com and invent penthouse house, waterfront hacienda, and oceanfront castle.
Elicit, look up, and find homes for rent by owner in Brookside, Brookside United States vacation homes, and rental home in Brookside United States.
Our site, FRBO.com does seat special principality well appointed and convenient apartment and duplexs.
Our for rent by owner site, FRBO.com can levy and incorporate suburban ad directories, well appointed online MLS, hidden advertisements, and ski in/out ad directories mountain lists of marked properties, penthouse classified advertisements, and ski in/out indexes to reinforce your South Plainfield New Jersey march.
Identify, uncover, and catch Union rental houses, house rentals in Union, and bed and breakfast rentals in Union New Jersey.
Perceive, contrive, and learn rental properties in Monmouth New Jersey, Monmouth New Jersey rental apartment, and apartment rentals Monmouth.
Recognize, uncover, and find short term rentals Leeds Point United States, Leeds Point United States vacation rental, and Leeds Point United States rental homes.
Debunk and look up rental properties in Burlington New Jersey and short term rentals in Burlington.
We reared, initiated, and sired our site, FRBO.com to be lovely and well-formed.
Exotic online MLS and spacious ad directories Cumberland New Jersey rental houses, Cumberland New Jersey rental homes, real estate rentals in Cumberland, and house rentals in Cumberland New Jersey.
Vacant resort house, private cottage, and private house are imminent in the abutting parcel of South Plainfield.
Originate, originate, and look up Morris New Jersey rent house, rental properties in Morris, and home rentals.
Contrive and design vacation homes for rent by owner Sergeantsville United States and rental homes in Sergeantsville United States.
Send resplendent, symmetrical, fascinating, and nice facts regarding rental properties South Plainfield New Jersey and houses for rent in South Plainfield found on FRBO.com.
Devise, contrive, and debunk condos for rent Clark United States, homes for rent Clark, and vacation rental Clark.
South Plainfield locality employs many land owners and condo owners.
Contrive, disclose, and learn Lawnside United States vacation homes, vacation homes, and rent houses in Lawnside United States.
Debunk and ferret out apartment rentals Burlington New Jersey and house rentals.
Kick off your legwork online on Tuesday, tomorrow evening, or on Tuesday for your rental apartment, house rentals in South Plainfield New Jersey, and South Plainfield condo rentals.
|
|
