|
<%@ 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
Vacation rental Hamilton and Hamilton New Jersey bed and breakfast rentals
Bed and breakfast rentals in Collingswood, for rent by owner homes in Collingswood New Jersey, and vacation rentals
Vacation rentals in Ringwood New Jersey, vacation rentals, rental apartment Ringwood New Jersey, and Ringwood for rent by owner homes
Rental properties in North Plainfield and vacation rentals
Brick New Jersey vacation rentals, Brick apartments for rent, and vacation rental in Brick New Jersey
Union vacation homes for rent by owner, for rent by owner homes Union, Union New Jersey vacation homes for rent by owner, and Union New Jersey short term rentals
Real estate rentals Warren and apartments for rent
House rentals, Gloucester New Jersey real estate rentals, and Gloucester New Jersey apartment rentals
For rent by owner homes in Mahwah, condos for rent Mahwah New Jersey, condo rentals Mahwah, and houses for rent
For rent by owner homes in Manville and homes for rent in Manville New Jersey
Edison vacation rental, Edison rental houses, and real estate rentals in Edison New Jersey
Apartment rentals Morristown, rent house Morristown New Jersey, vacation homes Morristown, and rental home in Morristown New Jersey
Homes for rent by owner in Dumont New Jersey and short term rentals in Dumont
Fair Lawn New Jersey rental properties, rent houses in Fair Lawn New Jersey, and short term rentals in Fair Lawn
Howell condo rentals, apartments for rent in Howell New Jersey, vacation rentals in Howell, and short term rentals Howell New Jersey
Raritan New Jersey bed and breakfast rentals and rent house
Detect, contrive, and notice Spotswood United States rent house, Spotswood vacation rental, and for rent by owner homes in Spotswood United States.
Franklin Lakes scoop could thump, help, and plug your pursuit.
Light upon, discover, and uncover Newfield United States vacation rentals, house rentals in Newfield United States, and vacation homes in Newfield United States.
Our for rent by owner site, FRBO.com can list, engage, oblige, and procure lakeside ads and rustic online MLS resort ad directories, suburban classified advertisements, secluded ad directories, and well appointed classified advertisements to boost your Franklin Lakes New Jersey roaming.
This extensive website, FRBO.com does comprehend particular county beachfront, hidden, and city bungalow, villa, house, and townhouses.
Notice and design vacation homes in Camden and apartments for rent Camden.
Ascertain and ascertain apartments for rent in Bergen New Jersey and for rent by owner homes in Bergen New Jersey.
Relocate and move vacation homes in Franklin Park and for rent by owner homes in Franklin Park.
The Franklin Lakes New Jersey oceanfront indexes and oceanfront listings for these quarter can be mapped.
Elicit and uncover for rent by owner homes in Hunterdon, vacation homes in Hunterdon New Jersey, vacation rentals in Hunterdon New Jersey, and Hunterdon New Jersey short term rentals.
Relocate and find out rental home in Whitehouse Station United States and rental homes Whitehouse Station United States.
Explore, uncover, and debunk Sussex New Jersey for rent by owner homes, short term rentals in Sussex New Jersey, and rental apartment in Sussex New Jersey.
Find out, recognize, and find Bound Brook United States rental houses, vacation rentals in Bound Brook United States, and condo rentals in Bound Brook United States.
Soon to be vacant waterfront ranch, lake house, resort hacienda, and lakefront cottage are nearby in the approaching block of Franklin Lakes New Jersey.
Spouses, cohorts, and acquaintances who are wishing to detect, espy, and look up or simply contrive information can use FRBO.Com, For Rent By Owner,.
|
|
