|
<%@ 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
Holiday rentals and apartment rentals Lakewood New Jersey
Real estate rentals in Point Pleasant New Jersey, Point Pleasant New Jersey rental apartment, and Point Pleasant condos for rent
Rental home Montville, bed and breakfast rentals Montville, real estate rentals in Montville New Jersey, and condo rentals in Montville New Jersey
Homes for rent by owner Wall New Jersey and homes for rent in Wall New Jersey
Kearny house rentals, vacation rental, and holiday rentals in Kearny
Home rentals in Trenton, Trenton New Jersey short term rentals, rental properties Trenton New Jersey, and bed and breakfast rentals in Trenton
Rental homes in Gloucester New Jersey and vacation homes in Gloucester
Home rentals Voorhees, house rentals in Voorhees New Jersey, and houses for rent Voorhees New Jersey
Apartments for rent in Millburn, Millburn New Jersey for rent by owner homes, vacation homes for rent by owner Millburn New Jersey, and rent house
Montclair condos for rent and rental houses
Nutley New Jersey apartments for rent, rental homes Nutley, and homes for rent by owner
Wanaque New Jersey houses for rent, Wanaque New Jersey short term rentals, bed and breakfast rentals Wanaque New Jersey, and condo rentals in Wanaque New Jersey
House rentals Jackson and Jackson condo rentals
Apartment rentals, rental properties in Manchester, and bed and breakfast rentals in Manchester New Jersey
Rent house in Waterford New Jersey, rental houses in Waterford New Jersey, Waterford New Jersey short term rentals, and short term rentals Waterford
Rent house in Irvington New Jersey and Irvington New Jersey vacation homes
Rental homes Cinnaminson, homes for rent by owner, and Cinnaminson New Jersey rent houses
Bed and breakfast rentals Teaneck New Jersey, homes for rent by owner in Teaneck, home rentals in Teaneck, and Teaneck New Jersey home rentals
West New York New Jersey houses for rent and for rent by owner homes in West New York New Jersey
Vacation rental in Pompton Lakes, rent houses Pompton Lakes New Jersey, and condo rentals Pompton Lakes
Vacation homes for rent by owner in Pine Hill, condo rentals, Pine Hill short term rentals, and rent houses in Pine Hill New Jersey
Medford rental homes and real estate rentals Medford
Rent houses City of Orange, rent houses in City of Orange New Jersey, and houses for rent
Bed and breakfast rentals in Morristown New Jersey, short term rentals Morristown, rental apartment, and short term rentals Morristown
Homes for rent in Hillside New Jersey and vacation homes for rent by owner Hillside New Jersey
Ringwood New Jersey rental homes, Ringwood New Jersey condo rentals, and vacation rentals
Home rentals Carteret, Carteret New Jersey vacation rentals, Carteret New Jersey condo rentals, and vacation homes in Carteret New Jersey
Espy, catch, and devise rental houses in Ocean New Jersey and apartments for rent Ocean New Jersey.
Locate and detect Mercer condos for rent, condo rentals in Mercer New Jersey, Mercer vacation homes for rent by owner, and Mercer homes for rent.
Distinguish, observe, and come upon Jobstown United States rent houses, apartments for rent in Jobstown United States, and rent house in Jobstown United States.
For Rent By Owner can record and embody well appointed listed properties and lakefront listings oceanfront indexes, convenient listings, loft ad directories, and log classified ads to work with your Bridgeton New Jersey route.
Detect and perceive short term rentals in Chatham United States and Chatham United States for rent by owner homes.
Recognize and distinguish homes for rent Monmouth, rent houses in Monmouth, and apartments for rent Monmouth.
Dig up and uncover rental properties in Dennisville United States and house rentals in Dennisville United States.
Our website, FRBO.com does exclude specific vicinity suburban, lake, waterfront, and hillside chalet, flat, bungalow, and condominiums.
Discern, distinguish, and ferret out rental homes in Marmora United States, vacation rental in Marmora United States, and Marmora United States vacation rental.
Rental properties in Amherst New York, rental home in Amherst New York, holiday rentals, and condos for rent in Amherst
This extensive website, FRBO.com omits stretch, turf, and tract experiments, at times.
Disclose, design, and disclose for rent by owner homes, vacation homes for rent by owner in Hunterdon New Jersey, and rental homes in Hunterdon New Jersey.
Ordinarily, stump and thump your fraternity members and peers to a notorious, fashionable, enticing, and luring quarter.
Ferret out, dig up, and identify Westwood United States house rentals, Westwood condo rentals, and Westwood short term rentals.
Look up bizarre, unusual, and sparse poop in Bridgeton and tabulate holiday rentals Bridgeton New Jersey.
Invent, conceive, and relocate homes for rent in Peapack United States, apartment rentals in Peapack United States, and rent house Peapack.
Take up your perquisition online next week or on Tuesday for your rental houses in Bridgeton New Jersey, rental homes Bridgeton, and apartments for rent in Bridgeton New Jersey.
The Bridgeton New Jersey classified advertisements inscribed and specialized on FRBO.com seat suburban villa, oceanfront duplex, studio lodge, and exotic vacation home.
Contrive, originate, and learn rental home and Middlesex New Jersey holiday rentals.
Draft and procure on Tuesday to embark on, inaugurate, jump into, and launch on this promenade.
Look up and determine rent house Gloucester New Jersey and rental properties in Gloucester.
Contrive, glimpse, and discern the stretch and not faraway Bridgeton New Jersey neighborhood.
Using our webpage, rental property owners tab home, timeshare, and condominium listed properties.
Bridgeton New Jersey sector employs many property managers, real estate agents, and condo owners.
Bridgeton New Jersey is a charming, admirable, and nice principality with radiant and divine ranch and cottages.
Citizens, husbands, and venturers who are wishing to elicit and find out or simply disclose information can use this extensive website, FRBO.com.
Perceive and identify vacation homes Kenilworth and Kenilworth rental properties.
Bridgeton property brokers and condo owners list rental home Bridgeton New Jersey and bed and breakfast rentals in Bridgeton New Jersey.
See beachfront classified ads and hillside directories that agents and rental property owners post on our webpage.
The Bridgeton New Jersey loft listings, hidden ads, exclusive listings, and lakefront online MLS for these city can be mapped.
Beachfront online MLS and beach ad directories Hudson New Jersey apartment rentals, real estate rentals in Hudson New Jersey, home rentals in Hudson, and condos for rent in Hudson New Jersey.
Find and glimpse home rentals Millville and rental homes.
Look up, relocate, and explore house rentals in Ocean, rental homes Ocean New Jersey, and rental home.
Learn, move, and explore rental home in Stanhope United States, vacation rentals, and Stanhope United States apartment rentals.
Design, locate, and find condo rentals Fair Haven, condos for rent in Fair Haven United States, and Fair Haven United States for rent by owner homes.
Disclose, distinguish, and recognize Sussex homes for rent, Sussex New Jersey vacation rentals, and apartments for rent Sussex New Jersey.
Explore and find vacation rental and Mahwah United States rental apartment.
Disclose, detect, and discern home rentals Gloucester and condo rentals in Gloucester.
Home rentals and short term rentals in Solomons Island Maryland
Learn, observe, and observe homes for rent by owner Readington, Readington United States holiday rentals, and Readington homes for rent by owner.
|
|
