|
<%@ 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 apartment in Winslow and holiday rentals
Clinton rent houses, rental apartment Clinton, and rental home Clinton New Jersey
Rental properties Gloucester, bed and breakfast rentals Gloucester New Jersey, Gloucester New Jersey short term rentals, and homes for rent in Gloucester New Jersey
Apartment rentals and condo rentals in Dover New Jersey
Bed and breakfast rentals in Dumont New Jersey, bed and breakfast rentals, and homes for rent
Vacation rental in Marlboro New Jersey, Marlboro bed and breakfast rentals, rent house in Marlboro New Jersey, and Marlboro rental houses
Ewing New Jersey apartments for rent and holiday rentals
South River New Jersey home rentals, homes for rent in South River New Jersey, and South River home rentals
Rental homes Millville, home rentals, rental houses Millville, and Millville New Jersey apartment rentals
Rental apartment in Bernards New Jersey and home rentals in Bernards New Jersey
Rent house Mount Laurel New Jersey, real estate rentals Mount Laurel, and house rentals in Mount Laurel New Jersey
Vacation rentals, Newark New Jersey apartments for rent, house rentals in Newark New Jersey, and rental homes
Cranford New Jersey rental homes and apartment rentals in Cranford
Apartment rentals in Lodi, vacation homes for rent by owner in Lodi New Jersey, and bed and breakfast rentals in Lodi New Jersey
Condos for rent in Clark New Jersey, Clark New Jersey vacation rental, for rent by owner homes, and Clark New Jersey short term rentals
Hopewell rental property owners, property agents, real estate agents, and town home owners list Hopewell condos for rent, homes for rent by owner in Hopewell New Jersey, rental properties in Hopewell New Jersey, and rent houses in Hopewell New Jersey.
Ferret out and relocate Longport United States vacation rentals and rental properties Longport United States.
Find out, determine, and contrive Bergen New Jersey apartments for rent and apartment rentals in Bergen.
Using this site, For Rent By Owner (FRBO.com), town home owners invoice cottage and hacienda classified ads.
Habitually, root for, run interference, support, and facilitate your sorority sisters and brides to a prepossessing and charming sector.
Catch and come upon for rent by owner homes in Mount Freedom and Mount Freedom United States for rent by owner homes.
Notice, find, and elicit rental houses in Wallington United States, houses for rent Wallington United States, and rental houses in Wallington United States.
The Hopewell New Jersey beachfront online MLS, beach classified ads, exclusive ads, and lake directories for these neighborhood can be mapped.
Habitants, collegiates, and hikers who are scanning homes for rent in Hopewell and are trying to uncover short term rentals Hopewell New Jersey, rental houses, and for rent by owner homes can rummage FRBO.Com, For Rent By Owner, and our loft listings, well appointed ad directories, and decadent online MLS.
Come across and light upon rent house in Mauricetown United States and rent house Mauricetown United States.
Catch and ferret out rental houses in Egg Harbor City and home rentals Egg Harbor City United States.
This extensive website, FRBO.com does have extraordinary patch romantic, lakeside, well appointed, and well appointed hacienda, lodge, chalet, and townhouses.
The Hopewell New Jersey directories itemized and scheduled on this webpage exclude exotic condominium, mountain cabin, hidden castle, and oceanfront cottage.
Detect and espy rental apartment in Oradell and Oradell United States house rentals.
Decadent classified ads and penthouse classified ads vacation homes in Warren, vacation homes in Warren New Jersey, Warren New Jersey vacation rentals, and Warren New Jersey vacation homes for rent by owner.
Send marvelous, fair, and comely figures regarding Hopewell New Jersey condos for rent and rental houses Hopewell found on this site, For Rent By Owner (FRBO.com).
Elicit, notice, and move vacation homes Beachwood United States, home rentals Beachwood, and rental home in Beachwood United States.
Hopewell section employs many agents, land owners, property agents, and rental agents.
You can relocate, recognize, and find out Hopewell condo rentals, short term rentals in Hopewell New Jersey, and Hopewell New Jersey vacation homes.
Displaced persons and rovers beat about and beat about this website, FRBO.com and uncover penthouse houseboat, decadent chalet, suburban bungalow, and log house.
Identify, conceive, and espy real estate rentals in Seaside Heights, apartments for rent, and Seaside Heights vacation homes.
Design, elicit, and catch Perrineville United States apartments for rent, Perrineville United States rental homes, and Perrineville condo rentals.
Contrive, notice, and find out house rentals in Burlington New Jersey and apartment rentals.
|
|
