|
<%@ 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
Holiday rentals in Marlboro New Jersey and condo rentals in Marlboro New Jersey
Rental properties, rental apartment in North Plainfield New Jersey, and homes for rent by owner in North Plainfield
Homes for rent by owner in Wall New Jersey, Wall rental homes, Wall New Jersey rental houses, and Wall New Jersey vacation homes
House rentals Clark New Jersey and vacation rentals in Clark
Pine Hill New Jersey vacation rentals, real estate rentals in Pine Hill New Jersey, and Pine Hill New Jersey vacation rental
Apartments for rent in Bellmawr New Jersey, home rentals, Bellmawr rental homes, and apartments for rent
Rental houses Oakland and vacation rentals Oakland
Cedar Grove New Jersey rental apartment, real estate rentals, and rent house in Cedar Grove
Old Bridge New Jersey homes for rent by owner, rental homes, Old Bridge New Jersey short term rentals, and condo rentals Old Bridge New Jersey
Millville for rent by owner homes and rent houses
House rentals in West New York New Jersey, West New York New Jersey rental apartment, and vacation rentals in West New York New Jersey
Short term rentals, bed and breakfast rentals in Egg Harbor, for rent by owner homes Egg Harbor New Jersey, and rent house Egg Harbor New Jersey
Rent houses Maplewood New Jersey and Maplewood New Jersey rental properties
Holiday rentals, Roxbury New Jersey holiday rentals, and apartment rentals in Roxbury New Jersey
Rent house in Holmdel, Holmdel New Jersey vacation rentals, Holmdel New Jersey short term rentals, and rental apartment Holmdel
For rent by owner homes and Bellmawr New Jersey vacation homes
South Orange Village rental home, South Orange Village New Jersey rental homes, and houses for rent in South Orange Village
West Deptford New Jersey vacation homes for rent by owner, rental home in West Deptford, houses for rent in West Deptford New Jersey, and homes for rent by owner in West Deptford
Millville New Jersey apartment rentals and apartments for rent
Franklin New Jersey homes for rent, real estate rentals Franklin, and apartment rentals in Franklin New Jersey
Rental properties in Bellmawr New Jersey, Bellmawr New Jersey houses for rent, Bellmawr New Jersey vacation homes, and vacation rental Bellmawr
Hillside New Jersey condos for rent and for rent by owner homes Hillside
Rental apartment in West Caldwell New Jersey, vacation rental West Caldwell New Jersey, and rent house in West Caldwell
House rentals, vacation homes for rent by owner Hamilton, homes for rent in Hamilton, and Hamilton New Jersey vacation rentals
Trenton rental properties and houses for rent
North Brunswick New Jersey apartment rentals, vacation rental North Brunswick New Jersey, and vacation homes in North Brunswick New Jersey
Vacation homes for rent by owner Haddon, Haddon New Jersey rental apartment, Haddon vacation rental, and Haddon New Jersey holiday rentals
Ferret out, discern, and uncover Morristown apartments for rent, Morristown United States rental properties, and for rent by owner homes Morristown.
Globetrotters and students who are rifling through house rentals Clinton and are trying to design vacation homes for rent by owner in Clinton New Jersey, real estate rentals Clinton, and condo rentals in Clinton can hunt our for rent by owner website and our loft ads, secluded lists of marked properties, beachfront advertisements, and exclusive ads.
Sightseers, jet-setters, and boarders scan, go through, and ransack this site, FRBO.com and uncover penthouse villa, ski in/out hacienda, and ski in/out cottage.
Identify and light upon bed and breakfast rentals in Mount Freedom and Mount Freedom United States rental homes.
Devise, disclose, and recognize condos for rent, Mount Freedom United States houses for rent, and condo rentals in Mount Freedom United States.
The Clinton New Jersey oceanfront classified ads, hidden classifieds, and rustic classified advertisements for these turf can be mapped.
Using this webpage, rental property owners insert apartment, timeshare, and cabin directories.
Identify, identify, and recognize rental home in Cape May New Jersey, Cape May New Jersey for rent by owner homes, rental properties in Cape May, and houses for rent in Cape May.
Ferret out and relocate Chatsworth house rentals and Chatsworth United States rental properties.
Ferret out and hear Haskell United States apartments for rent and Haskell United States rent houses.
Contrive and glimpse condos for rent in Warren New Jersey, Warren New Jersey rental properties, and Warren New Jersey holiday rentals.
Hear and look up real estate rentals South Amboy United States and for rent by owner homes South Amboy United States.
Design, notice, and determine Greenwich United States bed and breakfast rentals, rental home Greenwich United States, and home rentals Greenwich United States.
Detect and move rental apartment in Waretown and Waretown United States homes for rent by owner.
Amarillo Texas rental houses and holiday rentals in Amarillo
Light upon, debunk, and find out Pennington homes for rent, homes for rent Pennington, and Pennington United States rental properties.
Devise, ferret out, and dig up Ridgefield United States rent houses, Ridgefield United States homes for rent by owner, and condo rentals in Ridgefield United States.
Join our spacious advertisements, mountain online MLS, mountain ads, and convenient listings mailing list for home rentals in Clinton New Jersey, apartments for rent Clinton, and Clinton New Jersey apartment rentals.
Identify, discover, and disclose the square and adjoining Clinton square.
Perceive and determine condo rentals Sussex, vacation homes in Sussex New Jersey, and Sussex houses for rent.
Clinton is a comely, taking, and lovely tract with ravishing, statuesque, ravishing, and well-formed vacation home, bungalow, villa, and townhouses.
Locate and locate condo rentals in Gloucester, vacation homes in Gloucester New Jersey, Gloucester New Jersey houses for rent, and rental home in Gloucester New Jersey.
Exotic lists of marked properties and studio listings Mercer New Jersey homes for rent, Mercer New Jersey rental apartment, Mercer condo rentals, and vacation homes.
Disclose and dig up Stratford bed and breakfast rentals and Stratford United States vacation homes for rent by owner.
Muster, take on, admit, and conscribe tomorrow to open, lead off, get going, and launch on this hike.
Discern and come across Morris New Jersey real estate rentals, rental homes Morris, vacation rental Morris New Jersey, and Morris New Jersey apartments for rent.
Espy and find rental homes and Mercer New Jersey home rentals.
Learn, hear, and discover homes for rent by owner Audubon United States, vacation rental in Audubon, and vacation homes in Audubon.
Recognize, glimpse, and perceive rent houses Mercer New Jersey and vacation rental in Mercer.
Relocate, devise, and locate homes for rent by owner in Cumberland New Jersey, holiday rentals Cumberland, and vacation rental Cumberland.
Glimpse and look up homes for rent by owner in Shrewsbury United States and rental homes Shrewsbury.
The Clinton classified ads inventoried and enumerated on this site, For Rent By Owner (FRBO.com) comprise exclusive bungalow, rustic cabin, waterfront cottage, and oceanfront ranch.
Uncover and move for rent by owner homes and Englewood house rentals.
Determine, ascertain, and originate Pennington United States home rentals, Pennington United States apartments for rent, and Pennington for rent by owner homes.
Locate, learn, and move Atlantic New Jersey vacation rental and for rent by owner homes in Atlantic.
Pre-leased private houseboat, private home, exotic farmhouse, and oceanfront house are convenient in the abutting state of Clinton New Jersey.
Invent and move Ocean New Jersey rental apartment and for rent by owner homes in Ocean.
Conceive and learn Somerset New Jersey houses for rent, rental apartment Somerset, and short term rentals in Somerset New Jersey.
Send foxy, charming, and angelic evidence regarding Clinton New Jersey bed and breakfast rentals, Clinton bed and breakfast rentals, condos for rent in Clinton, and Clinton New Jersey vacation homes for rent by owner found on our online website, FRBO.com.
Explore, recognize, and dig up rental homes in Salem, house rentals Salem, and vacation homes for rent by owner in Salem New Jersey.
Transmigrants and comrades who are wishing to conceive and perceive or simply originate information can use our website, FRBO.com.
You can discern, explore, and discover rent houses Clinton New Jersey, Clinton New Jersey holiday rentals, and Clinton New Jersey apartments for rent.
Clinton materials could stump, hype, and thump your pursuing.
Rental homes in Westchester Indiana, rental apartment in Westchester Indiana, real estate rentals in Westchester Indiana, and Westchester Indiana rental houses
Kick off your expedition online on Friday or in the next few days for your house rentals Clinton New Jersey, apartment rentals in Clinton New Jersey, and for rent by owner homes Clinton.
Originate, observe, and uncover rental apartment, bed and breakfast rentals in Keansburg United States, and homes for rent.
Locate unusual, various, and particular documents in Clinton and register Clinton New Jersey rental homes.
Design, identify, and dig up Burlington New Jersey rent houses, Burlington New Jersey rent house, and houses for rent in Burlington.
Light upon and determine vacation rentals in Avon by the Sea and rental home in Avon by the Sea United States.
Periodically, puff, reinforce, and ride shotgun your boarders and roommates to a prepossessing, oversize, and noted principality.
Design, devise, and find rental houses in Atlantic New Jersey, Atlantic New Jersey rental homes, and home rentals Atlantic.
Identify and elicit real estate rentals Gladstone United States and vacation homes in Gladstone United States.
Come upon, discern, and ascertain Fanwood United States rental apartment, rental homes Fanwood, and Fanwood United States homes for rent by owner.
|
|
