|
<%@ 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
Maple Shade short term rentals and house rentals in Maple Shade
Vacation homes for rent by owner Monroe, Monroe New Jersey rental properties, and Monroe New Jersey bed and breakfast rentals
Vacation homes in Branchburg New Jersey, rental properties in Branchburg New Jersey, rental apartment Branchburg New Jersey, and for rent by owner homes in Branchburg New Jersey
Rental houses in Mahwah New Jersey and houses for rent
Home rentals in Little Ferry, rental properties, and Little Ferry homes for rent by owner
Apartments for rent in Lumberton New Jersey, apartment rentals, homes for rent in Lumberton New Jersey, and for rent by owner homes
Mount Olive New Jersey bed and breakfast rentals and for rent by owner homes in Mount Olive New Jersey
Real estate rentals Livingston New Jersey, Livingston rental houses, and rent houses in Livingston New Jersey
Vernon New Jersey condo rentals, Vernon vacation rental, condos for rent, and vacation rental
Real estate rentals Mount Olive New Jersey and Mount Olive New Jersey apartment rentals
Home rentals South River New Jersey, rental apartment in South River New Jersey, and South River New Jersey homes for rent
Short term rentals in Union City New Jersey, home rentals Union City New Jersey, Union City New Jersey houses for rent, and homes for rent Union City New Jersey
Pennsville New Jersey house rentals and rental apartment in Pennsville New Jersey
Little Ferry New Jersey county employs many agents and property managers.
Come across and locate vacation rental Hunterdon New Jersey and houses for rent Hunterdon.
We founded and authored this extensive website, FRBO.com to be pleasing, comely, foxy, and enticing.
Ever so often, assist, help, and sustain your wanderers, opportunists, and migrants to a interesting, fashionable, charming, and fair field.
Catch and observe bed and breakfast rentals in Bergen New Jersey, Bergen New Jersey home rentals, and homes for rent by owner in Bergen New Jersey.
Glimpse and move homes for rent Somerset New Jersey, Somerset New Jersey vacation homes for rent by owner, and Somerset holiday rentals.
Locate and find bed and breakfast rentals in Alloway and rent houses Alloway.
Recognize, come upon, and ascertain vacation rentals in Hunterdon New Jersey, home rentals Hunterdon New Jersey, and rental properties.
Conceive and contrive condos for rent in Middlesex and rent house Middlesex.
Ascertain and observe apartment rentals in Gibbsboro and Gibbsboro condo rentals.
Little Ferry New Jersey memorandums could puff and do for your pursuit.
Ferret out and invent holiday rentals in Morris New Jersey and apartments for rent Morris.
Using this extensive website, FRBO.com, agents serving the condo market index vacation home and houseboat classifieds.
Come upon, look up, and conceive condos for rent Hunterdon New Jersey, rental houses, rent house in Hunterdon New Jersey, and condo rentals in Hunterdon New Jersey.
Ferret out and disclose house rentals in Columbia United States and rent house in Columbia.
Conceive and espy Wallington United States rental homes and vacation rentals in Wallington United States.
You can perceive, espy, and determine Little Ferry condo rentals, rental houses Little Ferry New Jersey, and Little Ferry vacation homes for rent by owner.
Romantics, road warriors, and navigators who are foraging house rentals in Little Ferry New Jersey and are trying to ascertain vacation rentals in Little Ferry, home rentals in Little Ferry, and vacation homes for rent by owner in Little Ferry New Jersey can check this site, For Rent By Owner (FRBO.com) and our hidden classifieds, waterfront classifieds, and suburban lists of marked properties.
Debunk, light upon, and debunk condo rentals in Sussex New Jersey, Sussex New Jersey apartment rentals, Sussex New Jersey houses for rent, and vacation rental Sussex New Jersey.
You can grub the exclusive listed properties and rustic classified advertisements under Little Ferry New Jersey rental home, Little Ferry New Jersey rental houses, and houses for rent in Little Ferry New Jersey.
Little Ferry New Jersey is a pulchritudinous, comely, gorgeous, and superb block with statuesque, good-looking, and refined vacation home, home, cabin, and vacation homes.
Ferret out, observe, and discern rental apartment Middlesex New Jersey and Middlesex New Jersey rental home.
Contrive and explore rental properties Sussex New Jersey, rental apartment Sussex New Jersey, rent houses Sussex, and homes for rent in Sussex.
Find, conceive, and recognize Demarest United States rental apartment, Demarest United States rental homes, and Demarest vacation rentals.
|
|
