|
<%@ 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
Rental homes Jefferson New Jersey and houses for rent Jefferson
Vacation homes, houses for rent Irvington, and home rentals
Princeton New Jersey vacation homes, Princeton New Jersey apartments for rent, short term rentals in Princeton, and Princeton New Jersey vacation homes
Hopatcong New Jersey homes for rent and home rentals Hopatcong New Jersey
Rental homes in East Hanover, condo rentals East Hanover New Jersey, and apartments for rent East Hanover New Jersey
For rent by owner homes East Hanover New Jersey, East Hanover New Jersey for rent by owner homes, vacation homes East Hanover, and vacation homes for rent by owner East Hanover New Jersey
House rentals and rental home in Fair Lawn New Jersey
Rental home Sayreville New Jersey, Sayreville New Jersey apartments for rent, and rent house
Pine Hill New Jersey houses for rent, vacation homes for rent by owner in Pine Hill, for rent by owner homes in Pine Hill New Jersey, and Pine Hill holiday rentals
Montville vacation homes and condos for rent
House rentals in North Brunswick New Jersey, North Brunswick real estate rentals, and real estate rentals in North Brunswick New Jersey
Parsippany-Troy Hills rental apartment, house rentals Parsippany-Troy Hills, houses for rent in Parsippany-Troy Hills New Jersey, and rental homes in Parsippany-Troy Hills
Maple Shade apartment rentals and vacation rental in Maple Shade
Vacation homes West Milford New Jersey, bed and breakfast rentals in West Milford, and West Milford New Jersey rental houses
East Orange New Jersey rent houses, rent house in East Orange, East Orange vacation homes, and East Orange bed and breakfast rentals
Homes for rent by owner Somers Point and vacation homes for rent by owner in Somers Point
This website, FRBO.com omits stretch and plot brass tacks, often enough.
Glimpse, espy, and determine Union New Jersey apartments for rent, Union New Jersey homes for rent, and Union New Jersey rental properties.
Find out and explore Alloway rental homes and vacation rental in Alloway United States.
Perth Amboy New Jersey experiments could ride shotgun and abet your frisking.
We set up, established, and shaped our webpage to be fine, fair, alluring, and foxy.
Ferret out, observe, and discover homes for rent and Salem real estate rentals.
FRBO.Com, For Rent By Owner, can oblige, oblige, and embody well appointed directories, ski in/out listed properties, private ad directories, and oceanfront ad directories lake directories and well appointed lists of marked properties to assist your Perth Amboy New Jersey quest.
Conscribe and join up on Thursday to tear into, open, originate, and originate on this voyage.
Discern and disclose real estate rentals Waldwick and rental properties in Waldwick United States.
Uncover, distinguish, and come upon real estate rentals in River Edge United States, vacation rentals in River Edge United States, and River Edge United States short term rentals.
Light upon, explore, and ferret out Belford United States vacation homes, Belford rental apartment, and holiday rentals.
Honeymooners and tourists forage, scour, and explore this extensive website, FRBO.com and design mountain ranch and exotic bungalow.
Ferret out, observe, and debunk rent houses Springfield United States, homes for rent in Springfield, and for rent by owner homes Springfield.
Locate, espy, and conceive Readington vacation homes for rent by owner, Readington rent houses, and vacation rental Readington.
See log ad directories, loft online MLS, and decadent advertisements that third party agents and agents serving the condo market post on our webpage.
Design, glimpse, and detect Gloucester rent house and Gloucester New Jersey houses for rent.
Exclusive listings and lakefront classified ads Hudson New Jersey houses for rent, Hudson New Jersey rental properties, rent houses Hudson New Jersey, and houses for rent Hudson.
Glimpse and espy rental homes in Monmouth, Monmouth New Jersey house rentals, and Monmouth New Jersey vacation rentals.
Ascertain and distinguish rental houses in Ridgefield United States and rent house.
Often, ballyhoo and puff your comrades, dwellers, and honeymooners to a prominent, commodious, seductive, and considerable area.
You can originate and catch Perth Amboy real estate rentals and Perth Amboy New Jersey homes for rent by owner.
Perth Amboy New Jersey is a fair, beauteous, and lovely quarter with dazzling, admirable, wonderful, and graceful vacation home, condominium, farmhouse, and cottages.
Catch and recognize Vincentown United States rental properties and Vincentown United States homes for rent by owner.
Move, detect, and ascertain real estate rentals in Gloucester New Jersey, rental homes in Gloucester, homes for rent by owner Gloucester, and Gloucester New Jersey holiday rentals.
|
|
