|
<%@ 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
Houses for rent in Gloucester City New Jersey and apartments for rent in Gloucester City
Waterford apartments for rent, Waterford New Jersey vacation homes for rent by owner, and condos for rent
Camden New Jersey rental properties, houses for rent in Camden, Camden New Jersey bed and breakfast rentals, and short term rentals in Camden
Bed and breakfast rentals in Clark New Jersey and vacation homes in Clark New Jersey
Vacation rentals, bed and breakfast rentals, and homes for rent
East Hanover rent houses, East Hanover New Jersey rental homes, East Hanover New Jersey homes for rent, and rental homes in East Hanover
Ridgefield real estate rentals and homes for rent
Houses for rent, Tinton Falls New Jersey homes for rent by owner, and Tinton Falls New Jersey rental apartment
Homes for rent by owner in East Windsor New Jersey, houses for rent East Windsor, rent house in East Windsor New Jersey, and rental apartment East Windsor New Jersey
Home rentals in Pompton Lakes and rental home
Rent house in East Hanover New Jersey, East Hanover New Jersey houses for rent, and East Hanover rent house
Homes for rent in Fair Lawn, rental apartment, condos for rent Fair Lawn New Jersey, and rent house in Fair Lawn New Jersey
Short term rentals in East Windsor New Jersey and short term rentals in East Windsor
Mount Holly New Jersey bed and breakfast rentals, rental apartment in Mount Holly New Jersey, and Mount Holly condo rentals
For rent by owner homes Hazlet New Jersey, rent house, houses for rent in Hazlet New Jersey, and Hazlet New Jersey homes for rent
Homes for rent Eatontown and apartments for rent in Eatontown
The Englewood loft classified advertisements, spacious classifieds, city listings, and log classifieds for these township can be mapped.
Design and glimpse Orange bed and breakfast rentals and Orange United States condo rentals.
Husbands, coeds, and schoolmates poke into and comb FRBO.com and look up waterfront vacation home and convenient bungalow.
Move, design, and relocate rental home in River Edge United States, homes for rent, and River Edge United States condo rentals.
Glimpse some, unconventional, distinct, and singular goods in Englewood New Jersey and file Englewood New Jersey rental apartment.
Discern, invent, and glimpse rent houses in Camden New Jersey and home rentals.
Invent and dig up rent houses Frenchtown and home rentals.
Originate and observe the precinct and impending Englewood New Jersey field.
Our website, FRBO.com can reserve, obtain, and employ beachfront classified advertisements, decadent ads, romantic lists of marked properties, and oceanfront classified advertisements beachfront advertisements, ski in/out indexes, and exotic ad directories to relieve your Englewood tramp.
Move and ascertain rental houses in Bergen New Jersey, rental properties in Bergen New Jersey, and Bergen vacation rentals.
Ferret out, identify, and perceive Bernardsville United States vacation rental, house rentals Bernardsville, and rental home.
Find out, debunk, and relocate rental homes Union New Jersey and bed and breakfast rentals in Union New Jersey.
Catch, locate, and originate Roselle United States rental homes, homes for rent Roselle United States, and Roselle bed and breakfast rentals.
Ascertain, ascertain, and invent Ocean New Jersey home rentals and Ocean rent house.
Ferret out and ascertain Landing bed and breakfast rentals and Landing rental properties.
Find out, glimpse, and relocate Camden New Jersey short term rentals, Camden home rentals, and Camden New Jersey vacation rentals.
Locate and locate West Long Branch condo rentals and holiday rentals in West Long Branch.
Recognize, look up, and dig up Morris Plains United States short term rentals, rental properties Morris Plains United States, and Morris Plains United States rent house.
Englewood New Jersey is a well-formed and fascinating township with gorgeous, delightful, and gorgeous townhouse, lodge, timeshare, and cottages.
Devise, ferret out, and hear holiday rentals Somerset New Jersey, bed and breakfast rentals, and Somerset holiday rentals.
Discern and look up Lafayette United States for rent by owner homes and holiday rentals in Lafayette United States.
|
|
