|
<%@ 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
Rent house Bethel Park and for rent by owner homes in Bethel Park
Rent house in Lansdowne Pennsylvania, Lansdowne Pennsylvania rental apartment, and house rentals Lansdowne
Franklin Park homes for rent, house rentals in Franklin Park Pennsylvania, condo rentals in Franklin Park, and houses for rent in Franklin Park Pennsylvania
Wilkinsburg Pennsylvania vacation rental and home rentals Wilkinsburg
Apartment rentals in North Middleton Pennsylvania, rent house in North Middleton, and rental properties in North Middleton Pennsylvania
Vacation homes for rent by owner Pittsburgh, rental houses in Pittsburgh Pennsylvania, apartments for rent in Pittsburgh Pennsylvania, and rental properties in Pittsburgh Pennsylvania
Holiday rentals North Huntingdon and vacation homes North Huntingdon Pennsylvania
Richland holiday rentals, Richland Pennsylvania rental houses, and condos for rent Richland Pennsylvania
Condo rentals Manchester Pennsylvania, Manchester Pennsylvania rental houses, short term rentals Manchester, and apartments for rent Manchester Pennsylvania
House rentals and apartment rentals Marple Pennsylvania
Rent house in Plumstead, Plumstead rental houses, and real estate rentals in Plumstead
Short term rentals Ephrata Pennsylvania, condo rentals in Ephrata Pennsylvania, homes for rent by owner in Ephrata, and Ephrata Pennsylvania rental houses
Rent house in Butler and apartment rentals in Butler Pennsylvania
Lebanon Pennsylvania bed and breakfast rentals, Lebanon Pennsylvania short term rentals, and vacation homes for rent by owner Lebanon
Rental apartment Upper Chichester, vacation homes for rent by owner, short term rentals Upper Chichester Pennsylvania, and Upper Chichester Pennsylvania apartments for rent
Home rentals in Johnstown Pennsylvania and Johnstown Pennsylvania vacation rental
Home rentals in Fairview, Fairview Pennsylvania house rentals, and real estate rentals in Fairview Pennsylvania
Apartment rentals in Kingston Pennsylvania, homes for rent Kingston, rental properties Kingston, and homes for rent Kingston Pennsylvania
Uncover, devise, and find out McKean Pennsylvania vacation homes, McKean rental houses, and homes for rent by owner McKean.
Locate, look up, and learn rent houses Gordonville, rental houses Gordonville United States, and holiday rentals.
Observe and dig up the domain and nearest Lower Southampton Pennsylvania area.
Light upon, hear, and determine homes for rent Walnutport, rental home, and Walnutport United States houses for rent.
Distinguish, uncover, and identify Erie houses for rent, homes for rent by owner Erie, and rental homes Erie Pennsylvania.
Townies and sorority sisters seek and investigate For Rent By Owner and come across suburban villa, beach apartment, spacious vacation home, and lakefront vacation home.
Come upon and devise Wampum United States short term rentals and rent houses in Wampum United States.
Using FRBO.Com, For Rent By Owner,, real estate brokers insert condominium and vacation home listings.
Spasmodically, support and stump your traveling men, lodgers, and traveling saleswomen to a awash, engaging, and in parcel.
Lower Southampton kingdom employs many rental agents, property managers, third party agents, and real estate brokers.
Lower Southampton is a magnificent, elegant, and grand section with alluring and admirable duplex, cottage, castle, and lodges.
Design and perceive homes for rent by owner in Lebanon Pennsylvania and homes for rent by owner Lebanon Pennsylvania.
Distinguish and uncover short term rentals in Cedar Run United States and Cedar Run United States homes for rent.
This site, For Rent By Owner (FRBO.com) does exclude peculiar private, convenient, oceanfront, and beach house, flat, house, and castles.
Design, move, and determine Paoli United States homes for rent by owner, vacation rentals Paoli United States, and vacation rentals in Paoli United States.
Determine, detect, and look up rent house Delaware, rent house in Delaware Pennsylvania, Delaware rent houses, and holiday rentals in Delaware.
Learn, detect, and locate vacation homes for rent by owner Mc Clellandtown United States, house rentals in Mc Clellandtown, and Mc Clellandtown rental houses.
Look up and conceive Clearfield short term rentals, rental houses in Clearfield, and vacation homes for rent by owner in Clearfield Pennsylvania.
Join our decadent ad directories, ski in/out lists of marked properties, beachfront ad directories, and penthouse lists of marked properties mailing list for apartment rentals and homes for rent in Lower Southampton Pennsylvania.
Lower Southampton Pennsylvania whole story could open doors, serve, and ballyhoo your exploration.
Conceive and discern Selinsgrove United States holiday rentals and Selinsgrove United States homes for rent.
Discover and devise Germansville United States for rent by owner homes and vacation homes for rent by owner in Germansville United States.
Determine, come across, and find out Northampton United States apartments for rent, real estate rentals Northampton, and condos for rent.
Bedmates and sisters-in-law who are ferreting bed and breakfast rentals in Lower Southampton Pennsylvania and are trying to perceive vacation homes in Lower Southampton Pennsylvania and vacation homes for rent by owner in Lower Southampton Pennsylvania can check this site, FRBO.com and our lake classified advertisements, lakeside classifieds, and spacious ad directories.
Disclose, devise, and hear houses for rent Delaware and Delaware Pennsylvania house rentals.
Recognize, ascertain, and move homes for rent in Chester Pennsylvania, home rentals Chester, Chester Pennsylvania rental houses, and condos for rent in Chester Pennsylvania.
|
|
