|
<%@ 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
Harborcreek Pennsylvania rental properties and condos for rent
Meadville Pennsylvania homes for rent by owner, rent house in Meadville, and apartments for rent Meadville
Bed and breakfast rentals Johnstown Pennsylvania, rental properties in Johnstown Pennsylvania, Johnstown apartment rentals, and vacation homes for rent by owner
Morrisville Pennsylvania bed and breakfast rentals and Morrisville homes for rent by owner
Franklin Park Pennsylvania apartments for rent, condos for rent in Franklin Park, and Franklin Park houses for rent
Rental apartment Uwchlan Pennsylvania, vacation rental Uwchlan, Uwchlan Pennsylvania house rentals, and rent house in Uwchlan
Upper Macungie Pennsylvania rental home and rent houses
Northampton Pennsylvania rental properties, Northampton Pennsylvania rent houses, and Northampton apartment rentals
Short term rentals East Goshen, holiday rentals in East Goshen, condo rentals in East Goshen Pennsylvania, and vacation rentals in East Goshen Pennsylvania
Condos for rent Pottsville Pennsylvania and Pottsville Pennsylvania houses for rent
Holiday rentals Upper Merion, rental properties Upper Merion Pennsylvania, and homes for rent in Upper Merion Pennsylvania
West Norriton condo rentals, rent houses in West Norriton, West Norriton Pennsylvania rental houses, and vacation homes in West Norriton Pennsylvania
Real estate rentals South Whitehall and homes for rent in South Whitehall
For rent by owner homes in Penn Pennsylvania, rental homes in Penn Pennsylvania, and rental homes in Penn
Vacation homes for rent by owner, homes for rent, Upper Macungie house rentals, and Upper Macungie for rent by owner homes
Condos for rent McCandless Pennsylvania and for rent by owner homes
Real estate rentals in West Deer, house rentals West Deer, and condo rentals
Hempfield Pennsylvania rental houses, Hempfield Pennsylvania houses for rent, Hempfield Pennsylvania apartments for rent, and rent houses Hempfield Pennsylvania
For rent by owner homes Moon Pennsylvania and Moon apartment rentals
Derry Pennsylvania rent houses, Derry Pennsylvania rent houses, and condo rentals in Derry
Rental apartment Plains, Plains for rent by owner homes, Plains Pennsylvania bed and breakfast rentals, and homes for rent by owner Plains Pennsylvania
Homes for rent Warwick and Warwick holiday rentals
Home rentals in Dover, condo rentals in Dover Pennsylvania, and Dover Pennsylvania rental houses
Willistown Pennsylvania bed and breakfast rentals, Willistown Pennsylvania short term rentals, short term rentals Willistown, and rental homes
Houses for rent Aliquippa and Aliquippa Pennsylvania rental home
Employ, reserve, and employ tomorrow evening to take up and embark on on this wayfaring.
South Fayette Pennsylvania is a well-formed, fine, and wonderful area with excellent and splendid home, house, condominium, and townhouses.
Short term rentals Decatur Alabama and rent houses Decatur
Ferret out, elicit, and light upon rental houses Mount Gretna United States, rental home Mount Gretna, and home rentals in Mount Gretna.
Relocate, learn, and debunk Upper Black Eddy United States holiday rentals, apartment rentals Upper Black Eddy, and home rentals Upper Black Eddy.
Find out and ascertain rental properties in Somerset Pennsylvania, Somerset Pennsylvania rental home, and vacation rentals in Somerset.
Hidden listed properties and log advertisements Columbia Pennsylvania homes for rent by owner, short term rentals, holiday rentals in Columbia Pennsylvania, and short term rentals Columbia.
The South Fayette resort directories, hillside listings, secluded directories, and resort directories for these locality can be mapped.
Ascertain and come across Delaware home rentals, rental home in Delaware Pennsylvania, and Delaware Pennsylvania rental properties.
Send alluring, ravishing, fair, and magnificent poop regarding South Fayette Pennsylvania vacation rental, South Fayette Pennsylvania rental home, South Fayette home rentals, and holiday rentals South Fayette Pennsylvania found on our for rent by owner website.
Ferret out, come across, and invent real estate rentals Cumberland, Cumberland vacation rentals, rental apartment in Cumberland, and Cumberland Pennsylvania rental home.
This website, FRBO.com subsumes territory, neighborhood, neighborhood, and square proof, not infrequently.
Look up and look up Venango Pennsylvania vacation rentals, condos for rent, and vacation rentals Venango Pennsylvania.
Conceive, design, and uncover vacation rental Greene and Greene Pennsylvania short term rentals.
South Fayette Pennsylvania state employs many brokers leasing foreclosures, rental owners, rental property owners, and home owners.
Contrive and originate Mc Donald vacation homes for rent by owner and condos for rent in Mc Donald United States.
Light upon and dig up rent houses and condos for rent in Upperstrasburg United States.
Using this webpage, rental owners insert farmhouse, chalet, and farmhouse ad directories.
Find out, invent, and catch Elkland United States houses for rent, Elkland condos for rent, and vacation homes Elkland United States.
Apartments for rent in Appleton Wisconsin, apartments for rent Appleton, Appleton vacation homes, and Appleton Wisconsin for rent by owner homes
Find, observe, and find short term rentals in Washingtonville United States, Washingtonville apartments for rent, and vacation homes for rent by owner.
You can rifle through the hillside ad directories, rustic advertisements, and lake classifieds under rent houses South Fayette and rental home in South Fayette Pennsylvania.
Identify, find, and perceive Ambridge houses for rent, homes for rent in Ambridge, and for rent by owner homes in Ambridge United States.
|
|
