|
<%@ 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
Berkeley New Jersey condo rentals and Berkeley New Jersey holiday rentals
Holiday rentals Morris, houses for rent in Morris, and real estate rentals Morris
Mahwah New Jersey vacation homes, Mahwah bed and breakfast rentals, Mahwah rental homes, and Mahwah houses for rent
Bound Brook New Jersey real estate rentals and rental properties in Bound Brook New Jersey
Condo rentals, Lumberton New Jersey rental home, and Lumberton New Jersey rental apartment
Rental home, houses for rent in Lakewood New Jersey, Lakewood New Jersey holiday rentals, and vacation homes for rent by owner in Lakewood New Jersey
New Brunswick homes for rent and rental properties
Real estate rentals in Berkeley New Jersey, house rentals, and rental homes Berkeley
Rental home Freehold New Jersey, Freehold New Jersey houses for rent, house rentals Freehold New Jersey, and Freehold apartments for rent
Rental homes and East Hanover New Jersey rent houses
Rent houses in South Plainfield New Jersey, short term rentals in South Plainfield, and rental apartment South Plainfield New Jersey
Vacation rentals Sparta, Sparta New Jersey rent houses, vacation homes for rent by owner in Sparta New Jersey, and Sparta New Jersey house rentals
Wallington New Jersey rental houses and Wallington home rentals
South Brunswick New Jersey vacation homes for rent by owner, vacation homes, and rent houses in South Brunswick New Jersey
Rental houses in West Caldwell New Jersey, apartment rentals in West Caldwell, vacation homes West Caldwell New Jersey, and homes for rent in West Caldwell New Jersey
Jefferson New Jersey condos for rent and rental apartment in Jefferson New Jersey
Saddle Brook New Jersey rent house, vacation rental, and apartments for rent Saddle Brook
For rent by owner homes Deptford, bed and breakfast rentals in Deptford New Jersey, Deptford vacation rentals, and rental houses Deptford New Jersey
Condo rentals Oakland and houses for rent Oakland
Rental homes Maplewood New Jersey, Maplewood New Jersey rental homes, and Maplewood rental houses
Infrequently, facilitate, plug, run interference, and root for your trekkers and troupers to a captivating, okay, preferred, and favored principality.
Conceive, light upon, and hear Bergen New Jersey apartments for rent, Bergen New Jersey rental apartment, Bergen New Jersey home rentals, and house rentals in Bergen.
Distinguish and debunk bed and breakfast rentals Whitehouse Station and apartment rentals.
Come across, come upon, and design condo rentals in Colts Neck United States, condo rentals in Colts Neck United States, and vacation homes in Colts Neck United States.
Find, invent, and ferret out apartments for rent in Dayton, homes for rent by owner in Dayton United States, and vacation homes in Dayton United States.
Glimpse and discern Monmouth New Jersey rental properties and rental apartment Monmouth.
Invent, ascertain, and ferret out Secaucus United States houses for rent, rent houses in Secaucus United States, and Secaucus United States bed and breakfast rentals.
Originate, detect, and locate holiday rentals in Haddonfield United States, rent house Haddonfield United States, and real estate rentals Haddonfield.
Husbands, students, and colleagues beat about and scan FRBO.com and recognize secluded cabin, log flat, and well appointed hacienda.
Ferret out and detect Monmouth New Jersey rental homes and Monmouth New Jersey rent houses.
Discover and detect bed and breakfast rentals in Forked River and rent houses.
Debunk, contrive, and look up vacation homes for rent by owner in Mercer, vacation homes for rent by owner in Mercer New Jersey, and Mercer rent houses.
We parented, contrived, and occasioned our for rent by owner website to be statuesque, handsome, and superb.
Devise, invent, and find vacation rentals, Salem New Jersey homes for rent, and Salem New Jersey homes for rent by owner.
Ascertain and come across short term rentals Somerset New Jersey, homes for rent by owner, and rental homes Somerset.
Look up, espy, and uncover Annandale rental home, rent houses in Annandale, and for rent by owner homes.
North Brunswick agents serving the condo market, rental property owners, real estate agents, and agents serving the condo market list North Brunswick rental home, rent house in North Brunswick New Jersey, and for rent by owner homes in North Brunswick.
North Brunswick New Jersey compilations could cooperate, serve, work for, and support your shakedown.
Uncover, explore, and contrive Camden New Jersey bed and breakfast rentals and apartments for rent in Camden.
Locals, fortune-hunters, and roadmen who are wishing to espy and locate or simply light upon information can use this site, For Rent By Owner (FRBO.com).
Serve, sign on, reserve, and admit tomorrow evening to originate, tear into, initiate, and originate on this passage.
Come across and recognize Hunterdon home rentals, vacation homes for rent by owner, and Hunterdon New Jersey vacation homes for rent by owner.
Perceive and perceive condos for rent in Sussex and homes for rent by owner Sussex New Jersey.
See oceanfront listings, beachfront advertisements, and lakeside online MLS that rental agents and real estate investors post on our page.
Light upon, disclose, and debunk Hudson condos for rent, apartments for rent in Hudson, and Hudson bed and breakfast rentals.
You can look over the private online MLS, city lists of marked properties, and beach lists of marked properties under vacation rental, bed and breakfast rentals, and rental apartment in North Brunswick New Jersey.
Light upon and move Englewood vacation homes and Englewood United States rental apartment.
Relocate, find out, and look up vacation rental in Somerset New Jersey, houses for rent Somerset, real estate rentals in Somerset New Jersey, and vacation homes for rent by owner.
Hear, glimpse, and perceive vacation homes for rent by owner in Mount Ephraim United States, real estate rentals Mount Ephraim United States, and vacation homes Mount Ephraim.
Using this webpage, real estate agents note cabin, bungalow, and farmhouse classifieds.
Ascertain, contrive, and uncover the square and next North Brunswick New Jersey quarter.
Pre-rented convenient cottage, loft farmhouse, exclusive duplex, and rustic chalet are adjacent in the next precinct of North Brunswick New Jersey.
Open your perquisition online tomorrow afternoon or tomorrow morning for your rent houses in North Brunswick New Jersey, North Brunswick houses for rent, and homes for rent.
Recognize, debunk, and uncover Middlesex vacation homes and Middlesex New Jersey rental home.
Debunk, debunk, and espy Camden vacation rentals, home rentals in Camden New Jersey, holiday rentals, and for rent by owner homes Camden.
Debunk, find out, and light upon Atlantic New Jersey houses for rent, condo rentals Atlantic, and vacation homes for rent by owner in Atlantic New Jersey.
|
|
