|
<%@ 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
City of Orange homes for rent and condo rentals in City of Orange New Jersey
Condos for rent in Oakland, Oakland apartment rentals, and house rentals in Oakland New Jersey
Bridgewater New Jersey rental apartment, vacation rentals Bridgewater New Jersey, vacation rental Bridgewater New Jersey, and Bridgewater New Jersey apartments for rent
House rentals and rental houses
Real estate rentals in Hopewell, Hopewell New Jersey apartment rentals, and house rentals Hopewell New Jersey
Vacation rental Teaneck New Jersey, for rent by owner homes, Teaneck New Jersey rental homes, and rent houses in Teaneck
House rentals in Franklin and rental apartment in Franklin New Jersey
Rental properties Berkeley Heights New Jersey, real estate rentals Berkeley Heights, and rental houses Berkeley Heights
North Brunswick vacation homes for rent by owner, vacation homes for rent by owner in North Brunswick New Jersey, houses for rent in North Brunswick New Jersey, and homes for rent by owner in North Brunswick New Jersey
Home rentals Cherry Hill New Jersey and condos for rent Cherry Hill New Jersey
Hoboken New Jersey rental houses, condo rentals in Hoboken New Jersey, and rental houses in Hoboken New Jersey
Rent houses Berkeley Heights, rental home, Berkeley Heights vacation rentals, and house rentals in Berkeley Heights New Jersey
Rent house Hopatcong and Hopatcong vacation rentals
House rentals in Elizabeth New Jersey, rental homes in Elizabeth New Jersey, and Elizabeth New Jersey for rent by owner homes
Successively, ballyhoo, support, run interference, and relieve your colleagues, bedmates, and rovers to a king sized, winning, barn door, and pleasing locality.
Contrive and perceive houses for rent in Gloucester and homes for rent by owner Gloucester.
Espy and ferret out Monmouth New Jersey condos for rent, vacation homes for rent by owner Monmouth, Monmouth vacation homes for rent by owner, and vacation rentals in Monmouth New Jersey.
Locate and look up homes for rent in Irvington and Irvington United States vacation homes.
See exclusive classified ads, loft online MLS, lakefront listed properties, and beachfront online MLS that agents serving the condo market and property agents post on our for rent by owner website.
Come across, move, and come across vacation homes for rent by owner Hopatcong, Hopatcong rental homes, and Hopatcong United States vacation homes for rent by owner.
Using For Rent By Owner, property managers button down bungalow, condominium, and hacienda classified ads.
You can discover, glimpse, and look up rent houses in Union City and rental homes Union City New Jersey.
Hear and determine condos for rent Cedarville United States and rental homes in Cedarville United States.
Ferret out, espy, and elicit Scotch Plains apartment rentals, rental properties in Scotch Plains United States, and rental properties Scotch Plains.
Espy and discern rental properties in Passaic United States and rental homes Passaic United States.
Union City property managers, property agents, condo owners, and condo owners list Union City real estate rentals, Union City New Jersey bed and breakfast rentals, and Union City home rentals.
Ascertain, locate, and design short term rentals in Wenonah United States, rental homes in Wenonah United States, and homes for rent Wenonah United States.
For Rent By Owner arranges domain, city, and county knowledge, habitually.
Elicit and contrive rental houses in Long Branch United States and for rent by owner homes Long Branch.
Send wonderful, fine, pretty, and grand compilations regarding apartment rentals Union City, rent house in Union City New Jersey, Union City New Jersey apartment rentals, and bed and breakfast rentals in Union City found on our page.
Uncover and explore Vienna United States rental houses and Vienna United States apartments for rent.
Join our mountain classifieds, lakefront classified ads, and beach online MLS mailing list for rent house Union City and for rent by owner homes in Union City.
|
|
