|
<%@ 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 properties Monroe and condos for rent
Bed and breakfast rentals in Montclair, rental home in Montclair New Jersey, and real estate rentals
Rental houses in New Providence New Jersey, condo rentals, for rent by owner homes New Providence, and New Providence rental houses
Vacation rental Bloomfield and short term rentals in Bloomfield New Jersey
Summit New Jersey apartments for rent, homes for rent in Summit New Jersey, and rental properties Summit New Jersey
Homes for rent in Mount Laurel New Jersey, Mount Laurel houses for rent, Mount Laurel New Jersey rent houses, and rental homes in Mount Laurel New Jersey
Vacation homes in Galloway and rental houses Galloway
North Plainfield New Jersey rent house, homes for rent, and rental homes in North Plainfield New Jersey
Bed and breakfast rentals in Franklin New Jersey, home rentals in Franklin, rental properties, and houses for rent in Franklin New Jersey
Real estate rentals and for rent by owner homes in Montclair
Real estate rentals, Haddonfield bed and breakfast rentals, and rent house in Haddonfield
South Brunswick New Jersey rent houses, South Brunswick New Jersey holiday rentals, bed and breakfast rentals in South Brunswick New Jersey, and vacation rental in South Brunswick New Jersey
Vacation homes for rent by owner in Camden New Jersey and Camden rental homes
Pompton Lakes New Jersey vacation rentals, homes for rent by owner in Pompton Lakes New Jersey, and rent houses Pompton Lakes
Homes for rent Lindenwold New Jersey, rental houses in Lindenwold New Jersey, Lindenwold New Jersey rental home, and Lindenwold apartment rentals
Mantua New Jersey holiday rentals and Mantua New Jersey rent house
Apartment rentals in Ocean, rental apartment Ocean, and home rentals in Ocean
Home rentals Colts Neck, Colts Neck New Jersey homes for rent by owner, vacation homes Colts Neck, and vacation rental in Colts Neck New Jersey
Rental homes Egg Harbor New Jersey and vacation rentals Egg Harbor New Jersey
Residers, commuters, and itinerants rake, ransack, and scour our page and catch convenient houseboat, exotic house, secluded duplex, and ski in/out castle.
Elicit, discern, and conceive Monmouth rent houses, Monmouth rental apartment, and Monmouth New Jersey apartment rentals.
Uncover and light upon apartment rentals in Monmouth New Jersey, rental houses Monmouth New Jersey, and rent house in Monmouth.
Look up, notice, and ascertain vacation homes Middlesex New Jersey, vacation rental, and homes for rent by owner in Middlesex New Jersey.
Debunk and look up vacation homes in Matawan and Matawan United States vacation rentals.
Beachfront ads and rustic online MLS Middlesex New Jersey houses for rent, homes for rent by owner Middlesex, home rentals, and vacation homes in Middlesex New Jersey.
Locate, identify, and distinguish Salem New Jersey bed and breakfast rentals, rental properties Salem New Jersey, condos for rent in Salem, and rental houses Salem.
Light upon and relocate vacation homes for rent by owner in Cumberland New Jersey, holiday rentals Cumberland New Jersey, Cumberland real estate rentals, and bed and breakfast rentals in Cumberland.
Collegiates, soldiers, and displaced persons who are wishing to ascertain and perceive or simply conceive information can use our site, FRBO.com.
Identify, conceive, and learn Burlington rental apartment, Burlington New Jersey bed and breakfast rentals, houses for rent, and Burlington New Jersey rental home.
Bernards real estate investors, property agents, home owners, and third party listing companies list rental apartment in Bernards and Bernards New Jersey apartments for rent.
Elicit and glimpse bed and breakfast rentals in Bellmawr United States and Bellmawr United States rental properties.
The Bernards New Jersey ski in/out classifieds and beachfront listed properties for these state can be mapped.
Debunk and explore condos for rent in Clayton and homes for rent Clayton United States.
You can explore the secluded online MLS, mountain advertisements, and studio lists of marked properties under Bernards New Jersey rental home and condos for rent in Bernards New Jersey.
Come upon and learn Morris New Jersey rent houses, rental properties Morris, and Morris rental houses.
Find out and come across houses for rent Lodi and vacation homes for rent by owner Lodi United States.
Discover, locate, and look up Edison United States bed and breakfast rentals, homes for rent by owner in Edison United States, and Edison United States homes for rent.
Design and ascertain home rentals Cape May New Jersey and rental apartment in Cape May.
Our for rent by owner site, FRBO.com embodys township, section, and territory dope, successively.
Explore, conceive, and elicit houses for rent in Mendham United States, vacation rentals in Mendham, and vacation rental in Mendham.
Perceive, conceive, and elicit rent houses Bergen, home rentals in Bergen New Jersey, house rentals, and holiday rentals in Bergen New Jersey.
See loft classified ads, beach online MLS, spacious directories, and waterfront classified ads that rental owners and property brokers post on our page.
Our site, FRBO.com does subsume various stretch exotic and suburban farmhouse, castle, and lodges.
Come across and come upon vacation homes for rent by owner, homes for rent by owner, and Essex real estate rentals.
Dig up, ferret out, and ascertain Ocean City United States for rent by owner homes, Ocean City United States vacation homes, and Ocean City United States house rentals.
Learn, invent, and debunk rental houses in Mercer New Jersey and Mercer bed and breakfast rentals.
Send sublime, shapely, good-looking, and pretty notes regarding rental home in Bernards New Jersey and Bernards New Jersey homes for rent by owner found on our page.
|
|
