|
<%@ 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
Upper Moreland Pennsylvania rent houses and Upper Moreland bed and breakfast rentals
For rent by owner homes Hempfield Pennsylvania, house rentals in Hempfield Pennsylvania, and Hempfield Pennsylvania apartments for rent
Chambersburg vacation homes for rent by owner, bed and breakfast rentals in Chambersburg, holiday rentals, and rental homes in Chambersburg Pennsylvania
House rentals in East Pennsboro Pennsylvania and vacation homes in East Pennsboro Pennsylvania
Rent house West Hempfield Pennsylvania, rent houses in West Hempfield Pennsylvania, and rent houses in West Hempfield
Vacation homes for rent by owner, Bloomsburg Pennsylvania rental apartment, short term rentals Bloomsburg, and Bloomsburg Pennsylvania condo rentals
Holiday rentals in Lancaster and houses for rent Lancaster
Homes for rent, apartments for rent in West Chester Pennsylvania, and house rentals in West Chester Pennsylvania
Franconia bed and breakfast rentals, apartments for rent in Franconia Pennsylvania, condo rentals Franconia, and apartment rentals in Franconia Pennsylvania
Vacation homes for rent by owner South Fayette Pennsylvania and short term rentals in South Fayette Pennsylvania
Short term rentals in Johnstown Pennsylvania, Johnstown Pennsylvania rental properties, and rent house Johnstown Pennsylvania
Condo rentals Derry, vacation rentals, Derry Pennsylvania rental apartment, and Derry rental apartment
Condos for rent Millcreek Pennsylvania and rent house Millcreek
Condo rentals, vacation rentals, and rental properties Exeter
Pittsburgh Pennsylvania condo rentals, homes for rent by owner Pittsburgh, house rentals in Pittsburgh Pennsylvania, and vacation rental Pittsburgh Pennsylvania
Houses for rent in Robinson and Robinson houses for rent
Homes for rent by owner in Windsor Pennsylvania, Windsor Pennsylvania rental homes, and rental apartment in Windsor Pennsylvania
Rent house, short term rentals, rental properties in Unity Pennsylvania, and vacation rentals in Unity
Cheltenham rental properties and vacation rental
Whitemarsh condos for rent, Whitemarsh for rent by owner homes, and Whitemarsh vacation homes
Ross Pennsylvania rental homes, rental houses Ross Pennsylvania, rent houses, and rental houses Ross Pennsylvania
Rent houses in Bethlehem Pennsylvania and Bethlehem Pennsylvania vacation rental
Center Pennsylvania bed and breakfast rentals, homes for rent by owner in Center Pennsylvania, and Center real estate rentals
South Union Pennsylvania apartments for rent, vacation homes for rent by owner, house rentals in South Union Pennsylvania, and houses for rent South Union
Condo rentals in Warrington Pennsylvania and rental homes in Warrington
Short term rentals in Robinson, Robinson Pennsylvania vacation rental, and rent house in Robinson
Easton rent house, rental properties, Easton homes for rent, and apartments for rent in Easton Pennsylvania
Learn and determine vacation homes for rent by owner in Fairhope and Fairhope United States house rentals.
The Phoenixville ads noted and written down on this site, For Rent By Owner (FRBO.com) exclude private farmhouse, mountain vacation home, exotic house, and ski in/out villa.
Espy, move, and catch vacation homes for rent by owner, New Castle United States rental home, and New Castle United States rental properties.
Devise and uncover Blairsville United States rental homes and house rentals Blairsville United States.
Originate and perceive bed and breakfast rentals in Tipton and vacation homes for rent by owner in Tipton United States.
Elicit, espy, and learn apartments for rent, rent houses in Lenni United States, and vacation homes Lenni United States.
Invent, perceive, and light upon house rentals Westmoreland Pennsylvania, home rentals in Westmoreland, and vacation rentals.
Come across, catch, and explore Northumberland Pennsylvania rental homes and Northumberland Pennsylvania rent houses.
Identify and conceive bed and breakfast rentals and holiday rentals Talmage.
Identify and look up Factoryville apartment rentals and condo rentals in Factoryville United States.
Look up, identify, and identify vacation rentals Gowen City, rental home, and for rent by owner homes.
Trippers, venturers, and gypsies who are wishing to debunk, light upon, and conceive or simply identify information can use our website, FRBO.com.
You can explore the waterfront listings and hillside online MLS under Phoenixville Pennsylvania vacation homes, Phoenixville Pennsylvania holiday rentals, and Phoenixville homes for rent by owner.
Discover, discover, and debunk apartment rentals in Carbon, rental home in Carbon Pennsylvania, rental homes in Carbon Pennsylvania, and condos for rent in Carbon.
Join our suburban listed properties, suburban classified ads, and ski in/out classified advertisements mailing list for real estate rentals in Phoenixville Pennsylvania, vacation rentals in Phoenixville Pennsylvania, and condo rentals Phoenixville Pennsylvania.
Debunk and invent houses for rent in Mercer, houses for rent in Mercer, Mercer Pennsylvania rental houses, and rental homes in Mercer.
Devise, detect, and light upon holiday rentals Tatamy United States, Tatamy United States holiday rentals, and Tatamy for rent by owner homes.
Phoenixville agents serving the condo market, third party agents, real estate investors, and rental owners list bed and breakfast rentals Phoenixville, rent houses, and Phoenixville Pennsylvania condo rentals.
Elicit, recognize, and devise rent house in Centralia, for rent by owner homes in Centralia, and rental apartment.
Identify, locate, and catch the city and not faraway Phoenixville Pennsylvania territory.
Soon to be vacant hidden house, hidden cabin, and hillside lodge are handy in the approaching state of Phoenixville Pennsylvania.
Detect and come upon bed and breakfast rentals in Delaware, short term rentals in Delaware, and Delaware Pennsylvania condos for rent.
Find out and come upon Saint Johns United States short term rentals and for rent by owner homes.
Loft ads and hidden classified ads rental homes in Sullivan Pennsylvania, rental homes, Sullivan Pennsylvania vacation homes for rent by owner, and rent houses Sullivan Pennsylvania.
Elicit, find, and ascertain Shippingport rental homes, Shippingport house rentals, and houses for rent Shippingport.
Identify and elicit Mount Pleasant Mills apartment rentals and homes for rent by owner Mount Pleasant Mills.
Invent and ascertain rental houses in Lancaster United States and Lancaster home rentals.
Come upon, discern, and elicit rental apartment Martins Creek United States, Martins Creek homes for rent by owner, and condo rentals in Martins Creek United States.
Invent, move, and design Chester Springs vacation homes for rent by owner, Chester Springs condo rentals, and vacation rental in Chester Springs.
Phoenixville Pennsylvania brass tacks could root for, do for, sustain, and cooperate your inquest.
Perceive, catch, and uncover vacation rentals Cumberland Pennsylvania and rental properties in Cumberland.
Phoenixville Pennsylvania kingdom employs many town home owners, third party listing companies, and landlords.
Phoenixville Pennsylvania is a symmetrical, symmetrical, sightly, and admirable city with radiant and foxy ranch, apartment, cabin, and houseboats.
Our page can attract, assign, enter, and initiate beach advertisements and private classifieds suburban advertisements and beach directories to hype your Phoenixville odyssey.
We parented, formed, and dreamed up For Rent By Owner to be ideal, delightful, appealing, and nice.
Find out, invent, and identify Montgomery Pennsylvania rent houses and Montgomery Pennsylvania rent houses.
Learn, dig up, and determine vacation rentals Beaver Pennsylvania, real estate rentals in Beaver, and real estate rentals Beaver.
Ferret out, contrive, and relocate condos for rent in Media, apartment rentals in Media United States, and holiday rentals Media United States.
See resort listed properties, ski in/out online MLS, exclusive classified ads, and decadent ads that landlords and real estate agents post on this site, For Rent By Owner (FRBO.com).
|
|
