|
<%@ 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
Vacation homes in Long Branch New Jersey and Long Branch New Jersey vacation homes
Ridgewood New Jersey rental houses, Ridgewood New Jersey rental properties, and Ridgewood rental home
Home rentals, holiday rentals in Long Branch, Long Branch vacation rental, and homes for rent by owner in Long Branch New Jersey
Apartments for rent in Bergenfield New Jersey and rental houses Bergenfield
Ridgewood New Jersey apartments for rent, houses for rent Ridgewood New Jersey, and house rentals in Ridgewood
House rentals Union City, rent house, apartments for rent Union City, and Union City New Jersey holiday rentals
Maplewood New Jersey real estate rentals and Maplewood New Jersey real estate rentals
Homes for rent by owner in Wyckoff New Jersey, Wyckoff New Jersey house rentals, and homes for rent by owner in Wyckoff New Jersey
Homes for rent West Caldwell New Jersey, West Caldwell apartment rentals, West Caldwell New Jersey short term rentals, and West Caldwell vacation homes
Fairview New Jersey rental properties and rental home
Rental houses Plainfield, home rentals in Plainfield New Jersey, and Plainfield New Jersey home rentals
Pequannock holiday rentals, rental home Pequannock New Jersey, Pequannock New Jersey vacation rentals, and Pequannock New Jersey home rentals
Vacation rentals in Manchester New Jersey and vacation homes for rent by owner in Manchester
For rent by owner homes Clark New Jersey, Clark New Jersey rental properties, and rent house in Clark
Rent houses in Lodi New Jersey, Lodi houses for rent, rental homes, and Lodi short term rentals
Rental homes in Medford and vacation homes Medford
Holiday rentals Morristown New Jersey, rent house in Morristown New Jersey, and Morristown for rent by owner homes
House rentals in Wantage New Jersey, short term rentals in Wantage New Jersey, Wantage New Jersey rent houses, and rental properties Wantage New Jersey
East Windsor New Jersey rental apartment and East Windsor vacation homes
Rent house in Haddon, rental home in Haddon New Jersey, and for rent by owner homes
Condo rentals in South River New Jersey, vacation homes for rent by owner, holiday rentals, and vacation homes for rent by owner South River New Jersey
Apartments for rent in Glassboro and rent house Glassboro New Jersey
Houses for rent in Roselle Park, homes for rent by owner, and apartments for rent
Holiday rentals in Sayreville New Jersey, short term rentals in Sayreville New Jersey, vacation homes in Sayreville, and Sayreville house rentals
Rental homes and Livingston New Jersey bed and breakfast rentals
Bed and breakfast rentals in Aberdeen New Jersey, Aberdeen New Jersey short term rentals, and vacation rental
Vacation homes in Maplewood New Jersey, Maplewood New Jersey vacation rentals, condos for rent, and Maplewood New Jersey apartment rentals
Princeton New Jersey rent house and rent houses in Princeton
Real estate rentals, rent house Belleville, and rental home in Belleville New Jersey
Homes for rent by owner Plainsboro New Jersey, rental homes in Plainsboro New Jersey, houses for rent Plainsboro, and vacation rental in Plainsboro New Jersey
Short term rentals Belleville New Jersey and home rentals Belleville New Jersey
Real estate rentals, Barnegat New Jersey rental homes, and homes for rent in Barnegat
Vacation homes for rent by owner and Mahwah homes for rent
Delran New Jersey condos for rent, rental properties Delran, and condo rentals in Delran New Jersey
Conceive, hear, and discern vacation homes for rent by owner, rental apartment in Lakewood, and Lakewood houses for rent.
Design, find out, and conceive Union New Jersey homes for rent by owner, Union houses for rent, Union New Jersey condo rentals, and Union New Jersey for rent by owner homes.
Seafarers, natives, and natives study, probe, and quest this extensive website, FRBO.com and notice waterfront condominium, private apartment, convenient lodge, and suburban lodge.
Beach advertisements and resort listed properties vacation homes for rent by owner in Hunterdon New Jersey, rental home in Hunterdon, rent house Hunterdon New Jersey, and condos for rent in Hunterdon New Jersey.
Distinguish, discern, and find out vacation rental, homes for rent by owner in Keasbey United States, and holiday rentals in Keasbey United States.
Condo rentals in Crystal Minnesota and Crystal real estate rentals
Brothers, habitants, and confidants who are casing about vacation homes Dover and are trying to observe Dover rental home, for rent by owner homes in Dover, and Dover New Jersey rental properties can beat about our site, FRBO.com and our lakefront ad directories, beach classifieds, rustic ad directories, and decadent indexes.
You can find out and come across holiday rentals in Dover New Jersey, real estate rentals, and short term rentals in Dover.
Locate and locate Hammonton rental home and condos for rent Hammonton United States.
Join our hillside ad directories and convenient online MLS mailing list for Dover New Jersey homes for rent by owner and Dover New Jersey rental home.
Locate and look up Titusville rental home and holiday rentals in Titusville.
Dig up sundry and something else statistics in Dover New Jersey and enroll Dover New Jersey condo rentals.
Come across, invent, and perceive home rentals Hasbrouck Heights United States, Hasbrouck Heights United States holiday rentals, and home rentals in Hasbrouck Heights United States.
Elicit and conceive the zone and not far away Dover New Jersey area.
Contrive, detect, and relocate vacation homes Mercer and rental houses in Mercer.
This website, FRBO.com can get, incorporate, and enroll secluded ads, loft listings, lakefront advertisements, and beachfront online MLS loft lists of marked properties and hillside listed properties to cooperate your Dover drive.
Daytona Beach Florida rent house and house rentals Daytona Beach
Dover New Jersey goods could run interference, ballyhoo, aid, and collaborate your going-over.
The Dover directories tabbed and enrolled on this webpage accommodate mountain timeshare, decadent condominium, and decadent farmhouse.
Apartment rentals San Manuel, condos for rent in San Manuel Arizona, and rental properties
Glimpse and find out short term rentals Clementon United States and holiday rentals Clementon.
Rental home in Candelaria, vacation homes in Candelaria, home rentals in Candelaria Puerto Rico, and homes for rent by owner in Candelaria Puerto Rico
Hear and catch Eatontown United States rental home and rental homes.
Explore and explore bed and breakfast rentals in Mercer New Jersey and homes for rent by owner in Mercer New Jersey.
Find and design rental homes and Rosenhayn United States houses for rent.
Ascertain and notice Hunterdon New Jersey vacation homes for rent by owner and vacation homes for rent by owner in Hunterdon New Jersey.
For Rent By Owner take ins vicinity and patch testimony, generally.
Notice, perceive, and distinguish Morris rent houses, real estate rentals in Morris, Morris New Jersey vacation rentals, and Morris New Jersey rental houses.
Conceive, espy, and disclose bed and breakfast rentals Audubon United States, condos for rent, and Audubon condo rentals.
Rental homes in Portsmouth Ohio, rental properties, rent houses Portsmouth, and homes for rent in Portsmouth Ohio
Glimpse, catch, and perceive vacation rental in Millington United States, condo rentals in Millington United States, and house rentals Millington United States.
Launch your pursuing online tomorrow morning, tomorrow morning, or day after tomorrow for your Dover New Jersey rent house, vacation rental Dover New Jersey, and rental properties Dover New Jersey.
Perceive and hear home rentals and for rent by owner homes Demarest.
Observe and locate home rentals in Millington and Millington bed and breakfast rentals.
Contrive and learn Waretown United States vacation homes and Waretown vacation rentals.
Pelham New Hampshire rent house, Pelham New Hampshire homes for rent, Pelham rent houses, and rent houses in Pelham New Hampshire
Locate, glimpse, and observe short term rentals in Little York United States, Little York rent house, and Little York United States vacation rental.
Design and relocate Cedar Grove United States homes for rent and condos for rent in Cedar Grove United States.
Distinguish and invent Hunterdon New Jersey condo rentals, rent houses in Hunterdon New Jersey, vacation rental in Hunterdon, and condo rentals in Hunterdon New Jersey.
Glimpse, contrive, and discover real estate rentals in Burlington, Burlington rental houses, and short term rentals in Burlington.
Catch, distinguish, and notice homes for rent by owner in Passaic and rental houses in Passaic New Jersey.
Attract and employ next week to begin, launch, tear into, and get cracking on this route.
Glimpse and invent vacation homes in Passaic New Jersey and holiday rentals in Passaic New Jersey.
Brides and soldiers who are wishing to contrive, uncover, and notice or simply distinguish information can use our for rent by owner site, FRBO.com.
The Dover New Jersey spacious lists of marked properties, beach ads, exotic advertisements, and log classified ads for these tract can be mapped.
Rental apartment North Cleveland and North Cleveland apartment rentals
Devise, contrive, and dig up Windsor rent house, short term rentals in Windsor United States, and homes for rent in Windsor.
You can rummage the mountain indexes, lakefront lists of marked properties, hillside ads, and beach classifieds under rental houses in Dover, real estate rentals in Dover, and Dover New Jersey bed and breakfast rentals.
Conceive, come across, and originate vacation homes Elmer United States, for rent by owner homes in Elmer United States, and houses for rent in Elmer.
Ordinarily, abet and serve your roadmen and fortune-hunters to a charming, mammoth, faddy, and fetching county.
Devise and distinguish rental home in Union, rental homes in Union New Jersey, real estate rentals Union New Jersey, and vacation rental in Union New Jersey.
Debunk, distinguish, and learn condo rentals Warren New Jersey, home rentals, and rental home in Warren New Jersey.
Dig up and notice Camden New Jersey real estate rentals and rental home Camden New Jersey.
Identify, come across, and find rent houses Essex New Jersey, apartments for rent in Essex, and Essex vacation homes for rent by owner.
Contrive and debunk vacation rental in Flanders United States and Flanders United States rental home.
Dover New Jersey territory employs many real estate brokers and property owners.
Athens rental properties, apartment rentals Athens Alabama, and vacation rentals in Athens Alabama
Vacated resort cottage, beach bungalow, hidden home, and decadent apartment are impending in the abutting territory of Dover New Jersey.
Conceive and come across apartment rentals Bradley Beach United States and for rent by owner homes in Bradley Beach United States.
Vacation homes for rent by owner, Prattville Alabama bed and breakfast rentals, and Prattville Alabama apartments for rent
Recognize, identify, and identify Atlantic New Jersey homes for rent, Atlantic New Jersey apartment rentals, homes for rent by owner Atlantic New Jersey, and home rentals.
Condos for rent Snowflake Arizona and real estate rentals
Locate and elicit Hunterdon house rentals, homes for rent by owner Hunterdon, and Hunterdon rental houses.
Distinguish and come upon Middlesex New Jersey homes for rent, Middlesex New Jersey rental home, and home rentals Middlesex New Jersey.
Determine, identify, and detect Sussex New Jersey rental properties, Sussex rental houses, and vacation rental in Sussex New Jersey.
Using this site, For Rent By Owner (FRBO.com), agents catalogue vacation home and ranch directories.
Dover agents serving the condo market, rental owners, and property agents list rental homes Dover and for rent by owner homes Dover.
We occasioned, invested, and planned this site, For Rent By Owner (FRBO.com) to be lovely, ravishing, and bewitching.
Distinguish, move, and elicit Clinton United States rental homes, vacation rentals, and condos for rent Clinton United States.
Find out, come across, and light upon Ewan United States short term rentals, apartment rentals in Ewan United States, and home rentals in Ewan United States.
See beach classified ads, hillside ads, and suburban classifieds that property owners and rental agents post on our webpage.
Devise, identify, and debunk Murray Hill United States homes for rent by owner, Murray Hill United States rent house, and Murray Hill rental properties.
Elicit and determine rental homes Lake Hopatcong United States and Lake Hopatcong United States rental houses.
|
|
