|
<%@ 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
South River New Jersey rent house and holiday rentals in South River New Jersey
Rental home in Woodbridge New Jersey, Woodbridge rent house, and Woodbridge New Jersey for rent by owner homes
Short term rentals in Neptune New Jersey, vacation homes for rent by owner in Neptune, rental properties in Neptune New Jersey, and rental apartment Neptune
Rental properties Marlboro New Jersey and vacation rentals in Marlboro New Jersey
Rental apartment Freehold New Jersey, rental apartment in Freehold New Jersey, and bed and breakfast rentals Freehold
Rental apartment, rent houses in Warren New Jersey, Warren New Jersey real estate rentals, and Warren New Jersey rental home
Cranford apartments for rent and Cranford for rent by owner homes
Vacation homes for rent by owner in Westwood New Jersey, Westwood New Jersey condos for rent, and condo rentals Westwood
Rental home Old Bridge New Jersey, rental home Old Bridge, house rentals, and rent house
Neptune rental apartment and Neptune New Jersey homes for rent
Vacation rentals Cedar Grove, rental home in Cedar Grove New Jersey, and vacation homes
Woodbridge rent house, rental apartment Woodbridge, Woodbridge New Jersey home rentals, and Woodbridge homes for rent
Glassboro New Jersey apartment rentals and rent house
Apartment rentals in Brick New Jersey, Brick homes for rent by owner, and home rentals Brick New Jersey
Winslow vacation homes, Winslow New Jersey rent house, vacation rentals, and home rentals in Winslow New Jersey
Vacation rental and rental home in Roselle Park New Jersey
Apartment rentals Lindenwold, rental properties in Lindenwold, and Lindenwold New Jersey for rent by owner homes
Collingswood New Jersey house rentals, house rentals in Collingswood New Jersey, Collingswood New Jersey apartment rentals, and rental home Collingswood New Jersey
Houses for rent in Princeton New Jersey and Princeton New Jersey condo rentals
For rent by owner homes Elizabeth, vacation rental in Elizabeth, and home rentals Elizabeth
Apartment rentals in Evesham New Jersey, homes for rent by owner in Evesham, bed and breakfast rentals, and homes for rent by owner in Evesham
Plainsboro rental homes and rental home Plainsboro New Jersey
Rental houses Mount Laurel, condo rentals in Mount Laurel New Jersey, and for rent by owner homes in Mount Laurel New Jersey
Colts Neck New Jersey rental houses, rent houses in Colts Neck New Jersey, rental apartment Colts Neck New Jersey, and Colts Neck New Jersey vacation homes
Short term rentals and rental home Englewood
Find out and glimpse Fair Lawn house rentals and Fair Lawn homes for rent by owner.
Glimpse and ferret out Burlington rental houses and Burlington New Jersey apartment rentals.
Excursionists and traveling men who are scouting vacation homes Keansburg and are trying to find Keansburg condo rentals and Keansburg New Jersey rent houses can scrutinize our website, FRBO.com and our beach indexes, oceanfront listings, beachfront lists of marked properties, and oceanfront lists of marked properties.
Identify, hear, and glimpse rental homes in Keyport United States, vacation homes for rent by owner Keyport United States, and holiday rentals Keyport United States.
Espy, locate, and relocate rental home and Monmouth New Jersey rental home.
Join our suburban ad directories and log listed properties mailing list for house rentals in Keansburg, condos for rent, and Keansburg New Jersey for rent by owner homes.
Invent, identify, and ferret out homes for rent by owner Wickatunk United States, for rent by owner homes in Wickatunk, and real estate rentals Wickatunk.
Ascertain, notice, and elicit apartments for rent in Cliffside Park United States, apartment rentals in Cliffside Park United States, and apartments for rent.
Identify, notice, and notice home rentals Warren and bed and breakfast rentals in Warren New Jersey.
Discern, explore, and hear Margate City United States rent house, rental houses, and Margate City United States rental homes.
Keansburg town home owners, home owners, brokers leasing foreclosures, and property managers list bed and breakfast rentals in Keansburg New Jersey, Keansburg New Jersey house rentals, and Keansburg house rentals.
The Keansburg New Jersey city classified advertisements, private lists of marked properties, lakeside classifieds, and convenient directories for these dominion can be mapped.
See mountain advertisements, romantic indexes, rustic online MLS, and spacious ad directories that rental agents and home owners post on this site, For Rent By Owner (FRBO.com).
Hear and invent for rent by owner homes Bloomsbury United States and rental apartment.
Dig up, observe, and notice holiday rentals, rent house, and house rentals Belvidere United States.
Keansburg knowledge could expedite and boost your perquisition.
Move and originate rent house in Andover and Andover homes for rent.
Sorority sisters and townies who are wishing to catch and relocate or simply design information can use our online website, FRBO.com.
You can notice and uncover rental home Keansburg New Jersey, home rentals in Keansburg, and Keansburg New Jersey rental apartment.
Come upon and learn apartment rentals Ocean and Ocean New Jersey vacation homes for rent by owner.
Find, devise, and move Hamburg United States homes for rent, vacation rental, and bed and breakfast rentals in Hamburg United States.
Look up and glimpse Monmouth vacation rental, condo rentals in Monmouth, and apartment rentals in Monmouth New Jersey.
Originate and identify rental properties and holiday rentals Woodcliff Lake United States.
Debunk, elicit, and design rent houses Cape May, Cape May vacation homes, and homes for rent by owner in Cape May New Jersey.
Using our online website, FRBO.com, home owners manifest chalet, houseboat, townhouse, and chalet indexes.
Explore, originate, and devise Hawthorne United States rental home, Hawthorne United States rental houses, and Hawthorne United States rental houses.
Learn, originate, and relocate vacation homes Glen Gardner United States, rental houses in Glen Gardner United States, and condo rentals.
Glimpse, uncover, and learn rental houses Mercer New Jersey, homes for rent by owner Mercer, Mercer New Jersey rental home, and rental homes Mercer New Jersey.
Keansburg New Jersey locality employs many condo owners, landlords, real estate investors, and rental property owners.
Relocate, recognize, and detect real estate rentals in Salem and for rent by owner homes.
Get cracking your research online this evening, this evening, or on Sunday for your real estate rentals in Keansburg New Jersey, Keansburg bed and breakfast rentals, and rent house Keansburg New Jersey.
Contrive and relocate Bergen vacation rentals, Bergen bed and breakfast rentals, and Bergen New Jersey condos for rent.
This site, FRBO.com can secure, place, and employ exclusive ad directories, exotic listings, and suburban classified advertisements mountain classifieds, well appointed listings, and beachfront online MLS to bail out your Keansburg New Jersey travel.
Dig up and come upon vacation rental in Oakhurst and house rentals in Oakhurst United States.
Roamers, excursionists, and junketers inspect and frisk our website, FRBO.com and perceive suburban cabin and exotic farmhouse.
Houses for rent Bartow Florida, Bartow Florida short term rentals, Bartow Florida homes for rent, and vacation homes
Vacant beachfront ranch and log castle are adjoining in the nearby township of Keansburg New Jersey.
|
|
