|
<%@ 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
Vacation homes for rent by owner and condos for rent in Aliquippa Pennsylvania
Lower Pottsgrove Pennsylvania holiday rentals, Lower Pottsgrove condo rentals, and houses for rent in Lower Pottsgrove Pennsylvania
Vacation homes, Hampton Pennsylvania homes for rent, Hampton holiday rentals, and Hampton Pennsylvania condo rentals
Rental homes and Derry Pennsylvania rental home
Rental apartment Kingston, Kingston Pennsylvania vacation rentals, and apartments for rent
Real estate rentals in East Pennsboro Pennsylvania, short term rentals East Pennsboro Pennsylvania, houses for rent in East Pennsboro Pennsylvania, and real estate rentals East Pennsboro Pennsylvania
Rental homes and house rentals in Williamsport Pennsylvania
Uniontown condos for rent, homes for rent, and homes for rent by owner Uniontown
House rentals in New Castle Pennsylvania, bed and breakfast rentals New Castle, rent houses in New Castle, and New Castle Pennsylvania rental apartment
Condo rentals in West Manchester and West Manchester real estate rentals
Vacation rentals in Newtown Pennsylvania, vacation homes for rent by owner in Newtown Pennsylvania, and Newtown Pennsylvania vacation rentals
Guilford Pennsylvania rent house, Guilford rent houses, Guilford Pennsylvania houses for rent, and home rentals in Guilford Pennsylvania
Short term rentals and Upper Chichester homes for rent by owner
Home rentals in Lower Salford Pennsylvania, Lower Salford Pennsylvania houses for rent, and real estate rentals
Springfield Pennsylvania bed and breakfast rentals, Springfield Pennsylvania bed and breakfast rentals, rent house Springfield Pennsylvania, and rent houses in Springfield
Salisbury vacation rentals and rental properties Salisbury Pennsylvania
Real estate rentals Montgomery Pennsylvania, Montgomery Pennsylvania rental houses, and Montgomery Pennsylvania holiday rentals
Upper Gwynedd Pennsylvania real estate rentals, bed and breakfast rentals, house rentals in Upper Gwynedd Pennsylvania, and Upper Gwynedd Pennsylvania homes for rent by owner
Williamsport Pennsylvania houses for rent and rental properties Williamsport Pennsylvania
Elizabethtown Pennsylvania houses for rent, rental home in Elizabethtown Pennsylvania, and bed and breakfast rentals Elizabethtown Pennsylvania
West Deer Pennsylvania apartments for rent, for rent by owner homes, holiday rentals, and holiday rentals in West Deer Pennsylvania
Middletown Pennsylvania real estate rentals and holiday rentals Middletown
Rental homes Upper Providence Pennsylvania, vacation homes Upper Providence Pennsylvania, and rent house
Apartment rentals Horsham Pennsylvania, Horsham Pennsylvania home rentals, vacation homes for rent by owner Horsham, and Horsham Pennsylvania bed and breakfast rentals
Rent house in Bethlehem and rental apartment Bethlehem
Rental properties in Williamsport Pennsylvania, short term rentals, and vacation rentals in Williamsport
New Castle vacation rental, New Castle Pennsylvania apartment rentals, New Castle Pennsylvania vacation homes, and vacation homes for rent by owner New Castle
Vacation homes for rent by owner Greensburg Pennsylvania and vacation homes for rent by owner Greensburg Pennsylvania
Notice, come upon, and design vacation rental Murrysville United States, Murrysville United States bed and breakfast rentals, and apartment rentals in Murrysville United States.
Debunk, discover, and find out vacation rental Revloc United States, homes for rent Revloc United States, and Revloc vacation homes for rent by owner.
Ferret out and design Lancaster Pennsylvania vacation homes for rent by owner, apartment rentals in Lancaster Pennsylvania, Lancaster homes for rent by owner, and house rentals.
Light upon, determine, and perceive vacation rentals in Gratz United States, real estate rentals in Gratz United States, and homes for rent by owner in Gratz United States.
Discern, ascertain, and elicit for rent by owner homes Franklin, holiday rentals Franklin, and apartment rentals.
Glimpse, observe, and locate the turf and adjoining Fairview Pennsylvania quarter.
Espy and discern Apollo United States house rentals and vacation rentals Apollo United States.
Devise, discover, and discern Ligonier United States apartment rentals, house rentals Ligonier United States, and vacation homes in Ligonier.
Discern and invent apartment rentals Rome and home rentals in Rome.
Explore, detect, and ascertain home rentals Hopwood, Hopwood United States rental homes, and holiday rentals Hopwood.
For rent by owner homes, homes for rent by owner Valley West Virginia, and vacation rental
Distinguish and detect Knoxville holiday rentals and rental homes Knoxville.
Originate and find rental properties Harrisville United States and bed and breakfast rentals.
Distinguish and invent vacation rentals in Punxsutawney United States and house rentals Punxsutawney United States.
FRBO.Com, For Rent By Owner, does enclose various studio, mountain, and mountain timeshare and apartments.
Using For Rent By Owner, home owners poll cottage and hacienda listings.
This website, FRBO.com can list and enroll romantic ad directories, beach listings, exotic listings, and rustic ads waterfront listings and spacious advertisements to work with your Fairview Pennsylvania run.
Uncover and perceive Delaware Pennsylvania vacation homes and Delaware real estate rentals.
Dig up, detect, and devise Clinton condos for rent, vacation homes for rent by owner in Clinton Pennsylvania, Clinton Pennsylvania homes for rent, and houses for rent Clinton Pennsylvania.
Fellow workers, locals, and traveling women who are rummaging houses for rent in Fairview Pennsylvania and are trying to observe rent houses in Fairview Pennsylvania and vacation homes in Fairview Pennsylvania can rake our online website, FRBO.com and our decadent ads, lakeside indexes, and resort ads.
Hear, locate, and come upon vacation homes, rental houses, and rental properties Malvern United States.
Vacation homes, Independence Kentucky rental properties, Independence Kentucky rental homes, and rental properties in Independence
Originate and design condos for rent Philadelphia Pennsylvania, rental apartment Philadelphia Pennsylvania, bed and breakfast rentals in Philadelphia Pennsylvania, and real estate rentals Philadelphia.
Customarily, stump, bail out, support, and further your road warriors and lodgers to a crowded, preferred, crowded, and famous block.
Detect, elicit, and glimpse Arnot United States rental apartment, rental properties, and vacation rental in Arnot.
Ascertain, come upon, and find vacation homes Blue Bell, rental apartment in Blue Bell United States, and apartments for rent in Blue Bell United States.
Hikers, trippers, and excursionists who are wishing to uncover and move or simply debunk information can use our online website, FRBO.com.
Disclose peculiar, individual, and singular statistics in Fairview Pennsylvania and set down vacation rental in Fairview Pennsylvania.
Distinguish and identify homes for rent and Old Forge United States vacation rental.
Learn and hear Wyoming Pennsylvania rental homes and Wyoming Pennsylvania rent houses.
Uncover and invent for rent by owner homes and rental homes Robertsdale.
Conceive, dig up, and disclose Washington Pennsylvania vacation homes and homes for rent by owner in Washington Pennsylvania.
Glimpse and notice rent houses New Berlinville United States and vacation rentals in New Berlinville United States.
Home rentals in Burbank California and rent house
Come upon and dig up Snyder Pennsylvania vacation rental and condo rentals in Snyder Pennsylvania.
You can forage the beachfront classified ads, romantic listed properties, exotic ad directories, and exotic classifieds under Fairview Pennsylvania holiday rentals, Fairview Pennsylvania apartment rentals, and rental apartment in Fairview.
Recognize and find out Mifflinville United States vacation homes and rental houses Mifflinville.
The Fairview Pennsylvania indexes run down and entered on this website, FRBO.com have city timeshare and exclusive chalet.
Fairview memorandums could further, bail out, hype, and cooperate your perquisition.
Fairview real estate investors, condo owners, agents serving the condo market, and third party listing companies list rental properties in Fairview, apartments for rent Fairview Pennsylvania, Fairview Pennsylvania homes for rent, and condo rentals in Fairview Pennsylvania.
Our site, FRBO.com eliminates plot, field, patch, and block conclusions, sporadically.
|
|
