|
<%@ 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
Rental home Old Bridge New Jersey and rent house Old Bridge
Rental houses in Hillside New Jersey, vacation homes for rent by owner in Hillside, and holiday rentals in Hillside New Jersey
Rental homes in Monroe, Monroe rental homes, house rentals in Monroe New Jersey, and for rent by owner homes in Monroe
Vacation homes and Mantua condos for rent
Ocean City apartments for rent, homes for rent Ocean City New Jersey, and Ocean City New Jersey condos for rent
Rent house in Pine Hill New Jersey, rent house in Pine Hill New Jersey, rental properties in Pine Hill New Jersey, and Pine Hill New Jersey rental home
Saddle Brook New Jersey for rent by owner homes and Saddle Brook condo rentals
Vacation rentals in Franklin New Jersey, rent house in Franklin New Jersey, and rent houses in Franklin New Jersey
Apartment rentals North Brunswick, rental properties in North Brunswick, rental apartment in North Brunswick New Jersey, and homes for rent by owner in North Brunswick
Bed and breakfast rentals in Warren New Jersey and houses for rent in Warren New Jersey
Home rentals, home rentals, and vacation homes for rent by owner in Manalapan New Jersey
Rental houses in Barnegat New Jersey, holiday rentals in Barnegat New Jersey, Barnegat New Jersey rental apartment, and vacation rentals in Barnegat
Vacation homes Hawthorne New Jersey and vacation homes for rent by owner Hawthorne
Vacation rental in Sparta New Jersey, for rent by owner homes in Sparta New Jersey, and rental home in Sparta New Jersey
South Orange Village New Jersey rent house, homes for rent by owner in South Orange Village New Jersey, short term rentals in South Orange Village New Jersey, and real estate rentals
Rental apartment and Vernon house rentals
Rental houses in North Arlington New Jersey, apartments for rent North Arlington, and rent house in North Arlington New Jersey
Wantage vacation homes for rent by owner, rent houses in Wantage, condos for rent, and bed and breakfast rentals
Vernon New Jersey condo rentals and Vernon houses for rent
Homes for rent by owner Paterson New Jersey, Paterson bed and breakfast rentals, and Paterson New Jersey short term rentals
Vacation rental in Trenton, Trenton New Jersey rental houses, Trenton New Jersey rental houses, and Trenton short term rentals
Rental apartment Hasbrouck Heights and home rentals
Beachwood New Jersey rental home, vacation homes in Beachwood, and vacation rental Beachwood New Jersey
Rental home Haddon New Jersey, house rentals in Haddon New Jersey, condo rentals in Haddon New Jersey, and holiday rentals
Real estate rentals in Howell New Jersey and vacation rental
Bed and breakfast rentals in Cranford New Jersey, vacation rentals in Cranford, and rental homes
Rental properties Ramsey, vacation homes for rent by owner in Ramsey, vacation rentals in Ramsey New Jersey, and Ramsey New Jersey vacation rentals
Lawrence rent houses and Lawrence condos for rent
Vacation rentals in Verona, Verona New Jersey condo rentals, and house rentals Verona
Condo rentals, Tinton Falls New Jersey apartments for rent, rental home in Tinton Falls, and Tinton Falls rental apartment
Houses for rent Teaneck New Jersey and apartments for rent in Teaneck New Jersey
Rental properties in Franklin Lakes New Jersey, Franklin Lakes New Jersey holiday rentals, and condo rentals in Franklin Lakes New Jersey
Vacation homes for rent by owner in Florence and condo rentals
Elizabeth New Jersey input could open doors, aid, back, and further your fishing expedition.
Find out, recognize, and perceive short term rentals, homes for rent Franklin Park United States, and homes for rent Franklin Park.
Lake classified ads and oceanfront lists of marked properties rent house, for rent by owner homes in Morris New Jersey, Morris New Jersey houses for rent, and rental apartment in Morris.
Move, distinguish, and detect Atlantic New Jersey vacation homes for rent by owner, Atlantic New Jersey home rentals, house rentals Atlantic New Jersey, and vacation rental.
Join our hidden listed properties, secluded listed properties, and rustic directories mailing list for home rentals and bed and breakfast rentals.
Discern, originate, and relocate homes for rent Morris, houses for rent in Morris New Jersey, and real estate rentals.
Vacation rentals in Marblehead Massachusetts and rent houses in Marblehead
Determine and discover for rent by owner homes in Monmouth, vacation rentals Monmouth New Jersey, homes for rent by owner in Monmouth New Jersey, and Monmouth New Jersey homes for rent.
Incorporate, oblige, and join up on Saturday to begin, enter upon, and get cracking on this drive.
Free hidden hacienda, loft hacienda, private cabin, and exclusive bungalow are next in the adjoining quarter of Elizabeth New Jersey.
Observe, look up, and conceive for rent by owner homes in Kenilworth United States, house rentals in Kenilworth United States, and real estate rentals Kenilworth United States.
The Elizabeth New Jersey listings buttoned down and particularized on this website, FRBO.com have log condominium, lakeside castle, and rustic hacienda.
Detect and devise for rent by owner homes in Irvington United States and rental houses in Irvington United States.
Dig up and debunk rental home and condo rentals in Kearny.
Come across and learn holiday rentals Malaga United States and Malaga house rentals.
Come across and originate short term rentals in Dorchester and rent house Dorchester United States.
Uncover uncommon, rare, and discrete measurements in Elizabeth New Jersey and particularize bed and breakfast rentals Elizabeth New Jersey.
Identify, observe, and observe the precinct and not far Elizabeth vicinity.
Notice and observe vacation rental in Morris New Jersey and Morris New Jersey vacation homes.
Holiday rentals in Dallas, condo rentals Dallas, condos for rent, and Dallas Oregon short term rentals
Conceive and come across condo rentals in Changewater and rent house in Changewater United States.
Detect and explore rental houses Columbia United States and vacation homes Columbia United States.
The Elizabeth New Jersey exotic classified ads and lakeside listings for these can be mapped.
Elicit and originate rental home in Towaco and Towaco United States rental houses.
Rigby rental apartment, real estate rentals Rigby Idaho, Rigby Idaho apartment rentals, and homes for rent by owner in Rigby Idaho
Discover and espy rental properties Colonia United States and Colonia United States vacation rentals.
Knoxville Tennessee vacation homes and vacation homes in Knoxville Tennessee
House rentals in Kingsville Texas, Kingsville Texas house rentals, and Kingsville Texas vacation homes for rent by owner
Elizabeth is a divine and superb parcel with delightful and handsome condominium and duplexs.
Catch, conceive, and espy real estate rentals Mercer New Jersey, Mercer New Jersey real estate rentals, houses for rent in Mercer, and apartment rentals Mercer New Jersey.
Grant Illinois rental home, Grant Illinois rental houses, and vacation homes for rent by owner in Grant Illinois
Discover, devise, and design short term rentals Pottersville United States, Pottersville United States vacation rentals, and Pottersville rental home.
Disclose and dig up Stewartsville United States home rentals and homes for rent Stewartsville.
Sightseers, renters, and excursionists who are casing about rental properties Elizabeth and are trying to identify real estate rentals, Elizabeth New Jersey real estate rentals, and condo rentals Elizabeth New Jersey can investigate our site, FRBO.com and our romantic listed properties, exotic online MLS, waterfront ads, and lake ads.
Catch, espy, and identify Sussex condo rentals and houses for rent in Sussex New Jersey.
Explore, learn, and perceive rental apartment in Ocean, houses for rent in Ocean New Jersey, and short term rentals.
Relocate and move homes for rent in Monmouth New Jersey, vacation rental in Monmouth New Jersey, and Monmouth vacation rentals.
Short term rentals in Soddy-Daisy, Soddy-Daisy Tennessee apartment rentals, Soddy-Daisy rental homes, and real estate rentals Soddy-Daisy Tennessee
|
|
