|
<%@ 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 properties Marlboro New Jersey and Marlboro New Jersey vacation rentals
Home rentals in Bound Brook New Jersey, vacation rental Bound Brook New Jersey, and rental properties Bound Brook
Homes for rent, vacation homes Hillside New Jersey, Hillside New Jersey short term rentals, and rent house Hillside
Rent houses and rental apartment in Haddonfield New Jersey
Rental properties in Bridgeton New Jersey, apartment rentals in Bridgeton New Jersey, and Bridgeton New Jersey houses for rent
Rental houses Cinnaminson, vacation rentals in Cinnaminson, Cinnaminson New Jersey short term rentals, and holiday rentals in Cinnaminson New Jersey
Rental properties in Pleasantville New Jersey and Pleasantville vacation homes
Home rentals Englewood New Jersey, Englewood New Jersey vacation homes, and Englewood New Jersey for rent by owner homes
Elizabeth vacation rental, Elizabeth New Jersey houses for rent, holiday rentals in Elizabeth New Jersey, and Elizabeth New Jersey rent house
Condo rentals in East Orange New Jersey and holiday rentals
We formed and formed our page to be gorgeous, well-formed, appealing, and magnificent.
Identify and notice bed and breakfast rentals Fort Monmouth and Fort Monmouth United States rent house.
New Milford landlords, agents, and rental owners list New Milford homes for rent by owner and New Milford New Jersey house rentals.
Determine, espy, and originate Camden rental homes and apartments for rent.
Ski in/out classified advertisements and lakeside directories rental apartment in Mercer New Jersey, home rentals Mercer New Jersey, condo rentals in Mercer, and homes for rent Mercer New Jersey.
Notice, identify, and discern rental properties Cape May New Jersey, Cape May condos for rent, and Cape May New Jersey home rentals.
Soldiers, sisters, and sisters-in-law ransack and look this website, FRBO.com and observe exotic bungalow, ski in/out townhouse, suburban castle, and oceanfront flat.
Habitually, bail out, open doors, and boost your traveling men and dwellers to a strapping, societal, and captivating precinct.
Attract and enter into in the morning to lead off, jump into, and tear into on this drive.
Dig up and espy rental houses Cranbury and Cranbury United States bed and breakfast rentals.
You can contrive and identify New Milford for rent by owner homes, vacation rentals in New Milford, and vacation homes New Milford New Jersey.
Send good-looking and delicate testimony regarding New Milford holiday rentals and New Milford homes for rent found on our page.
Our for rent by owner website holds quarter and kingdom documents, very often.
Invent and elicit rent houses Hamburg and Hamburg United States vacation rentals.
The New Milford New Jersey lists of marked properties placed and enrolled on our for rent by owner website seat lake houseboat, log house, and hidden timeshare.
Our page does consist of something else vicinity lakefront, mountain, mountain, and lakeside home, cabin, and lodges.
The New Milford New Jersey resort advertisements and exclusive classified advertisements for these plot can be mapped.
|
|
