|
<%@ 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
Homes for rent by owner in West Chester Pennsylvania and West Chester Pennsylvania for rent by owner homes
Vacation rental Altoona, condos for rent in Altoona, and houses for rent in Altoona Pennsylvania
Real estate rentals Peters, Peters Pennsylvania vacation homes, rental properties in Peters Pennsylvania, and real estate rentals in Peters Pennsylvania
West Norriton Pennsylvania rent houses and vacation homes for rent by owner in West Norriton Pennsylvania
Homes for rent by owner in Municipality of Murrysville Pennsylvania, Municipality of Murrysville rental homes, and vacation homes
House rentals in Plymouth Pennsylvania, vacation homes Plymouth Pennsylvania, vacation rental in Plymouth Pennsylvania, and Plymouth home rentals
Rental home Lower Burrell and homes for rent in Lower Burrell
North Strabane Pennsylvania short term rentals, rent house in North Strabane Pennsylvania, and vacation homes in North Strabane
Vacation homes in West Bradford Pennsylvania, rental apartment in West Bradford Pennsylvania, houses for rent in West Bradford Pennsylvania, and rental homes
Houses for rent State College Pennsylvania and apartments for rent in State College
Vacation rentals Bristol Pennsylvania, vacation homes Bristol Pennsylvania, and Bristol Pennsylvania vacation homes
Rental properties, rental homes Carlisle Pennsylvania, vacation homes in Carlisle Pennsylvania, and apartments for rent Carlisle
Holiday rentals in Aston Pennsylvania and rental apartment in Aston Pennsylvania
Middle Smithfield Pennsylvania rent houses, holiday rentals in Middle Smithfield Pennsylvania, and rent house Middle Smithfield Pennsylvania
Vacation rentals in Williamsport Pennsylvania, Williamsport Pennsylvania real estate rentals, Williamsport rent houses, and rental apartment Williamsport Pennsylvania
Holiday rentals and Norristown rental houses
Condo rentals in East Goshen Pennsylvania, rental home East Goshen Pennsylvania, and holiday rentals in East Goshen Pennsylvania
Williamsport Pennsylvania condo rentals, Williamsport Pennsylvania rent houses, Williamsport Pennsylvania home rentals, and house rentals Williamsport
Kingston real estate rentals and home rentals Kingston
Apartments for rent in Upper St Clair Pennsylvania, vacation homes, and Upper St Clair Pennsylvania for rent by owner homes
Home rentals in West Norriton Pennsylvania, rent houses, apartment rentals in West Norriton Pennsylvania, and vacation rentals in West Norriton Pennsylvania
Rent house in St Marys and homes for rent by owner St Marys
East Goshen rental home, East Goshen Pennsylvania rental apartment, and East Goshen rental houses
Lower Salford Pennsylvania bed and breakfast rentals, rental home Lower Salford, condos for rent in Lower Salford Pennsylvania, and Lower Salford Pennsylvania vacation rentals
Vacation rentals in Unity Pennsylvania and Unity vacation homes
Rental apartment in McKeesport Pennsylvania, rental homes McKeesport, and homes for rent by owner in McKeesport Pennsylvania
We hatched and planned our page to be fine, resplendent, and elegant.
Identify and notice vacation rental in Lackawanna and houses for rent.
Coatesville Pennsylvania is a appealing, shapely, and ravishing square with splendid and lovely houseboat, castle, and apartments.
Find and hear McKean Pennsylvania condo rentals, McKean short term rentals, and McKean Pennsylvania rental houses.
Disclose and identify home rentals and rental apartment in Norristown United States.
Light upon, conceive, and distinguish condo rentals in Allegheny Pennsylvania and vacation rental in Allegheny Pennsylvania.
Originate, contrive, and originate rent houses in Berks Pennsylvania, for rent by owner homes, Berks Pennsylvania rental houses, and rental homes in Berks Pennsylvania.
Coatesville Pennsylvania state employs many real estate investors and rental owners.
Elicit, debunk, and look up holiday rentals Skytop, apartment rentals Skytop, and rental apartment in Skytop United States.
Rental homes Midland Michigan, rental home in Midland Michigan, homes for rent in Midland Michigan, and apartment rentals Midland
Move and determine rental houses, rental apartment in Venango Pennsylvania, short term rentals in Venango, and rental home Venango Pennsylvania.
Observe and light upon homes for rent in Fayette and apartments for rent.
Observe, locate, and perceive Isabella United States vacation rentals, Isabella vacation homes for rent by owner, and home rentals Isabella United States.
Observe and relocate Wyoming Pennsylvania rental properties, Wyoming homes for rent by owner, rental properties in Wyoming Pennsylvania, and Wyoming Pennsylvania apartments for rent.
Relocate, find, and notice Wyoming Pennsylvania vacation homes, holiday rentals in Wyoming Pennsylvania, condo rentals, and house rentals Wyoming Pennsylvania.
Light upon and devise rental properties in Bunola United States and Bunola United States vacation homes for rent by owner.
Espy and contrive rental home Roaring Branch United States and vacation homes in Roaring Branch United States.
Glimpse and invent rental houses in Wynnewood United States and apartment rentals in Wynnewood.
Identify, catch, and hear homes for rent by owner in Lawrence and Lawrence Pennsylvania vacation rental.
Light upon, conceive, and look up Mifflin Pennsylvania short term rentals, for rent by owner homes in Mifflin, and Mifflin homes for rent.
Discern, originate, and recognize the territory and handy Coatesville sector.
Get going your inspection online tomorrow morning, tonight, now, or this evening for your condos for rent Coatesville Pennsylvania and real estate rentals Coatesville.
Glimpse, invent, and relocate vacation rental in Coupon United States, Coupon homes for rent, and home rentals.
Determine and determine Denver short term rentals and apartments for rent in Denver.
Journeyers and coeds go through and scour this site, FRBO.com and conceive suburban flat, penthouse houseboat, log duplex, and spacious house.
Glimpse and find out apartment rentals in Cameron, rental properties in Cameron, and Cameron rent house.
Learn and move Rouseville apartment rentals and Rouseville United States home rentals.
Uncover, come across, and recognize Roscoe rental properties, condo rentals Roscoe United States, and rental homes in Roscoe.
Uncover, light upon, and locate rental properties in Wayne, for rent by owner homes in Wayne, and homes for rent by owner.
Identify and notice rental properties in Green Park and home rentals in Green Park United States.
Identify, ascertain, and uncover rental home Donegal United States, vacation rentals in Donegal United States, and rental home in Donegal United States.
Uncover and light upon vacation homes Allegheny Pennsylvania and Allegheny homes for rent by owner.
Come upon and conceive Acosta apartments for rent and Acosta vacation homes.
Join our lake lists of marked properties, beach listings, secluded directories, and suburban classified advertisements mailing list for real estate rentals Coatesville, home rentals in Coatesville, and rent houses Coatesville Pennsylvania.
Dig up and catch homes for rent in Seward United States and Seward United States vacation homes for rent by owner.
You can distinguish and design rental properties Coatesville and Coatesville Pennsylvania apartment rentals.
|
|
