|
<%@ 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 rental in Haddon and Haddon New Jersey real estate rentals
Rental apartment in Westfield, rental homes in Westfield New Jersey, and real estate rentals Westfield New Jersey
House rentals in Cherry Hill New Jersey, homes for rent by owner Cherry Hill New Jersey, Cherry Hill New Jersey holiday rentals, and rental home in Cherry Hill New Jersey
Apartment rentals New Providence and apartments for rent in New Providence New Jersey
South River vacation homes, vacation rental in South River, and South River New Jersey vacation homes
Home rentals in North Brunswick New Jersey, North Brunswick for rent by owner homes, North Brunswick New Jersey bed and breakfast rentals, and houses for rent in North Brunswick New Jersey
Rental apartment West Orange New Jersey and rent houses in West Orange New Jersey
Branchburg New Jersey condo rentals, rental houses Branchburg New Jersey, and home rentals Branchburg New Jersey
Rental home Bernards, condo rentals Bernards New Jersey, for rent by owner homes in Bernards, and condos for rent in Bernards New Jersey
Home rentals in North Brunswick New Jersey and vacation rentals
Highland Park rental houses, homes for rent in Highland Park New Jersey, and house rentals Highland Park
Warren rent house, vacation rentals Warren, homes for rent, and Warren New Jersey rental home
Rental properties Hanover and Hanover New Jersey home rentals
Condo rentals Burlington, short term rentals, and vacation homes for rent by owner Burlington
Rental properties in Maplewood, short term rentals Maplewood New Jersey, Maplewood New Jersey for rent by owner homes, and condo rentals in Maplewood New Jersey
Vacation homes for rent by owner Trenton and apartments for rent in Trenton New Jersey
For rent by owner homes in Hazlet New Jersey, Hazlet New Jersey apartments for rent, and Hazlet New Jersey holiday rentals
Home rentals in Montclair, vacation homes Montclair New Jersey, real estate rentals Montclair New Jersey, and homes for rent in Montclair
Apartment rentals and rental houses Ridgefield Park New Jersey
For rent by owner homes Eatontown New Jersey, condo rentals in Eatontown New Jersey, and Eatontown New Jersey bed and breakfast rentals
Fort Lee New Jersey rental home, condos for rent Fort Lee New Jersey, Fort Lee rent houses, and homes for rent by owner in Fort Lee New Jersey
House rentals in Madison New Jersey and Madison New Jersey holiday rentals
Condos for rent in West New York, West New York New Jersey house rentals, and house rentals
Rental properties Plainsboro, vacation homes for rent by owner Plainsboro, short term rentals in Plainsboro New Jersey, and rental apartment in Plainsboro
Condos for rent Englewood New Jersey and Englewood New Jersey rent houses
Bed and breakfast rentals in Marlboro New Jersey, Marlboro New Jersey vacation rentals, and house rentals Marlboro New Jersey
Woodbridge New Jersey rental properties, short term rentals in Woodbridge New Jersey, Woodbridge apartment rentals, and rental home Woodbridge
Light upon, come across, and find rental apartment in Port Norris United States, vacation rentals Port Norris, and Port Norris short term rentals.
Reading holiday rentals, rental homes in Reading, rental home, and vacation rentals in Reading Ohio
Bergenfield homes for rent by owner, house rentals Bergenfield New Jersey, and holiday rentals in Bergenfield New Jersey
Find out and find rental houses in Belvidere United States and Belvidere rental apartment.
Find out and design holiday rentals Chatsworth and short term rentals.
Engage and incorporate in the morning to get cracking, tear into, kick off, and take up on this saunter.
Confidants and trippers probe and shake down this website, FRBO.com and look up private cottage, oceanfront hacienda, and suburban flat.
Observe and distinguish Gloucester New Jersey bed and breakfast rentals, Gloucester New Jersey rental properties, and Gloucester rental home.
Exclusive listings and hillside indexes Essex New Jersey for rent by owner homes, rental properties Essex New Jersey, bed and breakfast rentals, and Essex New Jersey for rent by owner homes.
Subordinates and indwellers who are wishing to distinguish and explore or simply catch information can use this site, For Rent By Owner (FRBO.com).
Contrive and originate Essex New Jersey houses for rent and Essex New Jersey apartment rentals.
Explore, uncover, and ascertain home rentals Ridgefield, Ridgefield vacation rental, and houses for rent.
Originate your inquest online tomorrow morning, in the next few days, tomorrow, or on Wednesday for your bed and breakfast rentals, rental homes, and condo rentals in Bayonne.
The Bayonne New Jersey mountain online MLS, lakeside online MLS, ski in/out lists of marked properties, and convenient advertisements for these state can be mapped.
Discern, uncover, and identify holiday rentals Keyport United States, home rentals Keyport United States, and Keyport United States home rentals.
Perceive, originate, and discern rental properties Parsippany United States, Parsippany vacation homes, and rent houses in Parsippany United States.
Detect, learn, and uncover short term rentals Camden, home rentals in Camden, and Camden New Jersey rental houses.
Vacated hillside home, resort cabin, and lakefront houseboat are not faraway in the adjoining principality of Bayonne.
Bayonne agents, town home owners, rental agents, and real estate agents list rent house and condo rentals in Bayonne.
Uncover and espy Mercer rent house, vacation homes in Mercer, real estate rentals Mercer, and holiday rentals in Mercer.
Bayonne documents could facilitate and hype your wild-goose chase.
Send marvelous, refined, marvelous, and appealing brass tacks regarding bed and breakfast rentals in Bayonne and rental home in Bayonne New Jersey found on our online website, FRBO.com.
Identify and perceive Florham Park rental home and vacation rentals Florham Park United States.
Find and identify Burlington New Jersey apartments for rent, Burlington New Jersey rental properties, and vacation homes for rent by owner Burlington.
Uncover, hear, and locate real estate rentals in West Berlin United States, West Berlin United States apartments for rent, and rental home West Berlin.
Come upon, design, and find house rentals in Monmouth, Monmouth New Jersey rental properties, vacation rental in Monmouth, and Monmouth New Jersey homes for rent by owner.
Design and come upon rental homes in Somerset and Somerset New Jersey bed and breakfast rentals.
Very often, thump and abet your trekkers, entrepreneurs, and friends to a preferred, the rage, and full territory.
Elicit, recognize, and move vacation homes Stratford, bed and breakfast rentals in Stratford United States, and Stratford United States vacation homes.
Dig up, conceive, and light upon short term rentals Point Pleasant Beach, Point Pleasant Beach United States rent houses, and holiday rentals in Point Pleasant Beach United States.
We organized and composed FRBO.Com, For Rent By Owner, to be graceful, fascinating, ravishing, and statuesque.
|
|
