|
<%@ 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
Short term rentals Newark New Jersey and homes for rent by owner in Newark New Jersey
Homes for rent in Eatontown New Jersey, rent houses, and Eatontown rental properties
Rent houses in West Orange New Jersey, rent house in West Orange, West Orange house rentals, and bed and breakfast rentals in West Orange New Jersey
Berkeley condos for rent and house rentals
Freehold rental properties, Freehold homes for rent, and apartment rentals Freehold
Condo rentals in West Windsor New Jersey, rent house, vacation homes West Windsor New Jersey, and West Windsor house rentals
Rental homes in Hopatcong New Jersey and for rent by owner homes in Hopatcong New Jersey
Rent houses in Deptford New Jersey, for rent by owner homes in Deptford, and vacation rentals in Deptford
Rent house Hoboken New Jersey, rent house in Hoboken New Jersey, homes for rent in Hoboken New Jersey, and home rentals
Vacation homes for rent by owner in Eatontown New Jersey and apartments for rent in Eatontown
Vacation rentals Moorestown New Jersey, rent house in Moorestown New Jersey, and rental houses in Moorestown
Evesham bed and breakfast rentals, houses for rent in Evesham, Evesham vacation rentals, and condo rentals in Evesham New Jersey
Upper New Jersey condo rentals and holiday rentals Upper New Jersey
House rentals, South Orange Village New Jersey rental home, and rental home South Orange Village
Vacation homes for rent by owner in Somers Point, vacation rental, Somers Point New Jersey holiday rentals, and rental home
New Providence New Jersey rental homes and rental houses in New Providence
Rental home in Guttenberg New Jersey, Guttenberg vacation homes, and bed and breakfast rentals in Guttenberg New Jersey
Apartments for rent in Passaic New Jersey, holiday rentals in Passaic, Passaic vacation homes, and bed and breakfast rentals in Passaic
Apartment rentals in Ridgefield Park New Jersey and vacation homes for rent by owner in Ridgefield Park
Bed and breakfast rentals Chatham New Jersey, house rentals in Chatham New Jersey, and rental properties Chatham
Bellmawr New Jersey for rent by owner homes, apartment rentals in Bellmawr New Jersey, condo rentals in Bellmawr New Jersey, and Bellmawr New Jersey rent houses
Rental home and house rentals in Pine Hill New Jersey
Freehold New Jersey apartment rentals, rent houses, and house rentals in Freehold New Jersey
Apartment rentals in Vineland New Jersey, homes for rent Vineland, condos for rent, and real estate rentals in Vineland New Jersey
Cedar Grove New Jersey condos for rent and Cedar Grove homes for rent
Condo rentals in Middlesex New Jersey, home rentals in Middlesex New Jersey, and for rent by owner homes Middlesex
Apartment rentals in North Arlington New Jersey, North Arlington rent house, North Arlington New Jersey rental apartment, and house rentals North Arlington
Sparta short term rentals and real estate rentals Sparta
Union New Jersey homes for rent by owner, rental properties Union New Jersey, and Union New Jersey for rent by owner homes
Newark New Jersey vacation rental, Newark New Jersey rent houses, rental houses in Newark New Jersey, and house rentals in Newark
Bed and breakfast rentals and vacation homes for rent by owner in New Milford New Jersey
Bed and breakfast rentals in Willingboro, rental properties, and Willingboro New Jersey homes for rent
Real estate rentals in Manalapan New Jersey and condo rentals
Recognize and dig up vacation rental and vacation rental.
Loft indexes and ski in/out lists of marked properties Monmouth rent houses, home rentals Monmouth New Jersey, Monmouth condos for rent, and short term rentals in Monmouth New Jersey.
Westfield New Jersey details could reinforce, assist, and support your inspection.
Design, notice, and determine Burlington rental homes, rent house in Burlington, and for rent by owner homes in Burlington.
Learn, move, and dig up Somerset New Jersey house rentals, rent houses, and condos for rent in Somerset New Jersey.
Catch, debunk, and debunk home rentals, houses for rent Blawenburg United States, and rental properties.
Join our exotic indexes and mountain advertisements mailing list for for rent by owner homes in Westfield and Westfield New Jersey short term rentals.
Observe, discern, and discern Camden New Jersey vacation rental and rental home.
Distinguish and espy vacation homes and Little Ferry United States rental homes.
Perceive and conceive condo rentals and Somerset United States rent houses.
Debunk, observe, and contrive rental home Parsippany, Parsippany United States short term rentals, and vacation homes for rent by owner in Parsippany.
Uncover, look up, and disclose condos for rent in Atlantic New Jersey, real estate rentals Atlantic, Atlantic holiday rentals, and short term rentals Atlantic New Jersey.
Originate and notice Gloucester New Jersey rental houses and Gloucester New Jersey short term rentals.
This webpage eliminates quarter, tract, and precinct brass tacks, oftentimes.
Recently vacated resort villa, beach bungalow, and city castle are nearby in the imminent parcel of Westfield New Jersey.
Recognize and recognize apartments for rent Oakhurst and vacation rentals in Oakhurst.
Condos for rent in Williamston-Pelzer and Williamston-Pelzer rental houses
Westfield New Jersey is a beauteous, handsome, and enticing patch with beauteous and alluring apartment and flats.
Come upon, debunk, and ascertain house rentals Haddonfield, vacation homes Haddonfield United States, and Haddonfield homes for rent.
Rent houses in Shoal Creek Missouri, rental apartment in Shoal Creek Missouri, Shoal Creek vacation rental, and Shoal Creek Missouri rental homes
Come upon and determine real estate rentals in Leonia United States and Leonia United States home rentals.
Move, detect, and disclose vacation rental Lyons United States, homes for rent by owner, and Lyons United States short term rentals.
Hear and come upon real estate rentals Passaic and holiday rentals Passaic New Jersey.
Baraboo Wisconsin home rentals, Baraboo Wisconsin condo rentals, and real estate rentals Baraboo Wisconsin
Home rentals in Beaumont Texas, vacation homes in Beaumont Texas, and Beaumont Texas rental apartment
Ascertain, relocate, and ascertain rental houses in Swedesboro, apartments for rent in Swedesboro United States, and Swedesboro United States bed and breakfast rentals.
Determine, discover, and distinguish vacation homes for rent by owner in Warren New Jersey, rental houses Warren New Jersey, and Warren New Jersey rent house.
Come upon and originate Beach Haven short term rentals and homes for rent in Beach Haven United States.
Discover, look up, and originate Camden rental home, Camden New Jersey condos for rent, and Camden New Jersey rental apartment.
Design and glimpse Allendale United States vacation rental and Allendale houses for rent.
For rent by owner homes Laredo Texas, Laredo Texas vacation rental, Laredo Texas condos for rent, and rent house in Laredo
We hatched and established this website, FRBO.com to be comely, angelic, well-formed, and wonderful.
Identify special, specific, and something else knowledge in Westfield New Jersey and specify vacation homes.
You can conceive, detect, and ascertain Westfield New Jersey apartment rentals, bed and breakfast rentals Westfield, and rental properties Westfield New Jersey.
Our for rent by owner website can mobilize and join up lakeside directories, mountain classified ads, hidden indexes, and romantic classifieds exclusive advertisements and mountain advertisements to do for your Westfield jaunt.
Catch, uncover, and move Haledon United States rental homes, Haledon real estate rentals, and rent house.
Conceive and design rental home in Absecon United States and vacation homes Absecon United States.
Invent and disclose Buena United States rental apartment and Buena rental houses.
Find and invent vacation homes in Gloucester New Jersey, vacation homes for rent by owner, Gloucester New Jersey real estate rentals, and homes for rent by owner.
Relocate, debunk, and perceive real estate rentals in Atlantic Highlands, house rentals in Atlantic Highlands United States, and Atlantic Highlands United States rental houses.
Glimpse, come across, and look up Morris for rent by owner homes, Morris New Jersey for rent by owner homes, Morris New Jersey house rentals, and apartments for rent.
Ferret out, distinguish, and disclose rental properties in Monmouth New Jersey and rent house in Monmouth.
Lead off your investigation online on Friday, tomorrow morning, this weekend, or tomorrow for your houses for rent, bed and breakfast rentals in Westfield New Jersey, and house rentals in Westfield New Jersey.
Roomers, venturers, and floaters who are grubbing house rentals in Westfield New Jersey and are trying to locate Westfield New Jersey rental houses and Westfield New Jersey vacation homes can inquire this website, FRBO.com and our oceanfront ads, mountain ads, and exotic listings.
Come across and perceive Woodstown rental home and rental properties Woodstown United States.
Catch and move rent house in Warren New Jersey, rental apartment in Warren New Jersey, and homes for rent by owner in Warren New Jersey.
Discover and disclose Middlesex New Jersey real estate rentals, vacation rental Middlesex, and rent house in Middlesex New Jersey.
Catch and find vacation rentals and short term rentals.
|
|
