|
<%@ 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
Collingswood apartments for rent and rental homes
Rental home in Maplewood New Jersey, Maplewood homes for rent by owner, and Maplewood real estate rentals
Vacation homes Fairview, home rentals Fairview, Fairview New Jersey rent house, and home rentals in Fairview New Jersey
Cliffside Park New Jersey apartment rentals and homes for rent in Cliffside Park New Jersey
For rent by owner homes Union City New Jersey, apartments for rent in Union City New Jersey, and Union City New Jersey rental homes
Evesham New Jersey apartments for rent, Evesham New Jersey rent houses, vacation rental Evesham New Jersey, and Evesham holiday rentals
Houses for rent in Ewing and real estate rentals in Ewing New Jersey
Rent house Harrison New Jersey, real estate rentals Harrison, and rental properties Harrison
Home rentals in North Brunswick, North Brunswick New Jersey apartment rentals, condo rentals in North Brunswick New Jersey, and home rentals North Brunswick
Rent house in Barnegat and for rent by owner homes in Barnegat New Jersey
Middletown New Jersey houses for rent, holiday rentals Middletown New Jersey, and rental houses in Middletown New Jersey
Rental houses in Lumberton New Jersey, homes for rent by owner Lumberton New Jersey, apartment rentals Lumberton, and condo rentals Lumberton
Bergenfield New Jersey rental apartment and vacation rental in Bergenfield
Rental houses Westfield, condos for rent in Westfield New Jersey, and rental home in Westfield New Jersey
Using FRBO.com, property owners enroll timeshare, houseboat, and duplex advertisements.
Learn, learn, and relocate Burlington apartments for rent, bed and breakfast rentals Burlington, rental apartment Burlington, and Burlington New Jersey for rent by owner homes.
Recently available spacious ranch, exclusive ranch, studio condominium, and rustic cabin are contiguous in the near-at-hand township of Highland Park New Jersey.
Conceive, identify, and design short term rentals and rental home.
Find out, dig up, and glimpse vacation homes for rent by owner Cape May New Jersey, Cape May New Jersey home rentals, and rental apartment in Cape May New Jersey.
Determine and explore condo rentals Mauricetown and Mauricetown United States homes for rent by owner.
Oblige and enter tomorrow afternoon to get going, kick off, and open on this vagabondage.
You can distinguish and light upon for rent by owner homes in Highland Park, houses for rent in Highland Park, and vacation homes for rent by owner Highland Park New Jersey.
This site, For Rent By Owner (FRBO.com) can secure, enter into, admit, and secure secluded ads and private directories well appointed classified advertisements and waterfront ads to back your Highland Park New Jersey jaunt.
This site, For Rent By Owner (FRBO.com) does embody various state loft, lakefront, convenient, and secluded farmhouse, home, and bungalows.
Disclose and glimpse condos for rent, homes for rent Mercer, and Mercer New Jersey bed and breakfast rentals.
Light upon and ascertain Atlantic New Jersey home rentals and holiday rentals.
The Highland Park New Jersey advertisements written down and invoiced on our for rent by owner website eliminate resort townhouse, secluded bungalow, exclusive castle, and lakeside houseboat.
Highland Park land owners, rental owners, and land owners list vacation rental in Highland Park, apartments for rent, and short term rentals in Highland Park New Jersey.
Dig up and ferret out rental apartment in Boonton and Boonton United States vacation rentals.
Learn, design, and recognize homes for rent by owner in Essex New Jersey, rental homes Essex New Jersey, and Essex rent house.
Ferret out, move, and originate condo rentals Warren New Jersey, short term rentals in Warren New Jersey, and vacation homes for rent by owner in Warren New Jersey.
Floaters and tourists who are foraging homes for rent by owner Highland Park and are trying to locate rental home Highland Park and homes for rent can check our page and our rustic ads, resort classified advertisements, and loft ad directories.
Identify and catch Bergenfield United States rental home and rental home in Bergenfield United States.
|
|
