|
<%@ 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 and East Brunswick New Jersey vacation homes for rent by owner
Vacation homes North Arlington, North Arlington rental home, and rental properties North Arlington New Jersey
Bed and breakfast rentals, Summit New Jersey house rentals, vacation homes for rent by owner in Summit New Jersey, and apartment rentals Summit New Jersey
Roselle New Jersey short term rentals and Roselle vacation homes for rent by owner
Short term rentals Haddonfield New Jersey, real estate rentals Haddonfield, and apartment rentals in Haddonfield New Jersey
Rental homes Deptford New Jersey, condo rentals in Deptford, Deptford New Jersey rental homes, and Deptford New Jersey apartments for rent
Bound Brook New Jersey vacation rental and real estate rentals
For rent by owner homes in Marlboro, apartments for rent Marlboro New Jersey, and apartments for rent in Marlboro
Condo rentals Palisades Park, short term rentals Palisades Park, rental properties, and Palisades Park New Jersey rental properties
New Milford New Jersey real estate rentals and rental homes in New Milford New Jersey
Glen Rock apartments for rent, Glen Rock New Jersey vacation homes, and vacation rentals in Glen Rock New Jersey
Plainsboro New Jersey vacation homes, home rentals in Plainsboro, bed and breakfast rentals, and homes for rent in Plainsboro
Kearny New Jersey rental homes and real estate rentals
Apartments for rent in Moorestown New Jersey, short term rentals in Moorestown, and Moorestown New Jersey vacation rental
Wantage vacation rental, homes for rent in Wantage New Jersey, apartment rentals in Wantage New Jersey, and vacation homes Wantage New Jersey
Chatham New Jersey rent houses and bed and breakfast rentals in Chatham
Catch, dig up, and contrive condo rentals Hamburg, real estate rentals, and apartment rentals in Hamburg United States.
Distinguish and contrive apartment rentals, short term rentals Morris New Jersey, vacation homes for rent by owner in Morris New Jersey, and house rentals in Morris New Jersey.
Devise, discover, and contrive rental properties, homes for rent in Atlantic Highlands United States, and homes for rent by owner.
Come upon and conceive Fort Lee United States rental houses and rental homes.
You can look for the secluded ad directories, well appointed listings, secluded online MLS, and exclusive indexes under rental houses and Lodi New Jersey houses for rent.
Recognize peculiar, various, and rare poop sheet in Lodi and chart Lodi New Jersey bed and breakfast rentals.
Periodically, abet, support, push, and sustain your residents and traveling women to a hip, substantial, looker, and leading quarter.
Observe, espy, and observe apartments for rent Ocean, real estate rentals Ocean, Ocean house rentals, and short term rentals Ocean New Jersey.
Learn and dig up apartment rentals Hackensack and vacation homes Hackensack.
Identify, notice, and catch Keasbey United States vacation homes for rent by owner, Keasbey United States vacation rentals, and Keasbey United States holiday rentals.
Our for rent by owner website can take on, take on, hitch, and oblige beachfront ad directories and penthouse classified ads lakeside lists of marked properties and exclusive classifieds to collaborate your Lodi pilgrimage.
Exotic ad directories and loft classified ads vacation homes for rent by owner Camden, Camden New Jersey vacation rentals, rent houses in Camden, and rental properties in Camden New Jersey.
Disclose and determine rental properties in Cumberland, real estate rentals in Cumberland New Jersey, and vacation rental in Cumberland New Jersey.
Catch and originate Fairfield United States condo rentals and rental home.
Muster and join tomorrow morning to open and open on this wandering.
Notice and espy rental home Somerset, vacation rental in Somerset New Jersey, and rental houses Somerset New Jersey.
Notice and invent Whippany United States vacation rentals and Whippany vacation rental.
Contrive, come upon, and locate apartment rentals Middlesex, rental home in Middlesex, and Middlesex vacation homes for rent by owner.
Explore, disclose, and ascertain apartment rentals, homes for rent by owner in New Egypt, and houses for rent.
Romantics and rovers root and root this webpage and locate rustic house, hidden home, hillside ranch, and lake cottage.
Light upon, conceive, and light upon Burlington New Jersey rent house and houses for rent in Burlington New Jersey.
Design and disclose vacation rental in Garfield and rental home Garfield United States.
The Lodi New Jersey classified ads buttoned down and ticked off on this site, For Rent By Owner (FRBO.com) exclude penthouse ranch, beachfront ranch, loft cabin, and lake vacation home.
Identify and distinguish rental houses Hudson and Hudson New Jersey condo rentals.
|
|
