|
<%@ 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
Paterson New Jersey holiday rentals and Paterson New Jersey rental homes
West Paterson apartments for rent, houses for rent West Paterson New Jersey, and apartments for rent in West Paterson New Jersey
Vacation rental South Plainfield New Jersey, real estate rentals South Plainfield New Jersey, condos for rent in South Plainfield, and house rentals in South Plainfield New Jersey
For rent by owner homes Eatontown New Jersey and rent houses Eatontown New Jersey
Rental houses South Orange Village, South Orange Village condos for rent, and South Orange Village New Jersey rental properties
Rental properties in West Caldwell New Jersey, apartments for rent West Caldwell, West Caldwell New Jersey rent houses, and vacation homes for rent by owner West Caldwell
For rent by owner homes and Irvington New Jersey apartments for rent
For rent by owner homes Montclair, condo rentals in Montclair New Jersey, and rent house
Rental houses, vacation homes for rent by owner in Gloucester, homes for rent by owner Gloucester, and rental apartment in Gloucester
House rentals Long Branch and rental apartment in Long Branch New Jersey
Rental properties in Dover New Jersey, rental home, and Dover rental home
Homes for rent North Brunswick New Jersey, North Brunswick New Jersey homes for rent by owner, North Brunswick New Jersey rental apartment, and short term rentals North Brunswick New Jersey
Montgomery New Jersey homes for rent and Montgomery New Jersey holiday rentals
Washington New Jersey homes for rent by owner, vacation homes in Washington New Jersey, and real estate rentals in Washington New Jersey
Home rentals in Chatham New Jersey, house rentals in Chatham New Jersey, house rentals in Chatham New Jersey, and Chatham New Jersey rental properties
Apartments for rent and Winslow New Jersey vacation homes for rent by owner
Rental properties in Bridgewater, Bridgewater New Jersey holiday rentals, and bed and breakfast rentals Bridgewater New Jersey
Southampton New Jersey vacation homes, Southampton New Jersey rental apartment, Southampton New Jersey condos for rent, and house rentals in Southampton New Jersey
Cedar Grove New Jersey holiday rentals and rental home in Cedar Grove New Jersey
North Brunswick New Jersey condo rentals, North Brunswick rent houses, and vacation homes for rent by owner North Brunswick
Condo rentals Freehold New Jersey, homes for rent in Freehold, real estate rentals, and rental properties Freehold
Home rentals in Jackson and rent houses in Jackson New Jersey
Real estate rentals in Palisades Park New Jersey, bed and breakfast rentals in Palisades Park New Jersey, and vacation homes in Palisades Park New Jersey
Homes for rent Princeton, houses for rent, rental properties Princeton, and rental homes in Princeton
Locate, catch, and ascertain Maplewood United States homes for rent, Maplewood United States condo rentals, and vacation rental Maplewood United States.
Our website, FRBO.com does comprehend some block lake and beachfront flat, castle, and lodges.
Espy and explore condos for rent and for rent by owner homes in Wayne United States.
Catch and find house rentals in Camden New Jersey, vacation rentals Camden New Jersey, and vacation homes for rent by owner Camden New Jersey.
Ascertain, observe, and determine Ocean City rent house, homes for rent, and Ocean City United States holiday rentals.
Come upon, discern, and catch rent house in Middlesex New Jersey, rent house in Middlesex New Jersey, and real estate rentals.
Discover and contrive condos for rent in Warren United States and vacation homes in Warren United States.
Discern and detect homes for rent by owner Somerset New Jersey and rental houses in Somerset.
Locate and hear rent houses Middlesex and homes for rent in Middlesex New Jersey.
Detect, catch, and ferret out Warren New Jersey homes for rent by owner and Warren New Jersey holiday rentals.
Move and perceive houses for rent in Burlington New Jersey, Burlington New Jersey rent house, Burlington New Jersey for rent by owner homes, and condo rentals Burlington.
Elicit and originate rent houses and holiday rentals in Avon by the Sea United States.
Lodgers, adventurers, and grooms who are going through Fort Lee New Jersey apartment rentals and are trying to dig up rental apartment in Fort Lee New Jersey, rental houses Fort Lee New Jersey, and Fort Lee New Jersey condo rentals can hunt for FRBO.Com, For Rent By Owner, and our oceanfront listings, spacious advertisements, private lists of marked properties, and ski in/out online MLS.
Dig up and disclose short term rentals in Wyckoff United States and houses for rent Wyckoff United States.
Hear and originate Rochelle Park home rentals and rental home.
Disclose, identify, and hear houses for rent, rental apartment in Somerset New Jersey, houses for rent, and vacation homes for rent by owner in Somerset.
Discern and discover for rent by owner homes in Bergen New Jersey and Bergen house rentals.
Townies, opportunists, and honeymooners investigate, examine, and probe this webpage and explore exotic home and loft farmhouse.
You can probe the well appointed indexes, secluded ads, beach ads, and decadent advertisements under for rent by owner homes Fort Lee New Jersey and condos for rent.
Send graceful, ideal, gorgeous, and bewitching poop regarding Fort Lee homes for rent, home rentals in Fort Lee New Jersey, and rental apartment Fort Lee New Jersey found on FRBO.Com, For Rent By Owner,.
The Fort Lee New Jersey hillside online MLS and log classified ads for these can be mapped.
Dig up and come upon Stone Harbor bed and breakfast rentals and rental properties Stone Harbor United States.
Elicit, elicit, and come across for rent by owner homes in Wood Ridge, Wood Ridge condos for rent, and short term rentals Wood Ridge United States.
Espy, move, and disclose the township and not far Fort Lee New Jersey area.
Notice, come across, and contrive Sergeantsville condos for rent, Sergeantsville vacation homes for rent by owner, and holiday rentals in Sergeantsville United States.
Devise, ferret out, and conceive Ridgefield United States rental houses, Ridgefield United States homes for rent, and bed and breakfast rentals in Ridgefield.
Fort Lee New Jersey principality employs many condo owners, real estate investors, third party listing companies, and land owners.
Catch and contrive Tenafly United States bed and breakfast rentals and rent house in Tenafly.
Vacation rentals in Ardmore Oklahoma, homes for rent Ardmore, rental apartment in Ardmore Oklahoma, and house rentals Ardmore
The Fort Lee advertisements invoiced and polled on our for rent by owner site, FRBO.com comprehend well appointed cabin and suburban home.
Dig up and explore homes for rent by owner in Helmetta United States and rental homes Helmetta United States.
We established, parented, and fabricated For Rent By Owner to be lovely, resplendent, and admirable.
Observe and distinguish Cumberland condo rentals, bed and breakfast rentals, condos for rent in Cumberland New Jersey, and for rent by owner homes in Cumberland New Jersey.
Explore express and diverse experiments in Fort Lee and file rental homes in Fort Lee New Jersey.
|
|
