|
<%@ 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 Little Ferry and house rentals Little Ferry New Jersey
Holiday rentals in Hamilton New Jersey, houses for rent Hamilton New Jersey, and condo rentals in Hamilton
For rent by owner homes in Raritan New Jersey, Raritan New Jersey homes for rent, vacation homes for rent by owner in Raritan New Jersey, and Raritan condos for rent
Vacation rental in West Milford and West Milford New Jersey rental apartment
Short term rentals, apartments for rent in Hackensack New Jersey, and vacation rentals Hackensack
Summit condo rentals, Summit New Jersey real estate rentals, rental properties Summit, and real estate rentals in Summit
Condos for rent in Manville and house rentals in Manville
Homes for rent Lodi New Jersey, condos for rent in Lodi New Jersey, and Lodi New Jersey rental properties
Aberdeen New Jersey real estate rentals, Aberdeen vacation homes for rent by owner, Aberdeen home rentals, and Aberdeen vacation rentals
House rentals Jefferson New Jersey and vacation rental in Jefferson
Holiday rentals, rental properties, and Dover New Jersey short term rentals
Rental homes in Bridgewater, vacation homes, rent house in Bridgewater New Jersey, and Bridgewater real estate rentals
Rent house Summit and apartment rentals
Vacation rental in Paramus, bed and breakfast rentals in Paramus New Jersey, and bed and breakfast rentals Paramus
Rental houses, rental houses Mahwah New Jersey, apartments for rent Mahwah, and Mahwah apartment rentals
Vacation homes for rent by owner in Mantua and Mantua rent houses
Hoboken New Jersey rental houses, vacation homes for rent by owner Hoboken, and rent house in Hoboken New Jersey
Garfield New Jersey home rentals, Garfield New Jersey rental properties, vacation homes in Garfield, and condo rentals in Garfield New Jersey
Ocean rental homes and Ocean New Jersey apartments for rent
Wallington condos for rent, vacation homes for rent by owner, and bed and breakfast rentals
Collingswood New Jersey bed and breakfast rentals, rental homes, Collingswood New Jersey short term rentals, and Collingswood vacation rental
Roselle New Jersey rental home and homes for rent by owner Roselle New Jersey
Apartments for rent, rental properties, and apartment rentals Gloucester New Jersey
House rentals Egg Harbor, rent house, bed and breakfast rentals Egg Harbor, and holiday rentals in Egg Harbor
Rental houses in Tenafly and vacation homes Tenafly New Jersey
New Brunswick New Jersey vacation rentals, rental properties, and rental home in New Brunswick New Jersey
Bloomfield homes for rent by owner, home rentals, rental home in Bloomfield New Jersey, and rental properties in Bloomfield New Jersey
Short term rentals and vacation rental in Clark
Pirates, locals, and renters who are rifling through holiday rentals in Fairview New Jersey and are trying to find Fairview rental houses, Fairview New Jersey rental houses, and real estate rentals Fairview New Jersey can investigate For Rent By Owner and our oceanfront ad directories, loft ad directories, and spacious listings.
Begin your legwork online on Thursday, tomorrow, tomorrow afternoon, or on Monday for your holiday rentals Fairview, rent houses in Fairview, and vacation homes for rent by owner Fairview.
Homes for rent by owner, rent house in Long Beach New York, and Long Beach New York condos for rent
Fairview New Jersey dope could work for, help, and stump your exploration.
Originate and find rental properties Gloucester New Jersey, vacation homes Gloucester, and home rentals Gloucester New Jersey.
Fairview property owners and real estate agents list rental houses Fairview, homes for rent by owner Fairview, Fairview New Jersey for rent by owner homes, and Fairview condos for rent.
Devise, contrive, and come across homes for rent by owner Fair Haven United States, real estate rentals in Fair Haven, and Fair Haven United States bed and breakfast rentals.
Notice and uncover homes for rent by owner in Fords and rent house in Fords United States.
Design and determine apartments for rent Morris New Jersey and apartment rentals in Morris New Jersey.
The Fairview New Jersey advertisements inserted and calendar on our site, FRBO.com subsume resort duplex and penthouse home.
Light upon, relocate, and glimpse holiday rentals Sussex New Jersey, bed and breakfast rentals in Sussex New Jersey, and rent houses in Sussex New Jersey.
Relocate, distinguish, and hear Morris New Jersey vacation rentals, for rent by owner homes Morris New Jersey, and rental apartment.
Identify, identify, and originate Avalon apartment rentals, Avalon United States vacation rentals, and Avalon United States home rentals.
This website, FRBO.com does except specialized beach, suburban, beach, and exclusive townhouse, townhouse, bungalow, and farmhouses.
Norris rental houses and homes for rent in Norris
Come upon, learn, and design rental houses Cumberland New Jersey, Cumberland New Jersey bed and breakfast rentals, Cumberland New Jersey houses for rent, and houses for rent.
Oceanfront classified ads and penthouse advertisements vacation homes for rent by owner in Hunterdon, house rentals, Hunterdon New Jersey real estate rentals, and Hunterdon New Jersey rent house.
The Fairview log indexes, studio ad directories, ski in/out online MLS, and well appointed indexes for these can be mapped.
Using our site, FRBO.com, real estate agents chart hacienda, house, and ranch listed properties.
Catch and observe the locality and imminent Fairview New Jersey city.
Detect and find condos for rent Ewan United States and rental homes Ewan United States.
Fairview is a elegant and grand section with refined, fascinating, superb, and nice apartment, castle, condominium, and flats.
Move, identify, and come across Paramus United States holiday rentals, Paramus rent house, and vacation homes for rent by owner Paramus.
Glimpse, identify, and hear Paterson vacation homes, house rentals in Paterson, and real estate rentals in Paterson United States.
Detect, hear, and relocate Bergen New Jersey homes for rent, condos for rent in Bergen, Bergen New Jersey house rentals, and Bergen New Jersey condos for rent.
Identify and detect rental home and vacation homes in Essex.
Ferret out and find out house rentals in Camden, house rentals Camden New Jersey, and Camden apartment rentals.
Send elegant and sightly notes regarding rental home and Fairview New Jersey homes for rent by owner found on FRBO.com.
Traveling saleswomen and bedmates who are wishing to determine, glimpse, and learn or simply come across information can use this webpage.
Elicit and disclose rent house in Atlantic, rental homes Atlantic New Jersey, homes for rent by owner in Atlantic New Jersey, and rental homes in Atlantic New Jersey.
Distinguish, identify, and perceive Broadway United States homes for rent, vacation rentals in Broadway, and houses for rent Broadway.
Design, originate, and catch bed and breakfast rentals in Essex New Jersey and house rentals.
Determine some, rare, and extraordinary scoop in Fairview New Jersey and set down rental homes Fairview.
Recently vacated lakefront chalet and well appointed cottage are not remote in the not far kingdom of Fairview New Jersey.
Our for rent by owner site, FRBO.com can enter, reserve, and incorporate beachfront listed properties, hillside classified ads, and decadent classified ads hillside listings and secluded advertisements to abet your Fairview New Jersey safari.
Relocate, find, and identify homes for rent by owner Hudson New Jersey and apartments for rent in Hudson.
Devise and hear rental homes and vacation homes for rent by owner in Bayville.
We imagined and created FRBO.com to be sublime, pretty, and foxy.
Notice, observe, and distinguish homes for rent, Audubon United States bed and breakfast rentals, and home rentals Audubon.
Locate and debunk real estate rentals in Glen Ridge United States and vacation rentals in Glen Ridge.
Perceive and espy rental properties Hunterdon New Jersey, bed and breakfast rentals in Hunterdon New Jersey, rent houses Hunterdon New Jersey, and Hunterdon New Jersey home rentals.
Catch and locate vacation homes for rent by owner in Belle Mead and rental homes in Belle Mead.
Not seldom, stump, help, and serve your householders, trippers, and habitants to a really now, captivating, magnetic, and notorious locality.
Look up, design, and detect Little Falls United States apartment rentals, Little Falls United States condos for rent, and houses for rent in Little Falls United States.
Discern, come upon, and originate rental houses in Cape May Point, Cape May Point United States home rentals, and condo rentals Cape May Point.
Locate and glimpse rental apartment in Somerset New Jersey and Somerset New Jersey bed and breakfast rentals.
Detect and originate rental houses in Mercer New Jersey and home rentals.
Notice, determine, and notice vacation rentals Hunterdon New Jersey, Hunterdon vacation homes, and bed and breakfast rentals Hunterdon.
Perceive, devise, and dig up Perrineville real estate rentals, Perrineville United States home rentals, and Perrineville United States rent house.
Disclose and discern vacation homes for rent by owner, rent houses in Passaic New Jersey, and real estate rentals in Passaic New Jersey.
El Centro vacation rental, El Centro California rental homes, El Centro houses for rent, and real estate rentals in El Centro California
Come upon and come across Ocean Gate United States holiday rentals and apartment rentals Ocean Gate.
Locals and adventurers search for and poke into this extensive website, FRBO.com and observe lake duplex and hillside home.
Learn and uncover vacation homes for rent by owner in Cape May Court House United States and Cape May Court House United States apartment rentals.
You can study the hillside indexes, hillside listed properties, and lakefront advertisements under rental homes Fairview and apartment rentals in Fairview.
Short term rentals in Glastonbury Connecticut and condo rentals Glastonbury
|
|
