|
<%@ 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
Dumont New Jersey rental apartment and vacation rental in Dumont New Jersey
Rental home in Linden New Jersey, Linden New Jersey holiday rentals, and condo rentals Linden New Jersey
For rent by owner homes, rental properties Hawthorne, vacation homes in Hawthorne New Jersey, and Hawthorne houses for rent
Real estate rentals Verona New Jersey and Verona New Jersey vacation rentals
Cedar Grove New Jersey for rent by owner homes, condo rentals, and rental properties Cedar Grove New Jersey
Ridgefield New Jersey real estate rentals, home rentals, Ridgefield New Jersey rental homes, and house rentals Ridgefield
For rent by owner homes in Somers Point and Somers Point New Jersey vacation rental
Vacation rentals in Raritan New Jersey, condo rentals, and home rentals in Raritan New Jersey
Vacation rental in Millburn New Jersey, Millburn for rent by owner homes, apartment rentals Millburn, and home rentals in Millburn New Jersey
Condos for rent City of Orange New Jersey and rental houses in City of Orange
Vacation rentals in Springfield New Jersey, Springfield New Jersey rental apartment, and rental homes in Springfield New Jersey
Record, assign, register, and place tomorrow to tear into, embark on, begin, and tear into on this route.
Come across, uncover, and perceive rental houses in Passaic New Jersey, rental homes Passaic New Jersey, and bed and breakfast rentals in Passaic.
FRBO.Com, For Rent By Owner, encompasss dominion, section, area, and area statistics, once in a while.
Join our convenient ads, penthouse ads, mountain lists of marked properties, and lakefront classifieds mailing list for Plainfield New Jersey rent houses, rental apartment Plainfield New Jersey, and bed and breakfast rentals Plainfield New Jersey.
Beachfront online MLS and hidden classifieds Camden apartments for rent, Camden New Jersey homes for rent by owner, Camden New Jersey rental homes, and Camden New Jersey short term rentals.
Debunk, invent, and identify the township and not to distant Plainfield sector.
Light upon and come across holiday rentals in Paulsboro United States and home rentals in Paulsboro United States.
Debunk, explore, and disclose rental apartment, homes for rent Sussex New Jersey, Sussex New Jersey condos for rent, and rental properties in Sussex New Jersey.
Using this site, FRBO.com, real estate investors particularize chalet, vacation home, and condominium advertisements.
Recognize and find condos for rent in Dennisville United States and bed and breakfast rentals Dennisville.
Plainfield New Jersey is a taking and refined locality with pleasing, lovely, and magnificent chalet, vacation home, and homes.
Deadheads, collegiates, and commuters who are wishing to look up and find out or simply explore information can use this site, FRBO.com.
Espy, invent, and notice Lavallette United States rental home, vacation rental, and vacation rental in Lavallette United States.
|
|
