|
<%@ 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
Homes for rent in Hoboken and rental homes in Hoboken
Plainfield homes for rent by owner, Plainfield house rentals, and bed and breakfast rentals in Plainfield New Jersey
Houses for rent in Hasbrouck Heights New Jersey, rent house in Hasbrouck Heights New Jersey, short term rentals in Hasbrouck Heights New Jersey, and vacation rental in Hasbrouck Heights New Jersey
Rent houses in Scotch Plains New Jersey and rent house in Scotch Plains New Jersey
Branchburg New Jersey house rentals, rental home in Branchburg, and Branchburg New Jersey vacation rental
Galloway vacation rentals, Galloway New Jersey rent houses, rental houses in Galloway New Jersey, and Galloway vacation homes
Union rental home and home rentals
Franklin Lakes New Jersey rental properties, real estate rentals Franklin Lakes New Jersey, and Franklin Lakes New Jersey rental houses
Manchester New Jersey rent house, rental homes in Manchester, houses for rent in Manchester New Jersey, and Manchester New Jersey rental properties
Homes for rent Lakewood New Jersey and Lakewood condo rentals
Condo rentals Hawthorne New Jersey, Hawthorne homes for rent by owner, and rental properties in Hawthorne
Winslow real estate rentals, bed and breakfast rentals in Winslow, houses for rent Winslow, and rental home in Winslow New Jersey
Holiday rentals in Bergenfield and vacation homes in Bergenfield
Bed and breakfast rentals, house rentals, and Keansburg rental apartment
Bed and breakfast rentals, homes for rent in East Hanover, apartments for rent in East Hanover New Jersey, and houses for rent in East Hanover
Rent house Howell and house rentals in Howell New Jersey
Rental home in South River, house rentals, and South River New Jersey condos for rent
West Caldwell apartment rentals, houses for rent in West Caldwell New Jersey, homes for rent by owner in West Caldwell New Jersey, and West Caldwell New Jersey for rent by owner homes
Union City for rent by owner homes and holiday rentals in Union City New Jersey
Vacation homes for rent by owner Gloucester, Gloucester New Jersey vacation rental, and rental apartment
Neptune New Jersey vacation homes, rental properties in Neptune New Jersey, Neptune New Jersey condos for rent, and Neptune New Jersey vacation homes for rent by owner
Boarders, navigators, and hikers check, look over, and rake this webpage and design beachfront lodge, resort duplex, decadent villa, and lakeside cottage.
Our for rent by owner website can initiate, appoint, and initiate lake listed properties, well appointed lists of marked properties, hillside directories, and exotic online MLS exotic listings, decadent ads, convenient classifieds, and waterfront classifieds to cooperate your Parsippany-Troy Hills saunter.
Design, explore, and discover houses for rent Gloucester and Gloucester New Jersey condo rentals.
Observe, discern, and ferret out rental properties Califon, Califon holiday rentals, and Califon United States condo rentals.
Distinguish, ferret out, and ascertain rent house in Cumberland New Jersey, Cumberland New Jersey homes for rent, and rent house in Cumberland New Jersey.
Parsippany-Troy Hills is a well-formed, handsome, refined, and good-looking kingdom with ravishing, fair, wonderful, and excellent apartment, flat, and ranchs.
Using our online website, FRBO.com, rental agents tick off timeshare and villa lists of marked properties.
Explore and identify condo rentals in Sussex New Jersey and rental houses Sussex New Jersey.
You can contrive, come upon, and relocate bed and breakfast rentals in Parsippany-Troy Hills New Jersey, Parsippany-Troy Hills New Jersey short term rentals, and Parsippany-Troy Hills New Jersey rental home.
Look up and invent Sewaren United States for rent by owner homes and holiday rentals Sewaren United States.
Come upon, debunk, and distinguish rent house Gibbstown United States, rent houses Gibbstown, and Gibbstown house rentals.
Explore, invent, and come upon Cumberland New Jersey holiday rentals, apartment rentals in Cumberland, and for rent by owner homes in Cumberland.
Glimpse and explore condo rentals Somerset, condo rentals, and Somerset New Jersey homes for rent by owner.
Espy and uncover Carlstadt United States for rent by owner homes and Carlstadt United States houses for rent.
Get going your fishing expedition online tomorrow, day after tomorrow, on Friday, or now for your condo rentals in Parsippany-Troy Hills New Jersey, rental apartment in Parsippany-Troy Hills New Jersey, and houses for rent in Parsippany-Troy Hills New Jersey.
Originate and learn Port Norris United States rental properties and rental houses in Port Norris United States.
This website, FRBO.com omits patch and area picture, intermittently.
The Parsippany-Troy Hills New Jersey advertisements catalogued and placed on For Rent By Owner embrace convenient villa, lake timeshare, and hidden farmhouse.
Uncover, catch, and recognize Oldwick apartment rentals, apartments for rent Oldwick, and homes for rent in Oldwick United States.
Join our penthouse directories, resort classified ads, resort ads, and beach online MLS mailing list for Parsippany-Troy Hills New Jersey rental homes, homes for rent by owner in Parsippany-Troy Hills, and houses for rent in Parsippany-Troy Hills.
Notice, distinguish, and look up Cumberland New Jersey rental properties, rental houses in Cumberland, and apartment rentals in Cumberland New Jersey.
Identify and determine homes for rent in Sussex New Jersey and vacation homes in Sussex.
Light upon something else, atypical, and atypical brass tacks in Parsippany-Troy Hills New Jersey and inventory bed and breakfast rentals in Parsippany-Troy Hills New Jersey.
Hear and detect Little York United States real estate rentals and homes for rent.
Householders, troupers, and suburbanites who are wishing to find out and identify or simply come upon information can use our webpage.
|
|
