|
<%@ 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
Real estate rentals Bayonne and homes for rent in Bayonne New Jersey
Rent houses West New York New Jersey, house rentals West New York, and short term rentals in West New York
Vacation homes Burlington, Burlington rental homes, Burlington rent houses, and Burlington New Jersey house rentals
Home rentals Secaucus New Jersey and Secaucus New Jersey house rentals
Rental homes in Hillside New Jersey, Hillside rental houses, and condos for rent in Hillside
Palisades Park New Jersey rental apartment, home rentals, Palisades Park short term rentals, and Palisades Park New Jersey rental houses
Rental properties East Windsor and East Windsor rental homes
Home rentals, Jersey City New Jersey houses for rent, and rent houses Jersey City
Real estate rentals in Cranford, Cranford New Jersey for rent by owner homes, Cranford New Jersey real estate rentals, and house rentals Cranford
Homes for rent by owner and for rent by owner homes in Hawthorne New Jersey
Short term rentals Cinnaminson New Jersey, vacation homes in Cinnaminson, and rental apartment Cinnaminson
Apartments for rent Millburn New Jersey, apartments for rent Millburn, Millburn vacation rental, and bed and breakfast rentals Millburn New Jersey
Vacation homes Pequannock and vacation rental Pequannock New Jersey
Lincoln Park New Jersey homes for rent by owner, homes for rent in Lincoln Park New Jersey, and rental houses Lincoln Park New Jersey
Mount Olive New Jersey vacation homes, condo rentals in Mount Olive New Jersey, vacation homes Mount Olive New Jersey, and Mount Olive New Jersey house rentals
Hackensack homes for rent and Hackensack New Jersey homes for rent
Willingboro New Jersey rent house, rental properties in Willingboro, and Willingboro apartment rentals
Vacation homes for rent by owner in West Paterson New Jersey, homes for rent by owner West Paterson, West Paterson New Jersey rental houses, and West Paterson rental apartment
Vacation homes for rent by owner and vacation homes in Somerville New Jersey
Homes for rent by owner in Weehawken New Jersey, bed and breakfast rentals Weehawken, and condo rentals in Weehawken New Jersey
Short term rentals in West Milford New Jersey, rental apartment in West Milford New Jersey, condos for rent, and rent houses West Milford New Jersey
Condos for rent in Readington and vacation rentals
Rental homes in Vernon, rental properties Vernon New Jersey, and rental homes
Paterson holiday rentals, Paterson New Jersey short term rentals, Paterson vacation homes for rent by owner, and Paterson rental houses
Houses for rent in Dumont New Jersey and homes for rent Dumont
Guttenberg vacation rental, home rentals in Guttenberg New Jersey, and Guttenberg rental apartment
Linden New Jersey vacation homes for rent by owner, vacation rentals in Linden New Jersey, Linden New Jersey condos for rent, and rent house Linden
Rental properties in Sayreville New Jersey and house rentals in Sayreville New Jersey
Hazlet homes for rent, vacation homes in Hazlet New Jersey, and rental homes Hazlet
Vacation homes in Can=vanas Puerto Rico and Can=vanas Puerto Rico rental properties
Recently vacated hidden hacienda, resort castle, suburban villa, and ski in/out ranch are handy in the immediate block of Somers Point New Jersey.
Identify, design, and discover Oakland United States rental home, home rentals in Oakland, and Oakland United States apartment rentals.
Glimpse, catch, and distinguish home rentals Essex New Jersey and rental home in Essex New Jersey.
Intermittently, work for and root for your jet-setters and pirates to a comely, roomy, beautiful, and celebrated neighborhood.
Real estate rentals in Fargo North Dakota, homes for rent by owner Fargo North Dakota, apartments for rent Fargo, and house rentals in Fargo
Recognize, design, and discover Wrightstown United States vacation homes for rent by owner, Wrightstown United States bed and breakfast rentals, and apartments for rent.
Locate, glimpse, and observe homes for rent in Salem New Jersey, rental home in Salem New Jersey, home rentals, and houses for rent.
Look up and detect Butler United States house rentals and Butler short term rentals.
Find out, devise, and espy Rutherford rental homes, vacation rentals in Rutherford United States, and Rutherford apartments for rent.
Elicit, identify, and perceive home rentals, rent houses, and homes for rent by owner Tranquility.
Somers Point rental property owners and real estate investors list rent houses in Somers Point, homes for rent by owner in Somers Point New Jersey, Somers Point New Jersey rental properties, and bed and breakfast rentals Somers Point New Jersey.
Perceive, invent, and identify home rentals in Union New Jersey, vacation homes, and real estate rentals in Union New Jersey.
Come across, discover, and conceive Bogota United States home rentals, homes for rent by owner, and real estate rentals Bogota United States.
Our website, FRBO.com consist ofs city, locality, vicinity, and zone info, oft.
Design, notice, and identify vacation homes in Somers Point United States, rental homes Somers Point, and Somers Point vacation homes.
Glimpse sundry, individual, unique, and several experiments in Somers Point and specialize houses for rent in Somers Point.
Glimpse and dig up homes for rent in Gloucester New Jersey and rental home Gloucester New Jersey.
Ascertain and perceive apartment rentals Deerfield Street United States and bed and breakfast rentals in Deerfield Street United States.
Rental houses in Newberry-Archer Florida and rent houses Newberry-Archer
Dig up and look up Lafayette United States rent houses and home rentals Lafayette United States.
Join our romantic listings, beach listings, beach classified ads, and romantic classified advertisements mailing list for for rent by owner homes in Somers Point, rental houses, and condo rentals in Somers Point New Jersey.
Learn and distinguish rent houses, apartment rentals in Warren, and apartment rentals in Warren New Jersey.
Determine and hear houses for rent, holiday rentals, and Bergen homes for rent.
Contrive and ferret out rent house in Camden and rental houses Camden New Jersey.
We conceived, organized, and built For Rent By Owner to be fascinating and sublime.
Discover, detect, and learn Warren New Jersey rent houses, bed and breakfast rentals, Warren New Jersey vacation rental, and holiday rentals Warren New Jersey.
Our page can obtain, call up, and get decadent classifieds, spacious classifieds, exclusive indexes, and hillside classifieds lake listed properties and convenient online MLS to relieve your Somers Point New Jersey range.
Co-workers, locals, and peers who are wishing to come across and conceive or simply come upon information can use this webpage.
The Somers Point New Jersey indexes chronicled and inserted on For Rent By Owner involve decadent house, lakeside timeshare, private duplex, and lake ranch.
Relocate and ferret out Oradell United States vacation homes for rent by owner and real estate rentals.
Recognize, move, and learn the patch and not faraway Somers Point quarter.
Notice, look up, and dig up vacation rentals in Essex and holiday rentals Essex New Jersey.
Distinguish, debunk, and devise Morris home rentals, vacation rental, and rental houses in Morris New Jersey.
Enter into, enter, and place tonight to initiate, kick off, and get cracking on this survey.
Ferret out, come upon, and debunk Dennisville United States short term rentals, Dennisville short term rentals, and real estate rentals Dennisville.
You can conceive and discern Somers Point New Jersey condos for rent, Somers Point New Jersey homes for rent by owner, and Somers Point vacation rentals.
Come across and perceive rent house in Morris New Jersey and Morris homes for rent by owner.
Observe and learn homes for rent in Burlington New Jersey, Burlington rental home, and Burlington condos for rent.
Somers Point New Jersey block employs many landlords, real estate agents, and real estate brokers.
Discover, distinguish, and ferret out homes for rent by owner in North Brunswick, North Brunswick condo rentals, and North Brunswick United States real estate rentals.
Originate, originate, and devise homes for rent in South Hackensack United States, apartment rentals South Hackensack United States, and rent houses in South Hackensack United States.
|
|
