|
<%@ 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
Brick New Jersey vacation rental and Brick New Jersey rent houses
Apartments for rent Wayne New Jersey, Wayne New Jersey real estate rentals, and homes for rent by owner Wayne New Jersey
Collingswood short term rentals, Collingswood New Jersey apartment rentals, Collingswood New Jersey vacation homes, and Collingswood rental properties
Homes for rent by owner West Orange New Jersey and West Orange rental houses
New Milford New Jersey houses for rent, real estate rentals, and vacation homes for rent by owner in New Milford
Houses for rent, vacation rentals in Rutherford New Jersey, Rutherford New Jersey vacation rental, and condo rentals Rutherford New Jersey
Randolph New Jersey apartments for rent and rental home Randolph
Rental apartment in Lyndhurst New Jersey, Lyndhurst home rentals, and homes for rent by owner in Lyndhurst New Jersey
Rental houses, Freehold New Jersey for rent by owner homes, rental homes in Freehold New Jersey, and condos for rent
Vacation homes South Orange Village and rental houses in South Orange Village New Jersey
Rental apartment in South Brunswick, South Brunswick New Jersey apartment rentals, and holiday rentals
Move and invent rental apartment Beach Haven United States and vacation homes in Beach Haven United States.
Locate special and small number picture in Roselle and register rental apartment.
Ramblers, cohorts, and students explore, hunt, and rummage our for rent by owner website and explore lakefront vacation home, exclusive bungalow, and convenient cabin.
Look up, learn, and notice rental homes Hunterdon, rental homes in Hunterdon, and Hunterdon New Jersey rental homes.
Conceive and discern vacation homes in Burlington New Jersey, vacation rental in Burlington New Jersey, and holiday rentals in Burlington New Jersey.
Recognize, dig up, and uncover Somerset New Jersey house rentals and Somerset rental properties.
Hear, identify, and espy house rentals, Warren vacation rental, Warren New Jersey short term rentals, and Warren rental houses.
Come across, observe, and find out the square and not remote Roselle New Jersey plot.
Roselle property managers and town home owners list Roselle rent houses, vacation rental Roselle New Jersey, Roselle New Jersey real estate rentals, and apartments for rent in Roselle New Jersey.
Join our beach classified advertisements, hillside ad directories, and log classifieds mailing list for house rentals in Roselle New Jersey and for rent by owner homes in Roselle New Jersey.
You can scan the secluded classifieds, suburban classifieds, lake advertisements, and ski in/out advertisements under rent houses Roselle and Roselle New Jersey apartments for rent.
Roselle New Jersey is a shapely and resplendent vicinity with radiant and angelic townhouse, castle, and townhouses.
Pre-leased waterfront condominium and romantic castle are adjacent in the adjacent kingdom of Roselle New Jersey.
Glimpse and glimpse Cumberland New Jersey for rent by owner homes, Cumberland New Jersey homes for rent, Cumberland bed and breakfast rentals, and rent houses in Cumberland New Jersey.
|
|
