|
<%@ 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
For rent by owner homes and apartment rentals Little Egg Harbor New Jersey
Rental apartment in Medford New Jersey, Medford rent houses, and rent house Medford
South Plainfield New Jersey bed and breakfast rentals, South Plainfield New Jersey rental properties, apartment rentals in South Plainfield, and condo rentals South Plainfield
Hammonton New Jersey vacation rentals and vacation rentals in Hammonton
For rent by owner homes in West Orange, apartment rentals West Orange, and house rentals West Orange New Jersey
North Arlington New Jersey rental properties, rental houses, apartment rentals in North Arlington, and North Arlington New Jersey apartments for rent
Rental properties in Pemberton New Jersey and Pemberton rental apartment
Houses for rent in Roxbury New Jersey, houses for rent, and condo rentals Roxbury
Vacation homes for rent by owner Chatham, vacation homes Chatham New Jersey, short term rentals in Chatham New Jersey, and Chatham New Jersey short term rentals
Hamilton apartments for rent and vacation rentals in Hamilton New Jersey
Vacation homes for rent by owner in Carteret New Jersey, house rentals in Carteret New Jersey, and apartments for rent
Real estate rentals, rental homes Old Bridge, rental homes in Old Bridge New Jersey, and Old Bridge New Jersey vacation rentals
Condo rentals Middle New Jersey and house rentals Middle
House rentals in Chatham New Jersey, rental home Chatham, and home rentals
Home rentals in Long Branch New Jersey, Long Branch New Jersey rental home, Long Branch rental properties, and rent houses in Long Branch
Vacation homes for rent by owner in West Windsor and rental properties in West Windsor
For rent by owner homes, Cedar Grove New Jersey rent house, and Cedar Grove New Jersey vacation homes for rent by owner
Condo rentals in Newark New Jersey, rental home in Newark New Jersey, Newark New Jersey apartment rentals, and for rent by owner homes Newark New Jersey
Belleville rental properties and houses for rent in Belleville New Jersey
Rockaway rent house, vacation rental in Rockaway New Jersey, and rent house
Bed and breakfast rentals Gloucester City New Jersey, holiday rentals Gloucester City New Jersey, Gloucester City holiday rentals, and Gloucester City vacation rental
Rental home in Hopatcong New Jersey and Hopatcong rental apartment
Discover, ferret out, and discern short term rentals in Harrington Park United States, Harrington Park real estate rentals, and rent houses Harrington Park.
Discover, identify, and find out Monmouth New Jersey vacation homes, rental properties Monmouth, and vacation rental in Monmouth New Jersey.
Discern, contrive, and light upon Salem vacation rentals, Salem New Jersey rental home, and rental homes Salem New Jersey.
Hear and look up Liberty Corner United States house rentals and Liberty Corner United States bed and breakfast rentals.
Come upon and relocate apartments for rent in Bergen New Jersey, vacation rentals in Bergen, and rental apartment in Bergen New Jersey.
Jump into your perquisition online on Friday, on Friday, or day after tomorrow for your Jersey City rental houses and Jersey City New Jersey homes for rent by owner.
Notice and originate apartments for rent in Oceanport United States and real estate rentals in Oceanport United States.
The Jersey City New Jersey city ad directories and log directories for these can be mapped.
See well appointed classified ads, beach advertisements, and suburban classified ads that land owners and property agents post on this site, For Rent By Owner (FRBO.com).
This site, For Rent By Owner (FRBO.com) can inscribe, list, induct, and mobilize lake listings, hillside online MLS, and lakefront lists of marked properties lake advertisements, beach lists of marked properties, spacious classified advertisements, and exclusive lists of marked properties to ride shotgun your Jersey City New Jersey traveling.
Recognize and come upon Hunterdon vacation rentals, Hunterdon New Jersey short term rentals, Hunterdon New Jersey rent houses, and Hunterdon holiday rentals.
Invent and originate New Brunswick United States for rent by owner homes and bed and breakfast rentals New Brunswick.
Locate, identify, and design short term rentals in Warren and bed and breakfast rentals Warren.
Determine, recognize, and detect Monmouth New Jersey rent houses, rental homes, homes for rent by owner Monmouth, and rental properties Monmouth.
Catch and light upon rental homes in Pequannock and short term rentals in Pequannock United States.
Find out and uncover vacation homes Morris New Jersey and holiday rentals Morris New Jersey.
Glimpse, elicit, and learn Burlington New Jersey homes for rent, rental apartment in Burlington, and Burlington New Jersey real estate rentals.
Perceive and determine Basking Ridge rental apartment and Basking Ridge vacation homes.
Devise, identify, and design Augusta United States short term rentals, Augusta United States vacation homes for rent by owner, and house rentals Augusta United States.
Determine, dig up, and locate rental homes, home rentals Swedesboro United States, and homes for rent by owner in Swedesboro United States.
Studio ads and lakefront indexes bed and breakfast rentals in Hudson New Jersey, rental home in Hudson, rent houses in Hudson New Jersey, and rental houses in Hudson.
Bedmates and roommates who are probing vacation homes for rent by owner in Jersey City New Jersey and are trying to disclose vacation homes Jersey City, Jersey City New Jersey bed and breakfast rentals, and Jersey City rent houses can scour our for rent by owner website and our spacious classifieds, loft lists of marked properties, lakefront listings, and hidden directories.
Send exquisite, fine, divine, and fascinating goods regarding Jersey City New Jersey rental apartment, vacation rentals in Jersey City New Jersey, and real estate rentals in Jersey City New Jersey found on this extensive website, FRBO.com.
Trippers and tenants who are wishing to debunk, discover, and conceive or simply elicit information can use this website, FRBO.com.
You can relocate, uncover, and detect Jersey City New Jersey rental apartment and rental homes in Jersey City.
Perceive and glimpse vacation rental and vacation homes in Augusta United States.
Locate, identify, and discover homes for rent by owner Lyons United States, Lyons apartment rentals, and house rentals Lyons United States.
Appoint, join, and secure in the morning to open, begin, and lead off on this junket.
Catch, relocate, and look up Salem New Jersey rent houses, bed and breakfast rentals, and Salem apartments for rent.
|
|
