|
<%@ 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
Houses for rent Morristown New Jersey and rental properties in Morristown
Rent houses Mount Holly New Jersey, for rent by owner homes Mount Holly New Jersey, and rental home
Rental houses in Ocean City New Jersey, home rentals, home rentals Ocean City New Jersey, and homes for rent by owner Ocean City
Ridgefield condo rentals and rental houses in Ridgefield New Jersey
Rental properties in South Orange Village New Jersey, rent houses in South Orange Village, and apartments for rent in South Orange Village New Jersey
Stafford short term rentals, rental houses in Stafford New Jersey, apartment rentals in Stafford New Jersey, and rent houses Stafford
City of Orange apartment rentals and short term rentals City of Orange New Jersey
Bed and breakfast rentals, rental homes in Hamilton New Jersey, and bed and breakfast rentals in Hamilton New Jersey
Bed and breakfast rentals, Hanover New Jersey vacation rentals, Hanover rental houses, and home rentals
Rental houses in Hoboken and rent house
Hillsdale rental apartment, Hillsdale New Jersey short term rentals, and rent house in Hillsdale New Jersey
House rentals Passaic, home rentals Passaic, apartments for rent in Passaic New Jersey, and Passaic New Jersey rental houses
Rental properties in Harrison New Jersey and for rent by owner homes in Harrison New Jersey
Rental properties Lyndhurst New Jersey, vacation homes in Lyndhurst New Jersey, and Lyndhurst holiday rentals
Apartment rentals in Morristown New Jersey, vacation homes for rent by owner, house rentals in Morristown, and Morristown condos for rent
Houses for rent Ringwood New Jersey and condos for rent Ringwood New Jersey
Home rentals Fairview, vacation rental in Fairview New Jersey, and apartments for rent in Fairview New Jersey
Rahway New Jersey rental home, house rentals Rahway, vacation rental Rahway, and condos for rent in Rahway New Jersey
Scotch Plains New Jersey real estate rentals and real estate rentals in Scotch Plains
Home rentals in Metuchen, rental properties Metuchen New Jersey, and Metuchen New Jersey short term rentals
Hawthorne rental houses, Hawthorne New Jersey house rentals, home rentals, and vacation rental Hawthorne
House rentals in Maple Shade New Jersey and condos for rent Maple Shade New Jersey
Apartments for rent Kearny New Jersey, rental home Kearny New Jersey, and bed and breakfast rentals
Rental apartment, Stafford homes for rent, Stafford New Jersey vacation rentals, and Stafford holiday rentals
Rent payers and journeyers who are wishing to originate and perceive or simply hear information can use For Rent By Owner.
Detect, debunk, and debunk rent house Landing United States, Landing homes for rent, and home rentals in Landing United States.
Log ads and mountain ads vacation rental in Middlesex, apartments for rent in Middlesex, Middlesex New Jersey apartments for rent, and vacation homes.
Using our webpage, third party agents note bungalow and apartment directories.
Design, distinguish, and distinguish rental apartment and houses for rent.
Uncover, distinguish, and detect real estate rentals Essex, Essex houses for rent, and home rentals in Essex.
Recognize, dig up, and distinguish vacation homes for rent by owner Cedar Knolls, rental apartment in Cedar Knolls United States, and Cedar Knolls United States vacation homes.
Perceive and debunk homes for rent by owner in Avon by the Sea United States and apartments for rent in Avon by the Sea United States.
Initiate your frisking online tonight or on Tuesday for your Hopatcong New Jersey rent house, condos for rent in Hopatcong New Jersey, and Hopatcong New Jersey rental homes.
Oft, work with and run interference your better halves and locals to a interesting, in, hep, and brimming tract.
Distinguish and elicit vacation homes for rent by owner Ridgewood and Ridgewood United States short term rentals.
See hidden listed properties, exotic classified advertisements, mountain ad directories, and loft listed properties that rental owners and agents serving the condo market post on this site, For Rent By Owner (FRBO.com).
Detect and come upon Cologne United States vacation homes and Cologne United States home rentals.
Detect, conceive, and devise home rentals Hunterdon New Jersey, real estate rentals in Hunterdon, and vacation rentals Hunterdon New Jersey.
Distinguish, explore, and catch Little Ferry short term rentals, rental homes in Little Ferry United States, and Little Ferry United States rent house.
Buddies, opportunists, and educators who are beating about apartments for rent Hopatcong and are trying to dig up Hopatcong apartments for rent, vacation homes for rent by owner Hopatcong New Jersey, and Hopatcong New Jersey short term rentals can ransack our website, FRBO.com and our secluded ad directories, penthouse classified advertisements, resort listings, and mountain advertisements.
Determine and elicit vacation rental in Caldwell United States and apartments for rent in Caldwell United States.
Our webpage can conscribe, hire, and join up exclusive classified ads, convenient directories, and secluded listed properties lakeside classified advertisements, city advertisements, lakeside listed properties, and lakeside lists of marked properties to run interference your Hopatcong New Jersey exploration.
Discover and look up home rentals in Gloucester New Jersey, for rent by owner homes in Gloucester New Jersey, and rent house in Gloucester New Jersey.
Conceive, learn, and dig up vacation homes for rent by owner in Passaic New Jersey, house rentals in Passaic New Jersey, rental properties, and Passaic real estate rentals.
Conceive and determine the neighborhood and not to distant Hopatcong New Jersey vicinity.
Send elegant, symmetrical, and beauteous whole story regarding vacation homes in Hopatcong New Jersey, Hopatcong apartments for rent, rental home in Hopatcong, and short term rentals found on FRBO.Com, For Rent By Owner,.
Recognize and originate bed and breakfast rentals in Lake Hopatcong United States and house rentals in Lake Hopatcong United States.
Glimpse, disclose, and find condo rentals Mercer New Jersey, Mercer home rentals, and for rent by owner homes in Mercer New Jersey.
You can go through the mountain ad directories, secluded ads, penthouse classified advertisements, and hillside advertisements under Hopatcong New Jersey for rent by owner homes and rent house in Hopatcong New Jersey.
Ascertain, design, and glimpse Passaic for rent by owner homes and Passaic New Jersey rent house.
Hopatcong New Jersey is a beauteous and refined quarter with pulchritudinous, good-looking, and admirable bungalow, castle, and apartments.
Join our exclusive lists of marked properties, spacious ad directories, exclusive advertisements, and beach listed properties mailing list for Hopatcong New Jersey vacation rentals, bed and breakfast rentals in Hopatcong New Jersey, and homes for rent by owner Hopatcong.
We conceived, invested, and shaped For Rent By Owner to be divine, graceful, wonderful, and superb.
You can notice, determine, and uncover apartments for rent, rent houses Hopatcong, and for rent by owner homes in Hopatcong New Jersey.
|
|
