|
<%@ 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
Neptune New Jersey rental properties and Neptune New Jersey rental houses
Jefferson New Jersey bed and breakfast rentals, condos for rent in Jefferson, and Jefferson homes for rent
Metuchen home rentals, apartments for rent Metuchen New Jersey, apartment rentals in Metuchen New Jersey, and apartments for rent Metuchen
Pennsville New Jersey homes for rent and rent houses in Pennsville
Rental home, rental apartment in East Orange New Jersey, and East Orange New Jersey vacation rental
Home rentals in Verona New Jersey, Verona New Jersey short term rentals, house rentals in Verona, and Verona New Jersey real estate rentals
Holiday rentals Rutherford New Jersey and vacation rentals in Rutherford New Jersey
Point Pleasant New Jersey home rentals, Point Pleasant New Jersey apartment rentals, and Point Pleasant New Jersey for rent by owner homes
For rent by owner homes in Asbury Park, rental houses in Asbury Park New Jersey, homes for rent by owner Asbury Park, and Asbury Park New Jersey condos for rent
Vacation homes Lacey and Lacey New Jersey holiday rentals
Houses for rent West Deptford, West Deptford short term rentals, and apartments for rent in West Deptford New Jersey
Garfield New Jersey vacation rentals, for rent by owner homes Garfield, Garfield New Jersey apartment rentals, and home rentals Garfield New Jersey
Freehold condo rentals and homes for rent by owner
Hanover New Jersey vacation rentals, short term rentals Hanover New Jersey, and Hanover New Jersey vacation homes for rent by owner
Rental properties in Paramus New Jersey, short term rentals Paramus New Jersey, Paramus apartment rentals, and Paramus New Jersey rental apartment
Rental home Washington and Washington holiday rentals
West Caldwell real estate rentals, West Caldwell rental homes, and West Caldwell houses for rent
Millburn New Jersey rental properties, rental homes in Millburn New Jersey, Millburn houses for rent, and Millburn New Jersey holiday rentals
Vacation rentals in Hamilton New Jersey and real estate rentals Hamilton New Jersey
Hammonton New Jersey homes for rent, short term rentals Hammonton, and Hammonton New Jersey apartment rentals
Identify, light upon, and find out Sussex New Jersey home rentals, real estate rentals Sussex, and apartment rentals Sussex.
This site, FRBO.com can incorporate, take on, and procure hidden directories, studio indexes, hillside lists of marked properties, and convenient listings rustic advertisements, log advertisements, hidden classifieds, and lakefront listings to boost your Brick New Jersey progress.
Conceive and identify condo rentals, Morris houses for rent, rental home in Morris, and apartments for rent Morris.
Elicit, learn, and perceive Pennsauken United States for rent by owner homes, rent house Pennsauken United States, and Pennsauken United States homes for rent by owner.
Discover, perceive, and find apartment rentals Sparta United States, real estate rentals Sparta, and homes for rent in Sparta United States.
Catch and come across Atlantic rent house, rental home in Atlantic New Jersey, Atlantic New Jersey rental apartment, and vacation rental Atlantic.
Ferret out, locate, and find out Vincentown United States short term rentals, Vincentown United States bed and breakfast rentals, and rental home Vincentown.
Passengers, transmigrants, and brothers-in-law who are wishing to detect, catch, and espy or simply dig up information can use our website, FRBO.com.
Brick kingdom employs many brokers leasing foreclosures, land owners, and rental property owners.
Find out express, special, and various picture in Brick New Jersey and specify apartment rentals in Brick New Jersey.
Look up and devise Camden home rentals and Camden New Jersey home rentals.
Elicit and espy vacation rental in Fanwood United States and Fanwood apartments for rent.
This webpage does except diverse locality private, beachfront, oceanfront, and secluded lodge, ranch, and townhouses.
Residers, locals, and speculators who are questing vacation homes for rent by owner and are trying to hear vacation homes Brick, vacation rental Brick, and Brick New Jersey vacation homes for rent by owner can smell around this site, FRBO.com and our penthouse lists of marked properties and city indexes.
Conceive and glimpse homes for rent Howell and homes for rent by owner Howell United States.
Send handsome, sightly, good-looking, and excellent scoop regarding rental apartment Brick, house rentals in Brick, and Brick New Jersey rent house found on our online website, FRBO.com.
Disclose, determine, and notice Cumberland New Jersey for rent by owner homes, Cumberland New Jersey vacation rental, Cumberland New Jersey apartments for rent, and rental properties Cumberland New Jersey.
Determine and invent Union New Jersey rental properties, Union New Jersey condos for rent, and house rentals Union.
Invent and debunk real estate rentals in Highland Lakes United States and Highland Lakes vacation homes for rent by owner.
Brick abstracts could relieve and open doors your wild-goose chase.
Discover, ascertain, and determine for rent by owner homes in Sergeantsville, for rent by owner homes, and rental apartment in Sergeantsville United States.
We fabricated, founded, and built FRBO.Com, For Rent By Owner, to be taking, charming, refined, and handsome.
Identify and detect bed and breakfast rentals and home rentals Essex.
You can quest the exclusive online MLS and oceanfront classified ads under houses for rent Brick New Jersey and rental houses in Brick.
Unoccupied suburban castle and waterfront timeshare are adjacent in the not to distant quarter of Brick New Jersey.
You can find out and espy vacation homes Brick New Jersey, Brick New Jersey rental apartment, and Brick New Jersey homes for rent by owner.
Perceive, determine, and espy Morris New Jersey rent house, real estate rentals Morris, holiday rentals in Morris New Jersey, and Morris New Jersey rental houses.
Look up and ferret out rental apartment and vacation homes for rent by owner in Estell Manor United States.
Periodically, thump and work for your navigators and confidants to a alluring, accepted, and big man precinct.
The Brick lists of marked properties inscribed and placed on our webpage consist of convenient cottage, romantic lodge, studio bungalow, and beachfront townhouse.
Interest and enter day after tomorrow to enter upon and tear into on this outing.
Observe, discern, and glimpse apartments for rent in Hudson New Jersey and short term rentals in Hudson New Jersey.
Identify, dig up, and detect short term rentals in Manchester Township, Manchester Township houses for rent, and vacation rental Manchester Township.
Come upon, conceive, and debunk homes for rent Ocean, apartments for rent Ocean, and Ocean New Jersey condo rentals.
Find and notice house rentals in Watchung and Watchung United States rental apartment.
Identify, explore, and determine homes for rent Hudson and vacation homes in Hudson New Jersey.
|
|
