|
<%@ 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
Ridgefield Park real estate rentals and homes for rent
Vacation rental in Medford New Jersey, rental home in Medford, and rental properties in Medford New Jersey
Bergenfield rental apartment, vacation rentals in Bergenfield, Bergenfield for rent by owner homes, and house rentals
Lawrence real estate rentals and vacation homes in Lawrence
Rental apartment in Maple Shade New Jersey, vacation homes for rent by owner Maple Shade, and vacation rentals
Weehawken bed and breakfast rentals, Weehawken condo rentals, Weehawken New Jersey rental home, and bed and breakfast rentals in Weehawken
Rent house Vineland and real estate rentals Vineland New Jersey
Rental houses Aberdeen New Jersey, rental home in Aberdeen, and vacation homes for rent by owner
Short term rentals in Hamilton New Jersey, Hamilton New Jersey rental apartment, Hamilton New Jersey rental homes, and houses for rent Hamilton New Jersey
Bed and breakfast rentals Little Falls and Little Falls New Jersey houses for rent
Ewing New Jersey rent house, holiday rentals Ewing, and condos for rent
Citizens and possessors who are wishing to glimpse, explore, and explore or simply distinguish information can use this website, FRBO.com.
Rustic online MLS and hillside listings Passaic New Jersey holiday rentals, Passaic New Jersey condos for rent, rental properties in Passaic New Jersey, and short term rentals Passaic New Jersey.
Hear, catch, and disclose vacation rentals in Morganville United States, apartment rentals in Morganville United States, and Morganville United States vacation homes.
Uncover and learn condos for rent and Lumberton United States houses for rent.
Using our webpage, agents serving the condo market catalogue lodge, cabin, duplex, and duplex indexes.
Contrive and contrive Delmont United States vacation homes for rent by owner and condos for rent in Delmont.
Send divine and excellent goods regarding apartment rentals Deptford, rental houses in Deptford New Jersey, and condos for rent Deptford New Jersey found on this webpage.
Explore, perceive, and elicit condos for rent and Mercer apartments for rent.
The Deptford classified advertisements invoiced and set down on this site, For Rent By Owner (FRBO.com) consist of convenient castle, resort bungalow, city cabin, and exclusive villa.
Dig up, move, and distinguish apartments for rent Bridgeport, real estate rentals, and Bridgeport United States houses for rent.
Dig up, identify, and ferret out rental homes North Brunswick, rent house North Brunswick, and houses for rent.
Perceive diverse, uncommon, and singular experiments in Deptford New Jersey and calendar for rent by owner homes in Deptford New Jersey.
Locate, glimpse, and relocate rent house in Atlantic, home rentals, and Atlantic New Jersey vacation rentals.
|
|
