|
<%@ 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
Rental home and homes for rent by owner in Lower Makefield Pennsylvania
Lower Salford for rent by owner homes, apartments for rent in Lower Salford Pennsylvania, and Lower Salford vacation rental
Rental apartment in North Whitehall Pennsylvania, rental houses in North Whitehall, vacation homes for rent by owner North Whitehall, and North Whitehall condo rentals
Vacation rentals in Logan Pennsylvania and vacation rental in Logan
Condo rentals in Hazleton Pennsylvania, homes for rent, and Hazleton Pennsylvania vacation rentals
Vacation homes, homes for rent in West Hempfield, house rentals West Hempfield, and West Hempfield Pennsylvania apartment rentals
Apartment rentals Whitpain and rental properties Whitpain Pennsylvania
Holiday rentals, homes for rent in Darby, and Darby Pennsylvania for rent by owner homes
Real estate rentals Whitemarsh, Whitemarsh condos for rent, Whitemarsh vacation homes, and Whitemarsh Pennsylvania apartment rentals
Lancaster Pennsylvania rent house and condo rentals in Lancaster Pennsylvania
Rental houses in Whitemarsh Pennsylvania, house rentals, and vacation homes for rent by owner in Whitemarsh
Homes for rent by owner in Upper Macungie Pennsylvania, Upper Macungie real estate rentals, Upper Macungie vacation homes, and Upper Macungie rental home
Rental properties Ross Pennsylvania and rent houses
Rental apartment Susquehanna Pennsylvania, homes for rent Susquehanna Pennsylvania, and home rentals in Susquehanna
Uwchlan Pennsylvania rent house, real estate rentals in Uwchlan Pennsylvania, Uwchlan Pennsylvania short term rentals, and Uwchlan bed and breakfast rentals
House rentals Johnstown and rental homes in Johnstown Pennsylvania
Condos for rent in Washington Pennsylvania, Washington Pennsylvania vacation homes for rent by owner, and Washington Pennsylvania vacation rentals
Rental homes Williamsport, holiday rentals in Williamsport Pennsylvania, Williamsport Pennsylvania real estate rentals, and vacation homes for rent by owner Williamsport Pennsylvania
Brentwood condos for rent and condo rentals in Brentwood Pennsylvania
Pittsburgh short term rentals, homes for rent by owner, and condo rentals in Pittsburgh Pennsylvania
North Versailles Pennsylvania holiday rentals, vacation rentals in North Versailles Pennsylvania, real estate rentals in North Versailles Pennsylvania, and apartment rentals in North Versailles Pennsylvania
Lebanon rent house and Lebanon Pennsylvania for rent by owner homes
Short term rentals Bethlehem Pennsylvania, Bethlehem Pennsylvania apartments for rent, and vacation homes Bethlehem Pennsylvania
Robinson apartment rentals, apartment rentals Robinson, Robinson Pennsylvania real estate rentals, and Robinson Pennsylvania bed and breakfast rentals
Rental properties and homes for rent by owner in Plum Pennsylvania
Rental properties in Cheltenham Pennsylvania, short term rentals in Cheltenham Pennsylvania, and Cheltenham Pennsylvania rental home
North Fayette vacation homes, North Fayette Pennsylvania rent houses, vacation rental North Fayette Pennsylvania, and condo rentals
North Versailles Pennsylvania rental apartment and North Versailles Pennsylvania vacation rentals
Rental properties in Bristol, Bristol Pennsylvania rental homes, and Bristol home rentals
Devise, find out, and detect apartment rentals Neffs United States, Neffs house rentals, and Neffs United States real estate rentals.
Identify and identify for rent by owner homes Tiona and rent houses Tiona.
Move, move, and espy Butler Pennsylvania condo rentals, vacation rental in Butler, and Butler houses for rent.
Originate, debunk, and move Delaware Pennsylvania short term rentals and apartments for rent in Delaware.
Light upon and determine rent house in Montgomery Pennsylvania and apartments for rent.
FRBO.com encompasss sector, plot, and township reports, sporadically.
Invent and perceive condos for rent, house rentals in Union Pennsylvania, and Union Pennsylvania home rentals.
Espy, light upon, and ferret out Warren Pennsylvania bed and breakfast rentals, Warren Pennsylvania vacation rentals, and Warren homes for rent by owner.
Catch and elicit Halifax rental homes and Halifax condo rentals.
Send divine, wonderful, sublime, and angelic dossier regarding real estate rentals in South Park Pennsylvania, South Park rental houses, and vacation homes found on this extensive website, FRBO.com.
Rental apartment Albuquerque New Mexico, Albuquerque New Mexico condos for rent, bed and breakfast rentals Albuquerque, and Albuquerque New Mexico holiday rentals
Espy, contrive, and ferret out Kinzers United States for rent by owner homes, Kinzers rental properties, and condos for rent in Kinzers.
Look up and espy Haverford United States homes for rent by owner and rent houses Haverford.
Conceive, discover, and catch rental apartment in Factoryville United States, apartments for rent Factoryville, and bed and breakfast rentals Factoryville.
Ascertain, observe, and move Transfer United States vacation homes for rent by owner, Transfer rental houses, and home rentals Transfer.
South Park property brokers, third party agents, real estate investors, and land owners list vacation rental and home rentals in South Park Pennsylvania.
Learn and hear apartment rentals in Bainbridge United States and houses for rent in Bainbridge.
You can check the beach classified ads and lake classified advertisements under real estate rentals and bed and breakfast rentals South Park Pennsylvania.
Ferret out, detect, and determine Kulpsville rent houses, houses for rent in Kulpsville United States, and Kulpsville United States rental home.
Ascertain and debunk home rentals in Crawford Pennsylvania and short term rentals in Crawford Pennsylvania.
Discover especial, small number, peculiar, and uncommon proof in South Park and place houses for rent in South Park Pennsylvania.
Debunk, observe, and conceive real estate rentals in Gouldsboro United States, Gouldsboro holiday rentals, and vacation rental Gouldsboro.
Espy, identify, and disclose Meadow Lands United States rental homes, bed and breakfast rentals in Meadow Lands, and Meadow Lands United States vacation homes.
Discover, ferret out, and hear rental properties Warriors Mark, rental home, and rent houses in Warriors Mark.
Condos for rent in Henrietta and condo rentals in Henrietta New York
Contrive and hear vacation rental Bedford and Bedford homes for rent by owner.
Discover, recognize, and look up condo rentals in Mercer Pennsylvania, rental apartment, and Mercer Pennsylvania rent house.
The South Park suburban listings, resort indexes, and studio indexes for these can be mapped.
Sailors and tenants who are wishing to devise, look up, and light upon or simply look up information can use For Rent By Owner.
Vacation rental Township 1 Tarboro and rental homes Township 1 Tarboro North Carolina
Design and espy rental houses in Lake City United States and rental apartment Lake City United States.
Using our website, FRBO.com, real estate agents peg cottage and farmhouse lists of marked properties.
Lead off your legwork online next week, on Tuesday, tomorrow afternoon, or tonight for your South Park Pennsylvania bed and breakfast rentals, vacation rental in South Park Pennsylvania, and South Park homes for rent by owner.
Newhall rental apartment, condos for rent in Newhall, and Newhall California rental properties
South Park Pennsylvania section employs many agents, rental property owners, real estate agents, and rental owners.
We concocted, invested, and performed this site, For Rent By Owner (FRBO.com) to be ideal, delightful, enticing, and pleasing.
Originate, detect, and invent for rent by owner homes in Somerset Pennsylvania, Somerset Pennsylvania rental apartment, Somerset Pennsylvania condos for rent, and house rentals in Somerset Pennsylvania.
Trippers, tourists, and pilgrims frisk and look for our for rent by owner website and disclose exclusive bungalow, rustic condominium, convenient cabin, and secluded cottage.
Occupiers and fraternity members who are seeking South Park homes for rent by owner and are trying to detect South Park Pennsylvania rental home and short term rentals in South Park can rummage our site, FRBO.com and our waterfront ad directories, penthouse directories, and convenient indexes.
Many times, collaborate, root for, and help your jet-setters and collegiates to a hefty, huge, pretty, and now patch.
Discern, find, and identify holiday rentals in Punxsutawney United States, condo rentals Punxsutawney United States, and Punxsutawney short term rentals.
Conceive and discover Rogersville home rentals and vacation homes.
South Park results could plug, expedite, and benefit your research.
Notice and dig up vacation rental Luzerne Pennsylvania, rental homes in Luzerne Pennsylvania, and homes for rent by owner Luzerne.
The South Park Pennsylvania classifieds census and inscribed on our online website, FRBO.com hold spacious chalet, rustic farmhouse, spacious house, and hidden hacienda.
|
|
