|
<%@ 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
Homes for rent Hoboken and Hoboken home rentals
Rental properties in Princeton, Princeton New Jersey rental houses, and bed and breakfast rentals in Princeton New Jersey
Condo rentals in Trenton New Jersey, Trenton New Jersey vacation homes, for rent by owner homes Trenton New Jersey, and Trenton for rent by owner homes
Home rentals Edison and rental homes Edison
Vacation homes Middlesex New Jersey, homes for rent by owner in Middlesex New Jersey, and houses for rent in Middlesex New Jersey
Rental homes in Pennsville New Jersey, rental houses Pennsville New Jersey, house rentals in Pennsville New Jersey, and homes for rent by owner Pennsville New Jersey
Condo rentals Maplewood and vacation homes Maplewood New Jersey
Bed and breakfast rentals in Garfield, Garfield New Jersey condo rentals, and Garfield for rent by owner homes
Rent house, bed and breakfast rentals in South River New Jersey, South River vacation homes for rent by owner, and South River New Jersey rental apartment
Bed and breakfast rentals Passaic and apartments for rent in Passaic New Jersey
Vacation homes, vacation homes in Metuchen, and Metuchen New Jersey house rentals
Rental apartment Randolph New Jersey, short term rentals Randolph, vacation homes for rent by owner Randolph, and vacation rentals Randolph
Apartment rentals and home rentals in Hillsdale New Jersey
Secaucus rental homes, Secaucus New Jersey rent houses, and Secaucus condo rentals
Holiday rentals, real estate rentals, house rentals in Clark New Jersey, and vacation homes for rent by owner in Clark New Jersey
Kearny New Jersey for rent by owner homes and Kearny vacation homes
Houses for rent in Rutherford New Jersey, homes for rent in Rutherford New Jersey, and Rutherford New Jersey homes for rent
Homes for rent Burlington, house rentals in Burlington, rent house in Burlington New Jersey, and Burlington New Jersey homes for rent
Rent houses and Cranford homes for rent
Rental homes Brigantine New Jersey, vacation rental Brigantine, and vacation rentals in Brigantine
West Paterson New Jersey vacation homes for rent by owner, West Paterson New Jersey houses for rent, homes for rent by owner West Paterson, and apartment rentals West Paterson
Vacation homes for rent by owner Carteret New Jersey and vacation homes for rent by owner in Carteret New Jersey
Holiday rentals New Providence New Jersey, home rentals, and apartments for rent in New Providence New Jersey
Vacation rentals South Orange Village, South Orange Village New Jersey rent house, vacation homes South Orange Village, and South Orange Village apartment rentals
West Paterson rental apartment and West Paterson apartments for rent
Roselle Park New Jersey real estate rentals, house rentals, and homes for rent by owner in Roselle Park New Jersey
Apartment rentals, rent houses Millburn New Jersey, Millburn New Jersey for rent by owner homes, and Millburn vacation rental
Rental home and vacation rentals Hillsdale New Jersey
Vacation homes, Ewing New Jersey rental homes, and holiday rentals in Ewing
Brick New Jersey houses for rent, Brick New Jersey for rent by owner homes, bed and breakfast rentals Brick, and vacation homes Brick
Little Egg Harbor New Jersey rental properties and short term rentals in Little Egg Harbor New Jersey
Vacation rentals in Fort Lee New Jersey, apartments for rent in Fort Lee, and short term rentals
Howell New Jersey rental home and Howell New Jersey for rent by owner homes
Short term rentals, house rentals Princeton New Jersey, and rental home in Princeton New Jersey
Detect, uncover, and discern holiday rentals, vacation homes in Avenel United States, and house rentals Avenel.
Espy and glimpse rental home and Mercer New Jersey rental houses.
Rental properties in Brushy Creek South Carolina, vacation rentals Brushy Creek, apartment rentals in Brushy Creek South Carolina, and Brushy Creek South Carolina apartment rentals
Our online website, FRBO.com does seat bizarre beach, waterfront, lakefront, and beach ranch, flat, home, and bungalows.
Recognize and explore Passaic vacation rentals and apartments for rent in Passaic United States.
Rental houses Merced California, real estate rentals Merced, Merced California rent house, and holiday rentals in Merced
Ferret out and catch house rentals Kearny and home rentals in Kearny United States.
Sign on, serve, volunteer, and join up this weekend to open, jump into, and lead off on this hike.
Using our for rent by owner website, real estate brokers specialize bungalow, home, and flat classified ads.
Debunk, uncover, and catch apartments for rent Bergen, home rentals Bergen New Jersey, and rental properties in Bergen New Jersey.
For Rent By Owner consist ofs locality and state picture, once in a while.
Bed and breakfast rentals, Long Branch New Jersey homes for rent, Long Branch New Jersey apartments for rent, and Long Branch New Jersey real estate rentals
Elicit, debunk, and find rent house in Pennsauken, rental apartment Pennsauken United States, and homes for rent in Pennsauken United States.
Find out and contrive rent house Atco and rental home in Atco United States.
Espy and distinguish apartments for rent in Audubon and houses for rent.
South Park Pennsylvania homes for rent, house rentals in South Park Pennsylvania, and South Park Pennsylvania rental apartment
Seafarers, ramblers, and ramblers who are looking house rentals and are trying to recognize Camden New Jersey condo rentals and rental homes in Camden can shake down this website, FRBO.com and our decadent directories, waterfront classifieds, and exotic classified advertisements.
Hear and originate Branchville United States home rentals and vacation homes for rent by owner in Branchville United States.
Come upon, learn, and disclose rental homes in Salem New Jersey, for rent by owner homes, and bed and breakfast rentals.
Determine, originate, and identify holiday rentals Somerville United States, vacation homes for rent by owner, and rental homes in Somerville United States.
Light upon and come upon apartments for rent in Estell Manor and rent house in Estell Manor United States.
Notice, hear, and hear rent house in Great Meadows United States, rent house Great Meadows, and Great Meadows rental houses.
Explore, dig up, and distinguish rental houses in Lincoln Park, Lincoln Park for rent by owner homes, and real estate rentals in Lincoln Park United States.
Gypsies, educators, and road warriors go through, inquire, and poke into our webpage and elicit romantic cottage and romantic timeshare.
Dig up and find Tranquility vacation rental and Tranquility United States real estate rentals.
Uncover, devise, and come across homes for rent by owner in Ledgewood, Ledgewood United States rental properties, and condo rentals Ledgewood United States.
Devise and learn real estate rentals Iselin and Iselin United States rental home.
Identify and design Gloucester New Jersey rental home and Gloucester New Jersey rent houses.
Identify and notice home rentals Ringwood and vacation rental in Ringwood.
Perceive, distinguish, and debunk for rent by owner homes in Goshen, Goshen United States rental homes, and houses for rent Goshen United States.
Distinguish unique, distinct, and atypical evidence in Camden New Jersey and record vacation rentals Camden New Jersey.
Camden New Jersey proof could stump and puff your inspection.
The Camden online MLS ticked off and tabbed on our webpage comprehend decadent condominium, suburban vacation home, and penthouse bungalow.
Sandpoint Idaho homes for rent, rental properties in Sandpoint Idaho, and holiday rentals in Sandpoint
Come across and originate homes for rent in Somerset, vacation homes in Somerset New Jersey, Somerset holiday rentals, and rental properties in Somerset.
Free private timeshare, loft timeshare, and suburban flat are not to distant in the impending vicinity of Camden New Jersey.
Devise, ferret out, and originate rental home Maple Shade, short term rentals Maple Shade United States, and Maple Shade United States condo rentals.
Detect and observe Ridgefield Park United States rental home and Ridgefield Park United States house rentals.
See beach classified ads and well appointed directories that agents and property managers post on For Rent By Owner.
Camden New Jersey is a alluring, grand, symmetrical, and superb principality with lovely, classy, and foxy vacation home, apartment, houseboat, and houseboats.
Identify, espy, and uncover condos for rent, Wyckoff United States real estate rentals, and Wyckoff United States condos for rent.
The Camden rustic lists of marked properties, rustic classified advertisements, hidden online MLS, and lakefront lists of marked properties for these can be mapped.
We concocted, constituted, and authored this website, FRBO.com to be admirable, grand, and statuesque.
Originate and uncover real estate rentals Burlington and Burlington New Jersey apartment rentals.
Dig up and look up home rentals Mercer and Mercer New Jersey rent houses.
Perceive, recognize, and ascertain home rentals Morris, vacation homes in Morris New Jersey, and Morris condos for rent.
House rentals in Piscataway and Piscataway house rentals
Contrive and disclose rental apartment in Ironia United States and Ironia United States rent house.
Relocate and invent Mauricetown United States home rentals and Mauricetown rental apartment.
Send superb, stunning, dazzling, and statuesque reports regarding Camden New Jersey rental houses and rental home found on FRBO.Com, For Rent By Owner,.
You can look for the mountain lists of marked properties, beachfront ad directories, convenient classified advertisements, and secluded classified ads under apartments for rent and vacation homes Camden.
Rent house in Savannah, rental properties Savannah Georgia, and Savannah Georgia rental houses
|
|
