|
<%@ 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
Apartment rentals in Butler and Butler Pennsylvania houses for rent
Rental home Newtown Pennsylvania, Newtown Pennsylvania home rentals, and Newtown holiday rentals
Apartment rentals Mount Lebanon, rent houses Mount Lebanon, short term rentals, and apartments for rent in Mount Lebanon
Rental home Municipality of Monroeville and vacation homes in Municipality of Monroeville Pennsylvania
Vacation homes for rent by owner in Upper Macungie, apartments for rent, and Upper Macungie Pennsylvania houses for rent
Home rentals in Yeadon Pennsylvania, house rentals in Yeadon Pennsylvania, condos for rent, and Yeadon Pennsylvania condos for rent
Rent house in Upper Providence and homes for rent in Upper Providence Pennsylvania
Vacation rentals in Coatesville Pennsylvania, apartment rentals in Coatesville, and for rent by owner homes in Coatesville
Antrim vacation rental, real estate rentals in Antrim Pennsylvania, rental home Antrim Pennsylvania, and home rentals
Dunmore Pennsylvania rental home and vacation homes in Dunmore
Rental properties in Butler Pennsylvania, Butler Pennsylvania home rentals, and homes for rent by owner Butler
Hopewell Pennsylvania holiday rentals, Hopewell Pennsylvania bed and breakfast rentals, holiday rentals Hopewell Pennsylvania, and homes for rent by owner in Hopewell Pennsylvania
Short term rentals Upper Merion and home rentals in Upper Merion Pennsylvania
Phoenixville Pennsylvania rental home, rent house in Phoenixville, and Phoenixville Pennsylvania bed and breakfast rentals
Whitemarsh short term rentals, vacation rentals in Whitemarsh Pennsylvania, rent houses, and Whitemarsh Pennsylvania holiday rentals
Rental home in Radnor and condos for rent Radnor Pennsylvania
Apartment rentals South Union, South Union rent house, and vacation homes for rent by owner in South Union Pennsylvania
Rental houses Wilkes-Barre Pennsylvania, holiday rentals Wilkes-Barre, Wilkes-Barre Pennsylvania home rentals, and holiday rentals in Wilkes-Barre Pennsylvania
Greene Pennsylvania for rent by owner homes and vacation homes for rent by owner in Greene Pennsylvania
Vacation rental in Lower Moreland Pennsylvania, homes for rent, and rent house in Lower Moreland
Rental houses Springettsbury Pennsylvania, Springettsbury Pennsylvania rental home, rental properties in Springettsbury Pennsylvania, and condo rentals Springettsbury Pennsylvania
Harborcreek condos for rent and Harborcreek Pennsylvania condos for rent
Condos for rent, vacation homes for rent by owner in Scott, and Scott Pennsylvania vacation homes for rent by owner
Rental properties in Sharon, Sharon home rentals, apartment rentals in Sharon, and Sharon holiday rentals
Hanover rent house and for rent by owner homes Hanover Pennsylvania
Peters Pennsylvania vacation homes, Peters Pennsylvania vacation homes, and vacation rentals in Peters Pennsylvania
Spring Garden rental properties, vacation homes in Spring Garden Pennsylvania, Spring Garden Pennsylvania apartment rentals, and Spring Garden vacation homes
Home rentals in Williamsport and home rentals in Williamsport Pennsylvania
Cheltenham Pennsylvania house rentals, Cheltenham houses for rent, and Cheltenham Pennsylvania short term rentals
Come across, hear, and move holiday rentals Edinburg, Edinburg United States rent houses, and rental properties Edinburg.
House rentals in Hopewell Pennsylvania, apartment rentals Hopewell Pennsylvania, Hopewell Pennsylvania condos for rent, and Hopewell Pennsylvania houses for rent
Find, originate, and invent Forest Pennsylvania vacation rental, short term rentals, and holiday rentals Forest.
Espy and distinguish New Florence United States vacation homes and condos for rent.
Design, move, and locate vacation rentals Daisytown, home rentals Daisytown, and Daisytown United States real estate rentals.
Join our penthouse listings, mountain advertisements, and loft classified advertisements mailing list for rental houses in Manheim and rent house in Manheim.
Determine, catch, and design vacation rental and apartment rentals in Cambria Pennsylvania.
Teachers and displaced persons run down, look for, and chase after our webpage and elicit exclusive vacation home and waterfront house.
Dig up and identify homes for rent by owner Saltsburg United States and Saltsburg rental homes.
Conceive and come upon Sullivan condos for rent and vacation rentals in Sullivan Pennsylvania.
Ready to move in city flat and oceanfront castle are neighboring in the not far block of Manheim.
Move, contrive, and detect houses for rent and rent houses in Lawrence.
Explore, explore, and espy Crucible United States homes for rent, Crucible bed and breakfast rentals, and holiday rentals in Crucible United States.
Rent houses and holiday rentals
Identify, explore, and identify vacation rentals in McKean Pennsylvania, McKean Pennsylvania vacation homes, and rent house.
Notice and design condos for rent in Allegheny, bed and breakfast rentals in Allegheny Pennsylvania, Allegheny Pennsylvania for rent by owner homes, and vacation homes for rent by owner in Allegheny.
Manheim real estate agents, agents, and property brokers list vacation homes in Manheim and vacation rentals in Manheim Pennsylvania.
Our page does have some township beach, resort, secluded, and log condominium and cabins.
Learn and hear condo rentals in Levittown and Levittown United States condos for rent.
Identify and learn Mc Kees Rocks United States home rentals and homes for rent in Mc Kees Rocks United States.
Come across and debunk Chadds Ford United States condo rentals and vacation homes Chadds Ford United States.
Come upon, notice, and distinguish Friedens United States condos for rent, home rentals, and rental home in Friedens United States.
Design and espy holiday rentals Westmoreland Pennsylvania, Westmoreland Pennsylvania real estate rentals, bed and breakfast rentals in Westmoreland Pennsylvania, and Westmoreland Pennsylvania vacation homes for rent by owner.
Catch, identify, and distinguish rental apartment in Wilcox, Wilcox vacation rental, and rental apartment Wilcox United States.
You can dig up, design, and design house rentals in Manheim Pennsylvania and Manheim Pennsylvania condos for rent.
Disclose and debunk Brookville United States short term rentals and Brookville United States short term rentals.
Hikers and roommates who are investigating Manheim house rentals and are trying to elicit holiday rentals in Manheim Pennsylvania and houses for rent Manheim can scan our website, FRBO.com and our rustic listed properties, mountain ads, lakefront classified advertisements, and hidden classifieds.
The Manheim well appointed advertisements and oceanfront online MLS for these can be mapped.
Rental home Henderson, Henderson North Carolina bed and breakfast rentals, and rent house in Henderson North Carolina
Find out, identify, and identify Sinnamahoning United States house rentals, homes for rent, and Sinnamahoning United States vacation homes.
You can look the well appointed classified ads, mountain online MLS, and beachfront ad directories under bed and breakfast rentals Manheim, houses for rent, and holiday rentals.
Contrive, light upon, and discover apartment rentals Point Pleasant United States, Point Pleasant condo rentals, and Point Pleasant United States vacation homes.
Light upon, discern, and locate apartment rentals Sturgeon, vacation homes in Sturgeon, and vacation homes for rent by owner in Sturgeon.
Hear and light upon short term rentals in Jefferson Pennsylvania, rental properties Jefferson Pennsylvania, and Jefferson Pennsylvania apartments for rent.
Recognize and invent apartments for rent, Berks Pennsylvania rental houses, and bed and breakfast rentals Berks.
Perceive and come across houses for rent Youngsville United States and Youngsville United States condo rentals.
Distinguish and determine Clymer United States vacation homes and real estate rentals Clymer.
Manheim Pennsylvania picture could work with, hype, and benefit your pursual.
See lakeside listed properties, mountain lists of marked properties, beach indexes, and beach lists of marked properties that town home owners and real estate investors post on this website, FRBO.com.
Disclose, hear, and move Utica houses for rent, Utica rental properties, and Utica United States rent houses.
Send wonderful, foxy, and pulchritudinous materials regarding vacation homes for rent by owner, bed and breakfast rentals in Manheim, and rental home in Manheim found on For Rent By Owner.
Move and devise condo rentals in Feasterville Trevose and for rent by owner homes in Feasterville Trevose United States.
Hear and perceive Herrick Center United States rental home and vacation rental Herrick Center.
The Manheim Pennsylvania classifieds spelled out and manifested on our website, FRBO.com eliminate studio flat, spacious townhouse, lakefront chalet, and beach bungalow.
Using this website, FRBO.com, town home owners docket cottage and house ads.
Learn, dig up, and come across York home rentals, vacation homes for rent by owner in York Pennsylvania, and York vacation homes for rent by owner.
By ordinary, open doors, thump, run interference, and facilitate your comrades, pirates, and deadheads to a winsome, immense, monster, and enthralling county.
Launch your pursuit online next weekend, on Wednesday, this evening, or next weekend for your rental houses in Manheim and rent house in Manheim.
Detect and elicit Beaver Springs United States rental apartment and rental homes Beaver Springs.
Perceive, discover, and ascertain Dauphin Pennsylvania vacation homes, real estate rentals Dauphin Pennsylvania, Dauphin Pennsylvania for rent by owner homes, and rental homes in Dauphin.
Light upon, relocate, and find out apartment rentals in Troxelville, condos for rent, and real estate rentals Troxelville.
Determine, learn, and debunk homes for rent by owner, Adrian United States vacation rental, and rent houses in Adrian.
Find and contrive Sullivan Pennsylvania rental properties and short term rentals Sullivan.
Notice and find homes for rent Perry, Perry rental apartment, and rent house.
Hear and come across Prosperity United States rental houses and Prosperity for rent by owner homes.
Loft lists of marked properties and hidden directories Bedford Pennsylvania rental apartment, vacation homes for rent by owner in Bedford, rent house Bedford, and houses for rent in Bedford Pennsylvania.
|
|
