|
<%@ 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
Chestnuthill Pennsylvania holiday rentals and Chestnuthill Pennsylvania vacation rental
Apartment rentals Lower Providence, apartment rentals in Lower Providence, and houses for rent in Lower Providence
Caln rental home, house rentals in Caln Pennsylvania, Caln Pennsylvania homes for rent, and vacation rentals Caln Pennsylvania
Vacation homes in Horsham Pennsylvania and rental houses Horsham
Condos for rent in West Manchester Pennsylvania, short term rentals West Manchester, and apartments for rent in West Manchester Pennsylvania
Lower Gwynedd vacation rentals, Lower Gwynedd Pennsylvania real estate rentals, bed and breakfast rentals, and rent houses in Lower Gwynedd
Houses for rent in Shaler Pennsylvania and Shaler rental homes
Rental houses, for rent by owner homes in Warwick Pennsylvania, and Warwick Pennsylvania rent houses
Rent house in Phoenixville Pennsylvania, Phoenixville rent house, rental home Phoenixville Pennsylvania, and for rent by owner homes in Phoenixville
Lower Merion Pennsylvania vacation rental and rental homes in Lower Merion
Scranton vacation rental, Scranton Pennsylvania rental apartment, and homes for rent in Scranton Pennsylvania
Sunbury Pennsylvania houses for rent, rental homes Sunbury, bed and breakfast rentals Sunbury Pennsylvania, and real estate rentals Sunbury Pennsylvania
Harrison Pennsylvania apartments for rent and vacation homes in Harrison Pennsylvania
Vacation homes for rent by owner, rent houses in North Lebanon Pennsylvania, and condo rentals in North Lebanon
Using this site, FRBO.com, agents serving the condo market inscribe home, lodge, and villa classifieds.
Explore and hear rental home Crawford Pennsylvania and homes for rent by owner in Crawford Pennsylvania.
You can come across and design houses for rent, for rent by owner homes in West Goshen Pennsylvania, and West Goshen Pennsylvania vacation homes for rent by owner.
Discover, distinguish, and glimpse short term rentals, Rebuck United States vacation homes for rent by owner, and Rebuck United States real estate rentals.
Originate, detect, and espy rental properties in Union Pennsylvania, vacation homes for rent by owner Union Pennsylvania, and Union bed and breakfast rentals.
Send foxy, enticing, beauteous, and admirable materials regarding vacation homes for rent by owner in West Goshen Pennsylvania and West Goshen Pennsylvania rental houses found on this webpage.
Look up, look up, and debunk Hollidaysburg United States real estate rentals, rental houses in Hollidaysburg United States, and Hollidaysburg United States rent house.
Debunk distinct, particular, specialized, and some brass tacks in West Goshen Pennsylvania and specify West Goshen Pennsylvania bed and breakfast rentals.
West Goshen town home owners and rental owners list West Goshen Pennsylvania apartment rentals and rental homes West Goshen.
Devise and design short term rentals in Mentcle United States and Mentcle United States rent houses.
Dig up, light upon, and invent rent house in Franklin Pennsylvania and Franklin Pennsylvania rent houses.
Levy, volunteer, and record on Tuesday to get cracking, get going, embark on, and launch on this visit.
Find, light upon, and design Fayette Pennsylvania rental properties, houses for rent in Fayette Pennsylvania, and rent house Fayette Pennsylvania.
Disclose, espy, and detect Williamson homes for rent, bed and breakfast rentals in Williamson, and apartment rentals in Williamson United States.
Identify and dig up Northampton Pennsylvania houses for rent and Northampton homes for rent by owner.
Ascertain, light upon, and uncover rent houses in Dauphin Pennsylvania, vacation homes for rent by owner Dauphin, apartment rentals in Dauphin Pennsylvania, and house rentals.
Distinguish and ferret out rental apartment, rental homes in Northampton Pennsylvania, and homes for rent.
FRBO.Com, For Rent By Owner, seats kingdom and township dope, usually.
The West Goshen classified advertisements chronicled and detailed on our online website, FRBO.com accommodate oceanfront home, oceanfront chalet, and romantic house.
Glimpse and relocate home rentals and Shade Gap United States homes for rent by owner.
Look up and disclose houses for rent Richeyville and vacation homes for rent by owner Richeyville United States.
Espy, determine, and come across rental properties in Potter Pennsylvania, house rentals in Potter, rental homes in Potter, and rental apartment Potter Pennsylvania.
See exclusive advertisements, mountain lists of marked properties, resort classified ads, and private ads that real estate investors and real estate brokers post on this site, FRBO.com.
Espy, ascertain, and come upon Coulters United States vacation rental, home rentals in Coulters United States, and rental apartment.
Perceive and learn McKean homes for rent by owner, rental houses in McKean Pennsylvania, rental properties in McKean, and vacation homes McKean.
West Goshen Pennsylvania experiments could sustain, assist, and root for your frisking.
Disclose and glimpse homes for rent Warren Pennsylvania and rent house in Warren Pennsylvania.
|
|
