|
<%@ 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 and Pleasantville New Jersey for rent by owner homes
Condos for rent, holiday rentals West New York, and short term rentals
Hamilton New Jersey for rent by owner homes, condo rentals Hamilton New Jersey, rental apartment in Hamilton, and Hamilton New Jersey bed and breakfast rentals
Apartment rentals and vacation homes for rent by owner in Delran New Jersey
Homes for rent in Livingston, Livingston New Jersey rental properties, and Livingston for rent by owner homes
Rental homes in Marlboro New Jersey, rental apartment, Marlboro New Jersey bed and breakfast rentals, and short term rentals Marlboro
Rent houses and homes for rent Upper New Jersey
Vacation homes in Hillsdale, Hillsdale homes for rent, and Hillsdale New Jersey rental home
Maplewood New Jersey rental properties, house rentals, real estate rentals, and Maplewood New Jersey apartments for rent
Jersey City New Jersey bed and breakfast rentals and Jersey City rent house
Real estate rentals in Metuchen, rent house in Metuchen New Jersey, and real estate rentals in Metuchen
Home rentals in Montville, rental houses in Montville, short term rentals in Montville, and vacation rentals Montville New Jersey
Rent house in Hoboken New Jersey and Hoboken condos for rent
Vacation homes for rent by owner in Wallington New Jersey, vacation homes in Wallington New Jersey, and rent houses in Wallington
Moorestown rental apartment, apartment rentals Moorestown New Jersey, condo rentals Moorestown, and Moorestown New Jersey short term rentals
Middle houses for rent and rental homes
Hanover New Jersey rental apartment, Hanover vacation rental, and bed and breakfast rentals Hanover New Jersey
Galloway New Jersey condo rentals, real estate rentals in Galloway New Jersey, Galloway New Jersey rental homes, and Galloway rental homes
Rent house Garfield New Jersey and Garfield condo rentals
Houses for rent in Manalapan New Jersey, rental properties, and apartments for rent in Manalapan
Apartment rentals in Saddle Brook, apartment rentals Saddle Brook New Jersey, Saddle Brook New Jersey homes for rent by owner, and rent house in Saddle Brook New Jersey
Holiday rentals in Manville and Manville for rent by owner homes
Homes for rent in Jefferson New Jersey, bed and breakfast rentals in Jefferson New Jersey, and vacation homes Jefferson New Jersey
North Arlington house rentals, rental properties North Arlington, rental homes in North Arlington New Jersey, and North Arlington New Jersey condo rentals
Ever so often, work for, further, back, and do for your boarders and co-workers to a colossal, fair, roomy, and taking neighborhood.
Enter into, mobilize, register, and join on Sunday to enter upon and begin on this vagabondage.
You can ransack the resort classifieds, waterfront ad directories, and loft classified ads under vacation homes for rent by owner Point Pleasant New Jersey and home rentals Point Pleasant New Jersey.
Point Pleasant New Jersey is a divine and pulchritudinous dominion with ideal, admirable, and well-formed townhouse, cabin, bungalow, and lodges.
Determine, distinguish, and explore home rentals, Pemberton United States real estate rentals, and Pemberton United States rental properties.
Look up and come across Lawrenceville United States homes for rent by owner and Lawrenceville vacation rental.
Soon to be vacant hidden hacienda, hidden apartment, and exotic ranch are next in the neighboring vicinity of Point Pleasant.
Determine and ascertain Essex New Jersey vacation rentals, apartments for rent Essex, and apartment rentals Essex New Jersey.
Espy, design, and disclose vacation homes in Ridgefield Park United States, condo rentals in Ridgefield Park United States, and rental homes in Ridgefield Park United States.
Lodgers, husbands, and ramblers scour, scout, and check this webpage and discern ski in/out vacation home, secluded lodge, exclusive vacation home, and private bungalow.
Point Pleasant land owners, rental property owners, and condo owners list Point Pleasant rent houses, real estate rentals in Point Pleasant New Jersey, and Point Pleasant houses for rent.
Invent and ascertain Wallpack Center United States vacation rental and rental apartment in Wallpack Center United States.
Come across and light upon Mercer New Jersey rent house, houses for rent Mercer, Mercer New Jersey house rentals, and apartment rentals.
Find, find out, and learn houses for rent, condos for rent in Westwood United States, and rental properties in Westwood.
Catch, move, and design Lebanon United States bed and breakfast rentals, short term rentals Lebanon, and rental houses in Lebanon.
Contrive, elicit, and locate rental houses Mercer and rent house Mercer.
Uncover, espy, and espy Mercer New Jersey vacation rental, Mercer for rent by owner homes, and condo rentals Mercer New Jersey.
Explore and invent vacation homes Chester United States and condo rentals in Chester United States.
We invested and actualize our site, FRBO.com to be radiant and radiant.
Identify and find out rent house in Passaic United States and vacation rental Passaic United States.
Dig up and glimpse apartments for rent and homes for rent in South Bound Brook United States.
|
|
