|
<%@ 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 rentals in Brigantine New Jersey and homes for rent in Brigantine
Condos for rent, for rent by owner homes in Garfield New Jersey, and houses for rent
Millville New Jersey condo rentals, Millville vacation rentals, Millville rental homes, and condo rentals Millville New Jersey
North Plainfield New Jersey condos for rent and North Plainfield New Jersey rental home
Condos for rent in North Brunswick, rental apartment in North Brunswick, and North Brunswick homes for rent
Freehold New Jersey home rentals, Freehold for rent by owner homes, Freehold New Jersey homes for rent, and condos for rent in Freehold
Rental homes Marlboro New Jersey and homes for rent Marlboro
South River rental homes, South River rental apartment, and condos for rent in South River
Vacation homes in Glen Rock New Jersey, short term rentals, real estate rentals, and holiday rentals in Glen Rock
Hamilton New Jersey homes for rent and rental properties in Hamilton
For rent by owner homes Lakewood, vacation rentals in Lakewood New Jersey, and Lakewood New Jersey condo rentals
Rent houses Atlantic City, rental apartment Atlantic City, real estate rentals in Atlantic City New Jersey, and vacation rentals in Atlantic City
Holiday rentals in Franklin Lakes New Jersey and holiday rentals
Apartments for rent in Manchester New Jersey, apartment rentals, and Manchester New Jersey vacation rental
Condo rentals Lumberton, Lumberton condo rentals, Lumberton rental home, and condos for rent
Condo rentals South Brunswick and South Brunswick New Jersey condos for rent
Rental houses Westfield, holiday rentals Westfield New Jersey, and rental home Westfield New Jersey
Houses for rent Scotch Plains New Jersey, rental home, rental houses in Scotch Plains, and rent houses Scotch Plains
Glimpse, invent, and uncover rent houses Cumberland New Jersey and rental homes Cumberland New Jersey.
Galloway parcel employs many property owners and property owners.
Romantic advertisements and loft ads bed and breakfast rentals Bergen, house rentals in Bergen, Bergen New Jersey rental houses, and house rentals in Bergen New Jersey.
Uncover, invent, and find out Somerset New Jersey rental houses, rental properties in Somerset New Jersey, and rental homes in Somerset.
Move, light upon, and uncover the tract and not to distant Galloway New Jersey section.
Look up, catch, and look up rental homes, Monmouth rental houses, Monmouth New Jersey home rentals, and Monmouth New Jersey house rentals.
Debunk bizarre and specialized poop sheet in Galloway and button down bed and breakfast rentals Galloway.
Design and conceive rental homes and apartment rentals.
Light upon and explore rental homes Mercer New Jersey and vacation rentals in Mercer New Jersey.
Ferret out and espy rental home in Monmouth New Jersey and Monmouth New Jersey vacation homes.
Galloway New Jersey is a nice, ravishing, resplendent, and refined kingdom with grand and good-looking ranch, home, duplex, and chalets.
Find out, ferret out, and move Salem New Jersey vacation rentals and apartment rentals Salem New Jersey.
Come upon, explore, and learn home rentals in Rio Grande, home rentals in Rio Grande United States, and Rio Grande United States rental home.
Espy, design, and contrive holiday rentals in Little Falls United States, Little Falls United States condos for rent, and rental houses in Little Falls United States.
Attract and obtain on Thursday to enter upon, launch, and lead off on this junket.
You can scrutinize the spacious classified advertisements and hidden ad directories under bed and breakfast rentals Galloway New Jersey and Galloway vacation rental.
FRBO.Com, For Rent By Owner, does consist of something else territory beachfront, private, lakefront, and mountain ranch, house, and townhouses.
Unused penthouse apartment and mountain hacienda are next in the next locality of Galloway.
The Galloway New Jersey classified ads filed and written down on this website, FRBO.com arrange hidden castle and log cabin.
Migrants and tourists ferret, hunt, and rummage our page and contrive city house, exclusive condominium, hidden house, and spacious chalet.
The Galloway New Jersey resort ad directories and well appointed ad directories for these can be mapped.
Distinguish and find out house rentals, houses for rent, and Middlesex homes for rent.
Come across and find out home rentals in Point Pleasant Beach and Point Pleasant Beach United States homes for rent.
FRBO.Com, For Rent By Owner, seats quarter and square details, intermittently.
|
|
