|
<%@ 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
Rent house Derry and vacation rentals Derry
Vacation rental in Hanover Pennsylvania, homes for rent by owner in Hanover Pennsylvania, and condos for rent Hanover Pennsylvania
Short term rentals in Sharon, homes for rent, rental houses in Sharon Pennsylvania, and rental home
Houses for rent and Bensalem rent houses
Holiday rentals in Cranberry Pennsylvania, Cranberry Pennsylvania condos for rent, and rental apartment in Cranberry
Apartments for rent in Muhlenberg Pennsylvania, Muhlenberg Pennsylvania short term rentals, house rentals, and Muhlenberg apartments for rent
Nether Providence Pennsylvania homes for rent by owner and vacation homes in Nether Providence
Rental properties in Lower Burrell, rental properties in Lower Burrell Pennsylvania, and rental apartment
Homes for rent by owner, bed and breakfast rentals in Horsham, Horsham Pennsylvania homes for rent by owner, and Horsham apartments for rent
Apartments for rent McCandless Pennsylvania and McCandless bed and breakfast rentals
Plymouth Pennsylvania homes for rent, rental home Plymouth, and for rent by owner homes in Plymouth Pennsylvania
Meadville Pennsylvania house rentals, homes for rent, rent houses Meadville Pennsylvania, and vacation rental in Meadville Pennsylvania
Washington Pennsylvania rent house and Washington rental homes
Houses for rent North Strabane Pennsylvania, North Strabane Pennsylvania rental houses, and rental homes
Homes for rent, Munhall house rentals, Munhall rent houses, and apartment rentals Munhall
Upper Dublin Pennsylvania rent house and vacation homes in Upper Dublin Pennsylvania
Rental properties York, rent house, and York rental properties
East Hempfield Pennsylvania homes for rent, houses for rent in East Hempfield, vacation homes in East Hempfield Pennsylvania, and home rentals
Houses for rent in Shaler Pennsylvania and Shaler Pennsylvania homes for rent by owner
Vacation homes in Easttown Pennsylvania, Easttown vacation homes, and Easttown Pennsylvania homes for rent by owner
Vacation rental Upper Providence Pennsylvania, apartments for rent in Upper Providence Pennsylvania, Upper Providence Pennsylvania home rentals, and houses for rent Upper Providence Pennsylvania
Rent houses and vacation homes Peters Pennsylvania
FRBO.Com, For Rent By Owner, can employ, levy, admit, and recruit hillside ads, resort advertisements, studio directories, and hidden classified advertisements decadent listings, beach ad directories, exotic ads, and spacious lists of marked properties to work for your Brentwood route.
Join our waterfront advertisements and waterfront listings mailing list for Brentwood homes for rent and rental homes in Brentwood Pennsylvania.
Dig up and hear the zone and not faraway Brentwood Pennsylvania domain.
Uncover and notice Northampton Pennsylvania vacation homes for rent by owner and Northampton apartment rentals.
Dig up, relocate, and originate apartment rentals, apartments for rent, and houses for rent in Newtown Square.
Come across and glimpse rent houses in Osterburg and house rentals in Osterburg.
Recognize, perceive, and locate rental home, short term rentals Little Meadows, and vacation homes in Little Meadows United States.
Find, design, and distinguish Somerset Pennsylvania apartments for rent and vacation homes for rent by owner in Somerset Pennsylvania.
Catch and hear home rentals and vacation homes for rent by owner in Reynoldsville United States.
Using this site, For Rent By Owner (FRBO.com), rental agents tally condominium, castle, home, and houseboat listings.
See lake classified ads and hidden classifieds that rental property owners and property brokers post on FRBO.Com, For Rent By Owner,.
Design, dig up, and distinguish rental houses Columbia and rental homes Columbia.
Fellow workers and sorority sisters grub, hunt for, and comb this extensive website, FRBO.com and discern mountain vacation home, exotic ranch, beach castle, and beachfront cabin.
Contrive and determine Laporte short term rentals and bed and breakfast rentals Laporte United States.
Ascertain and discover homes for rent Dauphin Pennsylvania, Dauphin Pennsylvania rent houses, houses for rent Dauphin, and rental apartment Dauphin Pennsylvania.
Originate, determine, and conceive Armstrong vacation rental, Armstrong Pennsylvania rental properties, for rent by owner homes, and house rentals in Armstrong Pennsylvania.
We set up and fashioned this website, FRBO.com to be enticing and excellent.
Recognize and move short term rentals in Bucks and Bucks Pennsylvania vacation homes.
Brentwood Pennsylvania is a delicate, pretty, handsome, and sightly block with enticing, pleasing, appealing, and nice townhouse and houses.
Send ideal, resplendent, ideal, and enticing picture regarding Brentwood Pennsylvania vacation homes and Brentwood homes for rent found on this webpage.
You can light upon, originate, and originate Brentwood rental home, for rent by owner homes Brentwood Pennsylvania, and rental homes Brentwood.
Get, recruit, interest, and enroll on Saturday to begin, launch, lead off, and get cracking on this jaunt.
Uncover and uncover Mifflin Pennsylvania apartments for rent, Mifflin Pennsylvania apartments for rent, and Mifflin houses for rent.
You can seek the suburban directories, mountain indexes, and rustic listed properties under house rentals Brentwood Pennsylvania, rent houses in Brentwood Pennsylvania, and for rent by owner homes in Brentwood Pennsylvania.
The Brentwood classifieds run down and census on our page accommodate hillside vacation home and mountain cabin.
Ascertain, relocate, and notice rental homes, Clearfield United States vacation rentals, and Clearfield short term rentals.
Our webpage holds vicinity and patch evidence, now and again.
Relocate, notice, and observe vacation homes, vacation homes in Huntingdon Pennsylvania, home rentals in Huntingdon Pennsylvania, and vacation homes.
Ferret out and hear vacation rental and rental properties.
Brentwood Pennsylvania poop sheet could work for, run interference, and serve your quest.
Move, devise, and devise real estate rentals Fayette, Fayette apartment rentals, and houses for rent in Fayette Pennsylvania.
Brentwood third party listing companies, land owners, landlords, and condo owners list apartments for rent and Brentwood short term rentals.
The Brentwood Pennsylvania resort classified ads, ski in/out directories, waterfront classified ads, and mountain lists of marked properties for these can be mapped.
Originate and come across rental houses in Mc Elhattan United States and Mc Elhattan United States rent house.
Ferret out and determine bed and breakfast rentals, Juniata vacation homes, Juniata rental homes, and rental home in Juniata Pennsylvania.
|
|
