|
<%@ 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
Pottsville holiday rentals and homes for rent in Pottsville Pennsylvania
Apartments for rent in Chestnuthill, vacation rentals in Chestnuthill Pennsylvania, and vacation rentals Chestnuthill
Center Pennsylvania apartment rentals, rent house in Center Pennsylvania, rental home in Center Pennsylvania, and rental houses
Condos for rent in Spring Garden Pennsylvania and Spring Garden Pennsylvania apartment rentals
Coal Pennsylvania holiday rentals, rental home, and Coal Pennsylvania condos for rent
Philadelphia houses for rent, rental home, Philadelphia Pennsylvania vacation homes, and Philadelphia Pennsylvania holiday rentals
Rent house and rental apartment in Hilltown Pennsylvania
Rent house East Goshen Pennsylvania, rental home in East Goshen Pennsylvania, and for rent by owner homes
Lower Moreland Pennsylvania holiday rentals, rental home in Lower Moreland Pennsylvania, homes for rent Lower Moreland, and Lower Moreland vacation homes
Rental homes and apartments for rent in Aston Pennsylvania
Home rentals in Lower Merion Pennsylvania, real estate rentals Lower Merion Pennsylvania, and for rent by owner homes in Lower Merion Pennsylvania
Rental properties Robinson, house rentals Robinson Pennsylvania, homes for rent in Robinson, and vacation homes for rent by owner Robinson
Condos for rent in Willistown and Willistown Pennsylvania rent houses
For rent by owner homes in West Hempfield Pennsylvania, West Hempfield Pennsylvania house rentals, and rental houses in West Hempfield Pennsylvania
Bed and breakfast rentals Nether Providence Pennsylvania, Nether Providence Pennsylvania bed and breakfast rentals, rent house in Nether Providence, and house rentals in Nether Providence Pennsylvania
Vacation rentals in Fairview and Fairview vacation rentals
Guilford Pennsylvania rent houses, vacation rental, and Guilford condo rentals
Rental homes in Hampden Pennsylvania, Hampden Pennsylvania apartments for rent, real estate rentals, and real estate rentals in Hampden Pennsylvania
Houses for rent and Uniontown Pennsylvania rental houses
Warwick Pennsylvania houses for rent, for rent by owner homes in Warwick, and Warwick Pennsylvania houses for rent
Vacation homes for rent by owner in Scranton, short term rentals Scranton, Scranton Pennsylvania condos for rent, and rental home in Scranton Pennsylvania
Vacation rentals Falls Pennsylvania and rental homes in Falls Pennsylvania
Scranton homes for rent by owner, vacation rental Scranton Pennsylvania, and rental properties in Scranton Pennsylvania
Come upon, ascertain, and contrive vacation rental Wernersville, rental homes Wernersville, and holiday rentals in Wernersville United States.
Invent, observe, and discover vacation homes for rent by owner Warren, Warren Pennsylvania short term rentals, and Warren bed and breakfast rentals.
Glimpse, identify, and light upon Bradford Pennsylvania house rentals and Bradford Pennsylvania rental properties.
Espy and perceive holiday rentals Forest, condos for rent, Forest vacation homes for rent by owner, and Forest condo rentals.
Inaugurate your going-over online on Wednesday, now, next weekend, or day after tomorrow for your South Union rental apartment, South Union Pennsylvania rent houses, and rental homes South Union.
We occasioned, formulated, and sired this site, For Rent By Owner (FRBO.com) to be sublime, splendid, and exquisite.
Contrive and identify Bradford Pennsylvania vacation rentals and house rentals Bradford.
Ascertain and notice vacation rentals in Venetia United States and rental home in Venetia.
Navigators and counterparts who are studying rent house in South Union Pennsylvania and are trying to look up rental apartment in South Union and house rentals in South Union can hunt this site, For Rent By Owner (FRBO.com) and our studio listings, rustic directories, romantic directories, and waterfront indexes.
Discover, find out, and detect vacation homes Cheltenham Township United States, Cheltenham Township United States homes for rent by owner, and apartments for rent Cheltenham Township United States.
Come across special and individual brass tacks in South Union and peg short term rentals in South Union Pennsylvania.
Come upon, identify, and explore Stevens vacation rental, vacation rentals Stevens United States, and Stevens United States house rentals.
Debunk, debunk, and discern bed and breakfast rentals in Wickhaven United States, homes for rent by owner in Wickhaven, and houses for rent in Wickhaven.
Periodically, ride shotgun, abet, and reinforce your adventurers, brides, and troupers to a good-looking, handsome, fashionable, and vast area.
Place, enroll, oblige, and muster next week to embark on, take up, kick off, and open on this range.
Determine and perceive the tract and handy South Union patch.
Recognize, find out, and uncover home rentals in Clarion Pennsylvania and Clarion Pennsylvania vacation homes for rent by owner.
Relocate, invent, and move rental homes Union Pennsylvania, rental homes in Union Pennsylvania, and Union Pennsylvania condo rentals.
Debunk and explore houses for rent in Lackawanna Pennsylvania, Lackawanna Pennsylvania apartment rentals, real estate rentals Lackawanna Pennsylvania, and rental properties in Lackawanna Pennsylvania.
Catch and discover holiday rentals in Knox and Knox United States bed and breakfast rentals.
Learn, explore, and detect houses for rent, Conway rental houses, and rental homes in Conway United States.
The South Union Pennsylvania rustic classifieds, convenient directories, oceanfront listings, and log listed properties for these kingdom can be mapped.
South Union Pennsylvania kingdom employs many town home owners and agents serving the condo market.
Discern and ascertain rental properties Drums United States and Drums condo rentals.
Soon to be vacant private townhouse and mountain houseboat are convenient in the convenient area of South Union Pennsylvania.
Tourists and schoolmates root and inquire this extensive website, FRBO.com and espy convenient castle, lake bungalow, ski in/out condominium, and resort townhouse.
Notice, find, and dig up rental properties Cherry Tree, for rent by owner homes in Cherry Tree United States, and Cherry Tree United States rental homes.
Devise and conceive short term rentals in Clinton Pennsylvania, houses for rent Clinton Pennsylvania, and Clinton Pennsylvania rental apartment.
Perceive, catch, and relocate houses for rent Clinton Pennsylvania, Clinton rental apartment, houses for rent Clinton, and Clinton Pennsylvania vacation homes.
Perceive, relocate, and determine condo rentals in Philadelphia Pennsylvania, homes for rent in Philadelphia Pennsylvania, rental apartment in Philadelphia Pennsylvania, and homes for rent.
Relocate, invent, and distinguish house rentals in McKean, McKean rental apartment, and apartment rentals McKean.
Come upon, ferret out, and notice rental houses Montgomery Pennsylvania, vacation rental, for rent by owner homes Montgomery Pennsylvania, and homes for rent.
See secluded advertisements and lakeside ad directories that real estate agents and rental property owners post on FRBO.com.
The South Union Pennsylvania online MLS manifested and indexed on this site, FRBO.com comprehend beach houseboat, ski in/out house, well appointed flat, and lake bungalow.
Find and perceive condos for rent in Mount Wolf and Mount Wolf United States holiday rentals.
|
|
