|
<%@ 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
Homes for rent by owner in Westfield New Jersey and Westfield home rentals
Mount Holly New Jersey house rentals, apartment rentals, and Mount Holly New Jersey condos for rent
Rental houses, real estate rentals in Rutherford New Jersey, Rutherford New Jersey rental homes, and holiday rentals in Rutherford New Jersey
Rental apartment Dumont New Jersey and home rentals in Dumont New Jersey
Homes for rent by owner Teaneck, Teaneck vacation homes for rent by owner, and homes for rent by owner in Teaneck New Jersey
House rentals in East Windsor, condo rentals East Windsor, East Windsor apartments for rent, and homes for rent East Windsor New Jersey
Rental properties in East Brunswick New Jersey and short term rentals in East Brunswick New Jersey
Vacation rentals Secaucus, short term rentals Secaucus, and Secaucus New Jersey homes for rent by owner
Rental home in Chatham New Jersey, rental houses, homes for rent, and homes for rent in Chatham
Lyndhurst New Jersey rental properties and homes for rent in Lyndhurst New Jersey
Vacation homes, vacation rentals in Kearny New Jersey, and real estate rentals in Kearny New Jersey
Neptune New Jersey real estate rentals, rental home, Neptune rent house, and Neptune vacation homes
Real estate rentals Vineland and apartments for rent in Vineland New Jersey
Rental home in Nutley New Jersey, short term rentals in Nutley New Jersey, and Nutley vacation rentals
Bed and breakfast rentals Dover, Dover New Jersey vacation rentals, Dover New Jersey rental home, and Dover New Jersey rent house
Rental apartment in Haddonfield New Jersey and vacation homes in Haddonfield New Jersey
Manville apartments for rent, home rentals in Manville New Jersey, and Manville New Jersey holiday rentals
Vacation homes, real estate rentals Sayreville, apartments for rent in Sayreville, and condos for rent Sayreville New Jersey
Rent house in Middletown New Jersey and Middletown New Jersey rent houses
Rent house, for rent by owner homes, and Somerville New Jersey condos for rent
Rental homes, holiday rentals in Highland Park, Highland Park bed and breakfast rentals, and vacation rentals Highland Park
Old Bridge New Jersey rental homes and houses for rent in Old Bridge
Homes for rent by owner Readington, apartment rentals, and Readington New Jersey rental homes
Real estate rentals in Rockaway New Jersey, home rentals Rockaway, condos for rent Rockaway New Jersey, and holiday rentals Rockaway New Jersey
Discover, distinguish, and devise houses for rent in Monmouth New Jersey, Monmouth New Jersey bed and breakfast rentals, Monmouth New Jersey rental homes, and Monmouth condo rentals.
The Ventnor City New Jersey romantic listed properties, mountain online MLS, mountain online MLS, and penthouse listings for these precinct can be mapped.
Ventnor City New Jersey precinct employs many real estate brokers, real estate investors, property agents, and town home owners.
Co-workers and sightseers who are prospecting Ventnor City rent house and are trying to catch Ventnor City rental home, home rentals in Ventnor City, and Ventnor City New Jersey house rentals can frisk our webpage and our oceanfront listings, oceanfront listed properties, loft indexes, and waterfront advertisements.
Espy and determine condos for rent Mercer New Jersey and holiday rentals in Mercer.
Disclose and devise condo rentals Burlington, rental houses in Burlington New Jersey, condos for rent, and houses for rent Burlington.
Ventnor City property brokers, real estate agents, rental property owners, and real estate agents list apartment rentals Ventnor City, short term rentals Ventnor City New Jersey, Ventnor City New Jersey condos for rent, and rental apartment Ventnor City.
Conceive and conceive rental apartment Somerset and Somerset New Jersey for rent by owner homes.
Debunk, detect, and debunk Camden apartments for rent, Camden New Jersey vacation homes, and homes for rent.
Originate, catch, and move real estate rentals in Salem New Jersey, house rentals in Salem New Jersey, and Salem New Jersey rent houses.
Disclose, glimpse, and debunk Newton United States vacation rental, real estate rentals Newton, and apartments for rent in Newton.
Move, catch, and ascertain houses for rent in Essex New Jersey and rental home.
Come upon, debunk, and discover Springfield house rentals, rent house, and Springfield rental apartment.
Elicit, dig up, and find rental houses Mountain Lakes, Mountain Lakes short term rentals, and Mountain Lakes rent house.
Design, look up, and determine Whippany United States apartment rentals, vacation rental in Whippany, and rental home.
Disclose and ferret out bed and breakfast rentals in Maple Shade United States and Maple Shade United States houses for rent.
Come across and move houses for rent in Blackwood United States and Blackwood homes for rent by owner.
Find out, observe, and glimpse rent houses in Hunterdon and rental houses Hunterdon.
Discern, debunk, and espy Salem New Jersey for rent by owner homes, vacation homes for rent by owner Salem New Jersey, for rent by owner homes Salem New Jersey, and rental houses in Salem.
Determine, move, and conceive holiday rentals in Salem, Salem New Jersey rental home, and Salem rental homes.
Using this site, For Rent By Owner (FRBO.com), landlords tab home and timeshare classified ads.
You can uncover, discern, and contrive rental apartment Ventnor City, rental apartment in Ventnor City, and Ventnor City New Jersey apartments for rent.
Procure and appoint tomorrow evening to take up, jump into, begin, and launch on this peregrination.
Elicit specific, specialized, strange, and distinct info in Ventnor City New Jersey and register rental apartment in Ventnor City New Jersey.
Empty spacious cabin, beachfront townhouse, and ski in/out home are approaching in the abutting township of Ventnor City New Jersey.
|
|
