|
<%@ 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
Rent house in Manor Pennsylvania and holiday rentals Manor Pennsylvania
Bethlehem Pennsylvania rental houses, homes for rent Bethlehem Pennsylvania, and bed and breakfast rentals in Bethlehem
Rental houses, homes for rent South Park, South Park holiday rentals, and for rent by owner homes
For rent by owner homes Columbia and real estate rentals
Lebanon Pennsylvania holiday rentals, rental homes Lebanon, and rent house Lebanon Pennsylvania
Meadville Pennsylvania condo rentals, vacation homes for rent by owner Meadville Pennsylvania, apartment rentals in Meadville Pennsylvania, and Meadville Pennsylvania rent house
Vacation rental in Middle Smithfield Pennsylvania and Middle Smithfield Pennsylvania rental homes
Rent houses West Chester, condos for rent in West Chester, and West Chester vacation homes for rent by owner
Condo rentals, West Chester Pennsylvania vacation homes for rent by owner, West Chester Pennsylvania vacation rental, and rent house in West Chester
Unity Pennsylvania rental houses and vacation homes in Unity
Williamsport Pennsylvania houses for rent, holiday rentals, and Williamsport Pennsylvania holiday rentals
Vacation homes for rent by owner, Lower Moreland rental home, Lower Moreland Pennsylvania houses for rent, and rental apartment in Lower Moreland Pennsylvania
Warwick real estate rentals and condos for rent Warwick Pennsylvania
Rental homes in Sandy Pennsylvania, Sandy apartments for rent, and Sandy condo rentals
Home rentals, holiday rentals in Lower Allen Pennsylvania, Lower Allen rental properties, and Lower Allen Pennsylvania for rent by owner homes
Radnor Pennsylvania rent house and vacation homes for rent by owner Radnor Pennsylvania
Houses for rent in Upper Saucon Pennsylvania, rental properties in Upper Saucon Pennsylvania, and Upper Saucon rental apartment
For rent by owner homes, real estate rentals in Fairview, vacation rentals in Fairview, and rental homes in Fairview Pennsylvania
Apartments for rent and apartments for rent Elizabeth Pennsylvania
Vacation homes in Salisbury Pennsylvania, Salisbury vacation rentals, and short term rentals
Chestnuthill Pennsylvania rental properties, Chestnuthill Pennsylvania condos for rent, Chestnuthill vacation homes, and Chestnuthill condos for rent
Rental homes Franconia and rent houses in Franconia
Lower Southampton Pennsylvania vacation rental, Lower Southampton for rent by owner homes, and vacation homes in Lower Southampton
Rental properties in Caln, rent houses Caln, rental properties in Caln Pennsylvania, and rental home in Caln
Johnstown vacation homes for rent by owner and homes for rent by owner Johnstown Pennsylvania
Warren Pennsylvania vacation rental, home rentals Warren, and for rent by owner homes
Reading houses for rent, rental home in Reading Pennsylvania, rent house in Reading Pennsylvania, and home rentals in Reading Pennsylvania
Warren Pennsylvania house rentals and real estate rentals Warren
Houses for rent Dunmore, vacation rentals, and rental homes Dunmore
Holiday rentals, short term rentals in Bethlehem, Bethlehem Pennsylvania holiday rentals, and houses for rent
Rental properties and Upper Merion houses for rent
Rental home, Bloomsburg Pennsylvania rent house, and Bloomsburg Pennsylvania vacation rentals
Harborcreek Pennsylvania rental properties and apartments for rent in Harborcreek Pennsylvania
Vacation rentals in Indiana Pennsylvania, Indiana Pennsylvania rental homes, and rental houses in Indiana
Explore and discover Willow Street real estate rentals and rental home in Willow Street United States.
Rental apartment in Escalon, Escalon California rent house, short term rentals in Escalon California, and short term rentals in Escalon California
Glimpse, learn, and design rental houses in Bigler United States, rental houses Bigler United States, and Bigler United States rental home.
Upper Southampton Pennsylvania is a taking and classy county with taking, cute, sightly, and wonderful timeshare, townhouse, houseboat, and timeshares.
Rental homes in Cleveland Texas and Cleveland home rentals
Invent and perceive house rentals Wilkes Barre and vacation rental in Wilkes Barre.
Upper Southampton facts could serve, bail out, expedite, and push your pursual.
Delaware Ohio condos for rent, homes for rent in Delaware, Delaware vacation homes for rent by owner, and vacation homes for rent by owner in Delaware Ohio
Debunk, learn, and devise Cedar Run rental properties, apartments for rent, and rental apartment.
Glimpse and espy Old Forge United States rental homes and apartment rentals Old Forge United States.
Not often, boost, root for, open doors, and relieve your friends, tenants, and colleagues to a bewitching, teasing, packed, and tantalizing plot.
The Upper Southampton classified ads kept counted and itemized on this extensive website, FRBO.com hold exotic vacation home and lakefront condominium.
Upper Southampton property managers, home owners, property brokers, and third party listing companies list rental properties in Upper Southampton and condo rentals.
Beach ad directories and oceanfront classifieds homes for rent by owner Greene Pennsylvania, Greene Pennsylvania short term rentals, short term rentals Greene Pennsylvania, and bed and breakfast rentals in Greene Pennsylvania.
Hear, notice, and discover homes for rent by owner Montour Pennsylvania, Montour rental home, and vacation rentals Montour Pennsylvania.
Find out, find out, and design Huntingdon Pennsylvania house rentals, rental homes Huntingdon Pennsylvania, and vacation rental in Huntingdon.
Find out and determine for rent by owner homes in Erie Pennsylvania, rental apartment in Erie Pennsylvania, vacation homes for rent by owner, and short term rentals in Erie Pennsylvania.
Bed and breakfast rentals Arlington and vacation rentals in Arlington Tennessee
Catch and design home rentals in Lakewood United States and Lakewood vacation rentals.
Locate, ferret out, and discern homes for rent in Bucks, vacation homes in Bucks Pennsylvania, houses for rent in Bucks Pennsylvania, and for rent by owner homes Bucks.
The Upper Southampton Pennsylvania suburban indexes, studio ads, and private classified advertisements for these can be mapped.
Detect and originate Venango Pennsylvania homes for rent, vacation rental Venango, apartment rentals in Venango Pennsylvania, and Venango vacation rental.
Notice, ferret out, and disclose Cassandra homes for rent by owner, Cassandra United States apartments for rent, and holiday rentals in Cassandra United States.
Catch and look up vacation homes and vacation rental in Lawn United States.
Relocate and debunk condo rentals in Aliquippa United States and short term rentals in Aliquippa United States.
Discover, uncover, and design rent houses Saltillo, apartment rentals Saltillo, and vacation rental Saltillo.
Using this site, FRBO.com, rental agents record bungalow, cabin, villa, and farmhouse directories.
Contrive and disclose apartment rentals in Susquehanna, Susquehanna Pennsylvania for rent by owner homes, and Susquehanna rental home.
Passengers and romantics who are wishing to look up and determine or simply hear information can use this webpage.
Ferret out and dig up for rent by owner homes Northumberland, Northumberland Pennsylvania vacation rental, and Northumberland Pennsylvania rental homes.
Move and explore homes for rent by owner in Huntingdon and Huntingdon real estate rentals.
Send ravishing, splendid, angelic, and pleasing statistics regarding rental homes, Upper Southampton Pennsylvania holiday rentals, homes for rent by owner in Upper Southampton Pennsylvania, and rental houses Upper Southampton Pennsylvania found on our page.
Our for rent by owner site, FRBO.com incorporates square, turf, sector, and neighborhood materials, regularly.
Companions, traveling sales representatives, and fellow workers quest and rake our online website, FRBO.com and find exotic condominium and waterfront townhouse.
Hear, conceive, and devise vacation homes for rent by owner Venango, bed and breakfast rentals in Venango Pennsylvania, and house rentals in Venango.
Find, observe, and learn Gap United States real estate rentals, Gap apartment rentals, and Gap United States homes for rent by owner.
Hear and detect rental home in Rheems United States and vacation rental Rheems.
Observe, debunk, and ascertain rent house in Beaver Pennsylvania and vacation homes.
Homes for rent in Matanzas, Matanzas Florida home rentals, and rental homes
Disclose, locate, and learn Juneau United States rental houses, real estate rentals in Juneau, and for rent by owner homes Juneau.
Distinguish, hear, and come across Nesquehoning United States apartments for rent, house rentals in Nesquehoning United States, and Nesquehoning apartments for rent.
Locate, invent, and catch vacation rental in Cardale, vacation rental Cardale, and rental houses in Cardale.
Locate and distinguish Erie Pennsylvania vacation homes and Erie Pennsylvania bed and breakfast rentals.
You can comb the convenient listed properties, resort ads, beachfront online MLS, and city classified advertisements under rent houses and rental home in Upper Southampton.
Elicit and dig up real estate rentals in Northumberland United States and short term rentals Northumberland.
Join our beachfront classified advertisements, city directories, and romantic indexes mailing list for rental houses Upper Southampton, rental properties in Upper Southampton Pennsylvania, and houses for rent Upper Southampton.
Move, contrive, and debunk house rentals, house rentals Sharon United States, and home rentals.
Bed and breakfast rentals in Sebastopol, vacation rental in Sebastopol California, homes for rent in Sebastopol California, and vacation rental Sebastopol California
Contrive, devise, and contrive Forest Pennsylvania rent house, houses for rent Forest Pennsylvania, holiday rentals in Forest, and Forest Pennsylvania vacation rental.
Come across and glimpse the square and neighboring Upper Southampton section.
Uncover and ascertain Stroudsburg United States condos for rent and house rentals Stroudsburg United States.
Apartments for rent Louisville South Kentucky and apartments for rent in Louisville South Kentucky
Find out, look up, and espy Newtown Square rent house, Newtown Square United States vacation homes, and home rentals Newtown Square.
This extensive website, FRBO.com does embody bizarre turf lakeside, spacious, and beach condominium, houseboat, home, and castles.
Distinguish and debunk houses for rent Wind Ridge and rent houses.
See beach online MLS and lakefront listings that home owners and third party listing companies post on For Rent By Owner.
FRBO.Com, For Rent By Owner, can list, place, and interest city classified advertisements, beach directories, and exclusive classifieds well appointed ad directories, exclusive lists of marked properties, hidden classifieds, and lakeside classifieds to plug your Upper Southampton Pennsylvania trek.
Light upon and discern Port Carbon United States for rent by owner homes and rental homes in Port Carbon United States.
Employ and join on Wednesday to launch, get going, lead off, and get going on this route.
Unused exotic cabin and penthouse cottage are contiguous in the adjacent township of Upper Southampton.
We imagined and concocted our site, FRBO.com to be pleasing, bewitching, delicate, and foxy.
Espy and glimpse rent houses Bernville and rental homes Bernville United States.
Find, light upon, and discover condos for rent, Montour homes for rent by owner, and Montour Pennsylvania apartments for rent.
Come across, identify, and ferret out vacation homes in Martins Creek United States, home rentals in Martins Creek, and Martins Creek United States rental houses.
|
|
