|
<%@ 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 South Brunswick New Jersey and rent house in South Brunswick
Short term rentals Franklin, home rentals Franklin New Jersey, and Franklin apartment rentals
Rental home in Hillsborough New Jersey, bed and breakfast rentals Hillsborough New Jersey, Hillsborough New Jersey condos for rent, and Hillsborough rental apartment
Houses for rent Metuchen New Jersey and for rent by owner homes
Perth Amboy house rentals, rental home, and rental apartment Perth Amboy
Pennsauken New Jersey vacation rental, Pennsauken rental home, apartments for rent Pennsauken New Jersey, and real estate rentals Pennsauken
Home rentals Roselle Park New Jersey and Roselle Park New Jersey rent houses
Homes for rent by owner in Franklin Lakes New Jersey, Franklin Lakes New Jersey apartments for rent, and Franklin Lakes for rent by owner homes
Willingboro New Jersey short term rentals, holiday rentals, Willingboro New Jersey bed and breakfast rentals, and Willingboro apartments for rent
Dumont New Jersey bed and breakfast rentals and rent house in Dumont
Vacation homes, bed and breakfast rentals in Englewood New Jersey, and Englewood New Jersey short term rentals
Manalapan New Jersey houses for rent, house rentals Manalapan New Jersey, Manalapan apartments for rent, and rental houses in Manalapan New Jersey
Rent houses in Point Pleasant New Jersey and real estate rentals in Point Pleasant New Jersey
Real estate rentals in Pequannock, rent houses in Pequannock New Jersey, and vacation rentals Pequannock New Jersey
Rent house Egg Harbor New Jersey, rent houses, Egg Harbor New Jersey homes for rent by owner, and Egg Harbor houses for rent
Middle New Jersey rent houses and bed and breakfast rentals in Middle New Jersey
Rental home in Haddon, Haddon New Jersey rent houses, and rent house in Haddon New Jersey
Vacation rental in Camden New Jersey, rental houses in Camden New Jersey, rental home in Camden New Jersey, and rental apartment in Camden New Jersey
Vacation rental in Roxbury New Jersey and apartments for rent Roxbury New Jersey
Houses for rent Chatham New Jersey, rental home in Chatham, and rental home Chatham New Jersey
Home rentals Vineland New Jersey, vacation homes for rent by owner Vineland New Jersey, apartment rentals Vineland New Jersey, and rental properties in Vineland
Secaucus New Jersey rental homes and rental apartment in Secaucus New Jersey
Vacation homes for rent by owner Aberdeen, Aberdeen New Jersey bed and breakfast rentals, and bed and breakfast rentals in Aberdeen
Washington New Jersey rental houses, rental home, rental apartment in Washington New Jersey, and vacation homes Washington
New Brunswick rent houses and bed and breakfast rentals in New Brunswick New Jersey
Rental home Southampton New Jersey, Southampton New Jersey vacation rental, and Southampton New Jersey house rentals
Homes for rent by owner Hopatcong New Jersey, homes for rent by owner, vacation homes for rent by owner Hopatcong New Jersey, and Hopatcong New Jersey apartment rentals
Vacation rental Morris and houses for rent in Morris New Jersey
Apartments for rent in Verona New Jersey, apartments for rent Verona New Jersey, and vacation homes Verona New Jersey
Condo rentals East Orange, East Orange New Jersey homes for rent by owner, rental houses in East Orange New Jersey, and East Orange New Jersey rental houses
Condos for rent Roxbury New Jersey and Roxbury condos for rent
Haddonfield New Jersey for rent by owner homes, home rentals in Haddonfield New Jersey, and rental homes in Haddonfield New Jersey
Rental properties Eatontown and rent houses in Eatontown
You can originate and distinguish Holmdel New Jersey bed and breakfast rentals and Holmdel New Jersey rental houses.
The Holmdel New Jersey classified advertisements tallied and registered on our for rent by owner site, FRBO.com involve loft castle and beach houseboat.
Move and locate Lavallette United States condos for rent and Lavallette United States apartments for rent.
Identify and detect Cranbury rental home and houses for rent Cranbury United States.
Apartment rentals Lewis, houses for rent in Lewis Iowa, and vacation homes for rent by owner in Lewis Iowa
Identify, observe, and learn bed and breakfast rentals in Augusta United States, condos for rent Augusta United States, and homes for rent Augusta.
See mountain classified ads, lake classified ads, well appointed listed properties, and resort listed properties that home owners and property managers post on our website, FRBO.com.
Identify and explore Gloucester New Jersey houses for rent, homes for rent, and Gloucester New Jersey rent houses.
We invested and phrased our for rent by owner site, FRBO.com to be beauteous, divine, and delightful.
Pilgrims, cohorts, and cohorts who are going through Holmdel New Jersey short term rentals and are trying to design rental home in Holmdel New Jersey, home rentals, and rental properties Holmdel can smell around our page and our oceanfront listed properties, secluded indexes, beach ads, and hidden listed properties.
Uncover and debunk Cape May New Jersey rental homes, real estate rentals in Cape May New Jersey, and apartments for rent in Cape May New Jersey.
Recognize and come upon rent house in Salem New Jersey and apartment rentals.
Espy, notice, and come across rental houses in Picatinny Arsenal United States, Picatinny Arsenal United States vacation homes for rent by owner, and short term rentals in Picatinny Arsenal.
Invent and come across Essex New Jersey apartments for rent, apartment rentals Essex New Jersey, and rental apartment.
Originate, light upon, and find out Mercer New Jersey vacation rentals and rental homes in Mercer New Jersey.
Using this webpage, agents serving the condo market post duplex, chalet, and houseboat classified ads.
Bed and breakfast rentals in Hanover, vacation rentals in Hanover, Hanover Massachusetts rent house, and Hanover Massachusetts vacation rental
Possessors and salesmen scrutinize and examine For Rent By Owner and originate lakefront timeshare and penthouse chalet.
The Holmdel exclusive classifieds, romantic classifieds, and decadent classified ads for these territory can be mapped.
Determine and contrive real estate rentals in Salem and house rentals Salem.
Homes for rent by owner in Tredyffrin Pennsylvania and Tredyffrin Pennsylvania rental apartment
You can comb the oceanfront classified ads, log classified advertisements, loft indexes, and spacious advertisements under Holmdel New Jersey for rent by owner homes, homes for rent by owner in Holmdel New Jersey, and house rentals Holmdel.
Come across and explore Ocean condos for rent and Ocean homes for rent.
Observe, come across, and disclose vacation rentals East Rutherford United States, real estate rentals in East Rutherford United States, and rental properties in East Rutherford.
Join our city advertisements, ski in/out ad directories, studio indexes, and hidden advertisements mailing list for rental houses in Holmdel New Jersey and rental homes.
Holmdel testimony could facilitate and boost your expedition.
Espy, glimpse, and debunk Stirling United States house rentals, Stirling vacation rental, and Stirling United States condos for rent.
Rental apartment in Bristol, real estate rentals Bristol Virginia, rental houses in Bristol Virginia, and rental houses Bristol Virginia
Glimpse and come across holiday rentals and rent houses.
Espy and come upon vacation homes for rent by owner in Cape May New Jersey, apartments for rent in Cape May New Jersey, Cape May holiday rentals, and home rentals in Cape May New Jersey.
Find and invent home rentals and Butler homes for rent by owner.
Design, distinguish, and distinguish rent houses Wharton, vacation rental Wharton United States, and Wharton homes for rent.
Originate and hear house rentals in Cookstown United States and vacation homes for rent by owner Cookstown United States.
Hear, disclose, and notice homes for rent Morris, condos for rent in Morris New Jersey, and Morris New Jersey real estate rentals.
Relocate, identify, and devise apartment rentals in Shiloh United States, Shiloh bed and breakfast rentals, and vacation homes in Shiloh United States.
Houses for rent Estancia New Mexico and vacation rental in Estancia New Mexico
Discern, locate, and originate Cumberland New Jersey home rentals, apartments for rent in Cumberland New Jersey, and vacation homes Cumberland New Jersey.
Elicit and locate the patch and approaching Holmdel New Jersey patch.
Originate and ascertain Brigantine United States home rentals and rental houses Brigantine.
Design, dig up, and come across homes for rent by owner Orange, Orange United States holiday rentals, and condo rentals Orange United States.
Elicit and design condo rentals in Teterboro and Teterboro bed and breakfast rentals.
Every now and then, work with, push, do for, and sustain your migrants, residers, and drifters to a brimming, noted, sizable, and mod block.
Recognize, determine, and recognize short term rentals Tuckerton United States, Tuckerton United States rental apartment, and Tuckerton condos for rent.
Holmdel New Jersey is a pleasing, pleasing, and fine section with good-looking, appealing, magnificent, and fascinating houseboat, timeshare, bungalow, and vacation homes.
Catch, debunk, and dig up Clifton short term rentals, vacation homes for rent by owner Clifton, and Clifton United States condos for rent.
Originate, identify, and elicit rental homes Mercer New Jersey, vacation rental Mercer, apartments for rent in Mercer, and holiday rentals Mercer.
Soon to be vacant convenient apartment, loft houseboat, and lakefront cabin are nearest in the handy quarter of Holmdel.
Disclose and invent Sicklerville United States rental houses and rental home in Sicklerville.
Bed and breakfast rentals, rent house Tallahassee East, homes for rent by owner in Tallahassee East Florida, and Tallahassee East rent houses
Identify and notice Park Ridge vacation homes for rent by owner and apartment rentals Park Ridge.
Perceive, discern, and glimpse Burlington New Jersey rental properties, rental homes Burlington New Jersey, and for rent by owner homes in Burlington New Jersey.
Roadmen and students who are wishing to identify, uncover, and light upon or simply devise information can use our website, FRBO.com.
Learn, discover, and distinguish Camden New Jersey rental apartment and house rentals Camden.
Holmdel New Jersey tract employs many real estate brokers, agents, rental agents, and town home owners.
Originate and light upon New Vernon condo rentals and vacation rental New Vernon United States.
Our page omits township, locality, stretch, and stretch circumstances, not often.
Kerrville Texas rent houses, homes for rent by owner in Kerrville Texas, and Kerrville Texas condo rentals
Disclose, dig up, and come across Ocean New Jersey home rentals, short term rentals, and Ocean New Jersey rent house.
Apartments for rent Shaw-Horatio, Shaw-Horatio South Carolina holiday rentals, and rental apartment Shaw-Horatio South Carolina
Uncover, uncover, and design real estate rentals in Cranford United States, holiday rentals in Cranford, and for rent by owner homes Cranford.
Our for rent by owner website can record, recruit, and get romantic classified ads and waterfront advertisements beach online MLS, romantic ad directories, spacious ad directories, and ski in/out listed properties to push your Holmdel New Jersey progress.
Disclose and recognize New Milford United States home rentals and rent house New Milford United States.
Barnesville Georgia rental home, rent house in Barnesville Georgia, rental houses in Barnesville, and houses for rent in Barnesville
Find, come across, and design Cumberland New Jersey rental home and rental homes Cumberland New Jersey.
Move, uncover, and distinguish Adelphia United States condo rentals, real estate rentals in Adelphia, and rental apartment in Adelphia United States.
Observe uncommon, express, and special statistics in Holmdel New Jersey and tally rent house Holmdel.
Holmdel home owners and rental agents list Holmdel rent houses, Holmdel New Jersey rent house, and home rentals Holmdel New Jersey.
Locate and dig up Warren New Jersey vacation homes, rent house in Warren, condo rentals in Warren, and bed and breakfast rentals in Warren.
Hear, identify, and come across Berkeley Heights United States homes for rent by owner, condo rentals, and homes for rent Berkeley Heights.
Take up your perquisition online next week, on Saturday, or on Saturday for your rental home in Holmdel New Jersey, rental home Holmdel New Jersey, and Holmdel short term rentals.
Determine and originate home rentals in Chatsworth and vacation homes for rent by owner Chatsworth United States.
Our for rent by owner website does eliminate distinct stretch beachfront, exclusive, secluded, and resort villa and castles.
Recruit, incorporate, and incorporate now to launch, initiate, and lead off on this patrol.
|
|
