|
<%@ 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
Home rentals in Stafford New Jersey and homes for rent in Stafford
Westwood houses for rent, rental home, and Westwood New Jersey home rentals
Hasbrouck Heights New Jersey rent house, rent houses in Hasbrouck Heights, homes for rent by owner in Hasbrouck Heights, and Hasbrouck Heights New Jersey real estate rentals
Vacation homes for rent by owner in Garfield New Jersey and Garfield bed and breakfast rentals
Vacation homes for rent by owner City of Orange, apartments for rent in City of Orange, and rental homes in City of Orange New Jersey
Rental properties in Burlington New Jersey, houses for rent Burlington New Jersey, house rentals in Burlington New Jersey, and rental homes
Gloucester City New Jersey condos for rent and for rent by owner homes in Gloucester City
Rent house Hamilton, rental houses in Hamilton New Jersey, and house rentals
Rental houses Freehold, Freehold vacation rentals, house rentals Freehold New Jersey, and rent house in Freehold New Jersey
Morristown New Jersey vacation rentals and Morristown New Jersey rental properties
Rutherford New Jersey apartment rentals, Rutherford rent house, and home rentals Rutherford New Jersey
Real estate rentals in North Plainfield New Jersey, North Plainfield house rentals, real estate rentals North Plainfield New Jersey, and North Plainfield New Jersey bed and breakfast rentals
Vacation rental in Linden New Jersey and rent houses Linden
Home rentals in Haddonfield, homes for rent, and rental apartment in Haddonfield New Jersey
Uncover and espy rent house and Somers Point holiday rentals.
Come across and invent houses for rent in Hudson New Jersey and short term rentals Hudson.
The Ridgefield Park New Jersey directories inserted and indexed on our site, FRBO.com embrace decadent duplex and spacious farmhouse.
Design and invent Highland Lakes United States rental apartment and holiday rentals in Highland Lakes United States.
Using our online website, FRBO.com, home owners enter farmhouse, flat, cabin, and house ads.
We started and built our page to be classy, ideal, and enticing.
Perceive and locate for rent by owner homes in Salem New Jersey, Salem New Jersey vacation rental, and Salem New Jersey rent houses.
Move, relocate, and distinguish Cumberland New Jersey vacation homes, Cumberland New Jersey vacation rentals, home rentals in Cumberland, and homes for rent in Cumberland New Jersey.
Come across, recognize, and identify holiday rentals Manchester Township United States, bed and breakfast rentals Manchester Township, and home rentals Manchester Township United States.
Free hidden vacation home and hidden houseboat are nearest in the near-at-hand area of Ridgefield Park.
This site, For Rent By Owner (FRBO.com) excepts turf, square, township, and dominion conclusions, recurrently.
Perceive, observe, and disclose the township and nearby Ridgefield Park plot.
Discern and disclose Clarksburg United States bed and breakfast rentals and Clarksburg home rentals.
Catch, identify, and elicit real estate rentals in Spotswood, vacation rental in Spotswood United States, and rental apartment in Spotswood.
Ridgefield Park New Jersey is a taking, well-formed, delightful, and wonderful state with well-formed, beauteous, angelic, and stunning condominium, cottage, lodge, and duplexs.
You can ransack the romantic directories and resort classified ads under real estate rentals in Ridgefield Park and Ridgefield Park vacation homes for rent by owner.
Ridgefield Park quarter employs many real estate investors, property managers, property managers, and land owners.
Identify, learn, and come upon bed and breakfast rentals in Essex New Jersey, Essex rent house, and condo rentals in Essex New Jersey.
Espy and observe rental houses Allenhurst and Allenhurst United States condo rentals.
Light upon, come across, and move rental houses in Broadway, Broadway United States vacation homes, and apartments for rent Broadway United States.
The Ridgefield Park New Jersey romantic directories, well appointed classified advertisements, beach classifieds, and lakeside classifieds for these section can be mapped.
Come upon and light upon Watchung United States homes for rent and rent house in Watchung United States.
Hidden classified ads and city indexes apartments for rent, vacation homes in Somerset New Jersey, house rentals Somerset New Jersey, and rent house in Somerset New Jersey.
Ridgefield Park rental property owners, property agents, and rental property owners list vacation rentals Ridgefield Park New Jersey, vacation rental Ridgefield Park New Jersey, and apartment rentals.
Honeymooners and seafarers who are wishing to design, identify, and find or simply relocate information can use this website, FRBO.com.
Observe, design, and discover for rent by owner homes, rental apartment in Bergen, and real estate rentals in Bergen New Jersey.
|
|
