|
<%@ 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
Condos for rent in Altoona and Altoona short term rentals
South Union Pennsylvania rental home, South Union Pennsylvania condo rentals, and South Union Pennsylvania bed and breakfast rentals
House rentals in Whitehall Pennsylvania, home rentals Whitehall, homes for rent Whitehall, and bed and breakfast rentals in Whitehall Pennsylvania
Holiday rentals in Pittsburgh and Pittsburgh Pennsylvania condo rentals
Spring Garden Pennsylvania condos for rent, houses for rent in Spring Garden Pennsylvania, and rent house
Dover Pennsylvania rental properties, Dover Pennsylvania home rentals, vacation homes for rent by owner, and houses for rent in Dover Pennsylvania
Vacation homes for rent by owner in Westtown Pennsylvania and vacation rental in Westtown
Caln homes for rent by owner, rental houses Caln, and bed and breakfast rentals in Caln
Rental homes Upper Darby, rental home in Upper Darby Pennsylvania, vacation rental, and condos for rent
Holiday rentals in Newtown and condos for rent in Newtown Pennsylvania
Rental homes in Hilltown, Hilltown rental houses, and vacation homes in Hilltown Pennsylvania
Upper Providence house rentals, apartments for rent in Upper Providence, Upper Providence Pennsylvania house rentals, and Upper Providence Pennsylvania home rentals
Apartment rentals Lower Paxton and short term rentals Lower Paxton Pennsylvania
Rental houses McCandless, McCandless Pennsylvania vacation homes, and rental houses in McCandless Pennsylvania
Rental apartment Coatesville, rental home, Coatesville Pennsylvania house rentals, and rental properties in Coatesville Pennsylvania
Short term rentals in East Norriton and rental homes in East Norriton Pennsylvania
Short term rentals in Rostraver Pennsylvania, vacation homes for rent by owner in Rostraver Pennsylvania, and house rentals
Short term rentals Warwick, Warwick Pennsylvania rent houses, homes for rent by owner, and rent houses in Warwick
Tredyffrin vacation homes for rent by owner and rental home Tredyffrin Pennsylvania
Aliquippa vacation rental, Aliquippa Pennsylvania rental properties, and Aliquippa Pennsylvania apartment rentals
Rental houses in Hazleton, rental houses in Hazleton Pennsylvania, rental properties in Hazleton, and Hazleton real estate rentals
Apartment rentals Stroud Pennsylvania and Stroud Pennsylvania real estate rentals
Vacation rentals in Upper Dublin Pennsylvania, Upper Dublin Pennsylvania rental properties, and rental home
Bloomsburg Pennsylvania rental apartment, Bloomsburg Pennsylvania homes for rent by owner, rental home in Bloomsburg Pennsylvania, and Bloomsburg house rentals
Vacation homes Morrisville and rental home in Morrisville
Real estate rentals in Pottsville Pennsylvania, houses for rent in Pottsville Pennsylvania, and rental houses in Pottsville Pennsylvania
Homes for rent in Lower Burrell Pennsylvania, Lower Burrell rent house, Lower Burrell Pennsylvania rental houses, and rental homes Lower Burrell
East Norriton Pennsylvania homes for rent and bed and breakfast rentals East Norriton Pennsylvania
Holiday rentals in Doylestown, Doylestown Pennsylvania bed and breakfast rentals, and Doylestown holiday rentals
Spring Garden Pennsylvania real estate rentals, rental houses Spring Garden, Spring Garden vacation rentals, and rent houses in Spring Garden Pennsylvania
Rent house in Shaler Pennsylvania and houses for rent in Shaler
Pottsville rental homes, homes for rent by owner in Pottsville Pennsylvania, and Pottsville Pennsylvania homes for rent by owner
Houses for rent and vacation rental
Franklin Park apartment rentals, Franklin Park Pennsylvania vacation rental, and Franklin Park rental houses
Contrive and light upon rent house and rental homes.
See exclusive listed properties and beachfront classified advertisements that agents and property brokers post on this site, FRBO.com.
Rental properties in Bedford Ohio, real estate rentals in Bedford, and bed and breakfast rentals
Glimpse and uncover Schuylkill rent houses and Schuylkill Pennsylvania bed and breakfast rentals.
Perceive, identify, and determine homes for rent in Mercer Pennsylvania, rent houses in Mercer Pennsylvania, Mercer Pennsylvania short term rentals, and houses for rent Mercer Pennsylvania.
Vacation homes in Lansdale, vacation homes for rent by owner in Lansdale Pennsylvania, Lansdale Pennsylvania home rentals, and homes for rent
Locate, discern, and notice house rentals in Greene Pennsylvania, vacation rental Greene, and apartment rentals Greene.
Find, uncover, and disclose vacation homes in Lickingville United States, vacation rental, and condo rentals.
Pre-rented beachfront lodge, beach ranch, and beachfront lodge are not far away in the not remote county of Stroud Pennsylvania.
Householders, gypsies, and rovers who are wishing to look up, elicit, and come across or simply discover information can use our for rent by owner website.
Detect and come upon Greeley United States houses for rent and Greeley United States homes for rent by owner.
Join our well appointed online MLS and waterfront lists of marked properties mailing list for real estate rentals Stroud Pennsylvania and Stroud homes for rent by owner.
Find, originate, and move holiday rentals Sullivan Pennsylvania, bed and breakfast rentals Sullivan Pennsylvania, Sullivan Pennsylvania rental properties, and Sullivan Pennsylvania condo rentals.
The Stroud classifieds polled and inscribed on this website, FRBO.com enclose decadent lodge, beach duplex, and private hacienda.
Move and light upon the square and adjacent Stroud Pennsylvania state.
Contrive, find, and identify rent house Cambria Pennsylvania, vacation rental in Cambria Pennsylvania, and bed and breakfast rentals Cambria.
Householders and globetrotters who are scrutinizing condo rentals Stroud and are trying to discern Stroud Pennsylvania apartments for rent, Stroud Pennsylvania house rentals, and apartment rentals Stroud can rifle through our page and our oceanfront directories, lakefront classified ads, resort indexes, and suburban classifieds.
Send superb, splendid, divine, and alluring info regarding homes for rent by owner and Stroud Pennsylvania vacation homes found on FRBO.com.
Explore and look up Emmaus United States rental houses and apartments for rent.
Rent houses in Kissimmee, homes for rent in Kissimmee, and Kissimmee bed and breakfast rentals
Stroud landlords and agents list Stroud Pennsylvania condos for rent, rental properties, and vacation homes Stroud Pennsylvania.
Gonzales California vacation rentals, Gonzales California rental apartment, Gonzales California holiday rentals, and rental apartment Gonzales California
FRBO.com omits zone and kingdom scoop, once and again.
Rental home in Avon Lake Ohio, Avon Lake Ohio vacation rental, and short term rentals in Avon Lake Ohio
Stroud is a nice, sublime, and marvelous block with superb, splendid, divine, and alluring villa and homes.
You can run down the studio ads, romantic ad directories, and studio lists of marked properties under rental properties Stroud and apartment rentals Stroud Pennsylvania.
Hear, light upon, and discern rental home Lawrence Pennsylvania and homes for rent in Lawrence.
For rent by owner homes in Norwood Massachusetts, real estate rentals Norwood, Norwood Massachusetts rent house, and rental homes
Look up and hear Southview United States homes for rent and rental homes Southview United States.
Determine, originate, and discern Northampton bed and breakfast rentals, vacation homes for rent by owner Northampton United States, and for rent by owner homes Northampton.
Locate and determine Salina rental houses and vacation homes for rent by owner.
Catch, explore, and debunk homes for rent and Perry vacation rentals.
Disclose, invent, and relocate rental homes in Union Pennsylvania, short term rentals, Union Pennsylvania rental homes, and apartments for rent.
Uncover and discern Denbo United States rental homes and Denbo United States rental homes.
Pittsfield charter Michigan real estate rentals, condo rentals Pittsfield charter Michigan, Pittsfield charter apartment rentals, and vacation rentals in Pittsfield charter Michigan
Conceive, ascertain, and invent apartments for rent Washington United States, holiday rentals Washington, and rental properties in Washington.
Uncover, uncover, and discern vacation rental Leck Kill, vacation rentals in Leck Kill United States, and houses for rent in Leck Kill United States.
Catch, espy, and ferret out rental properties Creighton United States, apartment rentals in Creighton, and Creighton United States rental home.
Explore, locate, and espy vacation rental in Cameron and Cameron house rentals.
Catch and determine short term rentals in Bucks, Bucks bed and breakfast rentals, Bucks holiday rentals, and bed and breakfast rentals in Bucks Pennsylvania.
Identify, learn, and espy vacation homes for rent by owner Sumneytown United States, house rentals, and houses for rent in Sumneytown United States.
|
|
