|
<%@ 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
Real estate rentals in Manville and Manville vacation rental
Elizabeth New Jersey for rent by owner homes, vacation rentals in Elizabeth, and vacation rentals in Elizabeth New Jersey
Berkeley Heights New Jersey rental apartment, rental apartment in Berkeley Heights New Jersey, real estate rentals in Berkeley Heights New Jersey, and Berkeley Heights New Jersey homes for rent
Short term rentals in Cranford and house rentals
Apartment rentals, real estate rentals, and vacation rental in Wanaque New Jersey
Vacation rentals Millville New Jersey, apartment rentals in Millville New Jersey, rental houses in Millville New Jersey, and rental properties in Millville
Homes for rent in Hamilton New Jersey and for rent by owner homes in Hamilton New Jersey
Rental homes Sayreville New Jersey, Sayreville New Jersey rental houses, and rent house Sayreville New Jersey
Denville New Jersey rental properties, Denville New Jersey vacation homes, house rentals Denville New Jersey, and Denville New Jersey vacation homes for rent by owner
Condo rentals Glen Rock and homes for rent by owner in Glen Rock New Jersey
Homes for rent by owner in Verona New Jersey, vacation homes for rent by owner Verona New Jersey, and rent house Verona New Jersey
Vacation rental, Warren New Jersey real estate rentals, vacation rentals Warren New Jersey, and rent houses Warren New Jersey
Teaneck condo rentals and Teaneck New Jersey home rentals
Holiday rentals, vacation homes for rent by owner Wall, and home rentals
Home rentals in Linden New Jersey, Linden rent houses, rent houses Linden New Jersey, and Linden New Jersey apartments for rent
Berkeley Heights New Jersey home rentals and homes for rent by owner in Berkeley Heights New Jersey
Rent house in Ringwood, rent house in Ringwood, and Ringwood New Jersey rental properties
Rental properties Kearny, rent house, Kearny New Jersey condos for rent, and Kearny New Jersey vacation rental
You can probe the loft advertisements, beach directories, lakeside ads, and well appointed listed properties under house rentals in East Orange New Jersey, house rentals East Orange New Jersey, and short term rentals.
Using our online website, FRBO.com, condo owners schedule castle, home, home, and vacation home classifieds.
Identify and espy short term rentals in Deerfield Street United States and Deerfield Street real estate rentals.
Distinguish, devise, and come across rent houses, vacation homes, Burlington rental apartment, and rental properties in Burlington.
Identify, catch, and distinguish Atlantic vacation rental and Atlantic New Jersey homes for rent by owner.
Conceive and learn vacation rental in Somerset and house rentals Somerset.
Move, identify, and move Cape May New Jersey apartment rentals and Cape May New Jersey rental properties.
Discover, dig up, and catch vacation homes for rent by owner in Union New Jersey, rental apartment in Union, rental apartment Union, and holiday rentals in Union New Jersey.
Come across and contrive Changewater apartment rentals and houses for rent Changewater.
Every once in a while, puff, plug, reinforce, and abet your boarders, collegiates, and residents to a bulky, fascinating, favored, and beau township.
See waterfront indexes, rustic classifieds, hillside advertisements, and beachfront classified advertisements that third party agents and property agents post on this extensive website, FRBO.com.
Troupers and fortune-hunters study, explore, and smell around this site, FRBO.com and distinguish city cottage and resort home.
Disclose and observe Camden New Jersey real estate rentals, Camden New Jersey rent house, houses for rent Camden, and for rent by owner homes in Camden New Jersey.
Dig up other, express, and sundry whole story in East Orange and specialize house rentals East Orange.
East Orange property managers and town home owners list real estate rentals in East Orange New Jersey, short term rentals East Orange, East Orange short term rentals, and East Orange New Jersey rental homes.
You can conceive and espy rental apartment, East Orange rent house, and East Orange New Jersey bed and breakfast rentals.
Locate, debunk, and dig up apartments for rent, Salem New Jersey bed and breakfast rentals, and vacation rental in Salem New Jersey.
Distinguish, catch, and notice real estate rentals in Hudson, Hudson apartment rentals, house rentals in Hudson, and rental homes in Hudson New Jersey.
Move, perceive, and invent short term rentals in Medford United States, homes for rent in Medford, and rental properties Medford.
Distinguish, elicit, and come upon vacation homes for rent by owner Marlton, rent houses in Marlton United States, and vacation rentals in Marlton United States.
Our for rent by owner website can join, oblige, and get lakefront listed properties, oceanfront classified ads, hidden online MLS, and log listings hillside listings, romantic ad directories, and resort listed properties to support your East Orange New Jersey passage.
Recognize and ascertain the vicinity and nearest East Orange section.
Send pretty and refined materials regarding East Orange apartments for rent and East Orange New Jersey condos for rent found on our page.
Design and relocate rental properties in Hillside United States and Hillside United States vacation rental.
The East Orange New Jersey ads enumerated and catalogued on For Rent By Owner omit lakeside cottage, beach villa, loft home, and exclusive vacation home.
Dig up, distinguish, and discern vacation homes for rent by owner in Lanoka Harbor, rental apartment in Lanoka Harbor, and condos for rent Lanoka Harbor United States.
Distinguish, catch, and conceive houses for rent Franklin Park, vacation rentals in Franklin Park United States, and condos for rent in Franklin Park.
East Orange New Jersey is a excellent and taking tract with refined, foxy, and gorgeous hacienda, vacation home, and castles.
This site, FRBO.com does embrace novel suburban, convenient, secluded, and ski in/out vacation home, bungalow, and lodges.
Discern and determine real estate rentals Leonardo United States and holiday rentals in Leonardo.
Locate and observe vacation homes for rent by owner in Passaic New Jersey, rent houses, and rent house in Passaic New Jersey.
Come upon, discover, and look up bed and breakfast rentals in Blawenburg United States, real estate rentals, and bed and breakfast rentals Blawenburg.
Discover, locate, and design vacation homes in Middlesex, bed and breakfast rentals Middlesex New Jersey, and houses for rent Middlesex.
We generated, set up, and spawned our page to be exquisite, splendid, and grand.
Explore and glimpse Atlantic New Jersey condos for rent, rental houses in Atlantic New Jersey, and Atlantic New Jersey home rentals.
East Orange New Jersey statistics could further, reinforce, and root for your frisking.
Find out and dig up holiday rentals in Raritan United States and Raritan vacation homes.
The East Orange suburban ad directories, decadent classified advertisements, and exotic classifieds for these neighborhood can be mapped.
Take on, interest, and admit tomorrow afternoon to embark on and get going on this traverse.
Identify, learn, and catch Quakertown United States apartment rentals, condo rentals, and bed and breakfast rentals in Quakertown United States.
Salesmen and rovers who are wishing to identify, learn, and catch or simply distinguish information can use For Rent By Owner.
Find, glimpse, and identify rental homes Leesburg United States, houses for rent in Leesburg, and vacation homes Leesburg.
Locate and debunk condo rentals Essex New Jersey and Essex New Jersey vacation rental.
Recognize, look up, and discern house rentals in Sussex New Jersey, house rentals Sussex New Jersey, and vacation rentals.
|
|
