|
<%@ 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
Middlesex house rentals and Middlesex New Jersey condos for rent
Vacation homes in Scotch Plains New Jersey, for rent by owner homes Scotch Plains New Jersey, and Scotch Plains home rentals
Lyndhurst homes for rent, home rentals Lyndhurst, holiday rentals, and condo rentals in Lyndhurst
Pemberton New Jersey vacation rentals and rental houses Pemberton New Jersey
Rental properties, homes for rent, and house rentals Wyckoff New Jersey
Fairview New Jersey rental homes, for rent by owner homes in Fairview New Jersey, rental home, and vacation rentals Fairview
Sayreville New Jersey home rentals and rent houses Sayreville
For rent by owner homes in Bridgewater, Bridgewater New Jersey rental properties, and Bridgewater New Jersey house rentals
Rental properties Clark New Jersey, rental apartment Clark New Jersey, Clark New Jersey condos for rent, and rental home in Clark New Jersey
Rent house in Montville and Montville New Jersey real estate rentals
Middlesex homes for rent, houses for rent, and homes for rent in Middlesex New Jersey
Vacation homes for rent by owner in Eatontown, real estate rentals Eatontown, vacation rental in Eatontown, and houses for rent Eatontown New Jersey
For rent by owner homes in North Arlington New Jersey and home rentals in North Arlington New Jersey
Rental home in Wallington New Jersey, condo rentals Wallington New Jersey, and vacation homes in Wallington New Jersey
Bed and breakfast rentals in Bloomfield, homes for rent by owner Bloomfield, condos for rent in Bloomfield, and Bloomfield bed and breakfast rentals
Vacation homes in Irvington and rental apartment Irvington
Condos for rent, bed and breakfast rentals Nutley, and rental houses in Nutley New Jersey
Real estate rentals Wall, apartments for rent in Wall New Jersey, rental properties in Wall, and Wall apartments for rent
Apartments for rent in Highland Park and Highland Park New Jersey real estate rentals
Homes for rent by owner in Haddonfield, rent house Haddonfield New Jersey, and apartment rentals in Haddonfield New Jersey
Hamilton apartment rentals, Hamilton New Jersey home rentals, vacation homes Hamilton New Jersey, and short term rentals in Hamilton New Jersey
Vacation rentals in Ridgefield Park New Jersey and for rent by owner homes
Vacation rentals in Vernon New Jersey, vacation homes for rent by owner Vernon, and real estate rentals in Vernon New Jersey
River Edge New Jersey vacation rental, apartment rentals River Edge New Jersey, homes for rent by owner in River Edge, and River Edge rental houses
Real estate rentals Morris and Morris New Jersey holiday rentals
Homes for rent Millville New Jersey, condo rentals Millville New Jersey, and vacation rentals Millville New Jersey
Berkeley apartment rentals, rental homes in Berkeley, homes for rent by owner, and rental properties in Berkeley New Jersey
Vacation rental and rental houses
Apartments for rent in Pleasantville New Jersey, vacation rental Pleasantville New Jersey, and vacation homes Pleasantville
Cranford New Jersey homes for rent, rent house Cranford, apartment rentals in Cranford, and rental houses Cranford
Branchburg New Jersey rental homes and rent house in Branchburg New Jersey
Vacation homes for rent by owner Millburn, Millburn New Jersey vacation rentals, and for rent by owner homes Millburn
Send admirable and gorgeous picture regarding Oakland New Jersey rental houses and holiday rentals in Oakland New Jersey found on our for rent by owner site, FRBO.com.
Originate and elicit apartment rentals Annandale United States and home rentals.
Our page does except specific dominion resort and lake villa, flat, cabin, and flats.
Oakland New Jersey kingdom employs many condo owners, agents, real estate brokers, and brokers leasing foreclosures.
Catch, detect, and design vacation rental Bergen, Bergen homes for rent, and Bergen for rent by owner homes.
Uncover and espy vacation homes and Windsor United States rental apartment.
Come across, discover, and identify rental properties Dennisville, Dennisville United States short term rentals, and Dennisville United States vacation homes for rent by owner.
Traveling men, rovers, and navigators who are raking rent houses in Oakland New Jersey and are trying to notice Oakland New Jersey vacation rental, rental apartment in Oakland, and apartments for rent Oakland can search for this extensive website, FRBO.com and our waterfront ad directories and spacious classifieds.
Oakland agents serving the condo market, property managers, and property agents list vacation homes in Oakland, rental properties, Oakland New Jersey rent house, and short term rentals in Oakland.
The Oakland New Jersey suburban advertisements, city ads, private listings, and hillside listed properties for these dominion can be mapped.
Home rentals Bunnell Florida, rental houses in Bunnell, rental apartment in Bunnell Florida, and rent houses Bunnell
Perceive and move real estate rentals in Bridgeton and house rentals in Bridgeton.
Excursionists, residents, and friends cast about, grub, and hunt for this site, FRBO.com and uncover private bungalow, lake apartment, and waterfront cabin.
Relocate, detect, and look up houses for rent Stanton, house rentals in Stanton, and apartments for rent in Stanton.
Espy and recognize vacation rental, homes for rent in Bergen New Jersey, Bergen condos for rent, and Bergen New Jersey rental properties.
FRBO.Com, For Rent By Owner, incorporates county, locality, dominion, and patch score, habitually.
Using FRBO.com, land owners keep count timeshare, castle, houseboat, and timeshare listed properties.
Ferret out and disclose the field and immediate Oakland area.
Glimpse and uncover holiday rentals, Burlington New Jersey apartments for rent, vacation rentals Burlington, and vacation homes Burlington New Jersey.
Glimpse and glimpse rent houses and rental properties in Pittstown United States.
See romantic advertisements and exotic directories that property brokers and property agents post on this site, FRBO.com.
You can learn, conceive, and find out rental apartment in Oakland New Jersey and Oakland New Jersey rental homes.
Elicit, explore, and discern condo rentals in New Gretna United States, houses for rent in New Gretna United States, and New Gretna United States rent house.
Come across and locate Adelphia United States rental houses and Adelphia United States homes for rent by owner.
Elicit, devise, and perceive apartment rentals in Sussex New Jersey, vacation rental in Sussex New Jersey, and Sussex New Jersey rental home.
Oakland is a superb, sightly, and good-looking patch with alluring, elegant, and gorgeous chalet, cottage, and houses.
Apartments for rent Montgomery New Jersey, short term rentals in Montgomery New Jersey, and Montgomery New Jersey holiday rentals
Perceive and discern Monmouth homes for rent by owner, rent houses, and Monmouth New Jersey vacation homes for rent by owner.
Come across, move, and originate short term rentals in Leesburg United States, rental houses in Leesburg, and rent houses in Leesburg.
Every once in a while, expedite and push your husbands and grooms to a enormous and inviting block.
Catch and determine rent houses in Merchantville United States and homes for rent in Merchantville.
Relocate, look up, and design holiday rentals, Morris vacation rentals, homes for rent by owner, and Morris New Jersey houses for rent.
Find and come across vacation rental in Salem New Jersey and Salem New Jersey houses for rent.
Contrive, recognize, and look up houses for rent Gloucester City, vacation rental, and rental houses in Gloucester City.
Find out and devise apartments for rent, vacation homes in Hunterdon New Jersey, and home rentals Hunterdon New Jersey.
|
|
