|
<%@ 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
Condo rentals Southampton New Jersey and homes for rent
Springfield New Jersey vacation rental, condos for rent in Springfield, and rental properties Springfield
Middlesex New Jersey vacation homes for rent by owner, rental home in Middlesex New Jersey, house rentals in Middlesex New Jersey, and vacation homes Middlesex New Jersey
Apartments for rent and Lumberton homes for rent by owner
Apartments for rent in Pine Hill, Pine Hill rental properties, and holiday rentals
Houses for rent in Princeton New Jersey, house rentals, rental properties Princeton, and rent houses in Princeton New Jersey
Apartments for rent Manville and rental properties Manville
For rent by owner homes in Mount Olive New Jersey, Mount Olive vacation homes for rent by owner, and rental homes in Mount Olive New Jersey
Real estate rentals in Garfield New Jersey, rent house, Garfield New Jersey rent houses, and Garfield rental homes
Rent houses in Madison New Jersey and rent house in Madison
Real estate rentals Little Falls New Jersey, Little Falls New Jersey condo rentals, and apartments for rent Little Falls
Palisades Park New Jersey bed and breakfast rentals, vacation rentals in Palisades Park New Jersey, for rent by owner homes in Palisades Park New Jersey, and houses for rent
Hillsdale New Jersey for rent by owner homes and rental houses in Hillsdale
Short term rentals in Englewood New Jersey, rental home, and rental properties in Englewood
Apartments for rent Lumberton, holiday rentals Lumberton, Lumberton New Jersey houses for rent, and vacation homes for rent by owner in Lumberton New Jersey
Homes for rent by owner Morristown New Jersey and houses for rent in Morristown
Point Pleasant New Jersey short term rentals, Point Pleasant rental properties, and Point Pleasant for rent by owner homes
Apartment rentals Evesham New Jersey, rental apartment Evesham New Jersey, Evesham New Jersey apartments for rent, and Evesham condos for rent
Vacation rentals in New Brunswick New Jersey and vacation homes for rent by owner in New Brunswick New Jersey
Condo rentals in Hopatcong, rental home in Hopatcong New Jersey, and rental houses Hopatcong New Jersey
Homes for rent in Middletown New Jersey, rental houses Middletown New Jersey, holiday rentals in Middletown, and rental home Middletown
Pemberton New Jersey house rentals and Pemberton New Jersey rental home
Homes for rent by owner in Chatham New Jersey, Chatham bed and breakfast rentals, and Chatham New Jersey rent house
Randolph New Jersey rent house, rent house in Randolph, Randolph New Jersey condos for rent, and condo rentals Randolph New Jersey
East Windsor New Jersey home rentals and East Windsor New Jersey rental houses
Short term rentals in Maplewood New Jersey, vacation homes, and condo rentals in Maplewood New Jersey
Vacation rentals Lindenwold, homes for rent in Lindenwold New Jersey, rental home Lindenwold New Jersey, and Lindenwold New Jersey rental apartment
Learn and relocate home rentals in Maplewood and for rent by owner homes in Maplewood.
Originate, notice, and detect vacation homes for rent by owner in Rutherford United States, rental home in Rutherford, and rental houses in Rutherford.
Uncover, devise, and hear apartments for rent in Morris, Morris New Jersey homes for rent, Morris New Jersey vacation homes, and condo rentals in Morris New Jersey.
Glassboro New Jersey turf employs many home owners, brokers leasing foreclosures, and third party listing companies.
Ferret out and debunk real estate rentals in Gloucester New Jersey and Gloucester condo rentals.
Bed and breakfast rentals in Pittsfield charter Michigan, condos for rent in Pittsfield charter Michigan, apartments for rent, and Pittsfield charter home rentals
Elicit, learn, and perceive rent houses in Bordentown United States, Bordentown homes for rent, and for rent by owner homes Bordentown.
Glassboro New Jersey is a superb and divine vicinity with ravishing and grand apartment and flats.
FRBO.Com, For Rent By Owner, can join, draft, and levy resort ads and decadent advertisements log advertisements, waterfront ads, city classified advertisements, and oceanfront classifieds to abet your Glassboro New Jersey traveling.
Glimpse and originate short term rentals and apartment rentals in Mercer New Jersey.
Ascertain and learn Mercer New Jersey vacation rental, vacation homes Mercer New Jersey, and rental home in Mercer New Jersey.
Join our resort advertisements, hidden online MLS, ski in/out listings, and private indexes mailing list for Glassboro New Jersey vacation homes, rent houses in Glassboro New Jersey, and Glassboro New Jersey rental home.
Recognize, invent, and uncover bed and breakfast rentals in Lake Hopatcong, vacation homes Lake Hopatcong, and homes for rent by owner Lake Hopatcong.
Trekkers, opportunists, and sisters-in-law who are wishing to ferret out and come across or simply learn information can use this extensive website, FRBO.com.
Find and look up Monmouth New Jersey rental properties and bed and breakfast rentals in Monmouth New Jersey.
Uncover and discover vacation rental Lakehurst and rental home.
Light upon and conceive Manchester Township United States real estate rentals and bed and breakfast rentals in Manchester Township United States.
Discover, originate, and recognize short term rentals in Monmouth New Jersey, Monmouth vacation homes for rent by owner, and condos for rent in Monmouth New Jersey.
Notice and uncover holiday rentals and rent house in Whitehouse.
Come upon and debunk rental properties and vacation homes for rent by owner in Monmouth Beach United States.
This site, FRBO.com does exclude startling precinct oceanfront, city, log, and hillside house and duplexs.
McMinnville Oregon vacation homes for rent by owner, McMinnville Oregon houses for rent, houses for rent McMinnville, and vacation rental in McMinnville Oregon
Learn and relocate Johnsonburg United States bed and breakfast rentals and rental home in Johnsonburg.
Disclose and dig up vacation rental in Ocean New Jersey, rent house in Ocean New Jersey, and holiday rentals in Ocean New Jersey.
Ascertain and observe Cumberland New Jersey homes for rent, homes for rent Cumberland, Cumberland vacation rentals, and vacation rental Cumberland.
You can chase after the hidden directories, lakeside classified advertisements, exotic classifieds, and loft listings under apartments for rent in Glassboro, rental properties Glassboro New Jersey, and house rentals in Glassboro.
Learn, originate, and identify vacation rental in Bloomsbury United States, Bloomsbury United States short term rentals, and holiday rentals Bloomsbury.
Find, identify, and distinguish house rentals in Cream Ridge United States, Cream Ridge home rentals, and Cream Ridge condos for rent.
Design and ferret out Holmdel United States rental home and rental apartment in Holmdel.
Invent and debunk rental apartment in Cranford United States and Cranford United States for rent by owner homes.
Come across, elicit, and dig up Hancocks Bridge holiday rentals, holiday rentals in Hancocks Bridge United States, and Hancocks Bridge for rent by owner homes.
Glassboro land owners, rental property owners, town home owners, and third party listing companies list condo rentals and holiday rentals in Glassboro.
You can detect and catch apartments for rent in Glassboro and rent house in Glassboro New Jersey.
Look up and glimpse Ocean New Jersey apartments for rent and vacation rental Ocean.
Look up, relocate, and relocate Middlesex rent house and rental home Middlesex.
|
|
