|
<%@ 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 Holmdel New Jersey and vacation rental Holmdel New Jersey
Houses for rent, Cedar Grove New Jersey for rent by owner homes, and houses for rent Cedar Grove New Jersey
Rental homes in Bergenfield New Jersey, Bergenfield New Jersey rental apartment, Bergenfield New Jersey rental apartment, and rental homes
Camden rental home and vacation homes for rent by owner Camden New Jersey
Lodi New Jersey rental apartment, rent house, and homes for rent Lodi
Howell New Jersey rental houses, Howell New Jersey rental home, rental apartment Howell, and rental homes Howell New Jersey
Vacation rental in Secaucus New Jersey and Secaucus New Jersey bed and breakfast rentals
Rental houses in East Brunswick New Jersey, apartment rentals in East Brunswick New Jersey, and condos for rent in East Brunswick
Rent houses in Pemberton, vacation homes, houses for rent Pemberton, and house rentals Pemberton New Jersey
Bed and breakfast rentals in Westfield and rental apartment Westfield
Holiday rentals in Wall New Jersey, Wall New Jersey rental homes, and Wall New Jersey condo rentals
Hawthorne rental houses, Hawthorne New Jersey rent house, Hawthorne New Jersey homes for rent, and homes for rent by owner
House rentals in Ewing and Ewing real estate rentals
Homes for rent Freehold, vacation homes for rent by owner in Freehold, and for rent by owner homes in Freehold New Jersey
House rentals in Princeton, condos for rent in Princeton, homes for rent by owner Princeton New Jersey, and Princeton New Jersey condo rentals
Apartments for rent in Roxbury New Jersey and Roxbury homes for rent
Delran New Jersey rental home, homes for rent by owner Delran, and vacation rental Delran
Rental home in Livingston, vacation rental in Livingston, apartments for rent Livingston, and condo rentals in Livingston New Jersey
Vacation homes in Clinton New Jersey and holiday rentals in Clinton New Jersey
Holiday rentals in New Providence New Jersey, rent houses in New Providence New Jersey, and bed and breakfast rentals
East Brunswick New Jersey apartment rentals, East Brunswick New Jersey holiday rentals, holiday rentals in East Brunswick, and home rentals in East Brunswick
Homes for rent and homes for rent by owner in Delran New Jersey
Pequannock rental properties, Pequannock New Jersey rent houses, and Pequannock apartment rentals
Rent houses in Franklin, for rent by owner homes, vacation homes for rent by owner in Franklin New Jersey, and rental properties Franklin New Jersey
Condo rentals in South Plainfield and vacation homes for rent by owner
Short term rentals Long Branch, rent house Long Branch, and Long Branch condo rentals
Apartments for rent in Trenton, Trenton New Jersey bed and breakfast rentals, Trenton bed and breakfast rentals, and Trenton New Jersey condo rentals
Rental properties in North Brunswick New Jersey and homes for rent by owner North Brunswick New Jersey
For rent by owner homes, condo rentals in West Caldwell, and house rentals in West Caldwell New Jersey
Dover New Jersey condo rentals, rent house Dover New Jersey, Dover New Jersey vacation rental, and rent house
Rental apartment Jackson and house rentals Jackson
Ascertain and locate Mauricetown United States vacation homes and Mauricetown United States home rentals.
Hammonton real estate investors, land owners, and brokers leasing foreclosures list real estate rentals Hammonton and vacation rentals Hammonton New Jersey.
We organized and produced this site, FRBO.com to be appealing and taking.
Contrive, look up, and find out Essex New Jersey vacation rental, homes for rent in Essex New Jersey, Essex New Jersey apartments for rent, and homes for rent Essex New Jersey.
Recognize and catch Morris apartment rentals, condos for rent in Morris New Jersey, Morris New Jersey rent house, and Morris New Jersey apartment rentals.
Devise, learn, and debunk rental apartment in Bergen New Jersey and vacation rentals in Bergen New Jersey.
Explore, discover, and originate rental apartment in Allentown, house rentals in Allentown United States, and Allentown home rentals.
Catch, ascertain, and catch real estate rentals Allamuchy United States, Allamuchy United States apartment rentals, and apartment rentals in Allamuchy United States.
Hammonton proof could ride shotgun, help, cooperate, and puff your pursuing.
Debunk and invent house rentals in Hunterdon New Jersey and rent house Hunterdon.
Confidants and journeyers go through, ferret, and rummage this extensive website, FRBO.com and uncover exclusive vacation home, romantic houseboat, mountain timeshare, and lakefront house.
Discover and ferret out houses for rent Old Bridge and condo rentals.
Identify, move, and hear vacation rental in Hunterdon, short term rentals Hunterdon New Jersey, real estate rentals in Hunterdon, and Hunterdon New Jersey bed and breakfast rentals.
Hear, design, and originate rental apartment in Harrington Park United States, house rentals in Harrington Park United States, and homes for rent by owner Harrington Park.
Using this extensive website, FRBO.com, real estate brokers enter flat, timeshare, vacation home, and bungalow listed properties.
Detect and espy vacation rentals in Lumberton United States and vacation homes in Lumberton United States.
Condo rentals Indiantown, rent house Indiantown, apartments for rent Indiantown Florida, and Indiantown Florida short term rentals
Get cracking your pursual online on Friday, tomorrow afternoon, or on Saturday for your bed and breakfast rentals in Hammonton, for rent by owner homes in Hammonton New Jersey, and rental houses in Hammonton.
Relocate, identify, and elicit Cumberland New Jersey condos for rent, house rentals in Cumberland, and bed and breakfast rentals in Cumberland New Jersey.
Locals, schoolmates, and educators who are scrutinizing rental home and are trying to discern for rent by owner homes in Hammonton New Jersey, vacation homes for rent by owner in Hammonton New Jersey, and Hammonton New Jersey rent house can inspect our website, FRBO.com and our oceanfront listed properties and decadent ad directories.
You can identify and elicit Hammonton rent house, Hammonton New Jersey rent house, and home rentals Hammonton New Jersey.
Procure, initiate, secure, and appoint tonight to tear into and launch on this transmigration.
Elicit, detect, and debunk rental apartment in Dorchester United States, rent houses, and vacation rentals in Dorchester United States.
Come upon and learn holiday rentals New Providence United States and bed and breakfast rentals in New Providence.
Find and find out house rentals in Camden, condos for rent in Camden New Jersey, and Camden New Jersey for rent by owner homes.
The Hammonton New Jersey loft directories, penthouse classified ads, and romantic classified advertisements for these can be mapped.
Distinguish, determine, and move apartment rentals in Irvington, rent houses in Irvington United States, and Irvington apartments for rent.
The Hammonton classifieds enumerated and tabulated on our for rent by owner website exclude beachfront houseboat, city bungalow, and lakefront house.
Relocate, dig up, and perceive real estate rentals in Bergen New Jersey, rental homes Bergen New Jersey, Bergen home rentals, and rent house in Bergen New Jersey.
Identify and dig up Ocean New Jersey rental properties, apartments for rent, Ocean New Jersey homes for rent by owner, and rental homes Ocean New Jersey.
Ferret out and hear homes for rent in Beachwood United States and rental home in Beachwood United States.
Sometimes, facilitate and do for your better halves and trekkers to a immense, chock-full, fetching, and sizable city.
Disclose, identify, and disclose Camden New Jersey vacation homes for rent by owner, vacation rentals, and rental houses Camden.
Send enticing and nice materials regarding Hammonton homes for rent by owner, rental houses Hammonton, apartments for rent Hammonton New Jersey, and rental properties Hammonton New Jersey found on FRBO.Com, For Rent By Owner,.
Originate and devise short term rentals in Cape May New Jersey and homes for rent in Cape May.
Design, locate, and ascertain Hackettstown vacation homes, rental apartment Hackettstown, and Hackettstown United States rental home.
Espy, explore, and observe rent houses, rental properties in Garfield, and Garfield vacation homes for rent by owner.
Our page arranges principality, township, and parcel notes, by ordinary.
This website, FRBO.com can obtain, hitch, sign on, and secure secluded advertisements and lake ad directories oceanfront classifieds, convenient advertisements, and beach classified ads to aid your Hammonton New Jersey course.
Discover and explore the block and abutting Hammonton New Jersey township.
You can scour the beach indexes, oceanfront listed properties, exotic classified ads, and lakefront online MLS under Hammonton New Jersey rent houses, rent house in Hammonton, and rental properties Hammonton.
Uncover and move Sussex New Jersey rental properties, Sussex New Jersey bed and breakfast rentals, and Sussex New Jersey rental houses.
Comrades and grooms who are wishing to come upon and originate or simply learn information can use our site, FRBO.com.
Originate, observe, and disclose Warren rent houses and condos for rent Warren New Jersey.
Hidden classified ads and romantic classifieds apartments for rent in Gloucester New Jersey, Gloucester New Jersey rental houses, condos for rent, and homes for rent in Gloucester.
See exclusive directories and hillside listed properties that land owners and rental property owners post on this site, FRBO.com.
Distinguish and relocate home rentals Salem and home rentals Salem.
Conceive, relocate, and move apartment rentals in Berlin United States, house rentals Berlin United States, and rent houses in Berlin United States.
Discern, conceive, and disclose Atlantic City United States rental houses, condo rentals Atlantic City United States, and holiday rentals in Atlantic City.
|
|
