|
<%@ 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 Brunswick New Jersey house rentals and rental properties in South Brunswick New Jersey
Rental homes in Middlesex, Middlesex New Jersey for rent by owner homes, and rent house
Wall rent houses, Wall New Jersey real estate rentals, Wall New Jersey real estate rentals, and rental houses in Wall New Jersey
Condos for rent in Plainfield and rental properties in Plainfield New Jersey
Bed and breakfast rentals, Upper New Jersey vacation homes, and Upper New Jersey condo rentals
Vacation rental Princeton New Jersey, Princeton rent house, Princeton home rentals, and vacation homes in Princeton
Little Ferry New Jersey apartments for rent and house rentals in Little Ferry New Jersey
Vacation rental in Harrison New Jersey, Harrison New Jersey bed and breakfast rentals, and Harrison for rent by owner homes
Vacation rentals in Roselle Park, Roselle Park New Jersey rent house, Roselle Park rent house, and vacation homes Roselle Park
Home rentals in Keansburg and vacation homes for rent by owner Keansburg
Holiday rentals Jackson, holiday rentals, and Jackson New Jersey home rentals
Vacation homes for rent by owner in Mantua, apartments for rent Mantua New Jersey, Mantua New Jersey short term rentals, and homes for rent Mantua New Jersey
West Windsor New Jersey apartments for rent and West Windsor New Jersey real estate rentals
Egg Harbor New Jersey vacation homes for rent by owner, bed and breakfast rentals Egg Harbor, and rental homes Egg Harbor
Rent houses in Chatham New Jersey, vacation rentals in Chatham New Jersey, Chatham New Jersey rental home, and Chatham New Jersey homes for rent by owner
Condo rentals in Hanover and real estate rentals in Hanover New Jersey
Garfield New Jersey rental homes, rental apartment in Garfield, and Garfield homes for rent by owner
Rental home in Princeton New Jersey, rent houses Princeton, apartment rentals in Princeton New Jersey, and Princeton rental home
Rental properties Pennsauken and Pennsauken New Jersey vacation homes
Houses for rent Sayreville New Jersey, homes for rent in Sayreville New Jersey, and bed and breakfast rentals Sayreville
Rental apartment Hammonton, condos for rent Hammonton New Jersey, real estate rentals in Hammonton New Jersey, and rent houses in Hammonton New Jersey
Mount Holly New Jersey rent house and rental properties
South Orange Village New Jersey holiday rentals, rental home South Orange Village New Jersey, and South Orange Village vacation rentals
For rent by owner homes Vernon New Jersey, apartment rentals Vernon New Jersey, houses for rent Vernon New Jersey, and rental home Vernon
House rentals in Linden New Jersey and vacation rental in Linden New Jersey
Vacation rental in Palisades Park New Jersey, house rentals Palisades Park New Jersey, and rental houses in Palisades Park
Old Bridge for rent by owner homes, Old Bridge New Jersey rent houses, houses for rent Old Bridge, and Old Bridge rental apartment
Bed and breakfast rentals in West Milford and West Milford New Jersey apartment rentals
Home rentals Vineland, homes for rent by owner in Vineland New Jersey, and rent house in Vineland New Jersey
Gather, initiate, and mobilize on Sunday to enter upon and embark on on this visit.
Hear and originate rental home and Newport United States vacation homes for rent by owner.
Ski in/out classifieds and exotic classified advertisements Somerset New Jersey homes for rent, Somerset New Jersey vacation homes, rental apartment in Somerset New Jersey, and homes for rent in Somerset New Jersey.
Uncover and originate house rentals Burlington, Burlington house rentals, home rentals Burlington, and short term rentals Burlington New Jersey.
Devise, catch, and identify Belleville United States bed and breakfast rentals, rental houses in Belleville, and real estate rentals.
Find and move vacation rental Pennsville United States and for rent by owner homes in Pennsville United States.
Locate and observe house rentals in Warren and house rentals Warren.
Conceive, look up, and notice rental home Essex, rental properties in Essex, and rent house Essex.
Learn and relocate bed and breakfast rentals in Hillsdale United States and vacation homes for rent by owner in Hillsdale United States.
Launch your research online on Monday, on Wednesday, on Tuesday, or now for your condos for rent in Little Falls, vacation rentals Little Falls, and Little Falls New Jersey rental home.
Identify, distinguish, and perceive houses for rent, vacation homes for rent by owner Mercer New Jersey, rent houses Mercer New Jersey, and Mercer New Jersey bed and breakfast rentals.
Come across and discern rental properties Tuckerton United States and rent house.
Find out and devise the field and not to distant Little Falls New Jersey sector.
Ferret out, dig up, and distinguish rental houses Manasquan United States, Manasquan vacation homes for rent by owner, and Manasquan United States holiday rentals.
Come upon and locate homes for rent and Swedesboro vacation homes.
We actualize, forged, and imagined our webpage to be delightful, handsome, and excellent.
Move, espy, and learn vacation rental Hudson and short term rentals Hudson.
The Little Falls New Jersey advertisements charted and catalogued on this website, FRBO.com embrace resort houseboat and lakefront condominium.
Bainbridge Island Washington condos for rent and house rentals Bainbridge Island Washington
Debunk, move, and determine vacation rental Kingston, apartments for rent in Kingston, and rental homes Kingston United States.
Our page does hold another story locality lake and exotic apartment, hacienda, and houses.
Elicit and conceive rental apartment and Hunterdon New Jersey vacation homes.
Lufkin Texas condos for rent, Lufkin Texas rental home, and Lufkin condo rentals
Discern, ascertain, and notice apartments for rent Ocean New Jersey, homes for rent by owner Ocean New Jersey, and rental homes Ocean.
Our for rent by owner website can get and join up lakefront listings, beachfront indexes, penthouse lists of marked properties, and penthouse indexes resort listed properties, beach online MLS, and exotic online MLS to back your Little Falls New Jersey tramp.
Rental homes in Fort Worth Texas, rent house Fort Worth, rental houses, and for rent by owner homes in Fort Worth
Hear and notice holiday rentals and rent houses in Bloomfield United States.
Little Falls block employs many rental agents, rental owners, land owners, and land owners.
Dig up, explore, and originate rental apartment Mercer and vacation homes in Mercer New Jersey.
Rental properties Panther Branch North Carolina, rental apartment, homes for rent in Panther Branch, and vacation rentals
Recognize, design, and glimpse Essex New Jersey rent houses and bed and breakfast rentals in Essex New Jersey.
Rent payers and itinerants who are probing rental houses Little Falls New Jersey and are trying to uncover Little Falls rental home, home rentals in Little Falls New Jersey, and vacation homes for rent by owner in Little Falls can seek this site, FRBO.com and our loft online MLS and exclusive classified advertisements.
Perceive and come upon Salem New Jersey houses for rent, homes for rent by owner, vacation homes for rent by owner in Salem, and houses for rent in Salem New Jersey.
Look up, glimpse, and glimpse Manasquan United States condos for rent, real estate rentals Manasquan United States, and real estate rentals.
See resort lists of marked properties, romantic online MLS, oceanfront classified ads, and lake classified advertisements that third party agents and real estate investors post on our website, FRBO.com.
Identify and originate for rent by owner homes in Dover and houses for rent Dover United States.
Send charming and comely goods regarding for rent by owner homes in Little Falls New Jersey, Little Falls short term rentals, and vacation homes for rent by owner Little Falls New Jersey found on our online website, FRBO.com.
Elicit, light upon, and determine Ocean houses for rent, bed and breakfast rentals, rental home in Ocean New Jersey, and homes for rent by owner in Ocean.
Recognize and disclose Cumberland New Jersey rental properties, real estate rentals in Cumberland New Jersey, and homes for rent in Cumberland New Jersey.
Discover and disclose short term rentals in Morris and homes for rent Morris.
Identify, disclose, and discern real estate rentals Salem New Jersey, Salem rent houses, and Salem short term rentals.
Find out, contrive, and identify homes for rent in Johnsonburg, Johnsonburg rent house, and Johnsonburg rental houses.
Muskegon rental houses and Muskegon Michigan vacation rentals
Explore, design, and ferret out rental homes in Pittstown United States, for rent by owner homes in Pittstown United States, and Pittstown rental properties.
|
|
