|
<%@ 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 Abington Pennsylvania and home rentals Abington Pennsylvania
Rental houses Greene Pennsylvania, real estate rentals, and rent house in Greene Pennsylvania
Vacation rentals Franklin Park Pennsylvania, Franklin Park condo rentals, condos for rent in Franklin Park Pennsylvania, and rental apartment in Franklin Park Pennsylvania
House rentals and vacation homes for rent by owner in Guilford
Westtown Pennsylvania condo rentals, Westtown Pennsylvania house rentals, and Westtown vacation homes for rent by owner
East Hempfield homes for rent by owner, holiday rentals East Hempfield, apartments for rent in East Hempfield, and East Hempfield Pennsylvania homes for rent
Rent houses in Ephrata Pennsylvania and Ephrata Pennsylvania rental apartment
House rentals Whitehall, house rentals in Whitehall, and rental houses in Whitehall Pennsylvania
Vacation homes in East Norriton Pennsylvania, rent house in East Norriton, condos for rent, and vacation homes for rent by owner in East Norriton Pennsylvania
Municipality of Monroeville Pennsylvania house rentals and houses for rent Municipality of Monroeville Pennsylvania
Rental apartment Berwick, vacation homes for rent by owner in Berwick Pennsylvania, and real estate rentals
Condo rentals in Derry Pennsylvania, condos for rent in Derry, rental apartment in Derry, and Derry Pennsylvania apartments for rent
Real estate rentals Chester and vacation rentals
Condo rentals, Springfield Pennsylvania house rentals, and bed and breakfast rentals in Springfield Pennsylvania
Rental home in Bethlehem Pennsylvania, condo rentals, Bethlehem Pennsylvania vacation rental, and vacation rentals
North Versailles Pennsylvania for rent by owner homes and North Versailles Pennsylvania apartment rentals
Homes for rent by owner Penn Hills, Penn Hills Pennsylvania vacation homes, and for rent by owner homes Penn Hills
Rental houses in Derry Pennsylvania, Derry vacation rentals, holiday rentals, and Derry rental properties
Vacation homes and Wilkes-Barre Pennsylvania apartments for rent
Hanover Pennsylvania holiday rentals, real estate rentals in Hanover Pennsylvania, and short term rentals Hanover Pennsylvania
Short term rentals Hempfield Pennsylvania, Hempfield apartment rentals, real estate rentals in Hempfield Pennsylvania, and short term rentals Hempfield
Home rentals Greensburg Pennsylvania and short term rentals in Greensburg Pennsylvania
Vacation rentals Haverford Pennsylvania, vacation rental in Haverford Pennsylvania, and homes for rent in Haverford Pennsylvania
West Whiteland Pennsylvania rental apartment, West Whiteland vacation rental, bed and breakfast rentals West Whiteland, and West Whiteland apartment rentals
Hear and come upon condo rentals in Washington Pennsylvania and homes for rent in Washington.
Catch and move real estate rentals and Marietta United States rental apartment.
The Darby Pennsylvania log classified advertisements, studio ads, romantic classified ads, and hidden listings for these can be mapped.
Disclose, uncover, and come across apartments for rent Butler Pennsylvania, condos for rent Butler Pennsylvania, Butler holiday rentals, and rental apartment in Butler Pennsylvania.
Discern, disclose, and disclose Wayne bed and breakfast rentals, rental homes, and Wayne Pennsylvania rental houses.
Design and uncover rental home in Westmoreland Pennsylvania and condo rentals in Westmoreland.
Enter upon your wild-goose chase online tonight, tomorrow morning, on Saturday, or in the morning for your vacation homes for rent by owner Darby and Darby rental home.
Light upon, originate, and come upon Mount Carmel United States short term rentals, Mount Carmel rent houses, and Mount Carmel United States apartments for rent.
Perceive, elicit, and move rent house, condo rentals in Cameron Pennsylvania, and Cameron Pennsylvania rent houses.
Uncover, dig up, and find out condos for rent in East Brady, home rentals, and condos for rent.
Locate, distinguish, and hear vacation rentals Cranberry United States, vacation homes in Cranberry United States, and rental houses Cranberry United States.
Observe, ferret out, and notice real estate rentals in Clinton, vacation homes in Clinton Pennsylvania, and house rentals Clinton.
Debunk, discover, and uncover Clearfield apartment rentals and Clearfield apartments for rent.
Explore, dig up, and learn house rentals Lenhartsville United States, apartments for rent in Lenhartsville United States, and rental home Lenhartsville United States.
The Darby advertisements numerated and itemized on this site, For Rent By Owner (FRBO.com) consist of decadent chalet, studio villa, lake villa, and oceanfront timeshare.
We concocted and designed this webpage to be good-looking, pretty, appealing, and bewitching.
Darby Pennsylvania info could root for, benefit, stump, and back your inspection.
Perceive and contrive Buck Hill Falls United States apartment rentals and Buck Hill Falls United States rent houses.
Detect, dig up, and glimpse condo rentals in United States Furnace, rent house United States Furnace United States, and condos for rent United States Furnace United States.
Hear and conceive holiday rentals in Cameron, homes for rent by owner in Cameron Pennsylvania, rental home in Cameron, and rental home Cameron Pennsylvania.
Contrive and invent New Paris United States holiday rentals and New Paris United States short term rentals.
Come across and find short term rentals, apartments for rent, and rental home in Clearfield Pennsylvania.
Uncover, debunk, and find out house rentals Butler, rental homes Butler Pennsylvania, vacation rentals, and bed and breakfast rentals.
Learn diverse and special proof in Darby Pennsylvania and invoice vacation rental Darby.
Discover, detect, and originate rental apartment in Philadelphia, homes for rent in Philadelphia Pennsylvania, and houses for rent Philadelphia Pennsylvania.
Find and locate rental apartment in Centre and apartments for rent in Centre.
Identify and perceive McKean Pennsylvania short term rentals, condo rentals McKean Pennsylvania, and homes for rent by owner in McKean.
See resort listed properties, log online MLS, and beach advertisements that third party agents and rental agents post on FRBO.com.
Uncover and identify real estate rentals, rent houses in Armstrong, and rent houses Armstrong Pennsylvania.
Uncover, contrive, and observe the locality and nearly Darby Pennsylvania quarter.
Observe and look up bed and breakfast rentals Carmichaels United States and rental homes Carmichaels United States.
Cohorts and habitants who are probing condos for rent Darby Pennsylvania and are trying to glimpse Darby Pennsylvania vacation rentals, Darby Pennsylvania home rentals, and Darby Pennsylvania rental apartment can seek our site, FRBO.com and our log online MLS and beach classifieds.
This site, FRBO.com does consist of sparse sector decadent, suburban, beach, and mountain lodge and haciendas.
Conscribe and induct on Thursday to get going, take up, get going, and initiate on this vagrancy.
|
|
