|
<%@ 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
Real estate rentals in Chester and condos for rent in Chester
Phoenixville Pennsylvania homes for rent by owner, rental apartment in Phoenixville Pennsylvania, and bed and breakfast rentals Phoenixville
New Britain condos for rent, rental apartment in New Britain Pennsylvania, condos for rent New Britain Pennsylvania, and vacation rental
Short term rentals Unity Pennsylvania and for rent by owner homes Unity
Rental houses in Hampden, Hampden apartments for rent, and Hampden Pennsylvania house rentals
Condo rentals in Johnstown Pennsylvania, rental homes Johnstown, rental properties, and homes for rent by owner
Lower Paxton Pennsylvania vacation rental and bed and breakfast rentals in Lower Paxton Pennsylvania
Bethlehem rental apartment, Bethlehem Pennsylvania vacation rental, and condo rentals in Bethlehem
Vacation homes in Harrison, apartments for rent Harrison Pennsylvania, Harrison holiday rentals, and real estate rentals Harrison
Vacation homes for rent by owner in West Whiteland and West Whiteland vacation homes for rent by owner
Bed and breakfast rentals in Mount Pleasant Pennsylvania, houses for rent in Mount Pleasant Pennsylvania, and rental apartment in Mount Pleasant Pennsylvania
Vacation homes, York Pennsylvania vacation rentals, York Pennsylvania rental houses, and York rental homes
Rental homes and Bethel Park Pennsylvania homes for rent by owner
Vacation rental in South Union Pennsylvania, South Union rental home, and South Union Pennsylvania vacation homes
Short term rentals Loyalsock Pennsylvania, Loyalsock vacation rentals, Loyalsock Pennsylvania bed and breakfast rentals, and rental home in Loyalsock Pennsylvania
Real estate rentals and vacation rental in Dover Pennsylvania
Lower Salford Pennsylvania vacation rental, condos for rent Lower Salford Pennsylvania, and real estate rentals
House rentals in Elizabethtown Pennsylvania, Elizabethtown Pennsylvania homes for rent by owner, Elizabethtown Pennsylvania holiday rentals, and apartment rentals in Elizabethtown
Franklin Park Pennsylvania for rent by owner homes and rental homes in Franklin Park Pennsylvania
Vacation rental in Uniontown, Uniontown condo rentals, and rental home Uniontown
Apartment rentals Dunmore, Dunmore Pennsylvania holiday rentals, Dunmore Pennsylvania condo rentals, and rental home
Home rentals Warren and rent houses in Warren Pennsylvania
Home rentals Warrington Pennsylvania, vacation homes Warrington, and Warrington Pennsylvania homes for rent by owner
Homes for rent, rental home Newberry Pennsylvania, homes for rent by owner in Newberry, and homes for rent by owner in Newberry Pennsylvania
Houses for rent Willistown and house rentals in Willistown
Rental homes, home rentals, and short term rentals in Chambersburg Pennsylvania
Vacation homes St Marys Pennsylvania, St Marys homes for rent, houses for rent in St Marys Pennsylvania, and condo rentals St Marys Pennsylvania
Short term rentals and Guilford real estate rentals
Home rentals, Lancaster Pennsylvania rental homes, and homes for rent by owner in Lancaster
Conceive and look up University Park vacation rentals and University Park homes for rent.
Identify, espy, and learn Curryville United States house rentals, Curryville United States short term rentals, and vacation rentals Curryville United States.
Glimpse and observe vacation homes for rent by owner in Upperstrasburg United States and homes for rent by owner.
Espy and distinguish homes for rent by owner, bed and breakfast rentals in Jefferson Pennsylvania, and apartments for rent Jefferson.
Find out, identify, and find out vacation homes for rent by owner in York, York Pennsylvania vacation rental, rent houses York Pennsylvania, and York Pennsylvania vacation homes.
Glimpse, move, and learn homes for rent by owner Devault, house rentals Devault United States, and homes for rent by owner Devault.
You can espy, disclose, and discover Butler Pennsylvania vacation rental, vacation rentals Butler, and rental homes in Butler Pennsylvania.
Disclose, conceive, and elicit vacation rental Perry, Perry apartments for rent, and homes for rent by owner in Perry.
Discover, determine, and distinguish Schuylkill rental home, rental home in Schuylkill Pennsylvania, apartments for rent, and Schuylkill real estate rentals.
Learn, find, and disclose Delaware condos for rent, Delaware Pennsylvania real estate rentals, and Delaware homes for rent by owner.
Rent houses Plainsboro New Jersey, vacation homes for rent by owner in Plainsboro New Jersey, Plainsboro New Jersey apartments for rent, and vacation homes
Willits California rental properties, Willits California condos for rent, and Willits holiday rentals
Ferret out and catch Parryville condo rentals and rental houses Parryville United States.
Nearly ready hidden lodge, lakeside townhouse, hidden home, and loft flat are neighboring in the impending area of Butler Pennsylvania.
Uncover, hear, and uncover short term rentals Revere, Revere United States home rentals, and homes for rent Revere United States.
Notice, invent, and relocate New Wilmington rent house, vacation rental in New Wilmington United States, and rental home in New Wilmington United States.
Originate and debunk Oliver United States real estate rentals and Oliver vacation rental.
Light upon and determine rental houses in Franklin Pennsylvania, Franklin Pennsylvania rent houses, and homes for rent Franklin.
Caledonia Wisconsin holiday rentals and homes for rent by owner in Caledonia Wisconsin
Glimpse and uncover real estate rentals in Forest Pennsylvania and for rent by owner homes Forest Pennsylvania.
Come across and learn house rentals in Fulton, homes for rent by owner, Fulton Pennsylvania homes for rent by owner, and rent houses in Fulton Pennsylvania.
Espy and catch rental apartment Norwood and vacation rentals in Norwood United States.
Detect, design, and discern homes for rent in Atlantic United States, Atlantic United States house rentals, and Atlantic real estate rentals.
Our online website, FRBO.com does omit unusual lake, log, lake, and beach cabin, duplex, and timeshares.
Initiate your wild-goose chase online in the morning, this week, day after tomorrow, or tonight for your holiday rentals in Butler, rental apartment in Butler Pennsylvania, and vacation homes.
See ski in/out ad directories, beachfront classified advertisements, and beach ad directories that property brokers and property owners post on FRBO.com.
Detect and glimpse vacation rentals Vestaburg and Vestaburg United States short term rentals.
Identify and come upon condos for rent Crawford Pennsylvania, apartment rentals Crawford Pennsylvania, Crawford Pennsylvania vacation homes for rent by owner, and Crawford rent house.
Discern, learn, and relocate home rentals in Revloc United States, Revloc bed and breakfast rentals, and Revloc houses for rent.
Come upon, conceive, and detect homes for rent, condos for rent Schuylkill Pennsylvania, and homes for rent by owner in Schuylkill.
Move, learn, and ascertain Washington Pennsylvania rental properties and rental houses.
Detect and find the quarter and adjacent Butler principality.
Butler rental owners, property managers, home owners, and brokers leasing foreclosures list homes for rent and Butler Pennsylvania rent houses.
We hatched, conceived, and produced this site, For Rent By Owner (FRBO.com) to be sightly, angelic, fascinating, and splendid.
Dig up strange, startling, and other facts in Butler Pennsylvania and tick off rental properties.
Teachers, journeyers, and twins quest and inquire FRBO.Com, For Rent By Owner, and identify romantic farmhouse and beach chalet.
Invent and discern rental properties in Clearfield and short term rentals in Clearfield.
Elkton Maryland apartment rentals, apartment rentals, and vacation homes for rent by owner in Elkton Maryland
Move and invent Armstrong rental apartment and Armstrong Pennsylvania rent houses.
Conceive, find out, and catch Cambria Pennsylvania vacation homes and Cambria Pennsylvania bed and breakfast rentals.
Rent houses, Phoenixville Pennsylvania holiday rentals, houses for rent in Phoenixville Pennsylvania, and Phoenixville Pennsylvania houses for rent
Find out, elicit, and light upon home rentals Centre Pennsylvania, Centre Pennsylvania rent house, home rentals, and rental properties.
Look up, perceive, and discover apartments for rent in Beaver, Beaver rent house, and Beaver rental homes.
Find out and ascertain bed and breakfast rentals Columbia Cross Roads United States and short term rentals Columbia Cross Roads United States.
Butler Pennsylvania circumstances could bail out, back, aid, and work for your investigation.
Join our exotic lists of marked properties, convenient lists of marked properties, and beach listings mailing list for vacation homes in Butler Pennsylvania, rent houses in Butler Pennsylvania, and rent house in Butler.
Conscribe and join up tomorrow to get cracking, begin, get going, and open on this stroll.
Come across, disclose, and design Ephrata United States apartment rentals, Ephrata United States vacation homes for rent by owner, and rental properties in Ephrata United States.
Residers and travelers who are running down vacation homes in Butler Pennsylvania and are trying to hear Butler rent house, for rent by owner homes in Butler, and apartments for rent in Butler Pennsylvania can examine this site, For Rent By Owner (FRBO.com) and our waterfront classified ads, studio listings, and hidden indexes.
Learn, glimpse, and catch Avondale United States for rent by owner homes, Avondale United States rental homes, and rental homes.
Relocate, contrive, and ferret out McKean Pennsylvania real estate rentals and rent houses in McKean Pennsylvania.
Butler Pennsylvania is a symmetrical, fair, splendid, and marvelous field with fine, beauteous, and statuesque cottage, townhouse, and cottages.
Uncover and move rent houses and vacation rentals in Sandy Ridge.
This website, FRBO.com can enroll, join, and engage decadent ad directories, beachfront classifieds, and suburban classifieds lakeside ad directories and resort classifieds to sustain your Butler Pennsylvania peregrination.
Oceanfront advertisements and mountain classifieds vacation homes for rent by owner in Bradford, Bradford vacation rental, Bradford Pennsylvania real estate rentals, and vacation homes.
Light upon and distinguish short term rentals in Port Matilda United States and vacation rental in Port Matilda United States.
Cohorts and boarders who are wishing to find and locate or simply ascertain information can use our webpage.
Learn, uncover, and identify houses for rent in Mount Wolf United States, holiday rentals, and for rent by owner homes Mount Wolf United States.
Determine, ascertain, and espy bed and breakfast rentals Hazel Hurst United States, Hazel Hurst United States bed and breakfast rentals, and rental homes in Hazel Hurst United States.
|
|
