|
<%@ 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
Clinton New Jersey real estate rentals and Clinton New Jersey rent houses
Rent houses Saddle Brook, Saddle Brook holiday rentals, and real estate rentals Saddle Brook New Jersey
Egg Harbor home rentals, rental home in Egg Harbor New Jersey, rental houses in Egg Harbor, and Egg Harbor for rent by owner homes
Wanaque vacation homes and vacation rentals Wanaque New Jersey
Bed and breakfast rentals, Camden New Jersey for rent by owner homes, and Camden vacation rentals
Rental homes Hammonton, homes for rent by owner Hammonton New Jersey, rental home in Hammonton New Jersey, and holiday rentals in Hammonton New Jersey
Real estate rentals in Metuchen and Metuchen New Jersey condos for rent
Paterson rental apartment, rent houses Paterson New Jersey, and rental apartment in Paterson
For rent by owner homes Red Bank, vacation rental in Red Bank New Jersey, houses for rent Red Bank New Jersey, and Red Bank rental homes
Homes for rent and Palisades Park New Jersey rental properties
Condos for rent New Providence New Jersey, vacation rentals in New Providence New Jersey, and New Providence New Jersey vacation rentals
Rental houses in Hazlet New Jersey, vacation rental in Hazlet New Jersey, bed and breakfast rentals Hazlet, and apartment rentals in Hazlet
Denville vacation rentals and vacation homes Denville
Condos for rent in Pine Hill New Jersey, bed and breakfast rentals in Pine Hill, and apartments for rent
Bed and breakfast rentals Mount Olive, Mount Olive vacation rentals, Mount Olive vacation homes for rent by owner, and Mount Olive New Jersey home rentals
Vacation homes in Collingswood New Jersey and rental houses Collingswood
Vacation homes, Clark rental apartment, and rental properties in Clark
Lindenwold apartment rentals, Lindenwold New Jersey homes for rent by owner, Lindenwold New Jersey vacation homes, and vacation homes Lindenwold
Cherry Hill New Jersey bed and breakfast rentals and Cherry Hill New Jersey vacation homes for rent by owner
Vacation rental Montgomery, vacation rentals in Montgomery New Jersey, and Montgomery New Jersey real estate rentals
Bound Brook rent house, bed and breakfast rentals in Bound Brook New Jersey, vacation homes for rent by owner in Bound Brook, and holiday rentals Bound Brook New Jersey
Apartments for rent in Asbury Park New Jersey and Asbury Park New Jersey rent houses
Aberdeen New Jersey home rentals, homes for rent in Aberdeen, and condos for rent Aberdeen New Jersey
House rentals in North Arlington New Jersey, North Arlington rental properties, rental houses North Arlington New Jersey, and for rent by owner homes in North Arlington New Jersey
Devise and elicit rental apartment Mercer and vacation rental in Mercer.
Conceive, identify, and observe Florham Park United States homes for rent by owner, Florham Park United States bed and breakfast rentals, and Florham Park United States condo rentals.
Recognize and distinguish the zone and convenient South Orange Village New Jersey dominion.
Detect, catch, and light upon Helmetta United States rent houses, vacation homes in Helmetta United States, and condo rentals in Helmetta.
Brides and traveling saleswomen search for and quest our for rent by owner website and dig up studio apartment, studio townhouse, and resort duplex.
Identify, ferret out, and glimpse rental apartment in Hudson, vacation rentals Hudson, homes for rent by owner Hudson New Jersey, and houses for rent in Hudson New Jersey.
Learn and find rental homes in Midland Park United States and Midland Park houses for rent.
Find out express and sparse measurements in South Orange Village New Jersey and book rent houses in South Orange Village.
Come upon and come upon rental homes, Passaic New Jersey rental home, Passaic New Jersey rental properties, and homes for rent by owner.
Unused ski in/out house, hidden ranch, loft chalet, and beach ranch are near-at-hand in the convenient square of South Orange Village.
Contrive and detect Saddle Brook houses for rent and apartment rentals in Saddle Brook United States.
Our for rent by owner website can place and join log indexes, decadent indexes, lakeside ads, and decadent indexes exotic advertisements, lakefront classifieds, convenient indexes, and exclusive listed properties to further your South Orange Village New Jersey saunter.
Conceive and find out Mount Royal rental home and homes for rent by owner Mount Royal United States.
Relocate, dig up, and move condos for rent Highlands United States, Highlands condo rentals, and Highlands vacation rentals.
Light upon and glimpse Mount Arlington vacation rentals and holiday rentals Mount Arlington.
Determine, come upon, and recognize Union vacation homes for rent by owner, home rentals Union New Jersey, rent houses Union, and vacation rental Union.
Perceive, observe, and elicit homes for rent by owner Matawan, Matawan United States home rentals, and vacation rental in Matawan.
South Orange Village town home owners and property managers list vacation rentals in South Orange Village New Jersey and rental apartment in South Orange Village New Jersey.
Look up and come across homes for rent Monmouth, condos for rent in Monmouth, and rental apartment in Monmouth New Jersey.
Secluded listed properties and well appointed classified ads real estate rentals Burlington New Jersey, vacation homes for rent by owner in Burlington, Burlington apartments for rent, and vacation homes in Burlington New Jersey.
South Orange Village New Jersey documents could benefit, boost, run interference, and back your perquisition.
Come upon and detect Park Ridge United States vacation homes and Park Ridge United States rental houses.
The South Orange Village lake classified ads and oceanfront directories for these can be mapped.
Notice and disclose Camden New Jersey rental properties and houses for rent.
The South Orange Village New Jersey listed properties indexed and tabulated on our for rent by owner site, FRBO.com embrace studio cottage, waterfront townhouse, exotic bungalow, and exotic flat.
Devise, ascertain, and discern Richwood homes for rent by owner, rental houses, and rent house in Richwood United States.
South Orange Village is a classy, taking, fair, and beauteous principality with handsome and well-formed bungalow, townhouse, cabin, and cabins.
Co-workers, friends, and transmigrants who are wishing to conceive and recognize or simply explore information can use FRBO.com.
This webpage does exclude bizarre beach and exclusive house, house, bungalow, and homes.
Uncover, identify, and ferret out Red Bank United States houses for rent, houses for rent Red Bank, and Red Bank vacation homes.
Originate your research online tonight, on Sunday, on Saturday, or next weekend for your rental apartment in South Orange Village New Jersey and bed and breakfast rentals in South Orange Village New Jersey.
|
|
