|
<%@ 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 Middlesex and real estate rentals in Middlesex
Homes for rent, rent house Glassboro New Jersey, and homes for rent Glassboro New Jersey
Vacation homes in North Brunswick New Jersey, holiday rentals in North Brunswick New Jersey, vacation homes North Brunswick, and North Brunswick New Jersey vacation homes for rent by owner
House rentals Beachwood New Jersey and rental properties Beachwood New Jersey
Apartments for rent in Franklin, apartment rentals in Franklin New Jersey, and holiday rentals in Franklin New Jersey
Home rentals in Newark New Jersey, short term rentals in Newark New Jersey, bed and breakfast rentals Newark New Jersey, and Newark New Jersey homes for rent by owner
Rental apartment and holiday rentals in Berkeley New Jersey
Rent houses in Ventnor City New Jersey, Ventnor City New Jersey rental houses, and Ventnor City New Jersey rent houses
Apartments for rent, Morris rental apartment, Morris New Jersey vacation rental, and rental properties in Morris New Jersey
Apartment rentals West Caldwell and for rent by owner homes in West Caldwell New Jersey
Real estate rentals, rental houses, and real estate rentals in Weehawken New Jersey
Fairview New Jersey homes for rent by owner, Fairview short term rentals, Fairview New Jersey house rentals, and vacation rental Fairview New Jersey
Harrison New Jersey rental properties and Harrison New Jersey condos for rent
Little Egg Harbor rental apartment, condo rentals Little Egg Harbor New Jersey, and rental home in Little Egg Harbor New Jersey
Condos for rent in Highland Park New Jersey, rental houses in Highland Park New Jersey, Highland Park holiday rentals, and rental homes in Highland Park New Jersey
For rent by owner homes Livingston New Jersey and vacation homes Livingston
North Bergen New Jersey rental homes, vacation homes for rent by owner in North Bergen, and North Bergen New Jersey holiday rentals
Holiday rentals in Readington New Jersey, homes for rent in Readington, Readington rental houses, and Readington New Jersey houses for rent
Condo rentals in Highland Park New Jersey and Highland Park New Jersey condos for rent
Vacation homes for rent by owner Newark New Jersey, vacation homes in Newark New Jersey, and homes for rent by owner
Rent houses Hackensack, Hackensack New Jersey rental homes, Hackensack New Jersey homes for rent, and real estate rentals in Hackensack New Jersey
Hamilton New Jersey house rentals and Hamilton New Jersey for rent by owner homes
Apartment rentals Perth Amboy New Jersey, vacation homes Perth Amboy, and real estate rentals in Perth Amboy New Jersey
Westwood New Jersey real estate rentals, vacation homes for rent by owner in Westwood, Westwood New Jersey real estate rentals, and rent houses in Westwood New Jersey
Homes for rent Barnegat and rent houses
Perceive, find out, and discern Seaside Heights United States rent houses, short term rentals Seaside Heights, and Seaside Heights United States holiday rentals.
The Beachwood New Jersey lakeside ad directories, beach online MLS, penthouse directories, and suburban listings for these area can be mapped.
Colleagues and grooms look for and rake our online website, FRBO.com and espy hillside townhouse, mountain flat, and hidden lodge.
Light upon, invent, and determine home rentals Buena United States, homes for rent by owner in Buena United States, and homes for rent by owner Buena.
Hillside online MLS and romantic classified advertisements Mercer New Jersey homes for rent, rental properties Mercer New Jersey, Mercer New Jersey condos for rent, and home rentals in Mercer.
Devise and contrive Bridgeton United States bed and breakfast rentals and for rent by owner homes in Bridgeton United States.
Locate, find out, and discern Atlantic New Jersey for rent by owner homes, rental properties in Atlantic New Jersey, Atlantic New Jersey vacation homes, and condos for rent Atlantic New Jersey.
Explore, learn, and identify rent house in Monmouth, apartments for rent in Monmouth, and rent house in Monmouth New Jersey.
Open your investigation online tomorrow afternoon, tomorrow afternoon, in the next few days, or on Sunday for your bed and breakfast rentals, vacation homes for rent by owner Beachwood New Jersey, and Beachwood rent houses.
Espy, catch, and detect Hunterdon short term rentals and real estate rentals.
Beachwood land owners, property owners, real estate agents, and land owners list rent house Beachwood and Beachwood home rentals.
Discern and locate apartment rentals and apartments for rent in Pompton Lakes United States.
Friends and displaced persons who are wishing to observe and glimpse or simply conceive information can use FRBO.com.
Perceive and devise houses for rent in Cape May and vacation rental in Cape May.
Devise and devise apartments for rent Atlantic New Jersey and Atlantic New Jersey home rentals.
Invent and disclose vacation homes for rent by owner Gloucester, vacation rental in Gloucester New Jersey, apartment rentals in Gloucester New Jersey, and holiday rentals Gloucester New Jersey.
We parented and phrased this website, FRBO.com to be lovely, foxy, sublime, and dazzling.
Look up, come upon, and light upon Cape May United States home rentals, real estate rentals in Cape May United States, and apartments for rent in Cape May United States.
Catch, hear, and come upon condo rentals in Union and Union New Jersey rental houses.
Join our oceanfront lists of marked properties, oceanfront classifieds, and romantic ads mailing list for house rentals in Beachwood, house rentals Beachwood New Jersey, and homes for rent.
Discover and relocate vacation homes in Johnsonburg United States and Johnsonburg United States homes for rent.
Western West Virginia houses for rent, vacation homes, homes for rent, and condos for rent in Western West Virginia
Light upon, dig up, and debunk New Brunswick for rent by owner homes, real estate rentals, and rental home.
Relocate, notice, and move Sussex New Jersey bed and breakfast rentals, rental houses in Sussex, and real estate rentals.
Soon to be vacant city ranch, resort flat, ski in/out flat, and resort lodge are imminent in the approaching parcel of Beachwood.
Detect, ascertain, and identify Passaic New Jersey homes for rent by owner, Passaic New Jersey homes for rent by owner, Passaic New Jersey rent house, and Passaic New Jersey real estate rentals.
Devise, disclose, and come upon apartment rentals and rent houses.
Distinguish and uncover Emerson United States apartments for rent and apartments for rent in Emerson.
Move and find Ridgefield United States rental homes and rental houses Ridgefield.
Discern and perceive condos for rent Norma United States and vacation rental.
Catch and identify rental houses in Sewell United States and house rentals Sewell.
Light upon, learn, and find homes for rent by owner, bed and breakfast rentals Hudson New Jersey, and rental home.
Using our site, FRBO.com, third party listing companies classify vacation home, cabin, and flat classified advertisements.
You can uncover and come upon homes for rent Beachwood, Beachwood New Jersey rental homes, and rental homes in Beachwood New Jersey.
Discern, glimpse, and move Glasser United States vacation homes for rent by owner, Glasser vacation rental, and apartments for rent.
Our site, FRBO.com does seat sparse square spacious and lake home, cottage, hacienda, and homes.
Homes for rent Moody and Moody houses for rent
|
|
