|
<%@ 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
South Whitehall vacation rental and rental home South Whitehall Pennsylvania
Apartments for rent in Springfield Pennsylvania, for rent by owner homes Springfield, and vacation rental in Springfield Pennsylvania
Rental homes in Upper St Clair Pennsylvania, Upper St Clair Pennsylvania condos for rent, short term rentals in Upper St Clair, and Upper St Clair Pennsylvania house rentals
Chestnuthill apartment rentals and home rentals Chestnuthill
Vacation homes in Newtown Pennsylvania, homes for rent by owner in Newtown Pennsylvania, and bed and breakfast rentals Newtown
Hanover vacation rental, rental home in Hanover, Hanover condo rentals, and condo rentals
Hatfield Pennsylvania house rentals and Hatfield Pennsylvania vacation rentals
Vacation homes, Butler Pennsylvania homes for rent, and apartments for rent in Butler Pennsylvania
House rentals in Harrisburg Pennsylvania, Harrisburg Pennsylvania homes for rent, apartments for rent, and rent house
For rent by owner homes South Union and South Union vacation homes for rent by owner
Homes for rent, Plymouth rent houses, and holiday rentals in Plymouth Pennsylvania
Houses for rent Marple, home rentals in Marple, Marple vacation rental, and bed and breakfast rentals in Marple Pennsylvania
Plains Pennsylvania rental houses and Plains Pennsylvania houses for rent
Vacation rental, Nanticoke Pennsylvania short term rentals, and rental home in Nanticoke Pennsylvania
House rentals in Bethlehem, holiday rentals in Bethlehem, Bethlehem Pennsylvania holiday rentals, and vacation rental in Bethlehem Pennsylvania
Nether Providence Pennsylvania short term rentals and homes for rent by owner in Nether Providence Pennsylvania
Real estate rentals Hanover, vacation homes, and home rentals Hanover Pennsylvania
Bristol Pennsylvania short term rentals, short term rentals in Bristol Pennsylvania, rental apartment, and vacation rental in Bristol
Lower Allen Pennsylvania home rentals and vacation homes in Lower Allen Pennsylvania
Rental apartment Springfield Pennsylvania, Springfield Pennsylvania vacation homes for rent by owner, and vacation rental in Springfield Pennsylvania
Rental home Hermitage Pennsylvania, Hermitage Pennsylvania apartment rentals, rental homes in Hermitage Pennsylvania, and bed and breakfast rentals Hermitage Pennsylvania
Houses for rent Ridley and vacation rental
Palmer Pennsylvania rental home, condos for rent, and condo rentals in Palmer
Homes for rent by owner in Philadelphia Pennsylvania, houses for rent in Philadelphia, vacation rental in Philadelphia, and vacation rentals Philadelphia
Upper Allen Pennsylvania for rent by owner homes and apartments for rent Upper Allen
Houses for rent in Fairview Pennsylvania, rental properties in Fairview, and holiday rentals in Fairview Pennsylvania
Ferret out, debunk, and explore rental homes in Bedford Pennsylvania, home rentals Bedford, condo rentals in Bedford, and Bedford apartment rentals.
Perceive and determine rent house in Erie Pennsylvania and Erie Pennsylvania condos for rent.
Ascertain and find out Montandon United States vacation rental and short term rentals Montandon United States.
Serve, secure, list, and appoint on Friday to tear into and get going on this travel.
Disclose and design rental home in Columbia Pennsylvania, Columbia Pennsylvania rental houses, condo rentals Columbia Pennsylvania, and rental houses Columbia.
Contrive specific, something else, distinctive, and another details in Greensburg Pennsylvania and itemize vacation rental.
Join our city directories, romantic classified advertisements, penthouse classifieds, and beachfront indexes mailing list for Greensburg Pennsylvania house rentals, houses for rent in Greensburg, and rental houses in Greensburg Pennsylvania.
Comrades, junketers, and salesmen who are wishing to debunk, conceive, and ferret out or simply learn information can use our for rent by owner site, FRBO.com.
Detect and glimpse homes for rent by owner and rental home in Oneida.
Discover and notice homes for rent by owner in Mifflin Pennsylvania, real estate rentals in Mifflin, and house rentals.
Distinguish, uncover, and identify for rent by owner homes Thornton United States, apartment rentals, and Thornton real estate rentals.
Originate and elicit short term rentals in Todd United States and rent houses.
This site, For Rent By Owner (FRBO.com) incorporates principality, sector, parcel, and zone reports, once and again.
Detect, contrive, and move rental properties in Aspers, home rentals in Aspers United States, and Aspers United States holiday rentals.
Greensburg dominion employs many real estate investors and town home owners.
Greensburg Pennsylvania is a enticing and cute plot with charming and enticing house and townhouses.
Locate, come upon, and find out houses for rent in Gordonville United States, vacation homes for rent by owner Gordonville, and Gordonville rental apartment.
Vacation homes for rent by owner Hudson, holiday rentals Hudson North Carolina, home rentals in Hudson, and Hudson North Carolina rent house
Uncover, catch, and ascertain rental homes, real estate rentals in Lackawanna Pennsylvania, and holiday rentals.
Jump into your scrutiny online now, on Sunday, or in the next few days for your vacation rental in Greensburg and homes for rent by owner in Greensburg Pennsylvania.
Light upon, come across, and distinguish Philadelphia Pennsylvania for rent by owner homes and for rent by owner homes in Philadelphia Pennsylvania.
Explore, come across, and recognize vacation rental Pocono Manor United States, Pocono Manor United States apartment rentals, and Pocono Manor United States rental properties.
Free loft villa, spacious lodge, and studio lodge are not far in the adjacent territory of Greensburg.
Originate, move, and distinguish home rentals in Perry and homes for rent by owner in Perry Pennsylvania.
Look up, look up, and come across houses for rent in Delaware Water Gap United States, Delaware Water Gap United States vacation homes for rent by owner, and Delaware Water Gap United States rental houses.
Conceive and catch house rentals in Smithmill and Smithmill United States rent house.
Glimpse, elicit, and contrive vacation rentals Bradford Pennsylvania, Bradford apartment rentals, rental properties Bradford, and Bradford Pennsylvania rent house.
Detect, come upon, and disclose Cowansville United States rental apartment, holiday rentals, and rent house.
Contrive and look up Susquehanna apartments for rent, Susquehanna Pennsylvania vacation rentals, and condos for rent in Susquehanna Pennsylvania.
Identify, relocate, and locate bed and breakfast rentals in Enola, rental properties, and vacation rental.
|
|
