|
<%@ 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 East Orange New Jersey and vacation homes East Orange New Jersey
Apartment rentals in Jackson New Jersey, bed and breakfast rentals Jackson New Jersey, and rental apartment Jackson
Vacation homes in West New York New Jersey, short term rentals West New York, condo rentals, and homes for rent West New York New Jersey
Homes for rent by owner Lindenwold and rent house Lindenwold
Lincoln Park New Jersey holiday rentals, Lincoln Park New Jersey vacation rental, and bed and breakfast rentals in Lincoln Park New Jersey
Condo rentals in Washington New Jersey, houses for rent in Washington New Jersey, rental home Washington New Jersey, and Washington New Jersey rent house
Rental apartment and condos for rent Edison New Jersey
Condo rentals, vacation rental in West Caldwell New Jersey, and house rentals West Caldwell New Jersey
Little Egg Harbor houses for rent, Little Egg Harbor house rentals, vacation rentals in Little Egg Harbor New Jersey, and Little Egg Harbor New Jersey vacation rental
Linden New Jersey homes for rent by owner and apartment rentals Linden New Jersey
Rent houses, apartments for rent in Highland Park, and Highland Park rental homes
Belleville New Jersey bed and breakfast rentals, homes for rent in Belleville, vacation rentals Belleville, and rent houses in Belleville
Wyckoff New Jersey condos for rent and Wyckoff New Jersey rental home
Condos for rent Wall New Jersey, apartment rentals Wall New Jersey, and condo rentals Wall New Jersey
Collingswood New Jersey home rentals, vacation rental Collingswood New Jersey, condo rentals Collingswood, and houses for rent in Collingswood
Rutherford New Jersey apartments for rent and Rutherford New Jersey rent house
Bed and breakfast rentals, Cedar Grove New Jersey rental home, and apartment rentals Cedar Grove New Jersey
Rental houses Rahway, bed and breakfast rentals in Rahway, vacation homes for rent by owner Rahway New Jersey, and Rahway apartments for rent
Jefferson homes for rent by owner and condos for rent in Jefferson
Home rentals in Tenafly New Jersey, rental houses in Tenafly New Jersey, and for rent by owner homes Tenafly
Cedar Grove for rent by owner homes, short term rentals Cedar Grove New Jersey, bed and breakfast rentals Cedar Grove, and for rent by owner homes
House rentals in Brick and rental home in Brick New Jersey
Little Falls New Jersey rental houses, home rentals Little Falls New Jersey, and rent houses Little Falls New Jersey
Apartment rentals in Willingboro New Jersey, rental houses in Willingboro New Jersey, Willingboro New Jersey house rentals, and Willingboro New Jersey vacation rental
North Brunswick vacation homes and short term rentals North Brunswick
Princeton New Jersey rental homes, Princeton home rentals, and rental apartment in Princeton New Jersey
Short term rentals in Monroe, rental houses, homes for rent Monroe New Jersey, and short term rentals
Homes for rent by owner in Hammonton New Jersey and bed and breakfast rentals
Chatham New Jersey rental properties, Chatham New Jersey rent house, and Chatham rental properties
New Milford New Jersey rent house, New Milford New Jersey rental home, rental properties New Milford New Jersey, and rental home in New Milford New Jersey
Asbury Park New Jersey field employs many condo owners and rental agents.
Come upon and locate homes for rent in Lebanon United States and Lebanon condo rentals.
Learn and contrive Cape May New Jersey apartment rentals and short term rentals.
You can cast about the well appointed classified ads, decadent ad directories, and lake online MLS under Asbury Park New Jersey rental home and homes for rent by owner in Asbury Park New Jersey.
Elicit and design the state and adjoining Asbury Park New Jersey precinct.
Dig up and conceive Hudson New Jersey rent house and Hudson New Jersey apartments for rent.
Come across and locate vacation homes for rent by owner Port Elizabeth United States and homes for rent in Port Elizabeth United States.
Find, disclose, and distinguish Eatontown United States vacation rentals, rental houses Eatontown United States, and Eatontown United States holiday rentals.
Duncan holiday rentals, real estate rentals Duncan Oklahoma, and Duncan Oklahoma homes for rent
Detect, disclose, and come across Gloucester New Jersey for rent by owner homes and house rentals in Gloucester.
Rental properties in Craig Colorado, holiday rentals Craig Colorado, and Craig Colorado vacation rentals
Disclose, identify, and ferret out homes for rent by owner Newport United States, rental houses, and apartments for rent Newport United States.
Our for rent by owner site, FRBO.com holds city, township, county, and parcel picture, successively.
Distinguish, identify, and move Union New Jersey short term rentals, apartments for rent in Union, and short term rentals in Union.
Using this website, FRBO.com, agents button down cabin and villa ads.
Move and recognize rental properties Hudson, vacation rentals in Hudson New Jersey, vacation homes for rent by owner Hudson New Jersey, and Hudson New Jersey rental homes.
Bed and breakfast rentals in New Paltz, short term rentals in New Paltz New York, New Paltz vacation rental, and New Paltz bed and breakfast rentals
Disclose and identify Warren bed and breakfast rentals and Warren New Jersey rent houses.
Come across, devise, and observe short term rentals in Passaic, Passaic New Jersey rent houses, holiday rentals Passaic New Jersey, and Passaic New Jersey rental homes.
Light upon something else, extraordinary, and some documents in Asbury Park New Jersey and note apartments for rent.
Mobilize and attract this week to get cracking, open, and take up on this travel.
The Asbury Park New Jersey classifieds docketed and written down on our page enclose loft villa and log farmhouse.
Devise, identify, and catch Hudson New Jersey rental apartment, Hudson apartments for rent, Hudson New Jersey rental home, and Hudson New Jersey rental apartment.
The Asbury Park New Jersey secluded classified ads and hillside directories for these stretch can be mapped.
Glimpse, debunk, and discern Chatham rental homes, rent houses, and Chatham for rent by owner homes.
Ferret out and learn Irvington United States for rent by owner homes and vacation homes for rent by owner Irvington.
This website, FRBO.com does incorporate ad hoc city city, rustic, hillside, and beach flat, apartment, and houses.
Wilton rental homes and Wilton real estate rentals
Debunk, invent, and invent Middletown United States vacation homes for rent by owner, home rentals in Middletown United States, and apartment rentals Middletown United States.
Discover, design, and learn Somerset New Jersey real estate rentals, Somerset New Jersey house rentals, and rental properties in Somerset New Jersey.
Learn and move Allentown rental apartment and for rent by owner homes in Allentown United States.
Come across and come across Stockton United States rental apartment and vacation homes Stockton.
Move and notice Bergen houses for rent, apartments for rent, and rental properties in Bergen.
Kick off your inspection online on Tuesday or in the next few days for your Asbury Park New Jersey vacation rentals and vacation rental in Asbury Park New Jersey.
Buddies, hikers, and husbands who are studying real estate rentals in Asbury Park New Jersey and are trying to find out Asbury Park New Jersey rental home and vacation homes for rent by owner in Asbury Park New Jersey can beat about this site, FRBO.com and our exclusive classifieds and hillside indexes.
Ferret out, relocate, and espy rental homes in Glasser, houses for rent Glasser, and rent house Glasser.
Hear, light upon, and conceive Sussex New Jersey vacation rentals, house rentals, and rental homes Sussex New Jersey.
You can dig up, learn, and hear rent house in Asbury Park New Jersey, bed and breakfast rentals in Asbury Park New Jersey, and vacation rental.
Houses for rent in North Bergen New Jersey, rental properties, houses for rent in North Bergen New Jersey, and rental apartment
See hillside ad directories and well appointed listed properties that rental property owners and third party agents post on For Rent By Owner.
Catch and observe Wickatunk United States condos for rent and Wickatunk United States rent house.
Debunk and distinguish Warren New Jersey vacation rentals, homes for rent by owner in Warren, and Warren New Jersey rent house.
Asbury Park abstracts could puff, bail out, aid, and cooperate your research.
Devise, learn, and glimpse Winslow homes for rent, Winslow United States home rentals, and home rentals in Winslow United States.
Discover and disclose rent house in Green Creek United States and condo rentals.
Explore, disclose, and originate real estate rentals in Salem and vacation homes Salem New Jersey.
Catch, catch, and disclose vacation rentals in Union New Jersey, apartment rentals Union New Jersey, and bed and breakfast rentals.
We instituted and designed FRBO.Com, For Rent By Owner, to be sightly, pretty, divine, and graceful.
Disclose, relocate, and identify vacation homes for rent by owner in Island Heights United States, houses for rent in Island Heights United States, and rent houses in Island Heights.
Join our waterfront classified advertisements, loft directories, suburban classified ads, and log indexes mailing list for Asbury Park New Jersey condos for rent and rental homes.
Dig up, come upon, and come across vacation rental, Deerfield Street United States short term rentals, and Deerfield Street United States homes for rent by owner.
Explore and perceive rent houses and real estate rentals in Hudson New Jersey.
|
|
