|
<%@ 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
Lumberton real estate rentals and Lumberton vacation homes
Gloucester New Jersey condos for rent, rental homes Gloucester New Jersey, and rent house
Edison New Jersey apartments for rent, condo rentals in Edison New Jersey, rental houses in Edison New Jersey, and Edison New Jersey apartments for rent
Homes for rent by owner in Bernards and rental houses in Bernards New Jersey
Willingboro for rent by owner homes, rental houses in Willingboro New Jersey, and Willingboro homes for rent by owner
Elmwood Park New Jersey homes for rent by owner, apartment rentals Elmwood Park, Elmwood Park New Jersey rent houses, and for rent by owner homes Elmwood Park
Houses for rent in Manchester and home rentals in Manchester New Jersey
Egg Harbor New Jersey rent house, Egg Harbor New Jersey vacation homes for rent by owner, and house rentals in Egg Harbor New Jersey
Homes for rent by owner in Long Branch New Jersey, rental home Long Branch New Jersey, vacation homes for rent by owner in Long Branch, and homes for rent by owner
Rental apartment in West Milford New Jersey and West Milford New Jersey apartment rentals
Homes for rent by owner, Manchester rent house, and Manchester New Jersey home rentals
Branchburg New Jersey home rentals, Branchburg New Jersey holiday rentals, holiday rentals Branchburg New Jersey, and Branchburg vacation rental
Vacation rentals and rental home in Brigantine New Jersey
Summit New Jersey rent houses, Summit condos for rent, and Summit rent house
Homes for rent by owner, Pleasantville rental home, house rentals in Pleasantville, and Pleasantville for rent by owner homes
Apartments for rent in Saddle Brook New Jersey and apartment rentals in Saddle Brook New Jersey
Apartment rentals in Branchburg, rental apartment Branchburg, and vacation homes for rent by owner in Branchburg
Rent houses Willingboro New Jersey, rental houses, bed and breakfast rentals in Willingboro New Jersey, and home rentals Willingboro New Jersey
Rutherford New Jersey vacation rental and Rutherford New Jersey vacation rentals
Rental homes in Cinnaminson, Cinnaminson New Jersey for rent by owner homes, and Cinnaminson vacation homes
Apartments for rent, apartments for rent in Lodi New Jersey, for rent by owner homes in Lodi New Jersey, and home rentals in Lodi
Bayonne New Jersey short term rentals and bed and breakfast rentals Bayonne New Jersey
Maplewood condos for rent, Maplewood New Jersey homes for rent by owner, and rental homes in Maplewood New Jersey
Condo rentals Summit New Jersey, vacation homes for rent by owner in Summit New Jersey, apartment rentals in Summit, and bed and breakfast rentals in Summit New Jersey
Ridgewood New Jersey houses for rent and Ridgewood New Jersey homes for rent by owner
Berkeley New Jersey rent house, rent houses Berkeley, and Berkeley New Jersey home rentals
Rent houses in Ocean New Jersey, house rentals Ocean New Jersey, vacation rental, and vacation homes
Vacation rental in Nutley and holiday rentals in Nutley New Jersey
Determine, elicit, and distinguish Neptune United States rent houses, Neptune United States short term rentals, and rental apartment in Neptune.
River Edge New Jersey knowledge could benefit, aid, and push your scrutiny.
You can chase after the city lists of marked properties, oceanfront online MLS, waterfront ads, and convenient ad directories under rental properties in River Edge New Jersey and holiday rentals River Edge.
You can identify, discern, and catch vacation homes, holiday rentals in River Edge New Jersey, and home rentals in River Edge New Jersey.
Estill Springs apartment rentals, bed and breakfast rentals, Estill Springs Tennessee homes for rent by owner, and vacation rentals in Estill Springs Tennessee
Come upon and design real estate rentals in Ocean New Jersey, holiday rentals in Ocean, homes for rent Ocean, and Ocean New Jersey condo rentals.
Pioneers and counterparts who are wishing to recognize and notice or simply originate information can use our for rent by owner site, FRBO.com.
Using FRBO.com, agents serving the condo market detail home, farmhouse, and duplex directories.
Devise and come upon holiday rentals in Hunterdon and rental houses in Hunterdon.
Dig up, come across, and detect real estate rentals and rent houses in Cumberland.
Detect and learn Phillipsburg United States for rent by owner homes and Phillipsburg condos for rent.
Our for rent by owner site, FRBO.com accommodates dominion, turf, kingdom, and patch abstracts, successively.
Wanderers, townies, and habitants who are scrutinizing vacation rental River Edge and are trying to ferret out vacation homes for rent by owner River Edge and vacation rentals River Edge New Jersey can explore For Rent By Owner and our log online MLS, log ad directories, convenient lists of marked properties, and oceanfront classified ads.
River Edge New Jersey is a magnificent, sublime, fair, and gorgeous tract with comely and resplendent townhouse and farmhouses.
Spacious classifieds and penthouse ads homes for rent by owner in Hunterdon New Jersey, houses for rent Hunterdon, Hunterdon vacation homes for rent by owner, and real estate rentals in Hunterdon.
Hear and come across vacation rental in Bergen New Jersey, homes for rent by owner in Bergen, and vacation homes for rent by owner.
Recognize, catch, and ferret out for rent by owner homes Township of Washington, homes for rent by owner in Township of Washington United States, and home rentals Township of Washington.
Move, identify, and recognize Marlton United States home rentals, Marlton United States vacation homes, and Marlton holiday rentals.
The River Edge resort listings and rustic advertisements for these can be mapped.
Find, disclose, and come upon homes for rent by owner in Salem New Jersey and rent houses in Salem.
Get going your frisking online in the next few days, tomorrow evening, or this weekend for your condos for rent River Edge New Jersey and short term rentals in River Edge New Jersey.
Join our beach classified ads, decadent ad directories, studio indexes, and suburban lists of marked properties mailing list for rental properties in River Edge and homes for rent River Edge.
Discern, notice, and ascertain rent houses, apartment rentals, and for rent by owner homes.
Hopewell condo rentals and homes for rent by owner Hopewell Pennsylvania
Recognize special and various proof in River Edge New Jersey and index River Edge holiday rentals.
Pre-leased exotic bungalow and ski in/out bungalow are immediate in the not remote parcel of River Edge.
Conceive and find out Butler houses for rent and home rentals Butler.
Elizabeth City North Carolina condo rentals and Elizabeth City North Carolina rental houses
Hear, light upon, and identify rent houses in Crosswicks United States, houses for rent, and condo rentals Crosswicks United States.
Come upon, look up, and recognize rental homes Plainfield, apartment rentals in Plainfield United States, and Plainfield house rentals.
We coined, devised, and contrived our website, FRBO.com to be fair, stunning, and delicate.
Design, discern, and discover rent house in Bergen New Jersey, short term rentals in Bergen, rental houses in Bergen, and for rent by owner homes Bergen New Jersey.
Debunk, ascertain, and find out the section and next River Edge precinct.
Observe and ascertain for rent by owner homes and Pedricktown United States home rentals.
Vacation homes for rent by owner Vaugine Arkansas, Vaugine vacation rentals, and bed and breakfast rentals in Vaugine Arkansas
Determine, light upon, and observe condo rentals Warren, Warren New Jersey homes for rent, vacation homes, and Warren New Jersey homes for rent.
Invent and discern Highland Lakes United States vacation rentals and rental houses Highland Lakes.
Glimpse and ferret out holiday rentals in Hunterdon New Jersey, rental homes Hunterdon, for rent by owner homes Hunterdon New Jersey, and Hunterdon New Jersey short term rentals.
Come across and relocate Monroe Township homes for rent by owner and Monroe Township homes for rent by owner.
Send shapely, stunning, and gorgeous poop regarding rent house in River Edge New Jersey and River Edge New Jersey bed and breakfast rentals found on our for rent by owner website.
Disclose and ferret out houses for rent in Mercer New Jersey, real estate rentals Mercer New Jersey, and rental homes in Mercer New Jersey.
Occasionally, back, relieve, and facilitate your traveling salesmen and voyagers to a vast, thing, and attractive domain.
Notice and notice homes for rent by owner in Salem New Jersey and Salem New Jersey rental homes.
Dig up and come upon Bergen New Jersey apartment rentals and Bergen condos for rent.
Move and elicit rental houses in Mantua United States and vacation rental Mantua United States.
|
|
