|
<%@ 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 properties and rental home in Camden
Rental homes, Raritan rent house, and for rent by owner homes Raritan
Homes for rent by owner Belleville, Belleville condos for rent, bed and breakfast rentals in Belleville, and rental houses
Apartments for rent and Readington rental houses
House rentals in Madison New Jersey, for rent by owner homes in Madison New Jersey, and vacation rentals in Madison New Jersey
Lawrence New Jersey apartments for rent, vacation homes for rent by owner, Lawrence rental home, and vacation rental in Lawrence
Rent houses in Waterford and Waterford rent houses
West New York New Jersey rental houses, apartment rentals in West New York, and rental homes
Houses for rent in Point Pleasant, apartments for rent in Point Pleasant New Jersey, rental apartment in Point Pleasant New Jersey, and holiday rentals in Point Pleasant New Jersey
Somerville rental home and rent houses in Somerville New Jersey
Rental apartment, real estate rentals Wanaque New Jersey, and house rentals Wanaque
Holiday rentals in Glassboro New Jersey, apartments for rent Glassboro, Glassboro houses for rent, and condo rentals
Home rentals in Highland Park and apartments for rent Highland Park
Winslow New Jersey apartments for rent, Winslow New Jersey vacation rentals, and apartments for rent
Vacation homes Wyckoff, Wyckoff New Jersey apartment rentals, houses for rent Wyckoff New Jersey, and Wyckoff New Jersey apartment rentals
Wyckoff New Jersey vacation homes for rent by owner and Wyckoff New Jersey vacation rentals
Houses for rent Haddonfield, Haddonfield real estate rentals, and rental houses in Haddonfield
Home rentals, Cinnaminson New Jersey condo rentals, Cinnaminson holiday rentals, and rental homes Cinnaminson New Jersey
West New York third party listing companies, real estate investors, rental owners, and property agents list house rentals in West New York New Jersey, West New York rental properties, and house rentals West New York New Jersey.
Move, observe, and discover short term rentals, Mahwah rental homes, and short term rentals.
Perceive and devise real estate rentals in Bridgeton United States and apartments for rent.
Learn, light upon, and originate short term rentals in Juliustown United States, rent house Juliustown, and bed and breakfast rentals in Juliustown.
Pilgrims, displaced persons, and explorers who are wishing to notice and identify or simply detect information can use our page.
Design and identify real estate rentals and house rentals Windsor.
Ferret out and ferret out Gloucester New Jersey condo rentals and Gloucester New Jersey vacation homes.
This extensive website, FRBO.com excepts city, area, block, and plot evidence, occasionally.
Hear, discover, and light upon Hudson vacation rental, rental homes in Hudson New Jersey, and rental apartment Hudson.
Come upon and notice Bayonne United States vacation rentals and homes for rent in Bayonne.
This site, For Rent By Owner (FRBO.com) does enclose another story sector lakefront, ski in/out, resort, and oceanfront villa and haciendas.
Ferret out, notice, and glimpse home rentals Passaic, Passaic holiday rentals, bed and breakfast rentals in Passaic, and short term rentals in Passaic New Jersey.
Identify, disclose, and notice Passaic apartment rentals and for rent by owner homes.
The West New York beach advertisements and hidden classified ads for these plot can be mapped.
Find out and ascertain Atlantic New Jersey bed and breakfast rentals, rental apartment in Atlantic New Jersey, and rental apartment in Atlantic.
Learn and design rent house in Ocean New Jersey, holiday rentals in Ocean New Jersey, Ocean New Jersey bed and breakfast rentals, and houses for rent Ocean.
Log online MLS and exotic classified ads rental houses Bergen New Jersey, Bergen New Jersey homes for rent, Bergen New Jersey vacation homes for rent by owner, and vacation homes for rent by owner Bergen New Jersey.
For Rent By Owner can take on and serve suburban listed properties, lakefront listed properties, beachfront advertisements, and rustic ads penthouse lists of marked properties, lakeside classifieds, decadent ads, and hidden classified advertisements to back your West New York New Jersey pilgrimage.
Glimpse, devise, and look up short term rentals, condos for rent in Summit United States, and real estate rentals Summit.
Come upon, contrive, and disclose holiday rentals, Warren holiday rentals, and rental homes in Warren.
You can ascertain and catch West New York New Jersey for rent by owner homes and house rentals in West New York.
Using our webpage, third party listing companies run down vacation home, houseboat, ranch, and lodge lists of marked properties.
Find out and catch Union New Jersey short term rentals, Union New Jersey rental houses, and real estate rentals Union New Jersey.
Habitants and brides who are ransacking West New York vacation rental and are trying to recognize West New York New Jersey for rent by owner homes and short term rentals in West New York can chase after FRBO.Com, For Rent By Owner, and our suburban indexes, mountain indexes, exclusive directories, and hidden listings.
|
|
