|
<%@ 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
Houses for rent in North Bergen New Jersey and house rentals in North Bergen New Jersey
For rent by owner homes Westfield, rental homes Westfield New Jersey, and Westfield New Jersey vacation homes for rent by owner
Real estate rentals Stafford, Stafford rental apartment, real estate rentals in Stafford New Jersey, and Stafford New Jersey house rentals
Millburn houses for rent and apartment rentals in Millburn
Vacation rentals, real estate rentals, and Asbury Park New Jersey holiday rentals
Holiday rentals in Wall, house rentals, house rentals, and Wall houses for rent
Waterford New Jersey rental homes and Waterford New Jersey rental home
Apartment rentals Carteret New Jersey, Carteret New Jersey homes for rent by owner, and apartments for rent Carteret New Jersey
South Brunswick rent houses, South Brunswick New Jersey rental houses, condo rentals South Brunswick, and house rentals South Brunswick
Hopatcong holiday rentals and rental apartment in Hopatcong New Jersey
Millburn vacation homes, Millburn New Jersey rental properties, and Millburn vacation homes
Rental homes in Cliffside Park, houses for rent Cliffside Park New Jersey, rental properties in Cliffside Park New Jersey, and Cliffside Park apartment rentals
House rentals Clark New Jersey and rental home in Clark New Jersey
Rental houses in Delran, houses for rent Delran, and rental houses in Delran New Jersey
Palisades Park New Jersey apartments for rent, Palisades Park rental apartment, Palisades Park New Jersey homes for rent, and Palisades Park home rentals
Linden vacation rental and holiday rentals
Bellmawr New Jersey homes for rent by owner, Bellmawr New Jersey vacation rentals, and houses for rent Bellmawr New Jersey
Send fine, marvelous, and well-formed conclusions regarding homes for rent in Bridgewater, Bridgewater New Jersey holiday rentals, Bridgewater apartments for rent, and Bridgewater New Jersey rent house found on this extensive website, FRBO.com.
Come upon various and distinctive score in Bridgewater and register holiday rentals.
FRBO.Com, For Rent By Owner, does incorporate specific block beach, oceanfront, romantic, and loft bungalow and condominiums.
Bridgewater New Jersey patch employs many third party listing companies, real estate brokers, and real estate investors.
The Bridgewater New Jersey ads docketed and buttoned down on this extensive website, FRBO.com hold well appointed chalet, secluded home, hidden cottage, and romantic bungalow.
Glimpse, look up, and detect houses for rent in Clarksboro United States, rent houses Clarksboro United States, and Clarksboro United States rental homes.
Hikers and boarders who are probing condos for rent and are trying to catch rental homes in Bridgewater New Jersey and apartment rentals in Bridgewater New Jersey can look for our online website, FRBO.com and our lakefront indexes, beachfront indexes, exclusive ads, and exclusive classifieds.
Disclose, perceive, and espy Camden rent house, Camden vacation homes, and rental homes in Camden New Jersey.
Take on, get, hire, and list in the morning to take up, lead off, tear into, and tear into on this run.
Explore and discover Rutherford United States house rentals and bed and breakfast rentals in Rutherford United States.
Notice and discover Atlantic New Jersey home rentals, Atlantic New Jersey rental properties, and Atlantic New Jersey holiday rentals.
Vacant city castle, hillside flat, well appointed townhouse, and exclusive cottage are adjoining in the not far away quarter of Bridgewater New Jersey.
Twins, sightseers, and possessors look for, seek, and root this extensive website, FRBO.com and recognize romantic villa, loft house, lakeside villa, and lakeside ranch.
Using this website, FRBO.com, landlords inventory cabin, home, and hacienda classified ads.
Observe, disclose, and identify Mercer New Jersey vacation homes for rent by owner, Mercer New Jersey apartments for rent, Mercer New Jersey rent houses, and holiday rentals in Mercer New Jersey.
Hear and ferret out Glendora United States vacation homes and Glendora United States rental homes.
Find, elicit, and glimpse holiday rentals Sussex, short term rentals, and Sussex New Jersey rental properties.
Bridgewater agents, property brokers, condo owners, and condo owners list vacation rentals in Bridgewater New Jersey, Bridgewater rent house, and apartments for rent.
Discover and notice Union New Jersey vacation homes for rent by owner and Union New Jersey home rentals.
Notice, look up, and come upon rental apartment in Warren and Warren New Jersey holiday rentals.
Find out and design vacation rental in Audubon and vacation homes for rent by owner.
Devise and find out Atlantic New Jersey rental properties and bed and breakfast rentals in Atlantic New Jersey.
Invent and recognize home rentals Somerset New Jersey, rental home Somerset New Jersey, Somerset New Jersey rental properties, and apartment rentals in Somerset New Jersey.
Explore and come across rent houses in Mercer, rental home in Mercer, and Mercer vacation homes.
Notice and debunk real estate rentals Fortescue United States and homes for rent by owner Fortescue.
Join our secluded advertisements and penthouse classifieds mailing list for Bridgewater New Jersey for rent by owner homes, holiday rentals, and home rentals in Bridgewater New Jersey.
You can inspect the private classifieds and mountain ad directories under Bridgewater New Jersey apartment rentals and rental home Bridgewater.
See log lists of marked properties, hillside classified ads, lakeside advertisements, and lakefront classified ads that town home owners and land owners post on FRBO.com.
Catch and espy Freehold vacation homes for rent by owner and vacation homes for rent by owner Freehold.
We built and contrived our online website, FRBO.com to be delightful and graceful.
Bridgewater New Jersey is a graceful, charming, stunning, and lovely sector with excellent and marvelous ranch, castle, and chalets.
Recognize, ascertain, and observe homes for rent in Gloucester New Jersey and Gloucester New Jersey homes for rent by owner.
Find out and ferret out Teterboro United States rental homes and for rent by owner homes in Teterboro United States.
You can find out and recognize homes for rent in Bridgewater New Jersey and rental houses in Bridgewater New Jersey.
|
|
