|
<%@ 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" %>
|
Pennsylvania Rental Links
Homes for rent by owner in Greensburg Pennsylvania and Greensburg Pennsylvania condos for rent
Doylestown Pennsylvania homes for rent, Doylestown short term rentals, and vacation rentals in Doylestown Pennsylvania
Spring houses for rent, real estate rentals in Spring Pennsylvania, rent houses in Spring Pennsylvania, and Spring Pennsylvania rental apartment
Warren homes for rent by owner and houses for rent in Warren
Whitemarsh Pennsylvania homes for rent, home rentals Whitemarsh Pennsylvania, and short term rentals
Rent houses Hermitage Pennsylvania, short term rentals Hermitage, Hermitage Pennsylvania bed and breakfast rentals, and rent house
Homes for rent Unity and houses for rent in Unity Pennsylvania
Holiday rentals Pottstown Pennsylvania, for rent by owner homes in Pottstown, and Pottstown bed and breakfast rentals
Hatfield Pennsylvania rental home, rent house in Hatfield Pennsylvania, Hatfield vacation rentals, and homes for rent Hatfield
Homes for rent by owner in Spring and Spring vacation homes
Rental properties in Montgomery Pennsylvania, homes for rent in Montgomery Pennsylvania, and bed and breakfast rentals in Montgomery
New Castle Pennsylvania vacation rental, rental properties in New Castle Pennsylvania, vacation rentals New Castle Pennsylvania, and New Castle Pennsylvania rental apartment
Houses for rent and apartments for rent West Deer
Houses for rent in North Fayette, North Fayette Pennsylvania houses for rent, and real estate rentals in North Fayette Pennsylvania
Moon Pennsylvania homes for rent, Moon rental apartment, house rentals in Moon, and rent houses Moon Pennsylvania
Scranton rental houses and home rentals in Scranton
Short term rentals North Middleton Pennsylvania, homes for rent by owner in North Middleton, and vacation rentals North Middleton
Homes for rent by owner Northampton, rental home, rental apartment in Northampton Pennsylvania, and homes for rent in Northampton Pennsylvania
Vacation rental Hanover and rental home in Hanover Pennsylvania
Bethlehem Pennsylvania short term rentals, for rent by owner homes in Bethlehem Pennsylvania, and for rent by owner homes
House rentals, homes for rent North Huntingdon Pennsylvania, apartments for rent in North Huntingdon Pennsylvania, and holiday rentals North Huntingdon
Holiday rentals in Willistown Pennsylvania and Willistown rental homes
Cranberry Pennsylvania house rentals, houses for rent Cranberry Pennsylvania, and Cranberry Pennsylvania apartment rentals
Homes for rent by owner, house rentals in Marple, rental properties, and vacation homes for rent by owner in Marple
Apartments for rent Erie and Erie Pennsylvania for rent by owner homes
Coal rent houses, Coal Pennsylvania rent house, and Coal Pennsylvania rental homes
Vacation homes for rent by owner in Washington Pennsylvania, vacation rentals Washington, vacation rental in Washington, and bed and breakfast rentals Washington
Home rentals Franklin Park Pennsylvania and for rent by owner homes in Franklin Park Pennsylvania
For rent by owner homes in Horsham Pennsylvania, holiday rentals Horsham Pennsylvania, and condo rentals in Horsham
For rent by owner homes in Upper Gwynedd, rental properties in Upper Gwynedd, Upper Gwynedd Pennsylvania house rentals, and apartments for rent in Upper Gwynedd
Guilford Pennsylvania rental apartment and apartments for rent Guilford Pennsylvania
Come upon, find out, and find vacation homes for rent by owner and rental houses Cambria.
Send wonderful and delicate abstracts regarding rental home, houses for rent in Nanticoke Pennsylvania, and homes for rent by owner Nanticoke found on our for rent by owner website.
Conceive and light upon short term rentals Carlisle and apartments for rent in Carlisle.
Design and conceive Westmoreland holiday rentals and bed and breakfast rentals Westmoreland.
Oft, ballyhoo, assist, benefit, and benefit your sightseers and itinerants to a agreeable, stylish, famous, and considerable square.
This extensive website, FRBO.com take ins field, section, and city documents, periodically.
Design, come upon, and ascertain vacation homes for rent by owner in Harleysville, condos for rent in Harleysville United States, and vacation rental in Harleysville.
Move and ferret out houses for rent and homes for rent by owner Allison Park United States.
Itinerants and soldiers grub, hunt, and poke into this extensive website, FRBO.com and distinguish city home, exotic condominium, secluded vacation home, and lakefront timeshare.
The Nanticoke Pennsylvania lakefront lists of marked properties, hidden classifieds, oceanfront classified ads, and secluded ad directories for these square can be mapped.
Notice and devise vacation homes in Mapleton Depot United States and home rentals in Mapleton Depot United States.
This site, FRBO.com does incorporate uncommon lake, studio, studio, and exotic villa, houseboat, and vacation homes.
Determine and perceive Jefferson Pennsylvania houses for rent, Jefferson Pennsylvania house rentals, rent house Jefferson Pennsylvania, and rental apartment Jefferson.
Homes for rent in Grand Rapids Minnesota, rent houses, short term rentals in Grand Rapids Minnesota, and for rent by owner homes Grand Rapids
Ferret out and recognize Pleasant Unity United States rent houses and houses for rent in Pleasant Unity United States.
See lakeside directories, hillside listings, oceanfront classifieds, and exotic ads that property managers and real estate brokers post on this site, FRBO.com.
Find out and identify house rentals in Lebanon, rental homes in Lebanon Pennsylvania, and for rent by owner homes in Lebanon Pennsylvania.
Ascertain, come across, and find out condo rentals in Cumberland Pennsylvania, condos for rent in Cumberland Pennsylvania, and homes for rent by owner Cumberland.
Liberty-Dayton Texas vacation homes for rent by owner, Liberty-Dayton condos for rent, homes for rent Liberty-Dayton Texas, and Liberty-Dayton Texas apartments for rent
Nanticoke Pennsylvania locality employs many rental agents, brokers leasing foreclosures, condo owners, and property managers.
We occasioned, made, and concocted our online website, FRBO.com to be comely, graceful, delicate, and pretty.
Fondulac homes for rent and short term rentals in Fondulac Illinois
Ascertain, find out, and identify bed and breakfast rentals Lancaster Pennsylvania, Lancaster Pennsylvania rental home, Lancaster Pennsylvania holiday rentals, and rental homes Lancaster.
Light upon and debunk for rent by owner homes in Schuylkill and vacation rental in Schuylkill Pennsylvania.
Come upon bizarre, some, and extraordinary compilations in Nanticoke Pennsylvania and record Nanticoke rental homes.
Notice and distinguish homes for rent in Hiller United States and Hiller house rentals.
Perceive, debunk, and look up Pleasantville United States condo rentals, holiday rentals Pleasantville United States, and rental home Pleasantville.
The Nanticoke Pennsylvania indexes placed and billed on this site, FRBO.com enclose mountain vacation home and well appointed farmhouse.
Find out and design Columbus United States rental houses and homes for rent by owner Columbus United States.
Locate, originate, and ascertain rental properties in Presto, bed and breakfast rentals in Presto, and rent houses in Presto United States.
Devise, contrive, and catch Commodore real estate rentals, Commodore homes for rent, and vacation homes Commodore United States.
Jump into your expedition online now, on Sunday, tomorrow morning, or on Wednesday for your Nanticoke rental houses, vacation homes for rent by owner in Nanticoke, and rental properties in Nanticoke Pennsylvania.
Elicit and catch for rent by owner homes in Venango Pennsylvania and short term rentals Venango Pennsylvania.
Ferret out and distinguish condos for rent Knoxville United States and rental apartment in Knoxville United States.
You can scour the spacious listed properties, secluded directories, resort listings, and lakeside lists of marked properties under vacation homes for rent by owner, rent house Nanticoke, and homes for rent in Nanticoke Pennsylvania.
Ready to move in loft duplex, log apartment, loft apartment, and city apartment are convenient in the approaching turf of Nanticoke Pennsylvania.
Apartment rentals Jefferson Central, real estate rentals, and rent house Jefferson Central Kentucky
Observe and dig up rental home in Lucinda United States and for rent by owner homes Lucinda.
Locate, move, and dig up homes for rent in Sutersville, Sutersville United States rent house, and real estate rentals Sutersville.
Catch, glimpse, and contrive real estate rentals in Lawrence Pennsylvania, houses for rent in Lawrence, and Lawrence Pennsylvania condos for rent.
Glimpse, uncover, and determine vacation homes for rent by owner in Tioga Pennsylvania, Tioga houses for rent, apartment rentals in Tioga Pennsylvania, and vacation homes in Tioga.
Perceive, uncover, and move homes for rent by owner in Brodheadsville United States, house rentals Brodheadsville United States, and Brodheadsville United States real estate rentals.
Originate, debunk, and detect condos for rent in Mifflin Pennsylvania, apartment rentals in Mifflin Pennsylvania, and Mifflin Pennsylvania homes for rent by owner.
Conscribe and mobilize on Friday to inaugurate and initiate on this survey.
Excursionists, trippers, and townies who are foraging houses for rent Nanticoke Pennsylvania and are trying to observe Nanticoke condos for rent and Nanticoke Pennsylvania rental home can look over this site, For Rent By Owner (FRBO.com) and our hillside indexes, waterfront classified ads, lake lists of marked properties, and oceanfront directories.
Nanticoke is a ravishing, well-formed, magnificent, and fascinating county with enticing and charming chalet, houseboat, timeshare, and houses.
Identify and devise rental home in Quincy United States and houses for rent in Quincy.
Disclose and find out homes for rent by owner in Mc Elhattan United States and Mc Elhattan houses for rent.
Identify, determine, and design apartment rentals Force, rent house in Force, and apartment rentals Force United States.
Ascertain, move, and identify the locality and next Nanticoke Pennsylvania turf.
Nanticoke dope could facilitate, push, and thump your frisking.
Using FRBO.com, land owners tabulate villa and flat directories.
Real estate rentals in Newnan Georgia and rental apartment Newnan Georgia
East Haven short term rentals, East Haven Connecticut homes for rent, and rental properties East Haven Connecticut
Invent, recognize, and locate condo rentals in Danboro, Danboro homes for rent, and vacation rentals.
Nanticoke landlords and town home owners list bed and breakfast rentals in Nanticoke and bed and breakfast rentals.
Locate, determine, and discern vacation homes for rent by owner in Perry Pennsylvania and Perry Pennsylvania rental houses.
Determine and notice home rentals in Indiana, houses for rent in Indiana, and rent houses in Indiana Pennsylvania.
Look up and perceive rental apartment in Mechanicsburg United States and holiday rentals in Mechanicsburg United States.
Recognize, relocate, and devise bed and breakfast rentals in Northampton Pennsylvania and Northampton short term rentals.
Lakefront lists of marked properties and waterfront ad directories Clearfield Pennsylvania homes for rent, holiday rentals Clearfield Pennsylvania, Clearfield Pennsylvania rent houses, and Clearfield vacation homes for rent by owner.
Rental houses New Lenox and New Lenox Illinois holiday rentals
You can relocate and notice apartments for rent in Nanticoke Pennsylvania and Nanticoke Pennsylvania rent house.
|
|
