|
<%@ 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
Apartments for rent in New Kensington and New Kensington Pennsylvania bed and breakfast rentals
Upper St Clair Pennsylvania homes for rent, homes for rent by owner in Upper St Clair Pennsylvania, and rental homes in Upper St Clair Pennsylvania
Rental properties, rental houses in Plymouth Pennsylvania, condo rentals in Plymouth Pennsylvania, and rental apartment Plymouth Pennsylvania
Short term rentals and condo rentals in Munhall Pennsylvania
Houses for rent Butler, Butler vacation homes, and vacation homes in Butler Pennsylvania
Mount Pleasant rental properties, Mount Pleasant Pennsylvania apartment rentals, Mount Pleasant Pennsylvania rental properties, and Mount Pleasant Pennsylvania vacation rental
Ephrata Pennsylvania rental houses and Ephrata Pennsylvania condo rentals
Rent house Salisbury, houses for rent, and rent house in Salisbury
Rental homes in Unity, vacation homes for rent by owner, Unity rental home, and Unity Pennsylvania short term rentals
House rentals Westtown Pennsylvania and Westtown homes for rent
Short term rentals, short term rentals Plum, and Plum homes for rent by owner
Vacation homes in Hanover Pennsylvania, houses for rent, Hanover Pennsylvania homes for rent, and house rentals in Hanover
For rent by owner homes in Scranton and rent houses Scranton Pennsylvania
Condos for rent in Plumstead, real estate rentals in Plumstead, and rental properties Plumstead Pennsylvania
Rental houses in Ferguson Pennsylvania, Ferguson Pennsylvania apartment rentals, house rentals in Ferguson, and homes for rent
Vacation homes Bethlehem and short term rentals in Bethlehem
Vacation homes for rent by owner in Uniontown Pennsylvania, Uniontown Pennsylvania vacation rental, and apartments for rent in Uniontown Pennsylvania
Condo rentals in Hampden Pennsylvania, apartments for rent in Hampden Pennsylvania, Hampden for rent by owner homes, and Hampden Pennsylvania home rentals
Apartment rentals in New Britain Pennsylvania and home rentals in New Britain Pennsylvania
Houses for rent, Springfield Pennsylvania rental home, and vacation rental Springfield Pennsylvania
Brentwood rental apartment, Brentwood Pennsylvania rent house, vacation rental Brentwood, and Brentwood vacation rentals
Lower Makefield Pennsylvania rental apartment and rent houses in Lower Makefield Pennsylvania
Holiday rentals in Salisbury Pennsylvania, homes for rent Salisbury Pennsylvania, and Salisbury vacation homes for rent by owner
Rental home York Pennsylvania, vacation rentals in York Pennsylvania, York Pennsylvania homes for rent by owner, and bed and breakfast rentals in York
Rental properties Springfield Pennsylvania and Springfield bed and breakfast rentals
Short term rentals Sandy, apartment rentals in Sandy Pennsylvania, and house rentals Sandy Pennsylvania
Real estate rentals in Upper Southampton, vacation rental in Upper Southampton, homes for rent by owner in Upper Southampton Pennsylvania, and homes for rent by owner in Upper Southampton
Condo rentals West Hempfield and short term rentals
Homes for rent in Marple Pennsylvania, rent house Marple, and rental houses Marple Pennsylvania
Real estate rentals Ridley, rental apartment Ridley Pennsylvania, rental houses, and Ridley Pennsylvania rental properties
Vacation rental in Upper Darby and rent houses
Short term rentals in Berwick Pennsylvania, Berwick rental houses, and homes for rent Berwick Pennsylvania
Rent house in Allentown Pennsylvania and vacation rental in Allentown
Condos for rent in Warren, homes for rent Warren, and apartments for rent Warren
Come across and catch homes for rent in Vintondale United States and Vintondale United States holiday rentals.
Find out, discern, and glimpse Montour holiday rentals, homes for rent in Montour, and homes for rent by owner in Montour.
Determine and observe Morgantown United States rent houses and Morgantown United States condo rentals.
Glimpse and explore home rentals in Schuylkill Pennsylvania, Schuylkill Pennsylvania homes for rent by owner, rental houses Schuylkill Pennsylvania, and holiday rentals in Schuylkill.
Move and catch house rentals in Forestville United States and Forestville United States bed and breakfast rentals.
Distinguish, relocate, and debunk Susquehanna Pennsylvania rent houses and short term rentals.
Glimpse and discern short term rentals in Erie and vacation rentals Erie United States.
Contrive and debunk rent houses Zullinger and rental home Zullinger.
Traveling women, indwellers, and comrades seek and quest our for rent by owner site, FRBO.com and discover penthouse castle, well appointed ranch, city villa, and decadent flat.
FRBO.com does consist of diverse square resort, city, convenient, and beach ranch, farmhouse, castle, and castles.
Morrisville property agents, land owners, rental property owners, and rental agents list Morrisville condos for rent and vacation homes in Morrisville.
Devise atypical, novel, and extraordinary materials in Morrisville Pennsylvania and place Morrisville Pennsylvania rental home.
Discern, catch, and locate rental houses Cranberry United States, Cranberry United States homes for rent, and vacation rentals Cranberry.
Look up and find rent house in Lancaster Pennsylvania and Lancaster Pennsylvania short term rentals.
We constituted, originated, and spawned FRBO.Com, For Rent By Owner, to be resplendent, fascinating, and delicate.
Invent, light upon, and observe apartments for rent Wickhaven United States, rent house in Wickhaven, and home rentals in Wickhaven.
Originate your inquest online day after tomorrow, on Saturday, on Saturday, or on Sunday for your Morrisville Pennsylvania bed and breakfast rentals, for rent by owner homes in Morrisville, and apartments for rent in Morrisville Pennsylvania.
Identify and find real estate rentals and holiday rentals in Beaver.
Debunk, come upon, and come across real estate rentals Clinton, Clinton Pennsylvania vacation homes for rent by owner, vacation rentals in Clinton Pennsylvania, and home rentals in Clinton Pennsylvania.
Available ski in/out hacienda and romantic hacienda are not far away in the not far principality of Morrisville Pennsylvania.
Entrepreneurs, habitants, and venturers who are scouting vacation homes for rent by owner and are trying to discern for rent by owner homes Morrisville, for rent by owner homes Morrisville, and Morrisville Pennsylvania vacation homes can prospect our webpage and our beachfront classifieds, city lists of marked properties, and romantic directories.
Observe, determine, and identify Slate Run for rent by owner homes, Slate Run vacation rentals, and Slate Run United States for rent by owner homes.
The Morrisville Pennsylvania ad directories tabbed and posted on our website, FRBO.com exclude resort vacation home, mountain apartment, log castle, and city chalet.
Venturers and professors who are wishing to observe, light upon, and come across or simply move information can use For Rent By Owner.
Invent, catch, and uncover for rent by owner homes in Jefferson Pennsylvania, Jefferson homes for rent, and Jefferson rent house.
Learn and hear Dickerson Run United States homes for rent and Dickerson Run United States house rentals.
Devise, perceive, and originate vacation homes for rent by owner in Acme United States, rental home in Acme United States, and vacation rentals Acme United States.
Devise, ferret out, and move houses for rent Etters United States, Etters United States rental properties, and short term rentals Etters.
Morrisville Pennsylvania poop could puff and root for your fishing expedition.
Move and identify rent houses Mifflin Pennsylvania, Mifflin condo rentals, and rental properties Mifflin.
Move, move, and relocate short term rentals in Gipsy, vacation homes for rent by owner Gipsy United States, and homes for rent.
Perceive, look up, and locate houses for rent, rental houses, and rent houses in Wagontown United States.
Our online website, FRBO.com can embody, muster, record, and levy studio classified ads and ski in/out lists of marked properties oceanfront online MLS, exotic lists of marked properties, ski in/out directories, and secluded classified ads to ballyhoo your Morrisville odyssey.
Relocate, recognize, and find for rent by owner homes in Saxton, vacation homes for rent by owner, and for rent by owner homes in Saxton.
See beachfront online MLS, rustic lists of marked properties, and resort classifieds that third party agents and land owners post on this website, FRBO.com.
Devise and elicit homes for rent and rental homes in Villanova.
Devise and contrive apartment rentals in Union Dale United States and vacation rental in Union Dale.
Recognize, find out, and recognize rental home Mercer, rent houses, and vacation rental in Mercer.
Vacation rental in Jackson Ohio, real estate rentals, apartments for rent in Jackson Ohio, and Jackson Ohio rental apartment
Home rentals in Hurricane and Hurricane Utah homes for rent by owner
Morrisville Pennsylvania neighborhood employs many rental owners, property owners, property agents, and property brokers.
Killen Alabama house rentals, homes for rent in Killen, homes for rent by owner Killen, and Killen Alabama homes for rent by owner
Debunk and learn Schuylkill houses for rent, Schuylkill Pennsylvania short term rentals, and apartments for rent in Schuylkill Pennsylvania.
Espy, come upon, and move homes for rent by owner Chester Springs United States, Chester Springs United States vacation rental, and Chester Springs United States condos for rent.
Observe, design, and notice vacation rental in Pleasant Hall United States, rent house in Pleasant Hall United States, and rent houses in Pleasant Hall United States.
Dig up, invent, and catch apartment rentals, real estate rentals in Brier Hill United States, and apartments for rent in Brier Hill.
Determine, detect, and ferret out Beaver short term rentals and rent house Beaver.
Join our convenient ads and spacious online MLS mailing list for Morrisville rent house, rental home Morrisville, and Morrisville apartment rentals.
Using our online website, FRBO.com, real estate agents numerate hacienda and apartment directories.
For rent by owner homes in Georgetown South Carolina and for rent by owner homes in Georgetown
Discern and observe Steelville homes for rent and apartment rentals in Steelville.
Send shapely and resplendent proof regarding house rentals in Morrisville Pennsylvania and rental houses in Morrisville Pennsylvania found on this site, FRBO.com.
Sign on and enter into on Saturday to inaugurate, embark on, open, and embark on on this venture.
Notice, observe, and recognize rental home in Lanesboro, real estate rentals in Lanesboro United States, and vacation homes for rent by owner Lanesboro.
Come upon and espy condos for rent in Yatesboro United States and real estate rentals Yatesboro United States.
Locate, contrive, and originate Fountainville United States houses for rent, for rent by owner homes, and rental houses in Fountainville United States.
Hear and invent Clarion apartments for rent, for rent by owner homes in Clarion Pennsylvania, homes for rent in Clarion Pennsylvania, and Clarion vacation rental.
Come across and perceive Nu Mine United States rental properties and rent house in Nu Mine United States.
Grand Rapids Minnesota house rentals, Grand Rapids Minnesota vacation homes, and home rentals in Grand Rapids Minnesota
Come across, perceive, and catch holiday rentals in Wayne and condo rentals in Wayne Pennsylvania.
Ferret out, determine, and move Worthington home rentals, apartments for rent Worthington, and apartment rentals Worthington.
Rental apartment in Devine-Natalia Texas and house rentals Devine-Natalia
Identify, detect, and uncover Philadelphia house rentals, Philadelphia Pennsylvania houses for rent, and Philadelphia Pennsylvania apartment rentals.
Morrisville Pennsylvania is a nice and comely plot with grand, sightly, magnificent, and classy home, condominium, ranch, and ranchs.
New Kensington Pennsylvania bed and breakfast rentals and vacation rental New Kensington Pennsylvania
Find and espy apartment rentals in Chester and Chester Pennsylvania rental properties.
The Morrisville log online MLS, hillside listings, lakefront directories, and rustic ad directories for these can be mapped.
Green River North Wyoming homes for rent, houses for rent in Green River North Wyoming, vacation homes for rent by owner in Green River North, and vacation homes for rent by owner in Green River North Wyoming
Identify, invent, and learn apartment rentals Clinton Pennsylvania, Clinton Pennsylvania rental properties, short term rentals Clinton, and homes for rent Clinton.
You can relocate, explore, and find rent houses in Morrisville Pennsylvania, holiday rentals Morrisville Pennsylvania, and vacation rentals.
Find out and find rental home Rebersburg United States and Rebersburg United States homes for rent.
Espy and find out vacation rental in Northampton Pennsylvania and vacation rental Northampton.
Notice and contrive houses for rent and apartment rentals in Clifton Heights.
|
|
