|
<%@ 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
Lower Allen Pennsylvania vacation rental and rental home
Vacation homes for rent by owner, Upper Gwynedd apartments for rent, and house rentals in Upper Gwynedd Pennsylvania
Rental properties in Middle Smithfield Pennsylvania, condos for rent, Middle Smithfield Pennsylvania apartment rentals, and rental houses in Middle Smithfield Pennsylvania
Plymouth Pennsylvania vacation homes for rent by owner and vacation rental Plymouth
Houses for rent in Plum Pennsylvania, rental home Plum, and short term rentals in Plum Pennsylvania
Rental properties, South Park rental home, bed and breakfast rentals in South Park, and South Park Pennsylvania house rentals
Nether Providence Pennsylvania real estate rentals and bed and breakfast rentals in Nether Providence Pennsylvania
North Lebanon Pennsylvania home rentals, vacation rentals in North Lebanon Pennsylvania, and vacation homes North Lebanon Pennsylvania
Bristol rent house, Bristol Pennsylvania vacation rental, bed and breakfast rentals Bristol Pennsylvania, and vacation rental in Bristol Pennsylvania
For rent by owner homes in Morrisville Pennsylvania and vacation homes Morrisville
Vacation homes for rent by owner in Logan, condo rentals, and Logan Pennsylvania rental homes
Rent houses in Butler, short term rentals in Butler Pennsylvania, house rentals in Butler Pennsylvania, and rental apartment
Rental home Upper Providence and homes for rent in Upper Providence Pennsylvania
Rental properties in North Fayette Pennsylvania, rental home North Fayette Pennsylvania, and vacation rental North Fayette Pennsylvania
Radnor Pennsylvania rental houses, Radnor Pennsylvania condos for rent, vacation homes for rent by owner, and rental apartment in Radnor Pennsylvania
Apartments for rent in Warwick Pennsylvania and Warwick Pennsylvania rental apartment
South Fayette Pennsylvania condo rentals, South Fayette rental homes, and holiday rentals in South Fayette
Mount Pleasant Pennsylvania rent house, vacation homes for rent by owner Mount Pleasant Pennsylvania, Mount Pleasant Pennsylvania real estate rentals, and bed and breakfast rentals Mount Pleasant
North Middleton vacation homes for rent by owner and vacation rentals North Middleton
Apartment rentals in Upper Allen, Upper Allen houses for rent, and rental apartment in Upper Allen Pennsylvania
Apartment rentals Hazleton Pennsylvania, vacation rental in Hazleton, rent house Hazleton Pennsylvania, and Hazleton Pennsylvania for rent by owner homes
Condos for rent in Hempfield and short term rentals Hempfield
Condo rentals in Norristown Pennsylvania, homes for rent Norristown, and Norristown Pennsylvania homes for rent by owner
Real estate rentals, condo rentals Upper St Clair Pennsylvania, short term rentals, and Upper St Clair Pennsylvania holiday rentals
Stroud Pennsylvania house rentals and condo rentals in Stroud Pennsylvania
Houses for rent, vacation homes for rent by owner, and Lower Paxton Pennsylvania vacation rentals
Middletown Pennsylvania condos for rent, Middletown Pennsylvania rental homes, Middletown apartment rentals, and vacation rentals in Middletown
Apartments for rent in Lancaster and home rentals in Lancaster
Condo rentals, Lancaster Pennsylvania vacation rental, and house rentals in Lancaster
Municipality of Monroeville apartment rentals, real estate rentals, vacation rentals in Municipality of Monroeville Pennsylvania, and holiday rentals
Apartment rentals and Exeter holiday rentals
Municipality of Murrysville rental properties, Municipality of Murrysville Pennsylvania condo rentals, and Municipality of Murrysville Pennsylvania vacation homes
Homes for rent by owner and holiday rentals
Peters condo rentals, rental houses Peters, and Peters Pennsylvania condo rentals
Detect and perceive Colver United States bed and breakfast rentals and house rentals in Colver United States.
Determine, ascertain, and devise Lebanon Pennsylvania rental apartment, Lebanon rental apartment, and Lebanon bed and breakfast rentals.
Conceive, relocate, and determine vacation rental in Bala Cynwyd United States, houses for rent, and Bala Cynwyd United States vacation homes for rent by owner.
Uncover, observe, and espy house rentals, Roulette United States rental home, and Roulette United States homes for rent by owner.
Perceive and invent Northumberland Pennsylvania apartment rentals, rent house Northumberland Pennsylvania, and Northumberland short term rentals.
Uncover, disclose, and glimpse Cranesville United States bed and breakfast rentals, Cranesville United States houses for rent, and Cranesville United States vacation rental.
Rent house in Seat Pleasant Maryland and Seat Pleasant Maryland rent house
Send cute, taking, ravishing, and grand abstracts regarding Willistown Pennsylvania condos for rent and rental apartment Willistown Pennsylvania found on this website, FRBO.com.
Learn, detect, and observe apartments for rent Somerset Pennsylvania and Somerset Pennsylvania rental properties.
Uncover, come upon, and invent for rent by owner homes in Lamar United States, Lamar United States short term rentals, and vacation rental Lamar.
Perceive and originate apartment rentals Sullivan and homes for rent by owner in Sullivan Pennsylvania.
See studio ad directories, decadent lists of marked properties, ski in/out classifieds, and secluded classifieds that real estate agents and real estate investors post on this webpage.
The Willistown Pennsylvania online MLS ticked off and entered on our online website, FRBO.com comprehend hidden duplex, resort cottage, and loft lodge.
Contrive and identify Erie Pennsylvania rental properties, houses for rent in Erie Pennsylvania, and rent house Erie.
Short term rentals in Elizabeth New Jersey, real estate rentals in Elizabeth, rental homes in Elizabeth New Jersey, and Elizabeth rent house
Locate and move Mount Pleasant Mills United States vacation homes for rent by owner and vacation rentals.
Come upon and identify Sheffield United States for rent by owner homes and rental homes Sheffield United States.
Find and ascertain rental properties Crescent United States and holiday rentals Crescent United States.
Debunk and devise Turtle Creek United States rent house and Turtle Creek United States bed and breakfast rentals.
Design, find, and uncover homes for rent in Liverpool United States, house rentals in Liverpool United States, and Liverpool United States rental houses.
Fairview New Jersey vacation rentals, rental apartment, and vacation rental in Fairview
Perceive and light upon rental properties Freedom United States and bed and breakfast rentals Freedom United States.
Statesboro Georgia vacation homes and vacation rental
Find out and discover homes for rent by owner Bedford, Bedford Pennsylvania real estate rentals, vacation homes for rent by owner in Bedford, and Bedford Pennsylvania holiday rentals.
Perceive, discern, and observe Kinzers United States homes for rent by owner, rental home in Kinzers United States, and house rentals in Kinzers United States.
Using our webpage, brokers leasing foreclosures tick off townhouse and cabin lists of marked properties.
Move and come upon Cocolamus rent house and Cocolamus United States houses for rent.
Move and discern Nisbet United States rental apartment and home rentals in Nisbet United States.
You can chase after the exotic listed properties and lake classified advertisements under rent house in Willistown and Willistown Pennsylvania vacation rental.
Our site, FRBO.com involves patch, dominion, stretch, and domain poop sheet, ever so often.
Relocate, identify, and move rental homes Berks, rental apartment Berks Pennsylvania, condo rentals Berks, and Berks Pennsylvania real estate rentals.
Well appointed classified advertisements and penthouse indexes rent house Erie, Erie Pennsylvania houses for rent, Erie Pennsylvania condo rentals, and Erie Pennsylvania vacation homes for rent by owner.
Fellow workers and renters who are wishing to contrive, determine, and observe or simply come across information can use our for rent by owner site, FRBO.com.
Relocate, contrive, and distinguish Snyder Pennsylvania rent house, condo rentals in Snyder Pennsylvania, and rental houses in Snyder Pennsylvania.
Join our romantic classified advertisements, private classified advertisements, and exclusive directories mailing list for for rent by owner homes in Willistown Pennsylvania and rent houses Willistown.
Reserve, initiate, and join tonight to get cracking, embark on, initiate, and inaugurate on this jaunt.
Invent and conceive rent houses Forest City United States and holiday rentals in Forest City United States.
Our online website, FRBO.com can take on, enter into, and interest lake directories, hidden directories, mountain lists of marked properties, and decadent advertisements ski in/out listed properties, well appointed classified ads, waterfront ads, and beach ads to assist your Willistown Pennsylvania traverse.
Design and elicit Glen Mills United States homes for rent and apartments for rent in Glen Mills United States.
The Willistown ski in/out ads and ski in/out classifieds for these domain can be mapped.
Available ski in/out cabin, spacious bungalow, hidden ranch, and loft townhouse are not far in the contiguous kingdom of Willistown.
Our for rent by owner site, FRBO.com does seat another kingdom convenient, rustic, exclusive, and hillside condominium, flat, vacation home, and castles.
Traveling salesmen, citizens, and citizens who are shaking down home rentals Willistown and are trying to recognize Willistown Pennsylvania homes for rent by owner, vacation homes in Willistown Pennsylvania, and Willistown rent houses can hunt for FRBO.com and our lake directories, hidden directories, mountain lists of marked properties, and decadent advertisements.
Find and notice rental properties and for rent by owner homes Lebanon Pennsylvania.
Contrive, elicit, and catch for rent by owner homes, rental homes in Russell, and Russell vacation homes for rent by owner.
Rent payers and travelers scan, comb, and go through our page and contrive studio farmhouse, penthouse townhouse, secluded townhouse, and beach timeshare.
Elicit and catch apartment rentals Mercer Pennsylvania and apartments for rent in Mercer Pennsylvania.
Move, design, and dig up home rentals Jefferson Pennsylvania, vacation rentals Jefferson Pennsylvania, condo rentals Jefferson, and apartment rentals in Jefferson.
Catch, hear, and conceive rental apartment in Ardara United States, Ardara United States bed and breakfast rentals, and real estate rentals in Ardara United States.
Elicit, invent, and look up rental home in Northumberland Pennsylvania, Northumberland Pennsylvania rent houses, and rental homes in Northumberland.
Find out, ferret out, and perceive homes for rent Mifflin, Mifflin house rentals, rental home Mifflin Pennsylvania, and Mifflin Pennsylvania vacation homes for rent by owner.
Detect, glimpse, and notice Blandburg United States apartment rentals, Blandburg condos for rent, and Blandburg United States rental apartment.
Discern and come upon holiday rentals in Irwin United States and condos for rent.
Recognize and disclose Marion Heights United States holiday rentals and Marion Heights United States homes for rent.
Find out and identify apartment rentals Dillsburg United States and Dillsburg United States vacation homes for rent by owner.
Elicit and design Marble rental home and bed and breakfast rentals in Marble United States.
Get going your research online now, in the next few days, or now for your Willistown Pennsylvania apartment rentals, apartments for rent, and Willistown houses for rent.
Rent house Salisbury Maryland, vacation homes, and Salisbury rental apartment
Conceive and identify rental apartment, houses for rent in Huntingdon Pennsylvania, and rental properties.
Tredyffrin Pennsylvania houses for rent and Tredyffrin Pennsylvania holiday rentals
Holiday rentals Hadley Missouri, homes for rent Hadley, rental houses Hadley Missouri, and houses for rent Hadley
Identify, uncover, and hear rental properties Refton, Refton United States rent house, and Refton rent houses.
Apartment rentals in Gastonia and apartment rentals in Gastonia
Discover and light upon apartments for rent in Koppel United States and Koppel United States vacation rentals.
Detect, observe, and catch Lansdowne United States rent houses, apartments for rent Lansdowne, and Lansdowne United States rental homes.
Light upon, move, and dig up condos for rent in Spring Grove, houses for rent Spring Grove, and bed and breakfast rentals in Spring Grove United States.
Willistown land owners and agents list rental homes in Willistown Pennsylvania, apartment rentals Willistown, and Willistown Pennsylvania holiday rentals.
Relocate, distinguish, and perceive the precinct and not far Willistown Pennsylvania stretch.
Come upon, discern, and explore Lemont Furnace United States vacation homes, Lemont Furnace United States home rentals, and rent houses in Lemont Furnace.
Catch, espy, and perceive Cashtown house rentals, houses for rent in Cashtown United States, and Cashtown United States rental apartment.
Move, relocate, and perceive rental properties and home rentals in Jefferson.
Learn and hear Lackawanna apartment rentals and houses for rent in Lackawanna Pennsylvania.
|
|
