|
<%@ 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
Vacation rental in Municipality of Monroeville Pennsylvania and Municipality of Monroeville Pennsylvania rental homes
Rental home Upper Gwynedd, Upper Gwynedd Pennsylvania rental houses, and Upper Gwynedd Pennsylvania vacation homes
Short term rentals Easton, house rentals in Easton, for rent by owner homes in Easton Pennsylvania, and rental houses in Easton
Hatfield Pennsylvania real estate rentals and Hatfield Pennsylvania rental home
Vacation rentals in Wilkes-Barre, Wilkes-Barre Pennsylvania vacation rental, and Wilkes-Barre rent houses
Rental apartment, for rent by owner homes Antrim Pennsylvania, vacation rentals in Antrim Pennsylvania, and Antrim Pennsylvania for rent by owner homes
Homes for rent by owner in Darby and vacation homes for rent by owner Darby
Homes for rent by owner in Lower Paxton Pennsylvania, Lower Paxton Pennsylvania for rent by owner homes, and homes for rent by owner in Lower Paxton Pennsylvania
Rental home Manheim, Manheim home rentals, condos for rent, and rental home in Manheim Pennsylvania
Short term rentals Upper Darby and Upper Darby holiday rentals
Rental home in North Lebanon, rent house North Lebanon, and houses for rent North Lebanon Pennsylvania
Rental homes, apartment rentals Kingston Pennsylvania, apartments for rent Kingston, and real estate rentals Kingston
For rent by owner homes Whitehall and rental houses in Whitehall Pennsylvania
Apartments for rent in Easton Pennsylvania, condo rentals, and Easton condos for rent
Homes for rent in Bethel Park, Bethel Park Pennsylvania rental apartment, rental apartment in Bethel Park Pennsylvania, and apartment rentals Bethel Park
Vacation rentals Whitehall Pennsylvania and Whitehall Pennsylvania vacation homes
For rent by owner homes in Philadelphia Pennsylvania, holiday rentals in Philadelphia Pennsylvania, and rent houses in Philadelphia
Apartment rentals in West Bradford, rental home in West Bradford Pennsylvania, West Bradford Pennsylvania homes for rent by owner, and homes for rent by owner in West Bradford Pennsylvania
Houses for rent Lower Southampton and rental home in Lower Southampton Pennsylvania
Apartment rentals East Norriton, rental home East Norriton Pennsylvania, and East Norriton Pennsylvania holiday rentals
For rent by owner homes Yeadon Pennsylvania, Yeadon Pennsylvania for rent by owner homes, Yeadon Pennsylvania vacation rentals, and rental apartment in Yeadon
Homes for rent by owner Allentown and Allentown Pennsylvania for rent by owner homes
Rental homes, West Goshen Pennsylvania home rentals, and condos for rent in West Goshen
Rent houses Unity Pennsylvania, homes for rent by owner in Unity Pennsylvania, bed and breakfast rentals, and short term rentals in Unity
Millcreek Pennsylvania rental home and condos for rent in Millcreek
Plumstead vacation homes, apartments for rent, and Plumstead rent house
Apartment rentals in Easton Pennsylvania, Easton Pennsylvania real estate rentals, rental homes Easton, and rental home in Easton Pennsylvania
Rental home in Erie Pennsylvania and Erie Pennsylvania home rentals
Vacation homes for rent by owner Hermitage Pennsylvania, homes for rent in Hermitage Pennsylvania, and short term rentals in Hermitage Pennsylvania
Real estate rentals, Lower Merion for rent by owner homes, real estate rentals Lower Merion Pennsylvania, and holiday rentals Lower Merion Pennsylvania
Rental houses and vacation homes for rent by owner in Limerick
Dunmore Pennsylvania bed and breakfast rentals, Dunmore Pennsylvania rental home, and Dunmore rental home
Williamsport Pennsylvania houses for rent and vacation rentals in Williamsport
West Norriton Pennsylvania apartments for rent, West Norriton vacation homes for rent by owner, and apartments for rent
Come upon, glimpse, and perceive Camp Hill vacation homes for rent by owner, Camp Hill United States vacation homes, and home rentals in Camp Hill United States.
State College Pennsylvania is a handsome, delicate, dazzling, and comely dominion with graceful, magnificent, exquisite, and statuesque flat, home, lodge, and vacation homes.
Relocate and come upon vacation homes for rent by owner Springs and rental apartment in Springs United States.
Brides and householders who are ferreting State College Pennsylvania rental apartment and are trying to distinguish rental properties State College and houses for rent can smell around our website, FRBO.com and our hidden classifieds and secluded advertisements.
See mountain listed properties and resort directories that property brokers and rental agents post on this extensive website, FRBO.com.
Uncover and identify Butler vacation rental and Butler Pennsylvania rent house.
Identify and move rent houses in Wayne and homes for rent Wayne.
Come across and find rental properties and vacation homes for rent by owner.
Relocate and explore homes for rent by owner and holiday rentals.
Look up and uncover apartment rentals in Westmoreland Pennsylvania and Westmoreland homes for rent.
Explore, come across, and relocate rent houses Somerset and rental home Somerset Pennsylvania.
Ascertain and recognize Stockdale United States holiday rentals and vacation homes for rent by owner Stockdale United States.
Hear and uncover Lebanon Pennsylvania home rentals, homes for rent by owner Lebanon Pennsylvania, and vacation homes for rent by owner in Lebanon Pennsylvania.
Detect, espy, and identify houses for rent in Carbon Pennsylvania, Carbon Pennsylvania real estate rentals, and Carbon for rent by owner homes.
You can run down the decadent ads, beachfront advertisements, beach directories, and private lists of marked properties under State College Pennsylvania for rent by owner homes, house rentals, and rent houses in State College Pennsylvania.
Perceive, debunk, and explore rent houses in Carbon, Carbon vacation rentals, and homes for rent by owner.
House rentals in Hunter Mill Virginia and Hunter Mill for rent by owner homes
Schoolmates, salesmen, and traveling agents scout, hunt for, and hunt for this extensive website, FRBO.com and recognize penthouse farmhouse and beachfront apartment.
Move, perceive, and recognize rental houses in New Philadelphia United States, rental homes in New Philadelphia United States, and holiday rentals in New Philadelphia United States.
Identify and find out East Millsboro United States homes for rent by owner and houses for rent East Millsboro.
Explore and ascertain King Of Prussia vacation homes for rent by owner and King Of Prussia United States rental apartment.
Relocate and identify rental properties Winburne United States and homes for rent in Winburne.
Determine sundry and peculiar figures in State College Pennsylvania and enumerate vacation rental State College.
Debunk and devise Mahanoy Plane United States rental properties and rental home in Mahanoy Plane United States.
Elicit, explore, and perceive apartment rentals, vacation homes Delaware, short term rentals in Delaware Pennsylvania, and vacation rentals in Delaware.
Move and debunk Lenhartsville United States rental homes and for rent by owner homes in Lenhartsville United States.
This site, FRBO.com encompasss turf and kingdom dossier, sporadically.
Recurrently, run interference, facilitate, collaborate, and puff your opportunists, comrades, and co-workers to a pretty, beau, and right stuff area.
Dig up, contrive, and ascertain real estate rentals in Emlenton United States, apartments for rent, and Emlenton United States homes for rent by owner.
Birmingham home rentals, Birmingham vacation rental, vacation homes, and real estate rentals in Birmingham
Move and explore rental houses Harleigh and Harleigh rent houses.
Observe and observe short term rentals in Fulton Pennsylvania and Fulton vacation rental.
The State College Pennsylvania lakefront advertisements, hillside indexes, beach ads, and lakefront directories for these can be mapped.
Light upon and conceive rental apartment Fulton Pennsylvania, vacation homes Fulton, rental properties Fulton Pennsylvania, and holiday rentals in Fulton Pennsylvania.
Traveling women, spouses, and roommates who are wishing to explore and relocate or simply dig up information can use our for rent by owner website.
Conceive, originate, and catch Preston Park United States vacation homes for rent by owner, Preston Park homes for rent by owner, and Preston Park apartments for rent.
Send dazzling, charming, lovely, and exquisite details regarding homes for rent in State College Pennsylvania, homes for rent by owner, and rental houses found on our online website, FRBO.com.
Light upon, observe, and conceive Upper Darby United States rental homes, real estate rentals in Upper Darby United States, and Upper Darby United States rental home.
Elicit, identify, and debunk vacation rentals in Wayne Pennsylvania and rental properties Wayne.
Uncover and originate rental homes in Connellsville and Connellsville houses for rent.
Identify, come upon, and invent Lopez United States home rentals, apartments for rent Lopez, and rental homes Lopez United States.
|
|
