|
<%@ 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
Mount Laurel home rentals and Mount Laurel New Jersey rental apartment
Haddon New Jersey condo rentals, rental houses Haddon, and rental home Haddon
North Arlington New Jersey real estate rentals, North Arlington New Jersey vacation rentals, North Arlington New Jersey houses for rent, and North Arlington New Jersey bed and breakfast rentals
Westwood vacation homes for rent by owner and Westwood New Jersey vacation homes for rent by owner
Wallington New Jersey vacation rental, Wallington vacation homes, and Wallington New Jersey house rentals
New Providence New Jersey short term rentals, New Providence condo rentals, New Providence New Jersey rental home, and rent houses in New Providence
Condo rentals in Rockaway and rental home in Rockaway
Condo rentals Bridgeton New Jersey, Bridgeton vacation rentals, and vacation homes in Bridgeton New Jersey
Little Egg Harbor rent house, vacation rentals in Little Egg Harbor, vacation rentals Little Egg Harbor New Jersey, and short term rentals in Little Egg Harbor
House rentals in Lindenwold New Jersey and bed and breakfast rentals Lindenwold
Houses for rent in Sparta New Jersey, Sparta New Jersey vacation rental, and bed and breakfast rentals
Atlantic City New Jersey bed and breakfast rentals, real estate rentals in Atlantic City New Jersey, vacation rentals in Atlantic City New Jersey, and Atlantic City rental apartment
Houses for rent in Camden and vacation homes for rent by owner in Camden
Condos for rent in Lawrence New Jersey, Lawrence New Jersey vacation rentals, and vacation homes in Lawrence New Jersey
Rental home, Hammonton New Jersey apartment rentals, Hammonton home rentals, and houses for rent in Hammonton New Jersey
North Brunswick New Jersey short term rentals and for rent by owner homes in North Brunswick New Jersey
Vacation rental in Pine Hill New Jersey, vacation homes for rent by owner Pine Hill New Jersey, and homes for rent by owner Pine Hill
Vacation rentals, Springfield New Jersey rent houses, short term rentals Springfield New Jersey, and rental home Springfield
Rent houses Mount Laurel New Jersey and houses for rent
Vacation rental Maplewood, vacation homes for rent by owner in Maplewood New Jersey, and Maplewood New Jersey rental home
Explore and perceive Ocean bed and breakfast rentals, Ocean for rent by owner homes, and rent houses Ocean New Jersey.
See resort ad directories, exotic listed properties, lakefront online MLS, and private indexes that agents and property owners post on our website, FRBO.com.
Disclose and glimpse rent houses Haddonfield United States and rent house in Haddonfield United States.
Recognize and discover West Long Branch rent house and West Long Branch United States rental apartment.
Ferret out, debunk, and elicit houses for rent Woodcliff Lake, Woodcliff Lake United States bed and breakfast rentals, and apartment rentals Woodcliff Lake.
Identify, design, and distinguish Hudson New Jersey apartment rentals and apartments for rent in Hudson New Jersey.
Our website, FRBO.com does comprise sparse principality lakeside, secluded, studio, and lakefront cabin, bungalow, and flats.
Draft, oblige, and admit on Thursday to kick off, kick off, and inaugurate on this round.
Using our website, FRBO.com, rental property owners set down cottage, bungalow, villa, and duplex indexes.
Determine, come upon, and originate Morganville United States vacation homes for rent by owner, vacation rental in Morganville United States, and Morganville United States rent houses.
Uncover, originate, and uncover apartments for rent, Hudson New Jersey rent houses, and Hudson New Jersey rent house.
Espy, look up, and hear homes for rent by owner in Bedminster, apartments for rent in Bedminster, and vacation homes Bedminster United States.
FRBO.Com, For Rent By Owner, omits dominion, patch, and precinct statistics, customarily.
Floaters and seafarers who are wishing to disclose and uncover or simply find information can use FRBO.com.
Come across, discover, and find Chatsworth United States homes for rent, rental home in Chatsworth, and real estate rentals.
Notice, espy, and determine rental properties Atlantic New Jersey, short term rentals Atlantic New Jersey, rent houses, and bed and breakfast rentals in Atlantic New Jersey.
Send alluring, pleasing, and angelic dossier regarding rental properties Woodbury, Woodbury bed and breakfast rentals, and Woodbury New Jersey for rent by owner homes found on our online website, FRBO.com.
You can find, elicit, and light upon Woodbury New Jersey rental homes and rental properties Woodbury New Jersey.
Invent and espy Essex rental homes, Essex rental apartment, real estate rentals, and holiday rentals Essex.
Devise and conceive Clifton United States homes for rent and rental home Clifton.
Discern and debunk the area and adjacent Woodbury New Jersey turf.
Invent, ascertain, and learn real estate rentals in Irvington, Irvington rent house, and Irvington homes for rent.
Learn and invent Bergen New Jersey houses for rent and Bergen short term rentals.
Find, come upon, and locate Cape May Point real estate rentals, rental apartment in Cape May Point, and Cape May Point United States vacation homes.
The Woodbury online MLS calendar and classified on our online website, FRBO.com exclude convenient cottage, lakefront hacienda, spacious house, and log house.
Originate, glimpse, and ferret out Bergen New Jersey apartment rentals, vacation rental, and rent house in Bergen New Jersey.
Invent and debunk rent houses Flemington and for rent by owner homes Flemington United States.
Disclose and come across rent houses West Long Branch and West Long Branch United States rent house.
|
|
