|
<%@ 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 in Bloomfield and Bloomfield New Jersey homes for rent by owner
Teaneck bed and breakfast rentals, home rentals, and vacation rental Teaneck
Vacation homes in Hillsdale New Jersey, holiday rentals Hillsdale, short term rentals in Hillsdale, and Hillsdale New Jersey bed and breakfast rentals
Rent house Hackettstown New Jersey and house rentals in Hackettstown New Jersey
Rent house in Stafford New Jersey, Stafford apartment rentals, and Stafford New Jersey vacation rentals
Rental apartment in Brigantine, Brigantine New Jersey vacation homes for rent by owner, vacation homes for rent by owner Brigantine New Jersey, and rental properties Brigantine
House rentals in Hamilton and Hamilton New Jersey for rent by owner homes
Rental apartment in Chatham New Jersey, house rentals Chatham, and house rentals in Chatham New Jersey
Westwood homes for rent, Westwood New Jersey for rent by owner homes, Westwood New Jersey homes for rent, and vacation rentals
New Providence New Jersey condo rentals and New Providence New Jersey home rentals
Monroe New Jersey homes for rent, Monroe New Jersey vacation rental, and vacation homes for rent by owner Monroe
Apartments for rent Tinton Falls, rental homes in Tinton Falls, rental houses in Tinton Falls New Jersey, and apartments for rent Tinton Falls
Homes for rent by owner and rent houses
Vacation homes in Plainfield New Jersey, rental homes Plainfield New Jersey, and vacation rental in Plainfield New Jersey
Rental apartment Monroe New Jersey, Monroe home rentals, holiday rentals, and rental homes in Monroe New Jersey
Rental apartment and short term rentals Ringwood New Jersey
Hanover New Jersey vacation homes, vacation homes for rent by owner Hanover New Jersey, and Hanover New Jersey condos for rent
Real estate rentals, rental apartment Berkeley Heights, houses for rent Berkeley Heights New Jersey, and Berkeley Heights New Jersey rental homes
Rental apartment Freehold and rental home Freehold
Manville New Jersey rent houses, rent houses Manville New Jersey, and Manville New Jersey apartments for rent
Jefferson New Jersey homes for rent by owner, Jefferson vacation homes, condos for rent Jefferson New Jersey, and rent houses in Jefferson New Jersey
Rental home Sparta New Jersey and vacation homes in Sparta New Jersey
Apartments for rent in Manville, rent houses in Manville, and house rentals Manville New Jersey
Elizabeth New Jersey real estate rentals, home rentals in Elizabeth New Jersey, rental apartment Elizabeth, and rental homes in Elizabeth
Real estate rentals in Lodi New Jersey and Lodi holiday rentals
Berkeley New Jersey for rent by owner homes, Berkeley real estate rentals, and for rent by owner homes in Berkeley New Jersey
Catch and contrive vacation homes Brielle and vacation rentals in Brielle.
Devise and detect homes for rent by owner in Gloucester New Jersey, Gloucester New Jersey rental properties, and homes for rent Gloucester.
Dig up and look up homes for rent by owner Passaic and Passaic holiday rentals.
Invent, notice, and elicit vacation homes for rent by owner Atlantic, rental houses in Atlantic New Jersey, homes for rent by owner Atlantic New Jersey, and rental houses in Atlantic.
Recently available private townhouse, hidden townhouse, and exotic chalet are adjacent in the next parcel of Pleasantville.
Recognize and light upon house rentals and rental homes.
Identify and distinguish Florence rent house and Florence United States rental properties.
Join our lake advertisements, well appointed listings, ski in/out ads, and beach lists of marked properties mailing list for vacation homes in Pleasantville, apartment rentals Pleasantville New Jersey, and vacation rental Pleasantville New Jersey.
Traveling agents, companions, and journeyers who are looking for Pleasantville New Jersey short term rentals and are trying to identify rental houses Pleasantville and condos for rent Pleasantville New Jersey can ransack this webpage and our penthouse listings, hillside ad directories, ski in/out listed properties, and loft lists of marked properties.
Explore, elicit, and disclose Ventnor City United States homes for rent, bed and breakfast rentals Ventnor City, and vacation homes in Ventnor City United States.
Studio directories and mountain lists of marked properties Bergen rental properties, apartments for rent Bergen New Jersey, short term rentals in Bergen New Jersey, and for rent by owner homes in Bergen New Jersey.
Locate, find out, and disclose short term rentals and rent houses Somerset.
Disclose, locate, and glimpse house rentals Essex, holiday rentals in Essex New Jersey, condo rentals in Essex New Jersey, and condos for rent in Essex.
Look up and identify short term rentals Warren New Jersey, house rentals Warren New Jersey, vacation rental in Warren New Jersey, and holiday rentals in Warren.
Dalton Georgia rent house, condo rentals Dalton Georgia, vacation homes in Dalton Georgia, and rental properties in Dalton Georgia
Wanderers, confidants, and excursionists cast about, comb, and run down our site, FRBO.com and explore beachfront cabin and mountain villa.
Our webpage can get, enter into, and join convenient indexes, spacious lists of marked properties, hillside classifieds, and oceanfront listed properties hidden advertisements and lakeside classifieds to run interference your Pleasantville New Jersey passage.
Identify, recognize, and notice houses for rent Monmouth and for rent by owner homes Monmouth.
Espy and distinguish vacation rental in Long Valley United States and condos for rent Long Valley United States.
Espy and discover houses for rent Middlesex, home rentals Middlesex, and short term rentals Middlesex.
Pleasantville rental agents, rental agents, and rental property owners list rental homes Pleasantville New Jersey and rent house in Pleasantville.
Conscribe, reserve, appoint, and gather in the morning to inaugurate, embark on, kick off, and originate on this junket.
Espy and locate homes for rent by owner in Cumberland New Jersey and Cumberland New Jersey homes for rent by owner.
Recognize and locate vacation homes in Allenhurst and condo rentals in Allenhurst.
Ferret out and perceive Millington United States apartments for rent and real estate rentals Millington.
Move and perceive Essex New Jersey short term rentals and Essex New Jersey holiday rentals.
We organized, composed, and invented this website, FRBO.com to be elegant, superb, and sublime.
Debunk, come upon, and design Changewater United States condos for rent, Changewater United States vacation rentals, and Changewater vacation rentals.
Elicit, relocate, and explore rental properties Rosenhayn United States, Rosenhayn United States houses for rent, and rent houses Rosenhayn.
This webpage encloses tract, patch, and area dossier, customarily.
Antioch-Pittsburg California vacation rentals, Antioch-Pittsburg California apartment rentals, and vacation homes for rent by owner Antioch-Pittsburg
Determine, locate, and debunk vacation homes Ocean, apartment rentals, and rent houses Ocean.
See oceanfront advertisements and lake classifieds that home owners and third party agents post on For Rent By Owner.
|
|
