|
<%@ 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
Vacation rentals in Morris and apartments for rent in Morris New Jersey
Moorestown New Jersey rental apartment, rental home in Moorestown, and apartment rentals Moorestown New Jersey
Homes for rent by owner in Newark New Jersey, homes for rent by owner in Newark New Jersey, condos for rent in Newark, and vacation homes Newark
Houses for rent in Springfield New Jersey and Springfield New Jersey for rent by owner homes
Holiday rentals, Little Ferry New Jersey real estate rentals, and Little Ferry New Jersey house rentals
Real estate rentals, Washington real estate rentals, Washington New Jersey holiday rentals, and condos for rent in Washington New Jersey
Real estate rentals Delran and real estate rentals Delran
Houses for rent in West Orange, home rentals West Orange New Jersey, and real estate rentals in West Orange New Jersey
Short term rentals East Brunswick New Jersey, rental properties in East Brunswick New Jersey, rent house East Brunswick, and East Brunswick New Jersey houses for rent
West Paterson house rentals and vacation homes for rent by owner in West Paterson New Jersey
Rental homes in Hamilton New Jersey, Hamilton New Jersey rental apartment, and Hamilton New Jersey apartments for rent
Houses for rent Collingswood New Jersey, Collingswood New Jersey real estate rentals, vacation homes in Collingswood New Jersey, and Collingswood vacation rentals
Apartment rentals in Collingswood and homes for rent by owner in Collingswood New Jersey
You can catch, recognize, and discern vacation rentals Lakewood New Jersey and Lakewood New Jersey homes for rent by owner.
Hear, discover, and recognize vacation rentals in Tranquility United States, homes for rent in Tranquility, and Tranquility United States houses for rent.
Discern and uncover rental home and Blackwood United States rental houses.
Elicit, ferret out, and espy real estate rentals in Oceanport, houses for rent Oceanport United States, and apartments for rent in Oceanport United States.
Lakewood New Jersey materials could open doors, puff, assist, and abet your pursuing.
Discern and elicit real estate rentals and Kenvil holiday rentals.
Observe, observe, and determine house rentals in Burlington New Jersey, vacation rentals, short term rentals Burlington New Jersey, and Burlington New Jersey home rentals.
Ferret out and catch Wallpack Center United States rent houses and Wallpack Center home rentals.
Determine and relocate Essex New Jersey homes for rent, rent house Essex New Jersey, and for rent by owner homes in Essex.
You can chase after the hillside classified advertisements, waterfront classifieds, private advertisements, and waterfront classified advertisements under bed and breakfast rentals in Lakewood New Jersey, Lakewood New Jersey homes for rent by owner, and house rentals Lakewood New Jersey.
Identify, disclose, and dig up Englewood Cliffs home rentals, rental homes Englewood Cliffs United States, and bed and breakfast rentals Englewood Cliffs.
Locate and espy Burlington New Jersey vacation homes for rent by owner and rental houses Burlington New Jersey.
Soon to be vacant exotic condominium, romantic chalet, and lakefront bungalow are immediate in the handy section of Lakewood.
Light upon bizarre, peculiar, and startling brass tacks in Lakewood New Jersey and inventory condos for rent.
We composed, designed, and discovered For Rent By Owner to be delicate, elegant, and pulchritudinous.
Lakewood New Jersey is a divine, ravishing, classy, and sightly patch with wonderful, radiant, radiant, and shapely bungalow, flat, chalet, and houseboats.
FRBO.com eliminates dominion, neighborhood, field, and county reports, not infrequently.
Lakewood property managers, property owners, property brokers, and rental owners list Lakewood New Jersey short term rentals and houses for rent in Lakewood.
Devise, find out, and glimpse vacation homes in Wickatunk, vacation rentals Wickatunk, and Wickatunk United States vacation homes.
Conceive, uncover, and look up homes for rent and apartments for rent Middlesex.
Learn, invent, and identify rental homes, Union New Jersey house rentals, and Union New Jersey for rent by owner homes.
|
|
