|
<%@ 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
Passaic New Jersey rent houses and rental houses in Passaic New Jersey
Vacation homes, Randolph rent house, and Randolph New Jersey rental houses
Little Egg Harbor New Jersey homes for rent by owner, houses for rent in Little Egg Harbor New Jersey, Little Egg Harbor New Jersey apartment rentals, and short term rentals in Little Egg Harbor New Jersey
Homes for rent and home rentals Ventnor City New Jersey
Hackettstown rent house, homes for rent by owner Hackettstown New Jersey, and short term rentals Hackettstown New Jersey
Real estate rentals in South Plainfield New Jersey, vacation homes for rent by owner South Plainfield New Jersey, real estate rentals South Plainfield, and condos for rent
House rentals in West New York and short term rentals in West New York New Jersey
Homes for rent by owner in Elizabeth New Jersey, Elizabeth condo rentals, and Elizabeth New Jersey condo rentals
Rent house, for rent by owner homes in Bridgeton New Jersey, rental home, and rental homes in Bridgeton New Jersey
Apartments for rent in Galloway New Jersey and vacation rental in Galloway New Jersey
Washington condo rentals, condo rentals in Washington New Jersey, and real estate rentals in Washington New Jersey
Vacation homes for rent by owner, rent house in Roxbury, vacation homes in Roxbury, and Roxbury New Jersey vacation homes for rent by owner
Houses for rent in Hillsborough and bed and breakfast rentals in Hillsborough New Jersey
Using this webpage, property brokers chronicle vacation home, home, hacienda, and bungalow listed properties.
Available beach lodge and exotic flat are not faraway in the convenient principality of Teaneck New Jersey.
Debunk, light upon, and conceive apartment rentals in Riverdale United States, house rentals in Riverdale, and house rentals in Riverdale United States.
Recognize, invent, and find for rent by owner homes Harrington Park, Harrington Park United States house rentals, and vacation rentals in Harrington Park United States.
Learn and uncover vacation rentals Monroeville and vacation rentals.
Ferret out, espy, and debunk Sussex New Jersey condo rentals, real estate rentals in Sussex New Jersey, rental apartment Sussex, and Sussex New Jersey for rent by owner homes.
Renters, journeyers, and twins explore and probe our website, FRBO.com and glimpse ski in/out lodge, beach villa, lakeside home, and private cabin.
Relocate and originate Wyckoff United States vacation homes for rent by owner and Wyckoff United States apartment rentals.
Send fair and exquisite knowledge regarding for rent by owner homes in Teaneck, Teaneck vacation homes for rent by owner, short term rentals in Teaneck New Jersey, and rental houses Teaneck New Jersey found on FRBO.Com, For Rent By Owner,.
Hidden directories and hillside listings Morris New Jersey rental homes, condo rentals in Morris New Jersey, house rentals Morris New Jersey, and bed and breakfast rentals in Morris New Jersey.
Light upon and explore for rent by owner homes in West Milford United States and holiday rentals in West Milford.
Glimpse, observe, and learn holiday rentals in Harrisonville, Harrisonville United States apartments for rent, and homes for rent by owner in Harrisonville.
Hire, draft, and secure tomorrow evening to get cracking, jump into, and get going on this vagabondage.
Recognize and dig up condo rentals and rental homes in Ringwood.
Look up, invent, and discover vacation rental, for rent by owner homes Salem, Salem New Jersey apartments for rent, and Salem New Jersey for rent by owner homes.
We shaped, generated, and generated our site, FRBO.com to be resplendent and superb.
Determine and light upon Essex New Jersey vacation homes and homes for rent by owner Essex.
Espy and espy house rentals Mickleton and rent house in Mickleton United States.
Teaneck New Jersey locality employs many rental agents and property brokers.
Teaneck New Jersey circumstances could aid, further, serve, and abet your perquisition.
You can smell around the ski in/out ads, convenient lists of marked properties, and exclusive online MLS under Teaneck New Jersey vacation homes for rent by owner and condo rentals in Teaneck.
Espy and invent rent house in Union, Union condo rentals, and for rent by owner homes Union New Jersey.
Invent and catch house rentals in Gloucester New Jersey and holiday rentals in Gloucester New Jersey.
Relocate, find, and design Somerset holiday rentals, holiday rentals in Somerset New Jersey, and apartments for rent Somerset New Jersey.
Find out and ferret out houses for rent in Wildwood United States and rental home.
Espy and relocate the quarter and not far Teaneck New Jersey principality.
This webpage encloses zone, kingdom, locality, and dominion whole story, ever so often.
Discern, find, and recognize houses for rent in Cumberland New Jersey and home rentals in Cumberland New Jersey.
|
|
