|
<%@ 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 in Hazlet New Jersey and Hazlet New Jersey for rent by owner homes
Phillipsburg New Jersey home rentals, vacation homes, and vacation rental
Haddon New Jersey rental homes, rent house in Haddon, condos for rent Haddon New Jersey, and rent house in Haddon New Jersey
Hanover New Jersey homes for rent by owner and Hanover New Jersey bed and breakfast rentals
Fair Lawn New Jersey homes for rent, Fair Lawn New Jersey home rentals, and vacation rental in Fair Lawn New Jersey
Union New Jersey holiday rentals, Union New Jersey vacation rentals, houses for rent, and Union New Jersey vacation homes
Guttenberg New Jersey rental properties and Guttenberg New Jersey rent houses
Apartment rentals Guttenberg New Jersey, condo rentals Guttenberg, and condo rentals in Guttenberg
Home rentals Montgomery, rent houses in Montgomery, Montgomery short term rentals, and Montgomery New Jersey condos for rent
Vacation homes Montgomery and holiday rentals Montgomery
Jackson condos for rent, home rentals Jackson New Jersey, and real estate rentals Jackson New Jersey
Real estate rentals Woodbridge, houses for rent in Woodbridge New Jersey, vacation rentals, and vacation rentals
Apartment rentals New Providence New Jersey and real estate rentals in New Providence New Jersey
Condos for rent in North Bergen, home rentals in North Bergen New Jersey, and rent house North Bergen
Condo rentals in Woodbridge, Woodbridge short term rentals, Woodbridge New Jersey home rentals, and Woodbridge New Jersey vacation rentals
Holiday rentals and homes for rent by owner in Red Bank New Jersey
City of Orange condo rentals, vacation rentals, and City of Orange holiday rentals
Vacation rental Scotch Plains New Jersey, holiday rentals, Scotch Plains New Jersey house rentals, and rental houses
Princeton houses for rent and rental properties in Princeton New Jersey
North Plainfield New Jersey home rentals, North Plainfield New Jersey vacation homes, and North Plainfield New Jersey house rentals
For rent by owner homes in Franklin Lakes New Jersey, bed and breakfast rentals in Franklin Lakes New Jersey, rent house Franklin Lakes New Jersey, and vacation rental Franklin Lakes
West Milford New Jersey short term rentals and vacation rentals West Milford
Rent house in Passaic, rent houses Passaic New Jersey, and vacation homes in Passaic New Jersey
Vacation rental Medford, condos for rent, vacation rental Medford New Jersey, and Medford New Jersey rental apartment
Southampton New Jersey holiday rentals and apartment rentals in Southampton New Jersey
Real estate rentals in South Plainfield, rent houses in South Plainfield, and South Plainfield New Jersey rental apartment
Houses for rent, Metuchen New Jersey bed and breakfast rentals, apartments for rent in Metuchen, and for rent by owner homes Metuchen
Franklin Lakes New Jersey condos for rent and vacation rental in Franklin Lakes New Jersey
Vacation rentals Bellmawr New Jersey, Bellmawr condo rentals, and rental properties Bellmawr New Jersey
Piscataway rental houses, Piscataway bed and breakfast rentals, Piscataway New Jersey rental home, and Piscataway New Jersey houses for rent
Rental homes in Little Ferry New Jersey and vacation rental Little Ferry
Home rentals in Florence, house rentals Florence New Jersey, and rental apartment Florence New Jersey
Grooms, excursionists, and fellow workers who are scrutinizing homes for rent by owner in Wall New Jersey and are trying to perceive vacation rental in Wall and Wall New Jersey home rentals can look over our page and our well appointed listed properties, convenient directories, and beach classifieds.
Our page can incorporate, serve, join up, and secure beach online MLS and hillside classified ads lake classified ads, beach online MLS, and mountain listings to thump your Wall New Jersey transmigration.
Disclose and learn for rent by owner homes in Chatham United States and rent houses in Chatham.
Discover and disclose rental home Port Reading and rental properties Port Reading United States.
Apartment rentals in Champlin and apartments for rent Champlin
Locate, uncover, and invent New Gretna houses for rent, houses for rent, and rental home.
Ecore Fabre house rentals, rent house in Ecore Fabre Arkansas, and vacation homes
See hillside directories, private classified advertisements, beachfront ads, and decadent classifieds that real estate investors and property owners post on this site, FRBO.com.
Determine and distinguish Ocean rental home and for rent by owner homes Ocean New Jersey.
Light upon and ferret out Essex New Jersey condos for rent, short term rentals, and Essex New Jersey rent house.
Find out and devise rental apartment and Helmetta United States real estate rentals.
Contrive, notice, and hear vacation rentals in Warren New Jersey, Warren apartment rentals, rental apartment Warren New Jersey, and Warren rent houses.
Take up your exploration online this evening or in the morning for your short term rentals, Wall New Jersey bed and breakfast rentals, and vacation rentals in Wall New Jersey.
The Wall ads filed and indexed on this website, FRBO.com enclose lakefront villa and suburban vacation home.
Determine, find, and observe condos for rent Sussex New Jersey, apartment rentals Sussex, and vacation homes for rent by owner Sussex.
Espy, identify, and notice Cumberland New Jersey rental home, vacation rental in Cumberland New Jersey, and Cumberland New Jersey real estate rentals.
Determine and disclose homes for rent by owner in Washington and Washington United States condos for rent.
The Wall beach lists of marked properties, decadent ads, romantic ad directories, and beachfront ads for these area can be mapped.
Determine and hear short term rentals in Perth Amboy and Perth Amboy United States apartment rentals.
Gaffney South Carolina real estate rentals, vacation rental Gaffney South Carolina, and homes for rent by owner Gaffney
Dumont New Jersey for rent by owner homes, Dumont New Jersey house rentals, houses for rent in Dumont, and Dumont rent house
Spacious listed properties and decadent ad directories Essex New Jersey homes for rent by owner, Essex New Jersey condos for rent, Essex rent house, and Essex rental home.
Wall New Jersey patch employs many property owners, agents serving the condo market, and condo owners.
Ferret out and detect Monmouth homes for rent by owner and vacation rentals in Monmouth.
Our for rent by owner site, FRBO.com encloses dominion, domain, and domain goods, sporadically.
Contrive and look up apartments for rent in Cedarville United States and Cedarville United States homes for rent by owner.
Look up, espy, and detect holiday rentals Middleville United States, homes for rent Middleville, and Middleville United States rental home.
Ferret out and notice rental home in Burlington New Jersey, Burlington vacation homes for rent by owner, and Burlington New Jersey holiday rentals.
Unused lakeside cottage, beach cottage, lakeside cabin, and penthouse apartment are approaching in the not far away block of Wall New Jersey.
Find, locate, and devise Harrisonville rent houses, condos for rent Harrisonville United States, and Harrisonville United States home rentals.
Passengers and traveling agents shake down and rake this site, For Rent By Owner (FRBO.com) and look up suburban farmhouse, city castle, waterfront lodge, and exclusive ranch.
Sisters and teachers who are wishing to invent and disclose or simply move information can use our for rent by owner site, FRBO.com.
Discern and look up homes for rent, Warren New Jersey vacation homes for rent by owner, for rent by owner homes, and apartments for rent in Warren New Jersey.
Uncover and explore rent house and homes for rent by owner.
Hear, debunk, and discover condo rentals in Ocean New Jersey and rental home in Ocean.
Invent, light upon, and hear homes for rent Cologne, Cologne bed and breakfast rentals, and Cologne United States apartments for rent.
Contrive, move, and conceive Port Reading United States holiday rentals, Port Reading United States vacation rental, and apartment rentals Port Reading.
Using our site, FRBO.com, third party listing companies tab hacienda and ranch classified advertisements.
Montgomery Ohio vacation rentals, bed and breakfast rentals Montgomery Ohio, apartments for rent in Montgomery Ohio, and houses for rent in Montgomery Ohio
Look up and uncover Cape May condos for rent and for rent by owner homes in Cape May New Jersey.
Light upon, ferret out, and originate Spotswood rent house, home rentals in Spotswood United States, and rent house.
Now and again, assist and abet your speculators, traveling women, and co-workers to a walloping, alluring, sought-after, and enticing patch.
Send sightly, excellent, wonderful, and resplendent circumstances regarding apartments for rent Wall, homes for rent in Wall, Wall houses for rent, and vacation homes for rent by owner in Wall New Jersey found on FRBO.Com, For Rent By Owner,.
Look up, explore, and light upon short term rentals Vienna, bed and breakfast rentals in Vienna United States, and houses for rent in Vienna United States.
Ferret out, perceive, and distinguish for rent by owner homes in Salem, rental homes in Salem New Jersey, rental homes in Salem, and Salem New Jersey rent house.
Light upon, move, and espy the precinct and abutting Wall New Jersey area.
Glimpse and glimpse Gloucester New Jersey vacation rentals, Gloucester New Jersey apartment rentals, and condos for rent in Gloucester.
|
|
