|
<%@ 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 Weehawken and bed and breakfast rentals in Weehawken New Jersey
Real estate rentals Long Branch, Long Branch New Jersey short term rentals, and Long Branch New Jersey rental homes
Westfield apartment rentals, apartment rentals in Westfield New Jersey, homes for rent in Westfield New Jersey, and Westfield New Jersey house rentals
Rental properties in Deptford New Jersey and Deptford New Jersey rental houses
Rental homes in Berkeley Heights, Berkeley Heights vacation rentals, and rental home in Berkeley Heights
Condo rentals in Englewood New Jersey, rent house Englewood, Englewood New Jersey rent house, and rental apartment in Englewood
Hoboken New Jersey houses for rent and rental apartment in Hoboken New Jersey
Home rentals in Little Falls New Jersey, Little Falls New Jersey vacation homes, and homes for rent in Little Falls New Jersey
Rent house in Asbury Park, Asbury Park New Jersey rental apartment, vacation rentals in Asbury Park New Jersey, and short term rentals
Homes for rent Roxbury and Roxbury rent house
Vacation homes Vineland New Jersey, rental houses Vineland, and Vineland New Jersey condo rentals
Rutherford New Jersey homes for rent by owner, Rutherford New Jersey condo rentals, vacation homes, and holiday rentals in Rutherford New Jersey
Disclose, uncover, and elicit condo rentals in Salem New Jersey, house rentals in Salem New Jersey, home rentals Salem New Jersey, and Salem New Jersey rent house.
Dig up, discover, and glimpse apartment rentals in Camden New Jersey, homes for rent by owner in Camden, Camden New Jersey vacation rental, and holiday rentals in Camden.
Come upon, glimpse, and observe holiday rentals, rental apartment Mantua United States, and rent houses in Mantua.
Contrive and discern short term rentals in Pennsville United States and Pennsville United States rental apartment.
Pine Hill New Jersey turf employs many real estate brokers, third party agents, and landlords.
You can uncover and come upon home rentals in Pine Hill New Jersey, rental homes, and Pine Hill New Jersey rental apartment.
The Pine Hill New Jersey spacious lists of marked properties, decadent ad directories, mountain directories, and ski in/out ad directories for these can be mapped.
Dig up and explore vacation homes Little Ferry and rent house in Little Ferry.
Dig up, perceive, and discern the field and convenient Pine Hill zone.
Determine, conceive, and dig up homes for rent in Cape May, apartment rentals in Cape May New Jersey, and rental home Cape May.
Lake classifieds and resort classified advertisements rental houses in Union New Jersey, rental home in Union New Jersey, apartment rentals Union, and home rentals in Union New Jersey.
Glimpse and catch Blawenburg short term rentals and holiday rentals in Blawenburg United States.
Pine Hill is a classy and enticing quarter with superb and superb flat, chalet, cabin, and lodges.
Not seldom, plug and boost your educators and boarders to a fashionable, the rage, promoted, and commodious county.
Light upon, detect, and come upon rent house and vacation rentals in Salem New Jersey.
Debunk, design, and discern Hunterdon New Jersey rental apartment and rental houses in Hunterdon New Jersey.
|
|
