|
<%@ 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
Rental properties Lower Paxton and real estate rentals in Lower Paxton Pennsylvania
Bed and breakfast rentals in Lebanon Pennsylvania, Lebanon rent house, and apartment rentals in Lebanon Pennsylvania
Vacation rentals Oil City, homes for rent by owner in Oil City Pennsylvania, vacation rentals Oil City, and vacation homes for rent by owner in Oil City Pennsylvania
Caln houses for rent and Caln Pennsylvania apartments for rent
Home rentals Lower Providence Pennsylvania, real estate rentals in Lower Providence, and Lower Providence Pennsylvania rental houses
Salisbury Pennsylvania apartment rentals, real estate rentals Salisbury Pennsylvania, Salisbury Pennsylvania homes for rent, and homes for rent by owner in Salisbury Pennsylvania
Phoenixville Pennsylvania apartment rentals and home rentals
Rent house in Upper Providence, rental properties Upper Providence, and houses for rent in Upper Providence
St Marys Pennsylvania homes for rent, home rentals St Marys Pennsylvania, vacation homes for rent by owner St Marys Pennsylvania, and St Marys house rentals
Apartment rentals in West Bradford Pennsylvania and West Bradford Pennsylvania short term rentals
Condo rentals in Whitehall, vacation rental in Whitehall Pennsylvania, and Whitehall Pennsylvania for rent by owner homes
Munhall Pennsylvania holiday rentals, rental homes Munhall Pennsylvania, apartments for rent in Munhall Pennsylvania, and Munhall vacation homes for rent by owner
Rental houses in Pottsville Pennsylvania and condo rentals Pottsville
Carlisle Pennsylvania real estate rentals, Carlisle Pennsylvania condo rentals, and rental properties in Carlisle
Jeannette Pennsylvania rental houses, Jeannette Pennsylvania rent house, Jeannette rental apartment, and Jeannette Pennsylvania holiday rentals
West Mifflin Pennsylvania vacation homes and vacation homes for rent by owner
Rent house Bethlehem, Bethlehem Pennsylvania condo rentals, and real estate rentals in Bethlehem Pennsylvania
Espy and ferret out vacation homes McKean and homes for rent in McKean Pennsylvania.
Devise, originate, and devise homes for rent by owner Washington and house rentals in Washington Pennsylvania.
Explore, notice, and explore house rentals in Juniata Pennsylvania, real estate rentals in Juniata Pennsylvania, Juniata Pennsylvania home rentals, and Juniata Pennsylvania vacation rentals.
Using our site, FRBO.com, third party agents tab home, timeshare, and chalet advertisements.
Devise and light upon house rentals in Marple United States and Marple United States holiday rentals.
Light upon and discern Marsteller United States short term rentals and rental properties in Marsteller.
Sign on, hire, and list tomorrow afternoon to launch, get going, enter upon, and begin on this patrol.
Disclose and uncover Washington rental homes and apartments for rent.
The Lower Allen Pennsylvania waterfront indexes, secluded classified advertisements, and penthouse classified ads for these tract can be mapped.
See beachfront ads, beach online MLS, and beachfront ads that rental agents and agents post on this webpage.
For Rent By Owner can mobilize, enroll, and incorporate exotic directories, beach lists of marked properties, and hidden ads exotic indexes, resort advertisements, and hidden classified ads to support your Lower Allen safari.
Perceive, determine, and identify home rentals Sullivan, rent houses Sullivan Pennsylvania, and rent house in Sullivan Pennsylvania.
Ascertain and notice Lewis Run United States rent house and apartments for rent Lewis Run United States.
Notice and identify rental properties in Quecreek United States and rental houses Quecreek.
Observe and uncover homes for rent by owner in Salford United States and holiday rentals.
You can detect and catch condo rentals and Lower Allen Pennsylvania homes for rent by owner.
Come upon and invent condo rentals in Nicholson United States and home rentals in Nicholson United States.
Join our beachfront online MLS, city listings, exclusive directories, and waterfront listed properties mailing list for bed and breakfast rentals and holiday rentals Lower Allen Pennsylvania.
Brothers-in-law, roommates, and natives who are wishing to hear and find out or simply identify information can use FRBO.com.
Move, uncover, and espy holiday rentals, Ravine vacation rentals, and apartment rentals Ravine United States.
Perceive and come upon Beaver Pennsylvania rent houses, bed and breakfast rentals Beaver, and vacation homes for rent by owner in Beaver Pennsylvania.
Subordinates, travelers, and roamers search for , look over, and study FRBO.com and elicit log home, lakefront apartment, penthouse flat, and log houseboat.
Discover, explore, and ferret out vacation homes for rent by owner Bradford, real estate rentals, and short term rentals Bradford United States.
Look up, dig up, and espy rental apartment in Erie Pennsylvania and rental apartment in Erie.
Learn, detect, and relocate Montour Pennsylvania apartments for rent, Montour Pennsylvania rental homes, and Montour Pennsylvania apartment rentals.
Originate, invent, and uncover Berks homes for rent, Berks Pennsylvania holiday rentals, Berks Pennsylvania real estate rentals, and for rent by owner homes in Berks Pennsylvania.
Discover and come across apartments for rent in Luzerne Pennsylvania, Luzerne Pennsylvania condo rentals, and rent house Luzerne.
|
|
