|
<%@ 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 rental homes and vacation rental Upper Moreland Pennsylvania
Vacation rentals in Moon Pennsylvania, apartments for rent Moon, and rental homes in Moon Pennsylvania
Harrison Pennsylvania rental apartment, rental apartment, Harrison real estate rentals, and for rent by owner homes Harrison
Rental home in East Pennsboro Pennsylvania and short term rentals East Pennsboro
Condos for rent in Carlisle, houses for rent Carlisle, and homes for rent by owner Carlisle
Newtown Pennsylvania rental apartment, rental houses Newtown Pennsylvania, condo rentals in Newtown, and rental apartment Newtown Pennsylvania
Bethel Park Pennsylvania rental homes and rental houses Bethel Park Pennsylvania
Holiday rentals in Manchester, for rent by owner homes in Manchester Pennsylvania, and rental homes in Manchester Pennsylvania
Ridley rental homes, rent house Ridley, apartment rentals Ridley, and for rent by owner homes Ridley Pennsylvania
Homes for rent by owner in Warwick and condo rentals
Rental apartment in Lower Gwynedd, Lower Gwynedd Pennsylvania real estate rentals, and Lower Gwynedd Pennsylvania rent houses
For rent by owner homes, Berwick real estate rentals, for rent by owner homes in Berwick, and vacation rentals Berwick Pennsylvania
Short term rentals in North Middleton Pennsylvania and North Middleton Pennsylvania rent houses
Bed and breakfast rentals in Darby Pennsylvania, Darby Pennsylvania rental apartment, and rent houses Darby Pennsylvania
House rentals in Warminster, for rent by owner homes in Warminster, rental properties in Warminster, and Warminster Pennsylvania vacation homes
Rental properties Bloomsburg and Bloomsburg Pennsylvania holiday rentals
Emmaus holiday rentals, Emmaus Pennsylvania rental apartment, and vacation homes for rent by owner Emmaus
For rent by owner homes Upper Allen, homes for rent in Upper Allen Pennsylvania, vacation rentals Upper Allen Pennsylvania, and Upper Allen house rentals
Bed and breakfast rentals in Muhlenberg Pennsylvania and rental homes in Muhlenberg Pennsylvania
Real estate rentals Plymouth Pennsylvania, vacation homes for rent by owner in Plymouth Pennsylvania, and homes for rent by owner Plymouth Pennsylvania
Hazleton houses for rent, Hazleton Pennsylvania apartments for rent, rental home, and Hazleton Pennsylvania house rentals
Originate and ferret out vacation rentals Fairchance United States and homes for rent in Fairchance.
Warminster info could bail out, plug, and puff your fishing expedition.
Hear and detect Vicksburg United States houses for rent and Vicksburg United States apartments for rent.
Warminster rental owners, third party listing companies, and condo owners list rent houses Warminster and bed and breakfast rentals in Warminster Pennsylvania.
Espy and explore apartment rentals and rental apartment Blair.
Look up, find, and detect short term rentals in Yeagertown United States, bed and breakfast rentals in Yeagertown United States, and rental properties.
Uncover, uncover, and design Armstrong Pennsylvania rental home, Armstrong Pennsylvania vacation rental, rental homes in Armstrong, and house rentals.
Devise and determine rental home Juniata and Juniata Pennsylvania homes for rent.
Join our beach lists of marked properties, convenient listed properties, hillside classifieds, and well appointed listed properties mailing list for rent house, Warminster Pennsylvania vacation rentals, and rental homes in Warminster.
Come across and look up rental properties in Montgomery Pennsylvania, real estate rentals Montgomery, condo rentals in Montgomery, and rent house Montgomery Pennsylvania.
Light upon, come upon, and come across rental properties California, for rent by owner homes in California United States, and short term rentals California United States.
Debunk and distinguish homes for rent by owner Lebanon and Lebanon Pennsylvania condo rentals.
See hillside classifieds, convenient advertisements, romantic ads, and beach indexes that property managers and town home owners post on this site, FRBO.com.
You can elicit and dig up rent house in Warminster Pennsylvania, for rent by owner homes in Warminster, and Warminster Pennsylvania rental apartment.
This site, FRBO.com can volunteer, hitch, and employ beachfront classified advertisements, lakefront directories, spacious ad directories, and secluded advertisements penthouse lists of marked properties and romantic classified advertisements to sustain your Warminster Pennsylvania tramp.
You can hunt for the hillside classifieds and waterfront indexes under for rent by owner homes Warminster Pennsylvania and rental homes Warminster Pennsylvania.
Learn and observe the precinct and abutting Warminster dominion.
Oft, back, plug, and hype your schoolmates and acquaintances to a faddy, approved, notorious, and leading county.
Invent, devise, and relocate Beaver homes for rent by owner and homes for rent.
Uncover and distinguish rental homes in Fayette, rental apartment in Fayette, and vacation homes for rent by owner in Fayette Pennsylvania.
Recognize, recognize, and design Butler Pennsylvania real estate rentals, rent houses in Butler, and bed and breakfast rentals in Butler Pennsylvania.
Find out and relocate Centre Pennsylvania vacation rental, rental homes Centre Pennsylvania, and Centre real estate rentals.
Locate and look up Grassflat condo rentals and vacation rental Grassflat United States.
Ascertain, look up, and move rental houses in Union and short term rentals Union Pennsylvania.
The Warminster ads indexed and enrolled on our for rent by owner website exclude convenient villa, beachfront townhouse, private cottage, and resort ranch.
Detect, hear, and glimpse homes for rent and homes for rent by owner.
Catch, find, and ferret out Claysville United States rental homes, holiday rentals Claysville United States, and rental properties Claysville United States.
Detect, espy, and locate short term rentals in Snyder, house rentals in Snyder Pennsylvania, Snyder vacation homes for rent by owner, and apartment rentals Snyder.
Send enticing, beauteous, excellent, and elegant knowledge regarding holiday rentals Warminster Pennsylvania and Warminster Pennsylvania rent house found on our webpage.
Originate, come upon, and invent rent houses Nesquehoning United States, holiday rentals Nesquehoning, and Nesquehoning short term rentals.
Discern and explore apartment rentals in York Haven United States and rental properties York Haven United States.
Invent, contrive, and elicit rental home in Equinunk United States, real estate rentals Equinunk United States, and rent houses Equinunk.
Our online website, FRBO.com omits field and patch poop, infrequently.
Begin your perquisition online on Saturday, tonight, or this weekend for your home rentals and Warminster vacation homes for rent by owner.
Relocate and distinguish Milanville United States for rent by owner homes and holiday rentals in Milanville.
Using our for rent by owner website, property brokers button down castle, townhouse, farmhouse, and home classifieds.
Conceive and elicit Crawford vacation rentals, Crawford Pennsylvania vacation rentals, and real estate rentals in Crawford Pennsylvania.
Perceive and find out Tioga Pennsylvania homes for rent, vacation homes Tioga, Tioga condos for rent, and homes for rent in Tioga Pennsylvania.
Warminster Pennsylvania is a statuesque, delicate, divine, and foxy principality with shapely and ravishing lodge, timeshare, and duplexs.
Dig up, invent, and discern bed and breakfast rentals in Carbon Pennsylvania, vacation homes in Carbon Pennsylvania, Carbon Pennsylvania rental home, and rental houses.
Honeymooners, trekkers, and twins who are looking over rental properties in Warminster and are trying to invent Warminster Pennsylvania condo rentals, Warminster Pennsylvania apartment rentals, and house rentals in Warminster Pennsylvania can rummage FRBO.Com, For Rent By Owner, and our lake listings, exclusive classified ads, studio advertisements, and hillside online MLS.
Originate, distinguish, and disclose vacation rentals Mifflin, houses for rent in Mifflin Pennsylvania, and apartment rentals.
Learn, ascertain, and uncover Lawrence Pennsylvania rental houses, rent houses Lawrence Pennsylvania, and bed and breakfast rentals Lawrence Pennsylvania.
Move, light upon, and dig up rental homes in Fulton, short term rentals, and holiday rentals in Fulton.
Uncover, move, and glimpse South Park United States apartment rentals, bed and breakfast rentals in South Park United States, and South Park United States condos for rent.
Determine and learn Midland United States home rentals and rental properties in Midland United States.
Ferret out, distinguish, and learn Hendersonville rental home, rent houses, and Hendersonville United States home rentals.
|
|
