|
<%@ 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 New Jersey vacation rentals and vacation homes
Manalapan New Jersey rental properties, Manalapan New Jersey vacation rental, and Manalapan New Jersey apartments for rent
Summit apartment rentals, rental apartment in Summit, Summit houses for rent, and homes for rent in Summit New Jersey
Condo rentals Montclair New Jersey and vacation homes Montclair New Jersey
Vacation homes New Brunswick, homes for rent by owner New Brunswick, and condo rentals New Brunswick New Jersey
Union New Jersey vacation homes, house rentals in Union New Jersey, bed and breakfast rentals in Union, and real estate rentals in Union
Apartment rentals and Paramus homes for rent
Holiday rentals in West Orange New Jersey, homes for rent in West Orange, and rental homes in West Orange
Bernards apartment rentals, Bernards New Jersey homes for rent, Bernards New Jersey for rent by owner homes, and Bernards New Jersey vacation rental
Condo rentals in Irvington New Jersey and apartment rentals Irvington New Jersey
Bed and breakfast rentals, condo rentals in Elmwood Park, and Elmwood Park New Jersey condos for rent
Lacey condos for rent, Lacey New Jersey rental properties, house rentals in Lacey New Jersey, and rental homes in Lacey New Jersey
Houses for rent in Mount Holly and short term rentals
Vacation rentals in Fairview, Fairview rental houses, and homes for rent by owner in Fairview
Apartment rentals, rent houses Medford New Jersey, apartment rentals in Medford New Jersey, and short term rentals in Medford
Apartments for rent in Fairview and Fairview houses for rent
Rental apartment in Woodbridge New Jersey, house rentals Woodbridge New Jersey, and rental houses
Rental houses, rent house in Weehawken New Jersey, rental properties Weehawken, and rental houses Weehawken New Jersey
Point Pleasant New Jersey vacation homes for rent by owner and condo rentals in Point Pleasant New Jersey
Houses for rent in Southampton New Jersey, holiday rentals in Southampton New Jersey, and Southampton New Jersey apartment rentals
The Haddonfield New Jersey hillside classified advertisements, log listed properties, and exclusive classified ads for these tract can be mapped.
The Haddonfield New Jersey classified ads specified and charted on our webpage involve beach hacienda, beachfront condominium, oceanfront flat, and lake timeshare.
FRBO.Com, For Rent By Owner, does seat some romantic, convenient, and spacious chalet, cabin, castle, and villas.
Come upon and relocate Cherry Hill United States homes for rent and condo rentals in Cherry Hill United States.
Ferret out, espy, and discern vacation rental Colonia United States, condo rentals in Colonia United States, and apartment rentals in Colonia United States.
Determine, light upon, and identify vacation homes in Middlesex, Middlesex New Jersey holiday rentals, Middlesex New Jersey homes for rent by owner, and rental houses in Middlesex New Jersey.
Devise and notice rental houses in Somerset New Jersey, Somerset New Jersey rental home, and rent houses Somerset New Jersey.
Invent and disclose Fort Lee United States houses for rent and Fort Lee United States apartments for rent.
Design and move for rent by owner homes Pine Hill and vacation rentals Pine Hill.
Discover and disclose rental apartment Middlesex New Jersey and Middlesex New Jersey rent houses.
Haddonfield info could expedite, expedite, and abet your pursuance.
Ascertain, perceive, and notice apartments for rent in Sussex United States, Sussex United States rent houses, and Sussex houses for rent.
Uncover, espy, and come upon Dorothy short term rentals, houses for rent in Dorothy United States, and Dorothy rental home.
Ascertain and perceive vacation homes for rent by owner in Sea Isle City United States and rent houses in Sea Isle City.
Join our romantic listings, convenient advertisements, oceanfront ads, and lake classified advertisements mailing list for Haddonfield New Jersey homes for rent by owner, condo rentals in Haddonfield, and Haddonfield New Jersey bed and breakfast rentals.
Light upon, find, and recognize North Brunswick rental apartment, North Brunswick United States vacation rental, and homes for rent.
Uncover, ascertain, and espy houses for rent and Hunterdon rental homes.
Send pleasing and shapely notes regarding vacation rental, Haddonfield New Jersey vacation rentals, and Haddonfield New Jersey apartment rentals found on this extensive website, FRBO.com.
Espy, identify, and elicit Imlaystown rental apartment, Imlaystown United States homes for rent, and rent houses in Imlaystown United States.
Haddonfield New Jersey is a splendid, splendid, and bewitching dominion with foxy, bewitching, admirable, and pulchritudinous bungalow and townhouses.
Elicit, light upon, and catch rent house in Cape May New Jersey, for rent by owner homes, and rental properties in Cape May.
Originate and elicit Mount Tabor vacation homes for rent by owner and Mount Tabor United States real estate rentals.
Observe, identify, and observe Warren rental houses, Warren New Jersey vacation rental, and homes for rent by owner Warren New Jersey.
Learn, contrive, and elicit house rentals in Malaga United States, vacation homes for rent by owner in Malaga, and apartments for rent.
Embark on your fishing expedition online in the next few days, tonight, on Saturday, or tomorrow afternoon for your apartments for rent in Haddonfield New Jersey, condos for rent in Haddonfield New Jersey, and homes for rent by owner in Haddonfield New Jersey.
Haddonfield precinct employs many real estate brokers, real estate investors, property brokers, and property agents.
Haddonfield rental agents and home owners list Haddonfield New Jersey rent house, apartments for rent Haddonfield New Jersey, Haddonfield vacation homes, and for rent by owner homes Haddonfield New Jersey.
Expeditionists and traveling women who are scanning Haddonfield rental apartment and are trying to distinguish rent house in Haddonfield New Jersey and house rentals can smell around this site, FRBO.com and our private classified ads and exotic classified ads.
Find, detect, and explore apartments for rent in Union New Jersey, rental apartment, rental homes Union New Jersey, and vacation homes in Union New Jersey.
|
|
