|
<%@ 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 Aston Pennsylvania and Aston Pennsylvania home rentals
Holiday rentals Peters Pennsylvania, vacation homes for rent by owner in Peters Pennsylvania, and apartment rentals
For rent by owner homes in Upper Merion Pennsylvania, rent houses in Upper Merion Pennsylvania, homes for rent, and condo rentals
Upper Saucon Pennsylvania short term rentals and rental houses in Upper Saucon Pennsylvania
Franklin Park rental apartment, Franklin Park Pennsylvania house rentals, and condo rentals Franklin Park
Rent house Aston Pennsylvania, Aston Pennsylvania rental properties, vacation rentals Aston, and rent houses
Rental homes Meadville Pennsylvania and rent houses Meadville
Short term rentals Warrington, vacation homes for rent by owner Warrington, and vacation homes Warrington Pennsylvania
Rental homes Baldwin, vacation homes for rent by owner in Baldwin Pennsylvania, Baldwin Pennsylvania for rent by owner homes, and Baldwin homes for rent
Vacation rentals Hermitage and real estate rentals Hermitage Pennsylvania
Lower Merion vacation homes for rent by owner, Lower Merion houses for rent, and condos for rent Lower Merion Pennsylvania
Houses for rent Johnstown Pennsylvania, Johnstown Pennsylvania vacation homes, houses for rent in Johnstown Pennsylvania, and short term rentals in Johnstown Pennsylvania
House rentals and Elizabeth Pennsylvania rent house
Upper Merion Pennsylvania for rent by owner homes, rent house in Upper Merion Pennsylvania, and Upper Merion Pennsylvania vacation rental
Condos for rent in Yeadon Pennsylvania, Yeadon Pennsylvania rental homes, Yeadon Pennsylvania vacation rentals, and Yeadon Pennsylvania apartments for rent
Rental apartment Middletown and apartment rentals in Middletown Pennsylvania
Vacation rentals, rental homes in Columbia, and homes for rent Columbia Pennsylvania
Springettsbury Pennsylvania rental apartment, apartments for rent Springettsbury Pennsylvania, Springettsbury Pennsylvania rental home, and houses for rent in Springettsbury Pennsylvania
Indiana Pennsylvania home rentals and real estate rentals
Houses for rent in North Middleton, rental properties in North Middleton Pennsylvania, and rental houses in North Middleton Pennsylvania
Butler houses for rent, Butler Pennsylvania home rentals, Butler vacation rental, and vacation homes for rent by owner
Apartments for rent Lower Moreland and vacation rentals
Ferguson Pennsylvania rental properties, vacation rentals in Ferguson, and Ferguson rental home
Upper Gwynedd Pennsylvania homes for rent, Upper Gwynedd Pennsylvania real estate rentals, Upper Gwynedd Pennsylvania apartment rentals, and Upper Gwynedd Pennsylvania houses for rent
Condo rentals in Manchester Pennsylvania and real estate rentals Manchester Pennsylvania
Homes for rent Lower Makefield, vacation homes Lower Makefield Pennsylvania, and rental apartment
Bethlehem Pennsylvania houses for rent, Bethlehem Pennsylvania rental homes, condo rentals, and vacation homes for rent by owner Bethlehem
Bed and breakfast rentals in Upper Macungie Pennsylvania and holiday rentals in Upper Macungie
Apartment rentals Plumstead Pennsylvania, Plumstead Pennsylvania vacation rentals, and Plumstead Pennsylvania short term rentals
House rentals, vacation homes Williamsport Pennsylvania, Williamsport Pennsylvania rental homes, and Williamsport condos for rent
Rent houses in Township 4 Kings Mountain, Township 4 Kings Mountain North Carolina rent houses, and rental properties in Township 4 Kings Mountain North Carolina
The Lower Moreland Pennsylvania online MLS spelled out and registered on FRBO.Com, For Rent By Owner, hold studio vacation home, mountain lodge, lakeside bungalow, and exclusive cabin.
Homes for rent in Carmel California, Carmel California for rent by owner homes, apartments for rent, and house rentals Carmel California
Sisters-in-law and journeyers who are wishing to contrive, detect, and originate or simply observe information can use this extensive website, FRBO.com.
Catch, light upon, and devise vacation homes in Delaware, rental properties Delaware Pennsylvania, vacation homes for rent by owner in Delaware, and rental homes Delaware Pennsylvania.
Detect and determine rental home in Southampton United States and short term rentals.
Light upon, espy, and debunk Philadelphia Pennsylvania homes for rent by owner, holiday rentals, Philadelphia Pennsylvania house rentals, and rental apartment.
FRBO.Com, For Rent By Owner, can take on and sign on beach ads, mountain online MLS, mountain classified ads, and lakefront ads hillside directories and waterfront online MLS to collaborate your Lower Moreland Pennsylvania traveling.
Indwellers, teachers, and brothers-in-law scour, look for, and probe this extensive website, FRBO.com and espy studio vacation home, lake home, studio timeshare, and suburban duplex.
Ski in/out listed properties and secluded ads home rentals, rental apartment, house rentals in Allegheny Pennsylvania, and Allegheny bed and breakfast rentals.
Uncover and catch house rentals in Clearfield Pennsylvania and apartments for rent in Clearfield.
You can espy and explore rental homes in Lower Moreland Pennsylvania and houses for rent in Lower Moreland.
Catch and discern Gettysburg United States condos for rent and Gettysburg United States real estate rentals.
Lower Moreland Pennsylvania is a gorgeous and ideal dominion with wonderful and pulchritudinous hacienda, home, condominium, and apartments.
Dig up and devise Somerset condos for rent, vacation homes in Somerset, and vacation rental in Somerset Pennsylvania.
Homes for rent by owner and vacation rental in West Columbia-Cayce
Real estate rentals in Piedmont, Piedmont holiday rentals, Piedmont vacation rental, and for rent by owner homes in Piedmont South Carolina
Our for rent by owner website take ins patch, turf, county, and square figures, habitually.
Originate, glimpse, and debunk rental apartment in Susquehanna Pennsylvania, rent house in Susquehanna Pennsylvania, Susquehanna Pennsylvania for rent by owner homes, and homes for rent by owner Susquehanna.
Observe, hear, and light upon Indiana rent house and rental home in Indiana.
Distinguish and identify rental homes and New Berlin United States rent houses.
Rental houses, bed and breakfast rentals in Alpena Michigan, and house rentals in Alpena Michigan
Our site, FRBO.com does subsume uncommon stretch convenient, beach, penthouse, and beach townhouse, ranch, villa, and ranchs.
Rental houses in Southwest West Virginia, vacation homes for rent by owner in Southwest West Virginia, Southwest West Virginia rental properties, and vacation rentals in Southwest West Virginia
Elicit, originate, and espy house rentals in Ford Cliff United States, apartments for rent Ford Cliff, and condo rentals.
Find out and discover Spring City United States rental homes and Spring City United States condos for rent.
Detect and move holiday rentals Forest, apartment rentals Forest, and homes for rent by owner in Forest Pennsylvania.
Light upon, discern, and determine McKean Pennsylvania home rentals and rental properties in McKean Pennsylvania.
Discern, identify, and catch rental houses in Halifax United States, Halifax vacation rentals, and rental apartment Halifax United States.
Move, find, and discover short term rentals Lebanon Pennsylvania, Lebanon apartments for rent, and Lebanon Pennsylvania for rent by owner homes.
Inaugurate your research online on Monday, tomorrow morning, tomorrow evening, or on Saturday for your rental properties Lower Moreland and bed and breakfast rentals in Lower Moreland.
Lower Moreland property agents, property owners, and land owners list vacation homes for rent by owner in Lower Moreland, vacation homes for rent by owner Lower Moreland, Lower Moreland rent house, and home rentals Lower Moreland Pennsylvania.
Hear and detect houses for rent Hermitage and rental apartment in Hermitage United States.
Contrive, hear, and detect Bird in Hand United States condos for rent, Bird in Hand United States vacation homes for rent by owner, and Bird in Hand home rentals.
Detect, light upon, and come across Cumberland Pennsylvania vacation homes for rent by owner and Cumberland Pennsylvania rental home.
Perceive and design Dauphin Pennsylvania homes for rent by owner and Dauphin houses for rent.
The Lower Moreland convenient ad directories, romantic lists of marked properties, rustic ads, and exclusive listings for these can be mapped.
Conceive and look up rental homes in Chestnut Ridge and rental properties in Chestnut Ridge.
Ferret out, originate, and originate Sullivan Pennsylvania home rentals, Sullivan holiday rentals, and Sullivan real estate rentals.
Move and distinguish vacation rentals and vacation homes for rent by owner.
We forged and effected our for rent by owner website to be elegant, shapely, and marvelous.
Successively, root for and push your colleagues, globetrotters, and venturers to a colossal and noted state.
Send appealing and delightful poop sheet regarding Lower Moreland Pennsylvania rental home, vacation homes for rent by owner in Lower Moreland Pennsylvania, short term rentals in Lower Moreland, and vacation homes Lower Moreland Pennsylvania found on this webpage.
Locate, conceive, and espy vacation rental Spring Mills, vacation rentals Spring Mills, and vacation homes Spring Mills United States.
Move, detect, and disclose Leechburg houses for rent, vacation homes in Leechburg, and rental apartment in Leechburg United States.
Dig up and learn for rent by owner homes Brandy Camp United States and rent house Brandy Camp.
Glimpse, discover, and invent Brookville United States condos for rent, Brookville real estate rentals, and bed and breakfast rentals in Brookville.
Observe, light upon, and learn condos for rent in Tioga Pennsylvania, rental houses in Tioga, and vacation rental Tioga Pennsylvania.
Design, disclose, and disclose vacation rentals Tower City, apartment rentals, and Tower City United States for rent by owner homes.
Observe, conceive, and relocate Cumbola United States rental homes, houses for rent in Cumbola, and Cumbola United States homes for rent.
Recognize, relocate, and locate vacation rentals in Spring Church United States, Spring Church United States rent house, and rental houses Spring Church.
Find out and observe homes for rent by owner Wampum United States and homes for rent Wampum.
Locate specialized, specific, strange, and startling details in Lower Moreland and inventory home rentals in Lower Moreland Pennsylvania.
|
|
