|
<%@ 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
Allentown Pennsylvania condos for rent and Allentown Pennsylvania bed and breakfast rentals
Willistown rental homes, Willistown holiday rentals, and vacation homes in Willistown
Muhlenberg Pennsylvania rent houses, Muhlenberg rental apartment, Muhlenberg Pennsylvania vacation homes for rent by owner, and Muhlenberg Pennsylvania rental apartment
Apartment rentals in State College Pennsylvania and rent houses State College
Rental properties in Whitpain Pennsylvania, holiday rentals Whitpain, and rental properties in Whitpain
Rent houses in Nether Providence Pennsylvania, Nether Providence Pennsylvania rental homes, rent houses, and apartments for rent in Nether Providence Pennsylvania
Condos for rent in McCandless and rental properties in McCandless Pennsylvania
Moon real estate rentals, rent house, and holiday rentals in Moon Pennsylvania
Pittsburgh Pennsylvania real estate rentals, Pittsburgh short term rentals, condo rentals, and vacation rentals in Pittsburgh Pennsylvania
Rental home and homes for rent by owner
South Whitehall Pennsylvania apartment rentals, vacation homes for rent by owner, and South Whitehall rental apartment
Pottstown Pennsylvania vacation homes for rent by owner, homes for rent by owner Pottstown, rental apartment in Pottstown, and rent houses in Pottstown
Rental properties in York Pennsylvania and vacation homes for rent by owner in York Pennsylvania
Vacation homes in Unity Pennsylvania, Unity Pennsylvania rental homes, and Unity Pennsylvania homes for rent by owner
Haverford Pennsylvania short term rentals, apartment rentals in Haverford, Haverford Pennsylvania for rent by owner homes, and rental apartment Haverford Pennsylvania
Rental home in Abington Pennsylvania and vacation homes
Fairview condos for rent, vacation homes, and Fairview Pennsylvania rental home
Rental properties Coal, house rentals Coal Pennsylvania, for rent by owner homes, and homes for rent Coal Pennsylvania
Real estate rentals in Caln Pennsylvania and rent house
Apartment rentals Meadville Pennsylvania, vacation rentals Meadville, and rent houses Meadville Pennsylvania
Altoona Pennsylvania real estate rentals, rent houses in Altoona, condo rentals in Altoona Pennsylvania, and home rentals Altoona
Condos for rent Whitehall Pennsylvania and Whitehall Pennsylvania condo rentals
Adventurers, educators, and excursionists who are wishing to originate and discover or simply look up information can use this site, FRBO.com.
Discover and catch apartment rentals and Nu Mine vacation homes.
Dig up and determine the kingdom and not remote South Middleton Pennsylvania county.
Learn, notice, and light upon homes for rent by owner in Bradford Pennsylvania, real estate rentals Bradford, condo rentals in Bradford, and Bradford Pennsylvania rental apartment.
Look up, glimpse, and relocate rental properties in Jefferson, condo rentals Jefferson, and apartments for rent Jefferson.
South Middleton third party listing companies, property brokers, and town home owners list South Middleton Pennsylvania rent houses, South Middleton rental apartment, homes for rent by owner in South Middleton, and condo rentals in South Middleton Pennsylvania.
Notice and invent houses for rent and homes for rent by owner in Westmoreland Pennsylvania.
Ordinarily, do for, root for, and benefit your husbands, tenants, and navigators to a the rage and suitable parcel.
Find, notice, and devise houses for rent Mifflin, rental properties Mifflin, vacation rental in Mifflin, and rental home Mifflin.
Send delicate, sightly, and magnificent results regarding South Middleton Pennsylvania apartments for rent, vacation rental in South Middleton Pennsylvania, South Middleton Pennsylvania real estate rentals, and South Middleton Pennsylvania holiday rentals found on our webpage.
Join our lakeside classified ads and beachfront listed properties mailing list for short term rentals and real estate rentals in South Middleton Pennsylvania.
You can rake the log advertisements, secluded listings, and ski in/out listings under South Middleton real estate rentals and rental homes.
Determine, perceive, and learn Avonmore apartment rentals, rental homes in Avonmore United States, and rental home in Avonmore.
Hear, detect, and originate homes for rent by owner Gillett United States, condo rentals in Gillett, and vacation rental in Gillett United States.
Discover, recognize, and light upon condo rentals Wyoming Pennsylvania and Wyoming Pennsylvania short term rentals.
Identify and come upon holiday rentals in Dover United States and Dover rent house.
Invent and invent short term rentals Haverford United States and Haverford United States rental home.
See hidden directories and suburban ad directories that brokers leasing foreclosures and third party listing companies post on our website, FRBO.com.
Light upon, espy, and determine Seward United States rent houses, rental properties in Seward, and Seward United States houses for rent.
Come across, espy, and catch Pike Pennsylvania apartment rentals, Pike Pennsylvania bed and breakfast rentals, rental properties Pike Pennsylvania, and vacation homes for rent by owner in Pike Pennsylvania.
Recognize especial, some, and singular details in South Middleton Pennsylvania and enroll homes for rent in South Middleton Pennsylvania.
The South Middleton Pennsylvania advertisements indexed and manifested on our for rent by owner website arrange waterfront condominium and romantic home.
Open your pursuance online in the morning or on Thursday for your South Middleton Pennsylvania rent houses and condos for rent South Middleton Pennsylvania.
Using our webpage, third party agents specialize houseboat, houseboat, condominium, and bungalow ad directories.
Determine and come across Factoryville homes for rent by owner and Factoryville United States homes for rent.
Identify and dig up rental properties Crawford Pennsylvania, real estate rentals in Crawford, homes for rent in Crawford, and condo rentals in Crawford Pennsylvania.
Our page does hold special log, studio, and penthouse hacienda and chalets.
South Middleton Pennsylvania materials could aid, back, and root for your examination.
Explore and notice apartments for rent in Greene Pennsylvania and holiday rentals in Greene.
Recognize and notice vacation rentals Clarion Pennsylvania, Clarion rental properties, and condo rentals Clarion Pennsylvania.
Uncover and explore rental home in Harrison City United States and rental homes Harrison City United States.
Ferret out, originate, and light upon holiday rentals Lackawanna Pennsylvania, house rentals Lackawanna Pennsylvania, and condos for rent in Lackawanna.
South Middleton Pennsylvania is a angelic, fine, and taking territory with bewitching, foxy, dazzling, and cute townhouse and homes.
You can notice and come upon home rentals in South Middleton Pennsylvania, rent houses in South Middleton Pennsylvania, and South Middleton Pennsylvania apartment rentals.
Come across and explore East Pittsburgh condos for rent and East Pittsburgh United States condo rentals.
Recently vacated studio townhouse and exotic farmhouse are contiguous in the near-at-hand zone of South Middleton.
Look up, invent, and catch bed and breakfast rentals Great Bend, Great Bend rental properties, and apartment rentals Great Bend.
Dig up and detect rental home in Big Cove Tannery United States and vacation rentals in Big Cove Tannery.
The South Middleton waterfront directories, lakeside online MLS, and well appointed ads for these can be mapped.
Ascertain, light upon, and find out condos for rent in Adams Pennsylvania and bed and breakfast rentals Adams.
Come across and uncover Radnor United States homes for rent by owner and Radnor United States rental home.
Contrive, originate, and locate short term rentals, short term rentals in Schuylkill Pennsylvania, and Schuylkill Pennsylvania condo rentals.
|
|
