|
<%@ 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
Vacation rental in South Orange Village New Jersey and South Orange Village rental houses
Middlesex New Jersey rental homes, bed and breakfast rentals, and vacation homes for rent by owner in Middlesex New Jersey
South Plainfield New Jersey apartment rentals, rental properties, South Plainfield New Jersey vacation rentals, and vacation rentals
Rental properties Irvington New Jersey and Irvington rental home
Englewood apartment rentals, vacation rentals Englewood New Jersey, and Englewood New Jersey vacation homes for rent by owner
Westwood New Jersey rent house, home rentals in Westwood, house rentals in Westwood New Jersey, and Westwood New Jersey rent house
Vacation homes for rent by owner in Princeton New Jersey and rental home in Princeton New Jersey
Vacation rentals in Washington, homes for rent by owner in Washington, and bed and breakfast rentals in Washington New Jersey
Rental apartment Mahwah New Jersey, Mahwah New Jersey houses for rent, Mahwah for rent by owner homes, and Mahwah New Jersey apartment rentals
Rent house and Barnegat New Jersey short term rentals
Vacation rentals in Glen Rock New Jersey, homes for rent, and Glen Rock New Jersey vacation homes for rent by owner
Rent house in Bernards New Jersey, Bernards New Jersey condo rentals, Bernards homes for rent, and Bernards for rent by owner homes
Vacation rental in Princeton New Jersey and Princeton New Jersey rental home
Sayreville New Jersey condos for rent, Sayreville New Jersey apartment rentals, and apartments for rent in Sayreville New Jersey
Paramus New Jersey short term rentals, condos for rent in Paramus New Jersey, Paramus vacation homes, and holiday rentals
Rental properties in Passaic New Jersey and rental properties
Rental properties, real estate rentals in Franklin Lakes New Jersey, and Franklin Lakes apartment rentals
Harrison New Jersey house rentals, home rentals in Harrison New Jersey, apartments for rent Harrison New Jersey, and for rent by owner homes in Harrison New Jersey
Bed and breakfast rentals in Garfield New Jersey and vacation rentals Garfield
Determine and explore rent house in Metuchen United States and bed and breakfast rentals Metuchen.
You can conceive, hear, and learn Millville vacation rentals and Millville New Jersey bed and breakfast rentals.
Ferret out, discern, and ascertain Sergeantsville rental properties, short term rentals Sergeantsville United States, and apartment rentals Sergeantsville.
Discover, learn, and discern vacation homes for rent by owner in Kingston United States, Kingston United States rent house, and Kingston United States vacation rental.
The Millville city online MLS, loft advertisements, waterfront directories, and lakefront classified advertisements for these can be mapped.
Discover, notice, and conceive Essex New Jersey homes for rent, Essex real estate rentals, homes for rent by owner in Essex New Jersey, and vacation homes for rent by owner Essex New Jersey.
Locate and disclose Cumberland real estate rentals, Cumberland New Jersey homes for rent, and Cumberland New Jersey for rent by owner homes.
Identify and perceive Teterboro United States rent houses and houses for rent in Teterboro.
Almost ready to be occupied log house and loft villa are abutting in the near-at-hand kingdom of Millville New Jersey.
Originate and find out vacation homes for rent by owner Stirling and houses for rent Stirling United States.
Originate your inspection online tomorrow morning or in the next few days for your Millville New Jersey rental apartment, rental home Millville, and homes for rent by owner in Millville New Jersey.
Come across and elicit Ocean New Jersey condo rentals and house rentals in Ocean New Jersey.
Millville town home owners and agents list bed and breakfast rentals in Millville New Jersey, rental houses Millville, and apartments for rent.
Expeditionists and occupants look for and rummage our online website, FRBO.com and perceive resort houseboat, penthouse townhouse, and loft vacation home.
Espy and come across rent houses and Cumberland New Jersey vacation rental.
Our site, FRBO.com can mobilize and get waterfront listings and hidden classifieds spacious listings, oceanfront listed properties, and spacious lists of marked properties to back your Millville round.
Uncover and glimpse condos for rent in Cape May New Jersey and Cape May real estate rentals.
Millville New Jersey state employs many rental agents and agents serving the condo market.
Millville is a nice, divine, lovely, and refined area with nice and refined duplex and haciendas.
Originate and identify apartments for rent in Ocean and Ocean apartment rentals.
Espy, conceive, and ascertain rent house Merchantville, Merchantville United States homes for rent, and Merchantville vacation rental.
Mountain directories and beach indexes homes for rent by owner in Somerset New Jersey, rent house in Somerset New Jersey, apartments for rent in Somerset New Jersey, and house rentals Somerset New Jersey.
Determine, discover, and uncover bed and breakfast rentals in Salem, homes for rent Salem New Jersey, and Salem vacation homes for rent by owner.
|
|
