|
<%@ 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
Rental houses Morristown New Jersey and Morristown New Jersey rent houses
Vacation rental Teaneck New Jersey, rental home in Teaneck New Jersey, and condo rentals Teaneck New Jersey
For rent by owner homes in Red Bank New Jersey, house rentals in Red Bank New Jersey, short term rentals Red Bank, and Red Bank New Jersey condos for rent
Condo rentals in Aberdeen New Jersey and vacation rentals in Aberdeen New Jersey
Rental apartment in Washington, vacation rentals, and short term rentals Washington
For rent by owner homes, South Plainfield rental apartment, home rentals, and homes for rent
Holiday rentals in Millville and short term rentals in Millville New Jersey
New Providence New Jersey holiday rentals, vacation homes New Providence New Jersey, and New Providence rent house
Cinnaminson holiday rentals, holiday rentals in Cinnaminson New Jersey, Cinnaminson New Jersey rent houses, and holiday rentals in Cinnaminson New Jersey
Short term rentals in Haddon New Jersey and for rent by owner homes in Haddon
Vacation rentals in Jackson New Jersey, rent houses Jackson, and home rentals in Jackson
Hanover New Jersey rent houses, for rent by owner homes, Hanover New Jersey rental houses, and holiday rentals in Hanover
Rental home in North Plainfield New Jersey and North Plainfield short term rentals
Maple Shade New Jersey rental homes, vacation rentals in Maple Shade New Jersey, and rental home Maple Shade
Condo rentals in Millville New Jersey, rental apartment in Millville New Jersey, Millville for rent by owner homes, and Millville New Jersey homes for rent by owner
Ringwood New Jersey area employs many third party agents, real estate investors, home owners, and town home owners.
You can quest the loft classified ads, oceanfront classifieds, studio ad directories, and secluded online MLS under rent houses in Ringwood, vacation rentals in Ringwood New Jersey, and vacation homes in Ringwood New Jersey.
Determine, conceive, and discern Cologne United States vacation homes for rent by owner, rental home in Cologne United States, and condos for rent.
Come across, invent, and come upon Alloway United States rental houses, Alloway houses for rent, and rent houses in Alloway United States.
Determine and detect condo rentals in Sergeantsville and rental apartment Sergeantsville United States.
Explore, observe, and elicit rent house in Monmouth New Jersey, Monmouth New Jersey homes for rent by owner, and apartments for rent.
Identify and identify Leesburg condos for rent and apartments for rent Leesburg United States.
Design, identify, and devise the area and not faraway Ringwood New Jersey domain.
Our online website, FRBO.com encloses dominion and quarter brass tacks, oft.
Ringwood is a beauteous, classy, and angelic precinct with comely, lovely, and dazzling cottage, townhouse, cottage, and vacation homes.
Hear and contrive Monmouth New Jersey vacation homes for rent by owner and houses for rent Monmouth.
See suburban classified ads, mountain advertisements, spacious ad directories, and private indexes that property managers and rental property owners post on this webpage.
Empty romantic home, studio bungalow, lakeside chalet, and lakefront farmhouse are adjoining in the near-at-hand neighborhood of Ringwood New Jersey.
Oceanfront directories and log indexes vacation rental in Middlesex, houses for rent, homes for rent by owner, and houses for rent in Middlesex.
Ferret out, observe, and distinguish vacation rental Somerset, rental houses Somerset, and Somerset for rent by owner homes.
Perceive and debunk Vineland United States bed and breakfast rentals and homes for rent Vineland.
Procure, embody, and record in the morning to embark on, lead off, begin, and get going on this crossing.
Using this website, FRBO.com, rental property owners run down apartment, house, ranch, and houseboat classifieds.
Trippers and colleagues who are looking over Ringwood New Jersey vacation homes and are trying to come across Ringwood New Jersey rental apartment, rental home, and bed and breakfast rentals in Ringwood New Jersey can check our for rent by owner site, FRBO.com and our private indexes and secluded classifieds.
|
|
