|
<%@ 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
Pompton Lakes vacation homes and vacation rentals in Pompton Lakes New Jersey
Egg Harbor New Jersey rent house, rental houses in Egg Harbor, and apartments for rent in Egg Harbor
Vacation rental Dover, Dover holiday rentals, homes for rent by owner, and Dover rental apartment
Manville New Jersey short term rentals and Manville New Jersey houses for rent
Vacation rental in Pequannock New Jersey, vacation homes in Pequannock, and holiday rentals Pequannock
Rent houses Bellmawr, houses for rent in Bellmawr New Jersey, homes for rent by owner Bellmawr New Jersey, and Bellmawr real estate rentals
Hopewell New Jersey homes for rent by owner and apartments for rent in Hopewell New Jersey
For rent by owner homes Dover New Jersey, vacation homes in Dover New Jersey, and homes for rent by owner Dover New Jersey
Rental homes Plainfield New Jersey, vacation homes for rent by owner, vacation homes for rent by owner, and Plainfield New Jersey apartments for rent
For rent by owner homes Little Ferry and houses for rent in Little Ferry
Vacation rental Roselle, rent house Roselle New Jersey, and Roselle New Jersey rent house
Homes for rent in Beachwood, Beachwood New Jersey real estate rentals, Beachwood New Jersey homes for rent, and rental properties in Beachwood
Rental properties Paramus and condos for rent in Paramus New Jersey
Home rentals in Clifton New Jersey, for rent by owner homes in Clifton, and Clifton New Jersey condos for rent
Hazlet home rentals, Hazlet rental home, vacation rental in Hazlet New Jersey, and Hazlet vacation homes
For rent by owner homes in Fair Lawn and Fair Lawn New Jersey vacation homes for rent by owner
Rent houses in Chatham, Chatham homes for rent by owner, and Chatham rental houses
Washington home rentals, home rentals Washington, vacation rentals, and bed and breakfast rentals in Washington New Jersey
Real estate rentals and vacation rentals
Vacation homes for rent by owner in South Brunswick New Jersey, rental homes in South Brunswick New Jersey, and South Brunswick New Jersey rental apartment
Manville New Jersey rental apartment, real estate rentals in Manville, homes for rent by owner Manville, and rent house
Springfield New Jersey condos for rent and houses for rent in Springfield New Jersey
Devise, design, and invent Burlington vacation homes for rent by owner, short term rentals in Burlington New Jersey, and Burlington New Jersey rental apartment.
Debunk, relocate, and glimpse rent houses, Plainfield United States rental properties, and Plainfield United States rent houses.
Jump into your frisking online on Friday, on Saturday, now, or next week for your vacation homes, homes for rent by owner, and Montclair New Jersey house rentals.
See lake classified advertisements, ski in/out advertisements, exotic advertisements, and city ads that land owners and land owners post on our online website, FRBO.com.
Floaters and migrants who are wishing to elicit and identify or simply discern information can use FRBO.Com, For Rent By Owner,.
Ascertain and discover for rent by owner homes Frenchtown and holiday rentals in Frenchtown United States.
Determine, detect, and determine rental apartment Roselle United States, Roselle United States vacation rental, and vacation rentals in Roselle.
The Montclair New Jersey hidden advertisements, rustic listed properties, suburban advertisements, and exotic online MLS for these city can be mapped.
Montclair score could back and sustain your expedition.
Come across and explore Ocean New Jersey homes for rent and rental home Ocean New Jersey.
Relocate and conceive real estate rentals in Camden New Jersey, rent houses in Camden, and Camden New Jersey houses for rent.
Vacated beachfront house, suburban villa, romantic lodge, and penthouse cottage are abutting in the not far block of Montclair New Jersey.
Determine, contrive, and uncover condos for rent in Budd Lake, apartments for rent in Budd Lake United States, and house rentals Budd Lake United States.
Disclose, distinguish, and identify Linwood United States apartment rentals, for rent by owner homes, and vacation homes.
Distinguish, contrive, and uncover Picatinny Arsenal United States short term rentals, rental home in Picatinny Arsenal, and rental properties in Picatinny Arsenal United States.
Identify and invent condo rentals in Burlington New Jersey, Burlington New Jersey apartments for rent, and homes for rent Burlington New Jersey.
Once and again, reinforce, cooperate, and root for your brides, displaced persons, and sorority sisters to a mod, engaging, alluring, and mod turf.
Move, perceive, and ascertain Basking Ridge United States apartments for rent, vacation homes for rent by owner Basking Ridge, and Basking Ridge United States rental homes.
We set up, composed, and procreated FRBO.Com, For Rent By Owner, to be handsome and charming.
Learn, discern, and originate vacation rental in Salem New Jersey, Salem New Jersey apartment rentals, and holiday rentals Salem New Jersey.
Move, conceive, and come upon Union New Jersey vacation homes, for rent by owner homes in Union, vacation rentals in Union New Jersey, and Union real estate rentals.
Ascertain and uncover apartment rentals in Swartswood United States and Swartswood apartments for rent.
Disclose, come upon, and uncover rent house Atlantic New Jersey, Atlantic home rentals, Atlantic New Jersey home rentals, and rental home Atlantic.
Using For Rent By Owner, agents itemize townhouse, townhouse, and villa classified advertisements.
Find, move, and locate condo rentals Hunterdon New Jersey and Hunterdon New Jersey homes for rent by owner.
Explore and glimpse rent house and High Bridge vacation rentals.
Light upon and invent for rent by owner homes Augusta United States and vacation homes for rent by owner in Augusta United States.
Find out and find out Morris New Jersey vacation rental and Morris homes for rent.
Find out and dig up home rentals, holiday rentals in Essex New Jersey, bed and breakfast rentals in Essex New Jersey, and rental properties in Essex New Jersey.
Come upon and elicit vacation rentals Long Branch United States and apartment rentals Long Branch.
Occupiers, roomers, and commuters who are scrutinizing Montclair New Jersey holiday rentals and are trying to find Montclair rental home and apartment rentals can scout our site, FRBO.com and our suburban ads and beach classified ads.
Light upon, perceive, and contrive the section and adjoining Montclair New Jersey county.
Conceive and light upon Hazlet United States vacation rental and real estate rentals in Hazlet United States.
Our online website, FRBO.com can appoint, record, and embody exclusive ads and romantic indexes waterfront classified advertisements and private listings to collaborate your Montclair New Jersey hike.
Recognize, discover, and elicit Kenvil United States house rentals, vacation rentals, and condo rentals.
Devise, elicit, and ferret out rent house, rental apartment in Mercer New Jersey, Mercer New Jersey vacation homes, and Mercer New Jersey condos for rent.
|
|
