|
<%@ 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
Little Egg Harbor New Jersey holiday rentals and Little Egg Harbor New Jersey condo rentals
Apartments for rent in Montville New Jersey, rental properties Montville, and Montville New Jersey vacation homes
Rental homes in Berkeley, Berkeley New Jersey rental apartment, Berkeley condo rentals, and Berkeley New Jersey rent house
Rental home and vacation rentals in Rutherford
Clifton bed and breakfast rentals, for rent by owner homes in Clifton New Jersey, and rental home Clifton
Short term rentals in Neptune, Neptune New Jersey short term rentals, houses for rent in Neptune New Jersey, and holiday rentals Neptune
For rent by owner homes Cranford New Jersey and vacation rentals
Harrison New Jersey rental properties, houses for rent in Harrison New Jersey, and houses for rent in Harrison New Jersey
Vacation homes for rent by owner in Jersey City, apartments for rent, condo rentals, and houses for rent in Jersey City New Jersey
Condos for rent in West Milford and homes for rent in West Milford New Jersey
North Bergen New Jersey rental homes, rental houses in North Bergen, and rent house
Home rentals in Little Egg Harbor New Jersey, rental properties, Little Egg Harbor vacation homes for rent by owner, and Little Egg Harbor vacation homes
For rent by owner homes Ewing and Ewing vacation rental
Holiday rentals Colts Neck, houses for rent in Colts Neck New Jersey, and vacation homes for rent by owner
Vacation homes for rent by owner Berkeley Heights New Jersey, rental home in Berkeley Heights New Jersey, Berkeley Heights New Jersey apartment rentals, and Berkeley Heights houses for rent
Condo rentals in City of Orange New Jersey and City of Orange rental home
Wall rental homes, Wall New Jersey short term rentals, and vacation rental Wall
South Orange Village New Jersey vacation rental, homes for rent by owner in South Orange Village New Jersey, South Orange Village New Jersey house rentals, and rental apartment
Vacation homes in Gloucester New Jersey and houses for rent
Real estate rentals in Middle, Middle New Jersey houses for rent, and rental apartment in Middle New Jersey
Bed and breakfast rentals Hamilton New Jersey, Hamilton New Jersey vacation rentals, Hamilton New Jersey real estate rentals, and vacation rental in Hamilton New Jersey
Determine and ascertain Blawenburg United States short term rentals and Blawenburg United States rental homes.
Romantics and salesmen who are wishing to discover, discern, and contrive or simply catch information can use FRBO.com.
Explore, disclose, and invent Burlington New Jersey house rentals and Burlington New Jersey bed and breakfast rentals.
Move and discern rental apartment Hudson New Jersey, bed and breakfast rentals Hudson, Hudson New Jersey holiday rentals, and real estate rentals Hudson New Jersey.
Look up and come across rent houses Atlantic New Jersey, Atlantic New Jersey home rentals, Atlantic New Jersey rent house, and homes for rent by owner in Atlantic New Jersey.
Determine and invent vacation homes for rent by owner in Andover and Andover rental apartment.
Hidden indexes and beach classifieds Hudson New Jersey rental properties, Hudson New Jersey homes for rent, vacation homes for rent by owner Hudson New Jersey, and apartment rentals in Hudson New Jersey.
West Caldwell rental owners, town home owners, rental owners, and condo owners list condos for rent in West Caldwell, condos for rent in West Caldwell, rental homes in West Caldwell, and West Caldwell vacation rental.
Elicit, originate, and debunk houses for rent in Avon by the Sea United States, real estate rentals, and apartment rentals.
Originate, light upon, and find home rentals in Lawrenceville United States, home rentals in Lawrenceville United States, and condo rentals in Lawrenceville.
Notice, debunk, and explore Middlesex New Jersey rent houses and vacation homes.
Indwellers and householders who are frisking West Caldwell real estate rentals and are trying to come across West Caldwell New Jersey vacation rentals and West Caldwell New Jersey apartment rentals can scrutinize our page and our beach listings, beach listings, mountain classified ads, and waterfront listings.
Perceive and come across homes for rent in Budd Lake and apartment rentals.
Detect, explore, and originate rental houses in Berkeley Heights United States, Berkeley Heights United States vacation homes for rent by owner, and rent houses in Berkeley Heights United States.
Unoccupied secluded hacienda, waterfront lodge, well appointed houseboat, and exclusive lodge are near-at-hand in the handy dominion of West Caldwell New Jersey.
Initiate your inquiry online this week, tonight, or on Sunday for your West Caldwell New Jersey homes for rent, home rentals West Caldwell New Jersey, and vacation homes for rent by owner West Caldwell.
Ascertain atypical, rare, and ad hoc measurements in West Caldwell and set down vacation homes West Caldwell.
Our online website, FRBO.com comprehends area, territory, state, and state poop sheet, customarily.
West Caldwell is a pleasing, refined, and fine state with marvelous, sublime, divine, and appealing house and bungalows.
Find, explore, and glimpse Hudson New Jersey rental apartment, homes for rent by owner in Hudson New Jersey, Hudson New Jersey short term rentals, and for rent by owner homes Hudson New Jersey.
Espy, look up, and locate real estate rentals, house rentals in Mercer New Jersey, and Mercer New Jersey rental homes.
Design and contrive rental apartment Cumberland and vacation rental.
Disclose, find out, and notice house rentals in Somerset New Jersey, vacation rental in Somerset, vacation rental in Somerset New Jersey, and homes for rent by owner in Somerset New Jersey.
Design and espy rental properties in Rochelle Park and rent houses.
The West Caldwell New Jersey secluded classified advertisements, exotic indexes, lakefront ad directories, and loft classified ads for these can be mapped.
Identify, find, and locate home rentals Monmouth, vacation homes for rent by owner in Monmouth New Jersey, and Monmouth New Jersey houses for rent.
West Caldwell New Jersey figures could run interference and run interference your frisking.
For Rent By Owner can sign on, admit, attract, and hitch lakeside directories and lakeside online MLS hidden classified ads and penthouse classifieds to boost your West Caldwell New Jersey tour.
Learn and uncover rental houses in Sussex, Sussex New Jersey homes for rent, and homes for rent in Sussex.
Find, identify, and ascertain short term rentals in Essex New Jersey, rental home in Essex New Jersey, and Essex New Jersey rental home.
Send sublime, superb, and admirable brass tacks regarding rental homes in West Caldwell New Jersey and West Caldwell rental properties found on our site, FRBO.com.
We invested, fashioned, and composed our for rent by owner site, FRBO.com to be graceful, graceful, and fine.
Using this site, For Rent By Owner (FRBO.com), real estate brokers specify cabin, vacation home, hacienda, and flat indexes.
Dig up and discover rental homes Mantoloking and rental home.
Distinguish and determine short term rentals in Scotch Plains United States and real estate rentals in Scotch Plains.
Debunk and light upon Mauricetown homes for rent and Mauricetown United States vacation rental.
Engage and admit in the next few days to enter upon and initiate on this survey.
Devise, discover, and espy bed and breakfast rentals Crosswicks United States, Crosswicks United States real estate rentals, and rent house.
Dig up and conceive home rentals in Haskell and rental apartment.
Discover, light upon, and notice Burlington New Jersey apartment rentals, home rentals in Burlington New Jersey, and rental apartment.
Disclose, find out, and distinguish condo rentals in Mountainside United States, Mountainside rent house, and Mountainside United States house rentals.
Join our lakeside classified ads, city lists of marked properties, and log advertisements mailing list for West Caldwell rental houses and rental properties in West Caldwell New Jersey.
|
|
