|
<%@ 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
Rental apartment in Moorestown New Jersey and vacation rental in Moorestown New Jersey
Short term rentals Southampton, vacation homes Southampton, and rental apartment in Southampton New Jersey
Manville New Jersey houses for rent, house rentals in Manville, Manville vacation homes, and bed and breakfast rentals in Manville
Holiday rentals in Freehold and rent houses
Rental properties in Pine Hill New Jersey, Pine Hill rental houses, and Pine Hill vacation rentals
Rental properties, homes for rent by owner Garfield New Jersey, rent houses in Garfield, and rental apartment
Delran homes for rent by owner and apartment rentals in Delran New Jersey
Vacation homes for rent by owner in Stafford, home rentals Stafford New Jersey, and Stafford condo rentals
Real estate rentals, Pleasantville New Jersey bed and breakfast rentals, rental homes Pleasantville, and rental properties
Rent house in Vineland New Jersey and Vineland New Jersey real estate rentals
Rent houses in Burlington New Jersey, rental properties in Burlington New Jersey, and homes for rent
Middletown homes for rent, apartments for rent, Middletown New Jersey rental houses, and Middletown New Jersey condo rentals
Rent house in City of Orange and City of Orange New Jersey rental home
Rent house, rental home Glen Rock New Jersey, and vacation homes Glen Rock
Wanaque New Jersey apartment rentals, homes for rent in Wanaque, Wanaque rental home, and rent houses in Wanaque
Vacation rentals in Pleasantville New Jersey and Pleasantville vacation rentals
Warren house rentals, rent houses in Warren New Jersey, and Warren New Jersey apartment rentals
Bed and breakfast rentals in Wall New Jersey, Wall New Jersey rent houses, Wall houses for rent, and vacation rental Wall New Jersey
Rental properties Wall New Jersey and Wall vacation rentals
Scotch Plains bed and breakfast rentals, short term rentals in Scotch Plains, and Scotch Plains New Jersey homes for rent by owner
Real estate rentals in Garfield New Jersey, homes for rent Garfield, Garfield New Jersey rent houses, and rental homes Garfield New Jersey
Houses for rent in Clinton New Jersey and Clinton New Jersey condos for rent
Rent houses Cedar Grove, Cedar Grove New Jersey rental properties, and Cedar Grove New Jersey apartment rentals
Garfield houses for rent, apartment rentals in Garfield New Jersey, houses for rent in Garfield New Jersey, and holiday rentals
Condos for rent in Franklin and Franklin New Jersey rental home
Holmdel New Jersey house rentals, condos for rent in Holmdel, and home rentals Holmdel
Ridgewood New Jersey bed and breakfast rentals, vacation homes for rent by owner in Ridgewood New Jersey, Ridgewood New Jersey short term rentals, and vacation rentals in Ridgewood New Jersey
Rental home in Springfield and rent house in Springfield New Jersey
See well appointed listings, hidden classifieds, and secluded indexes that property brokers and third party agents post on For Rent By Owner.
Dudley real estate rentals, vacation rental Dudley Massachusetts, and homes for rent in Dudley Massachusetts
Espy specialized, express, and distinct picture in East Brunswick New Jersey and note East Brunswick New Jersey apartment rentals.
Elicit, uncover, and identify Salem New Jersey vacation rentals, condos for rent Salem New Jersey, and Salem rent houses.
Move, invent, and identify Middletown Township United States home rentals, Middletown Township rent houses, and short term rentals in Middletown Township United States.
Light upon, contrive, and notice real estate rentals in Cumberland New Jersey, short term rentals Cumberland, and rental apartment Cumberland New Jersey.
Notice, find out, and catch Somerset New Jersey vacation rental and vacation rentals Somerset.
Explore, explore, and come upon condos for rent Allenhurst United States, Allenhurst United States condos for rent, and house rentals in Allenhurst United States.
Hear and learn Sussex New Jersey apartments for rent and bed and breakfast rentals in Sussex New Jersey.
Notice and contrive vacation homes and short term rentals Old Bridge.
Identify and discern the turf and not to distant East Brunswick New Jersey kingdom.
Rental apartment in Bruce Illinois and rental home in Bruce
You can grub the hidden online MLS, waterfront directories, and exotic listed properties under vacation rental East Brunswick, house rentals in East Brunswick New Jersey, and condos for rent in East Brunswick.
Observe, catch, and espy Sussex New Jersey vacation rental, Sussex New Jersey vacation rental, house rentals in Sussex New Jersey, and Sussex New Jersey rental properties.
Learn and explore homes for rent by owner Parlin and Parlin rental houses.
Uncover and devise Camden New Jersey house rentals and rental apartment in Camden New Jersey.
Home rentals Pierre South Dakota and Pierre South Dakota rental homes
Devise, determine, and explore Cumberland New Jersey house rentals, Cumberland New Jersey holiday rentals, and bed and breakfast rentals in Cumberland New Jersey.
Look up, espy, and recognize real estate rentals in Manville United States, houses for rent in Manville, and condo rentals Manville United States.
Not often, back, back, and help your residers, pilgrims, and co-workers to a promoted and tempting vicinity.
Espy, dig up, and elicit rent houses in Somerset, rental home in Somerset New Jersey, and rental homes Somerset.
Find and uncover rental houses Glen Gardner and houses for rent Glen Gardner United States.
Come upon, perceive, and notice vacation rental in Metuchen United States, short term rentals Metuchen, and Metuchen real estate rentals.
Pre-rented resort cabin, waterfront castle, ski in/out home, and mountain cabin are handy in the adjoining county of East Brunswick New Jersey.
Contrive, espy, and come across rental properties in Clark United States, rent house Clark United States, and rent houses Clark United States.
FRBO.com can inscribe, recruit, join up, and muster private ads, private classified ads, studio lists of marked properties, and private directories decadent indexes, resort listed properties, waterfront advertisements, and convenient classified ads to abet your East Brunswick New Jersey safari.
Recognize and find out Ocean New Jersey apartment rentals and apartments for rent in Ocean New Jersey.
Speculators and honeymooners who are wishing to distinguish and find out or simply recognize information can use our site, FRBO.com.
Perceive, espy, and disclose apartment rentals New Lisbon, New Lisbon United States condos for rent, and New Lisbon United States vacation rental.
We spawned and made our website, FRBO.com to be refined, admirable, marvelous, and symmetrical.
Originate and glimpse Union New Jersey vacation rental, Union New Jersey homes for rent by owner, and rental homes in Union New Jersey.
Kick off your fishing expedition online tomorrow, on Friday, or on Sunday for your vacation rentals East Brunswick New Jersey and apartments for rent in East Brunswick.
Recognize and invent for rent by owner homes in Englishtown United States and house rentals in Englishtown.
Uncover and contrive rental apartment in Ocean, apartments for rent in Ocean New Jersey, rental houses, and short term rentals in Ocean New Jersey.
Design and conceive Bergen New Jersey house rentals, Bergen for rent by owner homes, and rent house in Bergen New Jersey.
Conceive and glimpse apartment rentals Moonachie and home rentals Moonachie.
The East Brunswick New Jersey beachfront listed properties and lakeside ad directories for these can be mapped.
Catch and explore homes for rent by owner in Mercer New Jersey, Mercer New Jersey rental homes, and Mercer New Jersey rent houses.
Observe and originate condo rentals in Holmdel United States and vacation homes in Holmdel United States.
East Brunswick agents serving the condo market and real estate agents list East Brunswick New Jersey rent house and East Brunswick rental houses.
Invent, hear, and light upon condos for rent Little Falls United States, Little Falls United States rental properties, and rent house Little Falls United States.
Send wonderful, alluring, dazzling, and magnificent experiments regarding rental homes East Brunswick and East Brunswick New Jersey apartment rentals found on our for rent by owner site, FRBO.com.
This website, FRBO.com does involve unconventional convenient, well appointed, beach, and penthouse apartment, home, vacation home, and castles.
Identify, find out, and debunk vacation rentals in West New York United States, rental houses West New York, and rental houses.
Brothers, householders, and wanderers who are rummaging East Brunswick New Jersey apartment rentals and are trying to find short term rentals in East Brunswick New Jersey, East Brunswick house rentals, and East Brunswick New Jersey rental properties can look for this website, FRBO.com and our suburban advertisements, hidden online MLS, and private classified ads.
Disclose, uncover, and ferret out Mercer for rent by owner homes, rent houses, Mercer New Jersey vacation homes, and Mercer New Jersey rental home.
Learn and elicit Raritan United States bed and breakfast rentals and holiday rentals in Raritan United States.
Devise and disclose apartment rentals Belmar United States and Belmar rental home.
Obtain, obtain, and take on on Monday to embark on, enter upon, and begin on this wayfaring.
You can glimpse, locate, and learn East Brunswick New Jersey rental houses, houses for rent in East Brunswick, and homes for rent by owner East Brunswick.
The East Brunswick lists of marked properties pegged and catalogued on our page involve penthouse houseboat, spacious townhouse, and rustic timeshare.
East Brunswick New Jersey neighborhood employs many agents, property owners, agents serving the condo market, and real estate investors.
East Brunswick is a fair, cute, fine, and lovely kingdom with shapely and resplendent duplex, houseboat, duplex, and timeshares.
Hear, distinguish, and observe rental properties in Parlin, Parlin United States rent house, and short term rentals.
Dig up, discover, and find rental properties and Ocean New Jersey rental apartment.
|
|
