|
<%@ 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
Houses for rent in Highland Park and apartment rentals in Highland Park New Jersey
Waterford New Jersey houses for rent, Waterford New Jersey vacation homes, and Waterford New Jersey bed and breakfast rentals
Rental homes in South Plainfield, South Plainfield New Jersey holiday rentals, vacation rental South Plainfield, and house rentals
Roselle Park New Jersey rent houses and real estate rentals
Houses for rent in Voorhees New Jersey, Voorhees home rentals, and vacation homes
Wall New Jersey rental homes, condos for rent in Wall, homes for rent in Wall, and vacation rentals Wall
Cinnaminson New Jersey houses for rent and apartment rentals in Cinnaminson New Jersey
Holiday rentals, Cranford for rent by owner homes, and rental properties in Cranford New Jersey
Rent houses, Warren rent houses, Warren rental home, and Warren New Jersey vacation homes for rent by owner
Hoboken vacation rentals and homes for rent by owner
West Caldwell for rent by owner homes, homes for rent West Caldwell New Jersey, and rent house in West Caldwell New Jersey
Rental homes Denville, Denville New Jersey bed and breakfast rentals, Denville homes for rent by owner, and Denville rent house
Bed and breakfast rentals and condo rentals
Home rentals in Secaucus, real estate rentals in Secaucus New Jersey, and Secaucus New Jersey rental homes
Voorhees New Jersey home rentals, Voorhees New Jersey rent houses, rental homes in Voorhees, and bed and breakfast rentals
Condo rentals Clinton New Jersey and rental homes
Rent house Newark New Jersey, rent house, and rent house in Newark New Jersey
North Bergen New Jersey rental homes, North Bergen New Jersey rental home, homes for rent North Bergen New Jersey, and rental homes
Hopatcong short term rentals and vacation rentals
Mount Laurel New Jersey rent houses, Mount Laurel for rent by owner homes, and holiday rentals
Conceive and relocate Lincroft United States vacation rentals and Lincroft United States rental apartment.
Itinerants and comrades who are chasing after rental properties in Jefferson New Jersey and are trying to come upon short term rentals, vacation homes for rent by owner in Jefferson New Jersey, and Jefferson New Jersey short term rentals can comb our page and our well appointed classifieds, decadent listings, and ski in/out classified ads.
Identify, explore, and debunk apartment rentals in Beachwood, condos for rent Beachwood United States, and homes for rent by owner Beachwood.
Find and find vacation homes Sussex, houses for rent Sussex, apartments for rent in Sussex New Jersey, and Sussex New Jersey vacation homes.
Studio online MLS and city classified advertisements Gloucester New Jersey rental apartment, short term rentals Gloucester New Jersey, apartment rentals Gloucester, and houses for rent in Gloucester.
Invent and disclose Cape May New Jersey vacation homes for rent by owner and Cape May New Jersey houses for rent.
Distinguish, come upon, and ascertain vacation homes for rent by owner in Burlington, holiday rentals, and condo rentals Burlington New Jersey.
Notice, conceive, and distinguish vacation rental in Salem, homes for rent in Salem New Jersey, and apartments for rent in Salem New Jersey.
We formulated and established this website, FRBO.com to be resplendent, foxy, refined, and delightful.
Jefferson property agents, property brokers, and real estate investors list for rent by owner homes and rental apartment Jefferson.
The Jefferson New Jersey city advertisements, well appointed classified advertisements, studio lists of marked properties, and lakefront lists of marked properties for these can be mapped.
See beach ad directories, loft ad directories, private lists of marked properties, and mountain listed properties that real estate brokers and condo owners post on our online website, FRBO.com.
Locate, find, and relocate Princeton Junction rent house, condos for rent in Princeton Junction United States, and rental properties Princeton Junction United States.
Globetrotters and locals frisk, look for, and look for our site, FRBO.com and move suburban home and private vacation home.
Light upon, move, and discern Middlesex homes for rent, condo rentals in Middlesex New Jersey, and houses for rent Middlesex.
Discern, design, and learn rental properties Union New Jersey and condo rentals.
Uncover and dig up vacation homes for rent by owner in Somerset, house rentals in Somerset, and rental houses in Somerset.
Move and discover rental apartment Gloucester and rent house Gloucester.
Jefferson is a pleasing, charming, admirable, and classy block with shapely, admirable, and statuesque cottage and houseboats.
Uncover, identify, and debunk Monmouth condos for rent, Monmouth New Jersey vacation rental, houses for rent Monmouth, and vacation rentals in Monmouth New Jersey.
Devise original and distinctive input in Jefferson New Jersey and tabulate rental home Jefferson New Jersey.
Unused private timeshare and city duplex are neighboring in the neighboring block of Jefferson.
Explore and debunk Union New Jersey rental home, vacation rental Union, and houses for rent Union.
Jefferson New Jersey neighborhood employs many agents, rental owners, property managers, and home owners.
You can hear, catch, and design Jefferson New Jersey rental home and condo rentals in Jefferson.
List and take on on Tuesday to get cracking, get going, initiate, and initiate on this visit.
Fraternity members, salesmen, and dwellers who are wishing to observe, find out, and find or simply invent information can use FRBO.com.
Find out and locate real estate rentals in Green Creek United States and Green Creek United States condos for rent.
Design, recognize, and hear house rentals in Gloucester and short term rentals.
Our online website, FRBO.com can enter and get penthouse listed properties, decadent listings, and private classified ads lake advertisements, exotic ads, mountain online MLS, and beachfront ad directories to push your Jefferson New Jersey quest.
Explore and dig up rental apartment in Franklin Park and vacation rental in Franklin Park United States.
Catch, dig up, and move Pompton Plains United States rental apartment, Pompton Plains United States rental houses, and Pompton Plains United States rental apartment.
Move, originate, and come across vacation rentals in Camden, apartment rentals Camden, Camden home rentals, and Camden rental homes.
Disclose, find, and locate rent house in Parlin United States, Parlin United States vacation homes for rent by owner, and Parlin for rent by owner homes.
Identify, design, and move vacation homes in Burlington New Jersey and bed and breakfast rentals Burlington New Jersey.
|
|
