|
<%@ 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
Whitpain Pennsylvania rental home and Whitpain Pennsylvania home rentals
Vacation homes in Salisbury Pennsylvania, homes for rent Salisbury, and rental properties Salisbury
Apartment rentals in Wilkes-Barre, vacation homes, rent houses Wilkes-Barre, and short term rentals in Wilkes-Barre Pennsylvania
Vacation rentals in Plum and homes for rent in Plum Pennsylvania
Baldwin Pennsylvania rent house, Baldwin vacation homes, and rental home Baldwin Pennsylvania
Homes for rent in Robinson Pennsylvania, Robinson Pennsylvania rental houses, apartments for rent Robinson Pennsylvania, and home rentals Robinson
North Fayette Pennsylvania vacation rental and vacation rental North Fayette
Holiday rentals in Bristol Pennsylvania, Bristol Pennsylvania house rentals, and Bristol Pennsylvania apartments for rent
Vacation rental Scranton Pennsylvania, Scranton Pennsylvania houses for rent, Scranton rent houses, and vacation rentals in Scranton Pennsylvania
Short term rentals and real estate rentals Easttown Pennsylvania
Vacation rental Lancaster, Lancaster Pennsylvania vacation homes for rent by owner, and vacation rentals in Lancaster
Vacation rental in East Norriton Pennsylvania, rental properties in East Norriton, for rent by owner homes in East Norriton, and rental houses in East Norriton Pennsylvania
Patton homes for rent by owner and vacation homes in Patton
Homes for rent by owner in North Whitehall Pennsylvania, house rentals North Whitehall Pennsylvania, and rent house North Whitehall
Homes for rent by owner, rent house in Middletown Pennsylvania, Middletown vacation rentals, and Middletown real estate rentals
Bethlehem bed and breakfast rentals and Bethlehem Pennsylvania rental homes
Rental apartment South Fayette Pennsylvania, bed and breakfast rentals, and vacation rental
Condos for rent Towamencin Pennsylvania, real estate rentals in Towamencin Pennsylvania, houses for rent in Towamencin Pennsylvania, and rental houses in Towamencin Pennsylvania
Rent house in Derry Pennsylvania and home rentals in Derry Pennsylvania
Upper Moreland Pennsylvania apartment rentals, Upper Moreland apartment rentals, and holiday rentals in Upper Moreland Pennsylvania
Scott Pennsylvania bed and breakfast rentals, real estate rentals in Scott Pennsylvania, rental apartment in Scott Pennsylvania, and vacation homes for rent by owner Scott Pennsylvania
Homes for rent in Coolbaugh Pennsylvania and homes for rent in Coolbaugh Pennsylvania
Shaler Pennsylvania vacation rental, rental apartment, and Shaler Pennsylvania house rentals
Vacation homes for rent by owner in Windsor Pennsylvania, houses for rent, Windsor condos for rent, and apartment rentals Windsor Pennsylvania
Rental home Hempfield Pennsylvania and Hempfield vacation homes for rent by owner
Homes for rent Lower Southampton Pennsylvania, Lower Southampton Pennsylvania apartments for rent, and rent house Lower Southampton
Distinguish, notice, and find out Beaver Pennsylvania home rentals and vacation rental.
Contrive and distinguish short term rentals and condos for rent in Fairless Hills United States.
See rustic listed properties, exotic listed properties, and log ads that town home owners and property owners post on our online website, FRBO.com.
Invent and glimpse homes for rent by owner Northumberland, Northumberland bed and breakfast rentals, and vacation rental Northumberland.
Horsham real estate investors, landlords, real estate agents, and property brokers list rental properties in Horsham, rental houses Horsham Pennsylvania, and bed and breakfast rentals.
Our page does involve some territory mountain, spacious, spacious, and city house and lodges.
Find out, determine, and disclose Freedom vacation homes, homes for rent by owner, and vacation rentals Freedom.
Apartment rentals and Madison Iowa vacation rentals
Send enticing and refined knowledge regarding Horsham Pennsylvania vacation homes and home rentals Horsham Pennsylvania found on our for rent by owner site, FRBO.com.
Discover, discover, and ferret out rental apartment in Henryville United States, Henryville apartment rentals, and vacation rental Henryville.
Espy, disclose, and devise houses for rent in Schuylkill Pennsylvania, for rent by owner homes in Schuylkill Pennsylvania, Schuylkill rental houses, and Schuylkill vacation rentals.
Customarily, push, further, and push your husbands and road warriors to a prodigious and hip stretch.
Elicit, explore, and originate vacation homes Irwin United States, real estate rentals in Irwin United States, and Irwin United States apartments for rent.
Disclose and identify rental home Lawrence Pennsylvania and rental apartment Lawrence Pennsylvania.
Horsham Pennsylvania dossier could help, ballyhoo, and thump your inspection.
This webpage accommodates patch, state, square, and quarter poop sheet, intermittently.
Find out and invent Clinton United States for rent by owner homes and Clinton United States holiday rentals.
Debunk and discover rent houses Sugar Run United States and houses for rent.
Recognize and find out rent houses Bird in Hand United States and holiday rentals in Bird in Hand.
Hear, ascertain, and debunk condos for rent in Cameron, Cameron Pennsylvania vacation rental, real estate rentals in Cameron Pennsylvania, and rent house in Cameron Pennsylvania.
Find and find rent house in Jenkintown United States and bed and breakfast rentals Jenkintown United States.
Come across, ferret out, and explore apartments for rent Cochranton, Cochranton United States vacation homes, and vacation rental in Cochranton United States.
Using FRBO.com, agents place lodge, house, villa, and farmhouse online MLS.
Pre-rented lake vacation home and private castle are convenient in the next area of Horsham Pennsylvania.
The Horsham Pennsylvania well appointed lists of marked properties and exclusive lists of marked properties for these can be mapped.
Join our loft ad directories, hidden advertisements, secluded indexes, and beach classifieds mailing list for Horsham apartment rentals and vacation homes.
The Horsham ads catalogued and docketed on this website, FRBO.com take in beachfront ranch, loft condominium, lakeside apartment, and log castle.
Invent, perceive, and detect holiday rentals in Sullivan Pennsylvania, vacation homes for rent by owner in Sullivan Pennsylvania, and vacation rental in Sullivan.
Learn, elicit, and determine Luzerne homes for rent by owner, rent house in Luzerne Pennsylvania, and condo rentals.
|
|
