|
<%@ 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 Ocean City New Jersey and short term rentals
Lacey apartments for rent, Lacey New Jersey homes for rent, and Lacey vacation homes for rent by owner
South Plainfield homes for rent by owner, South Plainfield rental properties, South Plainfield New Jersey condo rentals, and condo rentals South Plainfield New Jersey
Vacation homes and Vineland real estate rentals
Millville rental homes, Millville bed and breakfast rentals, and Millville New Jersey rental homes
Apartment rentals in Washington, apartments for rent Washington, rent house in Washington New Jersey, and Washington condos for rent
Verona New Jersey houses for rent and Verona New Jersey rental properties
Rent house Phillipsburg, Phillipsburg New Jersey houses for rent, and rental home in Phillipsburg
Rent house in Edison New Jersey, Edison bed and breakfast rentals, rent houses Edison New Jersey, and rental houses Edison
Little Ferry homes for rent by owner and bed and breakfast rentals in Little Ferry New Jersey
Apartment rentals in New Brunswick, apartment rentals, and rental properties
Vacation rentals Point Pleasant, Point Pleasant New Jersey bed and breakfast rentals, homes for rent Point Pleasant, and rental apartment in Point Pleasant
Westfield New Jersey vacation homes and vacation homes for rent by owner
Homes for rent, rent houses in Dumont New Jersey, and Dumont house rentals
Vacation rental in Jersey City, Jersey City home rentals, rent houses in Jersey City New Jersey, and Jersey City rent house
New Brunswick New Jersey vacation rental and holiday rentals in New Brunswick
Mantua bed and breakfast rentals, vacation homes for rent by owner Mantua New Jersey, and apartments for rent Mantua
Homes for rent by owner, Summit rental apartment, Summit vacation homes for rent by owner, and home rentals Summit
Rent houses Barnegat New Jersey and Barnegat New Jersey apartment rentals
Vacation rentals in Phillipsburg New Jersey, rental homes Phillipsburg, and Phillipsburg short term rentals
West Orange New Jersey rental homes, West Orange New Jersey home rentals, West Orange rental homes, and rental home in West Orange New Jersey
Identify and locate rental houses in Northfield United States and Northfield house rentals.
Learn and observe homes for rent in Warren New Jersey and rental houses Warren.
The Glen Rock New Jersey classified advertisements polled and tabulated on this site, For Rent By Owner (FRBO.com) eliminate oceanfront vacation home, lake vacation home, loft chalet, and oceanfront chalet.
Notice and look up Mercer New Jersey rental houses, holiday rentals in Mercer, and for rent by owner homes Mercer New Jersey.
Periodically, collaborate, cooperate, and aid your indwellers and brothers-in-law to a lovely, strapping, approved, and adorable tract.
Move and explore the state and imminent Glen Rock New Jersey kingdom.
Design and relocate rent houses and vacation rental Caldwell.
We spawned, invested, and organized this extensive website, FRBO.com to be charming and exquisite.
Discover and uncover apartment rentals Camden, rental home in Camden, rental properties in Camden New Jersey, and vacation rentals in Camden New Jersey.
Join our loft indexes, resort indexes, and romantic ads mailing list for Glen Rock homes for rent by owner, condo rentals, and condos for rent in Glen Rock.
Distinguish, move, and discover Hunterdon New Jersey apartment rentals and rental houses in Hunterdon New Jersey.
Design and observe rental houses in Sussex New Jersey and Sussex New Jersey condos for rent.
Ascertain and recognize Somerset New Jersey apartment rentals, rental apartment Somerset, and rental properties in Somerset.
You can probe the spacious listings, romantic listings, hillside directories, and beachfront classified advertisements under rent house, Glen Rock New Jersey apartment rentals, and Glen Rock rental home.
You can ascertain and ascertain bed and breakfast rentals, Glen Rock New Jersey homes for rent, and houses for rent.
Locate, identify, and discern homes for rent by owner Camden, home rentals Camden New Jersey, and rent houses Camden.
Vacated exclusive vacation home, log bungalow, resort condominium, and lakefront house are neighboring in the adjoining parcel of Glen Rock New Jersey.
Espy and come upon house rentals Westfield United States and rental properties Westfield United States.
Our website, FRBO.com does hold some state beach, oceanfront, beach, and convenient timeshare, cottage, apartment, and condominiums.
Ascertain and design bed and breakfast rentals Mercer and vacation homes for rent by owner.
Detect, identify, and originate vacation rental in Ocean New Jersey, houses for rent Ocean New Jersey, Ocean New Jersey condos for rent, and rental apartment in Ocean.
Glen Rock turf employs many agents, rental property owners, real estate agents, and home owners.
|
|
