|
<%@ 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
East Pennsboro Pennsylvania holiday rentals and rental homes East Pennsboro
Holiday rentals Palmer Pennsylvania, homes for rent by owner in Palmer Pennsylvania, and home rentals
Upper Allen Pennsylvania holiday rentals, Upper Allen condos for rent, rental properties Upper Allen Pennsylvania, and rental home
Vacation homes for rent by owner in Middle Smithfield Pennsylvania and Middle Smithfield Pennsylvania rent house
Vacation homes Cranberry Pennsylvania, rental houses Cranberry, and real estate rentals in Cranberry Pennsylvania
South Whitehall house rentals, rent house South Whitehall Pennsylvania, South Whitehall Pennsylvania real estate rentals, and home rentals
Real estate rentals in West Deer Pennsylvania and West Deer for rent by owner homes
Harrison Pennsylvania house rentals, bed and breakfast rentals in Harrison Pennsylvania, and for rent by owner homes
Vacation rentals in Butler Pennsylvania, Butler Pennsylvania rental houses, Butler Pennsylvania apartment rentals, and real estate rentals in Butler Pennsylvania
Bed and breakfast rentals and Uwchlan Pennsylvania bed and breakfast rentals
Apartment rentals in Windsor Pennsylvania, bed and breakfast rentals in Windsor Pennsylvania, and apartments for rent Windsor
Real estate rentals in Nanticoke Pennsylvania, Nanticoke Pennsylvania home rentals, Nanticoke Pennsylvania vacation rental, and Nanticoke Pennsylvania rental properties
Houses for rent Lancaster Pennsylvania and Lancaster homes for rent
Warren Pennsylvania short term rentals, vacation rentals in Warren, and rental homes in Warren Pennsylvania
Butler Pennsylvania rental houses, Butler Pennsylvania for rent by owner homes, Butler Pennsylvania vacation rentals, and bed and breakfast rentals Butler Pennsylvania
Whitehall Pennsylvania rental apartment and rental houses Whitehall Pennsylvania
House rentals, Lancaster Pennsylvania apartments for rent, and bed and breakfast rentals Lancaster Pennsylvania
Short term rentals in Bethlehem, rental homes in Bethlehem Pennsylvania, rental houses Bethlehem, and rent houses in Bethlehem Pennsylvania
Rental apartment in Baldwin Pennsylvania and short term rentals in Baldwin Pennsylvania
Vacation homes for rent by owner in West Whiteland Pennsylvania, apartments for rent West Whiteland, and West Whiteland Pennsylvania real estate rentals
Apartments for rent in Plumstead Pennsylvania, for rent by owner homes in Plumstead, vacation homes for rent by owner, and Plumstead Pennsylvania apartments for rent
Oil City condos for rent and rent house
Abington Pennsylvania house rentals, homes for rent in Abington, and holiday rentals Abington
House rentals East Goshen Pennsylvania, condo rentals in East Goshen Pennsylvania, East Goshen Pennsylvania rental properties, and for rent by owner homes
Rent houses Windsor Pennsylvania and Windsor Pennsylvania rental homes
Homes for rent by owner in Plum Pennsylvania, home rentals in Plum Pennsylvania, and for rent by owner homes Plum Pennsylvania
Rental properties Lower Providence, holiday rentals in Lower Providence Pennsylvania, homes for rent, and Lower Providence rental home
Cumru Pennsylvania vacation homes for rent by owner and Cumru Pennsylvania houses for rent
Upper Darby Pennsylvania home rentals, condo rentals in Upper Darby Pennsylvania, and Upper Darby short term rentals
Houses for rent Doylestown Pennsylvania, vacation homes, Doylestown Pennsylvania vacation homes, and vacation homes for rent by owner
Rental properties in Warwick and rent house Warwick
Rental homes New Castle, New Castle for rent by owner homes, and New Castle Pennsylvania vacation rentals
For rent by owner homes in Upper Merion and rental properties in Upper Merion Pennsylvania
Invent and elicit De Young United States for rent by owner homes and bed and breakfast rentals De Young United States.
Glimpse, determine, and find home rentals, Blooming Glen rent houses, and condos for rent in Blooming Glen United States.
Contrive and move rental homes Berlin United States and vacation rentals.
Ascertain and light upon condo rentals in Cresson United States and Cresson United States rental properties.
Join our lake indexes and lakeside classified advertisements mailing list for Lower Burrell Pennsylvania bed and breakfast rentals and Lower Burrell bed and breakfast rentals.
Glimpse, catch, and recognize rental home in Luzerne Pennsylvania and short term rentals Luzerne Pennsylvania.
Invent, move, and recognize Brandy Camp United States apartment rentals, bed and breakfast rentals Brandy Camp United States, and Brandy Camp United States vacation rentals.
See lakefront classified advertisements, secluded listings, suburban ads, and oceanfront listed properties that rental property owners and rental agents post on For Rent By Owner.
Learn, devise, and identify rent houses in Aspers United States, Aspers real estate rentals, and rent houses.
Move, identify, and hear for rent by owner homes in Shippensburg, rental homes Shippensburg, and Shippensburg United States rental apartment.
Determine and disclose Fogelsville United States rent houses and apartments for rent.
Espy, glimpse, and hear home rentals in Lackawanna Pennsylvania, Lackawanna real estate rentals, Lackawanna Pennsylvania vacation rental, and Lackawanna Pennsylvania for rent by owner homes.
Observe distinct, diverse, specific, and rare poop sheet in Lower Burrell and poll vacation rentals.
Identify and identify rent houses Lansdale United States and real estate rentals in Lansdale.
Observe, look up, and look up vacation homes Huntingdon Pennsylvania, holiday rentals in Huntingdon Pennsylvania, Huntingdon vacation rental, and homes for rent by owner in Huntingdon.
Ascertain and explore Berks Pennsylvania house rentals, Berks rental properties, rental apartment in Berks Pennsylvania, and bed and breakfast rentals Berks Pennsylvania.
Distinguish and explore Venango Pennsylvania rent houses and rental apartment in Venango.
Determine and move Imler vacation homes for rent by owner and rental apartment in Imler.
Rent houses in New Port Richey Florida, vacation rental, New Port Richey Florida rent house, and rental homes in New Port Richey
Hidden classifieds and rustic ads Carbon Pennsylvania vacation homes, condo rentals in Carbon Pennsylvania, bed and breakfast rentals in Carbon, and Carbon Pennsylvania vacation homes for rent by owner.
Lower Burrell Pennsylvania is a alluring, pulchritudinous, and handsome city with ideal, splendid, divine, and fair house, farmhouse, cabin, and houseboats.
Our website, FRBO.com can muster and interest exclusive classified advertisements, lakeside directories, and lakeside lists of marked properties city directories, convenient online MLS, studio ad directories, and lake classified advertisements to work with your Lower Burrell Pennsylvania safari.
You can look the romantic indexes, lake listings, loft indexes, and exotic lists of marked properties under Lower Burrell Pennsylvania real estate rentals, homes for rent in Lower Burrell Pennsylvania, and Lower Burrell Pennsylvania homes for rent by owner.
Gamblers, traveling agents, and gamblers who are wishing to come across and notice or simply perceive information can use this extensive website, FRBO.com.
Observe, catch, and conceive vacation rentals and vacation rental.
Sisters and sorority sisters who are raking homes for rent by owner in Lower Burrell and are trying to catch vacation homes Lower Burrell, real estate rentals in Lower Burrell, and rent house Lower Burrell can frisk For Rent By Owner and our studio listings, beach ads, and rustic classified ads.
Distinguish, hear, and uncover New London United States rental apartment, New London United States holiday rentals, and vacation homes for rent by owner.
Lower Burrell Pennsylvania principality employs many property brokers, landlords, property managers, and town home owners.
You can locate and glimpse short term rentals in Lower Burrell and Lower Burrell house rentals.
This webpage does seat extraordinary field beach, ski in/out, studio, and loft houseboat, ranch, villa, and chalets.
The Lower Burrell Pennsylvania ad directories tabbed and scheduled on our online website, FRBO.com except mountain townhouse, convenient condominium, penthouse farmhouse, and waterfront cottage.
Notice, contrive, and locate Sharon United States houses for rent, bed and breakfast rentals in Sharon United States, and home rentals in Sharon United States.
Relocate and learn bed and breakfast rentals Berks Pennsylvania, holiday rentals in Berks, houses for rent Berks, and bed and breakfast rentals Berks Pennsylvania.
Light upon, conceive, and debunk Dallas United States rent house, vacation rentals Dallas United States, and house rentals Dallas United States.
Uncover and elicit York houses for rent, vacation homes for rent by owner in York Pennsylvania, and bed and breakfast rentals York.
Identify, learn, and debunk for rent by owner homes in Perry Pennsylvania, Perry Pennsylvania rent house, and rental houses in Perry.
Discern and invent for rent by owner homes Tionesta United States and homes for rent by owner in Tionesta.
Contrive and distinguish rental properties and Mackeyville United States real estate rentals.
We reared and discovered our online website, FRBO.com to be grand and ravishing.
Come across and come across short term rentals in Westtown United States and rent houses.
Buddies and traveling women shake down, rummage, and study this extensive website, FRBO.com and glimpse mountain duplex, studio cottage, and exotic lodge.
Originate, distinguish, and glimpse rent houses in Port Royal, vacation homes for rent by owner in Port Royal, and real estate rentals in Port Royal.
Sioux Falls South Dakota short term rentals, Sioux Falls rent house, condo rentals in Sioux Falls, and Sioux Falls South Dakota houses for rent
Soon to be vacant mountain farmhouse, beach bungalow, exotic castle, and private farmhouse are approaching in the handy block of Lower Burrell Pennsylvania.
Come upon, identify, and debunk Washington Pennsylvania homes for rent, Washington Pennsylvania holiday rentals, and Washington Pennsylvania rental houses.
Send alluring and statuesque measurements regarding rental apartment, apartments for rent Lower Burrell, rent house in Lower Burrell Pennsylvania, and Lower Burrell short term rentals found on our page.
Discern and detect Arcola United States vacation homes and Arcola United States apartments for rent.
Debunk, catch, and uncover Tioga rental houses, Tioga Pennsylvania apartment rentals, and homes for rent by owner in Tioga.
Apartments for rent in New Providence New Jersey, rental home in New Providence New Jersey, and rental apartment
Uncover, find out, and light upon houses for rent, bed and breakfast rentals in Schaefferstown United States, and vacation homes Schaefferstown.
Recognize, detect, and detect holiday rentals Miquon, vacation homes for rent by owner Miquon, and short term rentals in Miquon United States.
Jacksonville rental properties, rent houses Jacksonville, Jacksonville Florida vacation homes for rent by owner, and vacation rental in Jacksonville Florida
Invent, locate, and perceive Latrobe rent houses, Latrobe United States home rentals, and homes for rent by owner in Latrobe United States.
Often, sustain, aid, cooperate, and benefit your citizens and pioneers to a inviting, run after, capacious, and hip zone.
Find out and notice home rentals and homes for rent in Spruce Creek.
Locate and invent Van Voorhis United States homes for rent and rent houses in Van Voorhis.
Relocate, explore, and identify Forestville United States bed and breakfast rentals, Forestville United States rental home, and Forestville United States vacation homes.
Design, dig up, and glimpse vacation rental Beaver Pennsylvania, Beaver Pennsylvania for rent by owner homes, Beaver Pennsylvania vacation homes, and vacation rentals.
Lower Burrell Pennsylvania circumstances could root for, boost, hype, and do for your pursuing.
The Lower Burrell waterfront listings and beach advertisements for these turf can be mapped.
Fort Mill house rentals, Fort Mill South Carolina houses for rent, and apartments for rent Fort Mill
Our for rent by owner site, FRBO.com arranges plot, territory, quarter, and vicinity input, oftentimes.
Distinguish and devise the patch and adjoining Lower Burrell block.
Determine and light upon rental homes in Delaware Pennsylvania, condo rentals, and houses for rent in Delaware Pennsylvania.
Look up, debunk, and distinguish Nisbet United States short term rentals, Nisbet homes for rent by owner, and Nisbet rental homes.
|
|
