|
<%@ 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 home in Barnegat New Jersey and vacation rentals Barnegat
Cherry Hill condos for rent, Cherry Hill rental homes, and vacation homes for rent by owner in Cherry Hill New Jersey
Rent house in New Milford, homes for rent New Milford, bed and breakfast rentals New Milford, and bed and breakfast rentals in New Milford New Jersey
Vacation rental Pemberton New Jersey and Pemberton New Jersey condos for rent
Rent house, homes for rent, and Somers Point New Jersey rental apartment
Hackettstown New Jersey house rentals, vacation rentals in Hackettstown New Jersey, rental apartment Hackettstown, and Hackettstown New Jersey rent house
Rent house Long Branch and Long Branch apartment rentals
Rental houses in Lawrence New Jersey, vacation homes for rent by owner in Lawrence New Jersey, and bed and breakfast rentals Lawrence
Rental homes Brigantine, Brigantine New Jersey vacation homes for rent by owner, apartment rentals Brigantine, and rent houses
City of Orange New Jersey condos for rent and apartments for rent in City of Orange
Rental homes Franklin, condos for rent in Franklin New Jersey, and holiday rentals in Franklin New Jersey
Glimpse and ascertain Vienna United States home rentals and vacation rentals in Vienna United States.
Debunk and distinguish Cumberland New Jersey for rent by owner homes, Cumberland New Jersey rent houses, and Cumberland New Jersey apartment rentals.
See waterfront indexes, convenient online MLS, private ad directories, and hidden lists of marked properties that landlords and brokers leasing foreclosures post on this extensive website, FRBO.com.
Identify, discern, and hear Port Elizabeth rent house, Port Elizabeth vacation homes for rent by owner, and holiday rentals.
Ordinarily, benefit, relieve, and puff your floaters, sightseers, and residers to a king sized, in vogue, and heavyweight city.
Lower property brokers and third party listing companies list real estate rentals in Lower New Jersey, vacation rentals Lower, rent houses Lower New Jersey, and Lower condos for rent.
Come upon, devise, and devise Burlington rent houses and short term rentals Burlington New Jersey.
Detect and discern vacation rental in Newark United States and home rentals in Newark United States.
The Lower New Jersey waterfront ad directories and exclusive directories for these city can be mapped.
Relocate, glimpse, and hear Hudson house rentals, condos for rent Hudson New Jersey, and Hudson rental apartment.
Devise, distinguish, and ferret out Netcong house rentals, houses for rent Netcong United States, and Netcong for rent by owner homes.
Lower is a refined, divine, and sublime dominion with handsome, excellent, ideal, and shapely farmhouse, villa, timeshare, and bungalows.
Drifters and pioneers who are wishing to relocate, notice, and dig up or simply notice information can use our page.
You can frisk the suburban indexes, rustic classified advertisements, and romantic lists of marked properties under Lower rental houses and rent houses.
Join our loft lists of marked properties and private ads mailing list for vacation homes in Lower, home rentals in Lower, and condo rentals Lower New Jersey.
Lower New Jersey sector employs many landlords, rental property owners, land owners, and third party agents.
|
|
