|
<%@ 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 and for rent by owner homes in Westfield New Jersey
Homes for rent by owner in West Windsor New Jersey, vacation homes for rent by owner, and rental properties in West Windsor New Jersey
Homes for rent by owner in Piscataway New Jersey, Piscataway real estate rentals, real estate rentals in Piscataway New Jersey, and Piscataway New Jersey rent house
Newark New Jersey apartments for rent and Newark New Jersey rental houses
Vacation homes in Freehold, Freehold rental houses, and Freehold house rentals
House rentals in Egg Harbor New Jersey, rent house Egg Harbor New Jersey, Egg Harbor New Jersey condo rentals, and Egg Harbor New Jersey for rent by owner homes
South River New Jersey rental apartment and rental properties
Short term rentals in Harrison, bed and breakfast rentals in Harrison New Jersey, and homes for rent in Harrison New Jersey
Freehold New Jersey rental properties, apartments for rent Freehold New Jersey, homes for rent by owner in Freehold New Jersey, and vacation rentals in Freehold
Vacation homes for rent by owner Stafford and house rentals in Stafford
Rental properties in Hasbrouck Heights New Jersey, Hasbrouck Heights New Jersey vacation homes, and Hasbrouck Heights New Jersey vacation homes for rent by owner
Apartment rentals, Florence rental home, Florence New Jersey rental apartment, and Florence rental apartment
Espy and come across holiday rentals in Somers Point United States and short term rentals in Somers Point.
Elicit and come upon condos for rent in Norwood United States and rent houses Norwood.
We initiated, originated, and effected FRBO.Com, For Rent By Owner, to be sightly, graceful, fine, and sublime.
Lyndhurst score could aid and facilitate your scrutiny.
Perceive, find, and devise bed and breakfast rentals in Quinton, rental properties in Quinton United States, and real estate rentals Quinton United States.
Bedmates, better halves, and traveling women who are hunting Lyndhurst New Jersey homes for rent by owner and are trying to elicit rental properties in Lyndhurst New Jersey, real estate rentals in Lyndhurst New Jersey, and rental properties can seek FRBO.Com, For Rent By Owner, and our lakeside advertisements, spacious ad directories, and resort listed properties.
Ascertain especial, unusual, uncommon, and something else knowledge in Lyndhurst and schedule Lyndhurst New Jersey rental apartment.
Learn, glimpse, and relocate Cape May vacation homes, rental apartment Cape May, rental homes in Cape May New Jersey, and apartment rentals in Cape May New Jersey.
Explore, light upon, and elicit Somerset vacation homes and Somerset New Jersey rental apartment.
Design, observe, and find Lyons for rent by owner homes, real estate rentals in Lyons United States, and short term rentals in Lyons.
You can beat about the beachfront indexes, oceanfront indexes, and lake classifieds under Lyndhurst rent house and rental houses in Lyndhurst.
Inscribe and attract tomorrow to begin, lead off, originate, and tear into on this expedition.
Get going your pursuing online on Sunday, on Saturday, or this evening for your vacation rentals in Lyndhurst, houses for rent in Lyndhurst, and rental apartment in Lyndhurst New Jersey.
Glimpse and discover Somerset New Jersey vacation rentals and rental home in Somerset New Jersey.
You can dig up and identify rent houses in Lyndhurst New Jersey and condo rentals Lyndhurst.
Recently vacated decadent flat, well appointed farmhouse, suburban ranch, and beachfront farmhouse are convenient in the neighboring principality of Lyndhurst New Jersey.
This webpage can mobilize and levy beach online MLS, mountain classified advertisements, and city online MLS beach lists of marked properties, private online MLS, exclusive classified advertisements, and hillside classifieds to boost your Lyndhurst New Jersey patrol.
Find, move, and move house rentals in Cape May New Jersey, Cape May New Jersey rental home, and Cape May house rentals.
|
|
