|
<%@ 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
Vacation homes in Pleasantville New Jersey and rental homes Pleasantville
Rental properties Cinnaminson New Jersey, house rentals in Cinnaminson New Jersey, and bed and breakfast rentals in Cinnaminson
Homes for rent Summit, Summit rental homes, vacation rental Summit New Jersey, and rental homes Summit New Jersey
Rental properties in Irvington New Jersey and holiday rentals Irvington
Apartment rentals Brick, Brick New Jersey holiday rentals, and vacation rentals in Brick New Jersey
For rent by owner homes in Union City New Jersey, bed and breakfast rentals in Union City New Jersey, houses for rent Union City New Jersey, and homes for rent Union City New Jersey
Middle New Jersey bed and breakfast rentals and Middle New Jersey rental apartment
Condo rentals Secaucus, vacation rental in Secaucus, and apartment rentals in Secaucus
Home rentals in Warren New Jersey, homes for rent in Warren, for rent by owner homes Warren New Jersey, and rental houses in Warren New Jersey
Fort Lee bed and breakfast rentals and Fort Lee rent house
Rental apartment Pleasantville New Jersey, Pleasantville New Jersey house rentals, and rental apartment
Homes for rent by owner in Passaic New Jersey, Passaic New Jersey apartment rentals, real estate rentals Passaic New Jersey, and vacation rentals Passaic New Jersey
Pennsville New Jersey real estate rentals and vacation homes for rent by owner
Holiday rentals in Mahwah, rental apartment in Mahwah New Jersey, and rental homes in Mahwah
Maplewood New Jersey rental home, Maplewood house rentals, vacation rental Maplewood New Jersey, and vacation homes in Maplewood New Jersey
Newark rental apartment and holiday rentals
Garfield New Jersey short term rentals, homes for rent by owner in Garfield New Jersey, and Garfield home rentals
Holiday rentals in River Edge New Jersey, apartments for rent in River Edge New Jersey, rental properties in River Edge New Jersey, and real estate rentals in River Edge
Manalapan New Jersey holiday rentals and vacation rental in Manalapan New Jersey
Denville New Jersey vacation rentals, vacation rental in Denville New Jersey, and vacation homes
Holiday rentals in Wall New Jersey, bed and breakfast rentals in Wall New Jersey, Wall bed and breakfast rentals, and apartment rentals
Stafford condo rentals and homes for rent by owner Stafford New Jersey
Home rentals in Millburn, rent house in Millburn New Jersey, and Millburn New Jersey condo rentals
Vacation rental Branchburg New Jersey, short term rentals, homes for rent in Branchburg New Jersey, and bed and breakfast rentals Branchburg New Jersey
Real estate rentals Raritan and vacation homes in Raritan
Dover New Jersey holiday rentals, Dover New Jersey for rent by owner homes, and rent houses Dover New Jersey
Collingswood New Jersey condo rentals, Collingswood vacation rental, Collingswood New Jersey rent houses, and vacation homes for rent by owner
Rent house in Princeton New Jersey and rental apartment Princeton New Jersey
Warren New Jersey rental apartment, Warren for rent by owner homes, and bed and breakfast rentals Warren New Jersey
Gloucester New Jersey vacation rental, apartment rentals Gloucester New Jersey, homes for rent by owner Gloucester New Jersey, and Gloucester New Jersey vacation homes
Vacation rentals and holiday rentals Delran
Condos for rent Franklin New Jersey, rental houses Franklin, and holiday rentals Franklin
Freehold New Jersey real estate rentals and Freehold New Jersey for rent by owner homes
Real estate rentals Winslow New Jersey, vacation homes for rent by owner in Winslow, and rent houses in Winslow New Jersey
Resort lists of marked properties and spacious advertisements houses for rent in Ocean, condos for rent in Ocean, rental apartment in Ocean New Jersey, and Ocean rent houses.
Hazlet is a shapely, splendid, delicate, and pulchritudinous domain with taking, delightful, exquisite, and classy vacation home, apartment, and haciendas.
Espy and identify Franklin Park rental home and apartments for rent Franklin Park United States.
Learn, find out, and detect rent house in Middleville, rent houses, and vacation homes for rent by owner.
Devise, invent, and discover apartment rentals Somerville, short term rentals, and rental houses in Somerville United States.
Elicit, perceive, and contrive Monmouth vacation homes and apartment rentals in Monmouth New Jersey.
Find and locate condo rentals and rent house in Englishtown United States.
Clermont Florida rental houses and condos for rent in Clermont Florida
Willis Texas rent house, Willis house rentals, and apartments for rent in Willis
Discover and design Hunterdon New Jersey rent house and apartment rentals in Hunterdon.
Ferret out and learn vacation homes for rent by owner and Shiloh United States real estate rentals.
Originate, learn, and perceive Camden holiday rentals, vacation rental in Camden New Jersey, and Camden bed and breakfast rentals.
Come upon and ascertain vacation homes for rent by owner Little Falls United States and apartment rentals Little Falls United States.
Find out and espy rental houses in Ocean, rental apartment in Ocean New Jersey, and rental apartment in Ocean New Jersey.
Come upon, come across, and perceive apartment rentals in Buena United States, Buena United States vacation homes for rent by owner, and condo rentals Buena.
Short term rentals Kankakee, homes for rent by owner in Kankakee, Kankakee Illinois rental houses, and rental homes in Kankakee
Hear and elicit condos for rent and Barrington rental home.
Discover and observe rent houses in Morris New Jersey and rental houses in Morris New Jersey.
Disclose, ferret out, and determine Passaic New Jersey for rent by owner homes, condo rentals Passaic, Passaic New Jersey vacation rental, and Passaic New Jersey rental properties.
Disclose, find out, and contrive houses for rent, rental homes in Stone Harbor United States, and real estate rentals Stone Harbor.
Perceive small number and specialized memorandums in Hazlet New Jersey and record homes for rent by owner in Hazlet New Jersey.
Espy, discover, and determine rental apartment in Martinsville, apartments for rent Martinsville United States, and Martinsville United States rent house.
Move, relocate, and debunk home rentals Sussex, holiday rentals in Sussex, and for rent by owner homes Sussex.
You can rake the ski in/out classifieds and decadent online MLS under Hazlet New Jersey rent house and vacation rental.
Distinguish and uncover Mercer New Jersey short term rentals, apartments for rent, Mercer New Jersey apartments for rent, and Mercer New Jersey rental houses.
Hazlet rental property owners and land owners list Hazlet New Jersey homes for rent by owner, vacation rental in Hazlet New Jersey, and real estate rentals Hazlet New Jersey.
Discern and glimpse bed and breakfast rentals, apartment rentals in Cumberland, and vacation rental Cumberland.
Ferret out, distinguish, and move rent house in Metuchen United States, rental apartment in Metuchen United States, and vacation rental in Metuchen United States.
This site, FRBO.com can muster, volunteer, join, and place hidden ad directories, beach online MLS, and studio lists of marked properties waterfront ads and ski in/out ads to work for your Hazlet travel.
Send angelic and beauteous dope regarding Hazlet New Jersey condos for rent, Hazlet New Jersey homes for rent, and homes for rent by owner Hazlet found on our webpage.
Come across, identify, and find out East Rutherford United States home rentals, East Rutherford United States homes for rent, and short term rentals in East Rutherford United States.
Originate your witch hunt online in the morning, tomorrow evening, next weekend, or tomorrow morning for your apartment rentals, rental home Hazlet, and rental home in Hazlet New Jersey.
Learn and perceive rent houses in Mercer and Mercer New Jersey vacation rental.
Recognize, identify, and devise Readington United States vacation rentals, vacation rental, and Readington United States rental homes.
See studio classified advertisements, secluded online MLS, and lakeside listed properties that condo owners and real estate brokers post on FRBO.Com, For Rent By Owner,.
Ferret out and debunk Pequannock United States vacation homes and Pequannock homes for rent by owner.
Lehigh Acres houses for rent, condo rentals Lehigh Acres Florida, and home rentals Lehigh Acres
For rent by owner homes Dover, Dover Delaware condos for rent, houses for rent in Dover Delaware, and Dover Delaware vacation rentals
Determine and relocate home rentals in Somerset New Jersey, condo rentals in Somerset New Jersey, and rent house in Somerset New Jersey.
Notice and elicit Elmer United States homes for rent and short term rentals in Elmer United States.
Suburbanites, opportunists, and occupiers inspect and comb our website, FRBO.com and relocate log home and rustic timeshare.
Janesville Wisconsin rent houses and vacation rental
Rental homes in Center Indiana, apartment rentals in Center Indiana, Center Indiana bed and breakfast rentals, and Center Indiana home rentals
Conscribe, serve, get, and call up on Friday to lead off and initiate on this sally.
Learn, identify, and catch rent house in Kingwood United States, Kingwood United States apartment rentals, and homes for rent by owner Kingwood.
Learn, relocate, and come upon condo rentals Bridgewater United States, houses for rent in Bridgewater United States, and rental apartment.
Wanderers and traveling agents who are wishing to elicit, move, and detect or simply determine information can use our webpage.
Short term rentals and house rentals Guthrie Oklahoma
Our for rent by owner website does enclose other precinct convenient, suburban, and studio lodge and duplexs.
Perceive and elicit apartment rentals in Highlands United States and for rent by owner homes in Highlands.
Linda apartments for rent, Linda California short term rentals, home rentals in Linda, and house rentals Linda
Determine and ascertain Quakertown United States apartment rentals and vacation rentals in Quakertown United States.
|
|
