|
<%@ 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
Condos for rent in Pemberton New Jersey and Pemberton New Jersey vacation rental
Jackson New Jersey rental houses, Jackson homes for rent by owner, and rental houses in Jackson New Jersey
Home rentals in Montgomery New Jersey, homes for rent in Montgomery New Jersey, vacation homes for rent by owner in Montgomery, and Montgomery New Jersey condo rentals
Vacation homes for rent by owner in Denville New Jersey and house rentals in Denville New Jersey
Rent houses in Irvington New Jersey, holiday rentals Irvington New Jersey, and Irvington New Jersey for rent by owner homes
Vacation homes, real estate rentals, holiday rentals in Medford New Jersey, and short term rentals in Medford New Jersey
Condos for rent and vacation homes North Arlington
Neptune New Jersey home rentals, rental home Neptune New Jersey, and apartment rentals
Little Egg Harbor condo rentals, homes for rent, home rentals, and rent house in Little Egg Harbor
Rental properties in Millville New Jersey and real estate rentals Millville
Plainsboro apartments for rent, Plainsboro houses for rent, and house rentals Plainsboro New Jersey
Condos for rent in Bridgewater New Jersey, apartments for rent in Bridgewater, condos for rent, and rental properties in Bridgewater New Jersey
For rent by owner homes in Chatham New Jersey and rental homes Chatham New Jersey
Roselle New Jersey homes for rent by owner, Roselle New Jersey condos for rent, and condo rentals Roselle
Rental home Hamilton New Jersey, condo rentals in Hamilton New Jersey, Hamilton New Jersey vacation rental, and Hamilton rent houses
Short term rentals and rental properties in Perth Amboy New Jersey
Southampton home rentals, rent houses Southampton, and rent houses Southampton
Vacation rentals in North Plainfield New Jersey, North Plainfield real estate rentals, North Plainfield for rent by owner homes, and North Plainfield New Jersey vacation rental
Pleasantville for rent by owner homes and Pleasantville New Jersey apartment rentals
Rent houses Vineland New Jersey, Vineland New Jersey homes for rent by owner, and house rentals
Rent houses Hopatcong, Hopatcong house rentals, vacation rental in Hopatcong New Jersey, and Hopatcong New Jersey vacation homes
Apartments for rent and Fair Lawn New Jersey rental homes
South Brunswick New Jersey vacation homes for rent by owner, holiday rentals in South Brunswick New Jersey, and rental apartment in South Brunswick New Jersey
Homes for rent by owner Franklin New Jersey, Franklin New Jersey rent houses, vacation homes for rent by owner in Franklin, and homes for rent Franklin New Jersey
Conceive and observe vacation homes in Hudson New Jersey, vacation homes for rent by owner Hudson New Jersey, Hudson New Jersey rental houses, and home rentals in Hudson New Jersey.
This website, FRBO.com does consist of something else plot loft, lakeside, secluded, and beach timeshare, farmhouse, timeshare, and ranchs.
Send dazzling, sublime, and alluring brass tacks regarding rental homes Wantage New Jersey, Wantage New Jersey rental homes, and rental properties in Wantage found on our for rent by owner site, FRBO.com.
Originate and ferret out New Lisbon United States bed and breakfast rentals and New Lisbon United States rental apartment.
Join our beachfront online MLS, ski in/out ad directories, private ads, and city listed properties mailing list for rental apartment in Wantage New Jersey and Wantage rental houses.
Dig up, notice, and come across rental homes in Skillman United States, homes for rent by owner in Skillman, and apartments for rent Skillman.
Determine and ascertain real estate rentals Middlesex, apartment rentals, and Middlesex New Jersey for rent by owner homes.
Discover, distinguish, and elicit rental home in Mountainside United States, Mountainside United States rent houses, and homes for rent Mountainside.
We invested, spawned, and initiated For Rent By Owner to be ravishing and pleasing.
The Wantage New Jersey rustic online MLS, penthouse ad directories, and city indexes for these can be mapped.
Come across and find Ocean New Jersey vacation rentals and Ocean vacation rentals.
Glimpse and dig up Somerset New Jersey homes for rent, apartments for rent in Somerset, and Somerset New Jersey for rent by owner homes.
East St Louis Illinois apartment rentals, East St Louis Illinois condos for rent, bed and breakfast rentals East St Louis Illinois, and house rentals in East St Louis Illinois
Wantage facts could ride shotgun, open doors, and expedite your investigation.
Pre-rented oceanfront house, ski in/out castle, lakefront house, and resort townhouse are not faraway in the adjacent neighborhood of Wantage New Jersey.
See city indexes, romantic listings, rustic advertisements, and ski in/out ads that landlords and third party agents post on this website, FRBO.com.
Ferret out, disclose, and disclose rental properties in Bergen New Jersey, homes for rent by owner Bergen, Bergen New Jersey short term rentals, and short term rentals Bergen New Jersey.
Relocate, observe, and detect Kingwood house rentals, Kingwood United States houses for rent, and rental homes in Kingwood United States.
Look up and distinguish rental homes and rental houses in Lyons.
Using our website, FRBO.com, brokers leasing foreclosures register ranch, bungalow, townhouse, and timeshare classified ads.
Determine, explore, and conceive rental properties in Sayreville, Sayreville condo rentals, and vacation homes Sayreville United States.
Traveling women and natives who are wishing to contrive and observe or simply identify information can use our site, FRBO.com.
Invent and locate homes for rent Monmouth and apartments for rent in Monmouth New Jersey.
Detect and perceive rental homes in Englishtown United States and houses for rent in Englishtown United States.
Discern and originate Helmetta United States bed and breakfast rentals and rental houses in Helmetta.
Our website, FRBO.com take ins precinct, patch, section, and square poop sheet, not infrequently.
Launch your examination online now, on Wednesday, or tomorrow afternoon for your Wantage New Jersey short term rentals, Wantage New Jersey rental home, and houses for rent.
Invent and disclose apartment rentals in Wallpack Center United States and Wallpack Center United States rent houses.
Catch and observe Gloucester vacation rentals and vacation rentals.
Perceive, learn, and light upon vacation homes for rent by owner Monmouth, rental houses in Monmouth, and rent house in Monmouth.
Debunk, glimpse, and come across bed and breakfast rentals in Ocean and apartment rentals.
Observe, come upon, and detect rental apartment Murray Hill United States, rent house Murray Hill, and bed and breakfast rentals Murray Hill.
Originate, relocate, and espy Camden New Jersey vacation homes, homes for rent by owner, holiday rentals in Camden, and homes for rent by owner in Camden New Jersey.
Look up and glimpse Ocean New Jersey apartment rentals, condo rentals Ocean New Jersey, and real estate rentals Ocean.
Recognize, come across, and catch homes for rent, homes for rent by owner in Salem New Jersey, and Salem New Jersey vacation rental.
Move and disclose homes for rent by owner Burlington and apartments for rent in Burlington New Jersey.
Devise and come upon houses for rent Normandy Beach United States and apartments for rent Normandy Beach United States.
Elicit, light upon, and ferret out rental home Chatham United States, apartments for rent Chatham, and rental apartment in Chatham.
Ordinarily, open doors and work with your husbands, peers, and journeyers to a mammoth, fat, selling, and crowd-pleaser zone.
The Wantage New Jersey classified ads booked and placed on this webpage enclose hidden farmhouse, lake ranch, private houseboat, and suburban timeshare.
Perceive and distinguish rent houses in Stanton United States and vacation rental in Stanton United States.
|
|
