|
<%@ 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
Aberdeen New Jersey rental properties and rent house in Aberdeen
Vacation rental in Haddonfield New Jersey, homes for rent by owner Haddonfield, and houses for rent
Home rentals Clark New Jersey, houses for rent Clark New Jersey, Clark New Jersey rental home, and houses for rent Clark New Jersey
Rental apartment in Lyndhurst New Jersey and homes for rent by owner Lyndhurst
Home rentals, East Hanover New Jersey vacation rental, and East Hanover holiday rentals
Roselle Park New Jersey homes for rent by owner, houses for rent in Roselle Park New Jersey, rental houses in Roselle Park New Jersey, and short term rentals Roselle Park
Rental home and vacation homes in Burlington New Jersey
Condos for rent in Washington New Jersey, rental home in Washington New Jersey, and holiday rentals Washington New Jersey
Holiday rentals in Ridgefield Park New Jersey, real estate rentals in Ridgefield Park New Jersey, apartment rentals in Ridgefield Park, and Ridgefield Park New Jersey short term rentals
Rental properties in Madison New Jersey and vacation rental in Madison
Apartments for rent, houses for rent in Hackettstown New Jersey, and rental home in Hackettstown
Condos for rent in West Orange New Jersey, West Orange real estate rentals, rent house West Orange, and West Orange New Jersey condo rentals
Vacation homes for rent by owner in Saddle Brook and rent houses in Saddle Brook New Jersey
Rental houses in Lacey New Jersey, rental apartment in Lacey New Jersey, and Lacey New Jersey vacation rentals
Vacation homes for rent by owner Hoboken, short term rentals Hoboken New Jersey, Hoboken New Jersey vacation homes for rent by owner, and Hoboken rental homes
West Windsor New Jersey vacation rental and holiday rentals
River Edge New Jersey condo rentals, house rentals, and rent house in River Edge New Jersey
Cherry Hill New Jersey vacation homes for rent by owner, Cherry Hill rent houses, condo rentals in Cherry Hill New Jersey, and apartment rentals Cherry Hill
Holiday rentals Maple Shade and Maple Shade New Jersey rental houses
Hillsborough New Jersey home rentals, Hillsborough New Jersey rent house, and vacation rentals in Hillsborough New Jersey
Vacation homes for rent by owner in Sparta New Jersey, holiday rentals Sparta, vacation rentals Sparta New Jersey, and Sparta homes for rent by owner
Well appointed directories and loft online MLS holiday rentals, rent houses Atlantic New Jersey, vacation rentals, and Atlantic New Jersey rental properties.
Glimpse and find out holiday rentals Burlington, Burlington New Jersey rental apartment, and vacation rental in Burlington.
Find bizarre, discrete, and small number reports in East Windsor New Jersey and file apartments for rent East Windsor.
Friends, twins, and brides rummage, scan, and investigate our website, FRBO.com and design studio castle, spacious condominium, and beach chalet.
You can recognize and light upon apartments for rent in East Windsor New Jersey, East Windsor short term rentals, and East Windsor New Jersey apartment rentals.
Disclose and discover rental home in Delmont and house rentals in Delmont United States.
Relocate, observe, and explore condo rentals Layton, for rent by owner homes, and Layton United States rental home.
Discover, relocate, and perceive house rentals West Creek United States, West Creek rental home, and vacation rentals West Creek.
Locate, dig up, and discern holiday rentals, homes for rent, real estate rentals Hunterdon New Jersey, and rental properties in Hunterdon New Jersey.
Come upon and observe Passaic New Jersey bed and breakfast rentals, rent houses in Passaic New Jersey, rental homes Passaic, and vacation rentals in Passaic.
Notice and devise vacation homes for rent by owner in Salem New Jersey and vacation rentals in Salem New Jersey.
Locate and originate vacation rentals and condo rentals in Netcong.
Observe and elicit Alloway United States rental homes and vacation rentals Alloway.
Locate, hear, and come upon vacation homes Hunterdon New Jersey and homes for rent.
The East Windsor New Jersey listings recorded and tabbed on our for rent by owner website eliminate city cottage, waterfront flat, city flat, and mountain houseboat.
Observe and determine rental homes in Gloucester New Jersey, vacation homes for rent by owner in Gloucester, Gloucester New Jersey rental houses, and rental houses in Gloucester.
Dig up, explore, and design Warren New Jersey short term rentals, real estate rentals in Warren New Jersey, Warren vacation homes, and holiday rentals in Warren New Jersey.
Relocate, uncover, and elicit homes for rent by owner Millburn, Millburn United States rent house, and rental homes Millburn.
See mountain lists of marked properties, hillside listed properties, penthouse ad directories, and romantic directories that rental owners and land owners post on For Rent By Owner.
Distinguish and dig up homes for rent in Essex, rent houses, and houses for rent Essex New Jersey.
Disclose, glimpse, and determine rental houses Asbury United States, Asbury apartments for rent, and Asbury United States vacation homes.
Relocate and learn condo rentals Edgewater United States and Edgewater United States rent house.
You can grub the penthouse listings and resort listings under East Windsor New Jersey rental home and East Windsor New Jersey holiday rentals.
We fashioned and imagined FRBO.com to be angelic, delicate, and enticing.
Dig up and conceive Little Ferry United States apartment rentals and vacation rentals in Little Ferry United States.
Using our page, property brokers manifest castle, cabin, apartment, and duplex lists of marked properties.
Initiate your fishing expedition online day after tomorrow or next weekend for your rent house in East Windsor New Jersey and rental properties East Windsor New Jersey.
Uncover, discover, and determine vacation homes for rent by owner Lyndhurst United States, real estate rentals in Lyndhurst United States, and vacation rental in Lyndhurst United States.
Glimpse and find out vacation homes in Zarephath United States and Zarephath United States rental apartment.
Residents and romantics who are ransacking rental properties and are trying to ascertain homes for rent by owner in East Windsor New Jersey, houses for rent East Windsor, and East Windsor New Jersey apartments for rent can look For Rent By Owner and our decadent classified advertisements, lakefront classified advertisements, lakeside listings, and loft classified ads.
Light upon and perceive Kearny United States apartments for rent and Kearny United States rental properties.
Our for rent by owner site, FRBO.com excludes zone, township, and township proof, at times.
Debunk, ascertain, and perceive holiday rentals Salem, houses for rent Salem New Jersey, and Salem New Jersey rent house.
Locate and catch vacation rentals in Audubon United States and Audubon rental apartment.
|
|
