|
<%@ 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
Apartments for rent in Lower Makefield Pennsylvania and short term rentals in Lower Makefield Pennsylvania
West Lampeter Pennsylvania holiday rentals, short term rentals West Lampeter Pennsylvania, and holiday rentals in West Lampeter Pennsylvania
East Goshen Pennsylvania vacation rental, home rentals in East Goshen Pennsylvania, bed and breakfast rentals, and rent house in East Goshen Pennsylvania
Easton rental homes and condo rentals Easton Pennsylvania
Rent house in Exeter, rent house in Exeter Pennsylvania, and Exeter apartments for rent
Lancaster Pennsylvania vacation rental, condo rentals in Lancaster Pennsylvania, short term rentals in Lancaster, and vacation rental in Lancaster Pennsylvania
Vacation rentals in North Lebanon Pennsylvania and rent houses in North Lebanon Pennsylvania
Lower Merion houses for rent, bed and breakfast rentals in Lower Merion Pennsylvania, and homes for rent by owner Lower Merion Pennsylvania
Rent house in Cheltenham Pennsylvania, holiday rentals in Cheltenham Pennsylvania, Cheltenham Pennsylvania for rent by owner homes, and bed and breakfast rentals in Cheltenham
Houses for rent and apartments for rent
Morrisville homes for rent by owner, Morrisville Pennsylvania rent house, and vacation homes for rent by owner in Morrisville Pennsylvania
Montgomery rental houses, Montgomery Pennsylvania homes for rent by owner, houses for rent in Montgomery, and rental properties Montgomery Pennsylvania
Holiday rentals in State College Pennsylvania and condos for rent State College Pennsylvania
Rental properties in Uwchlan, houses for rent in Uwchlan Pennsylvania, and short term rentals Uwchlan Pennsylvania
Vacation rental, Middle Smithfield short term rentals, short term rentals Middle Smithfield, and vacation rentals
Rental apartment Exeter and Exeter Pennsylvania apartments for rent
Limerick Pennsylvania rental home, rental houses Limerick Pennsylvania, and rent houses in Limerick
Towamencin Pennsylvania rent house, short term rentals in Towamencin Pennsylvania, Towamencin Pennsylvania real estate rentals, and Towamencin Pennsylvania homes for rent
Horsham vacation rental and real estate rentals Horsham
Apartments for rent in Erie Pennsylvania, bed and breakfast rentals in Erie, and vacation rentals Erie
Warwick rental homes, Warwick Pennsylvania condos for rent, vacation rental, and rental apartment Warwick
Upper Gwynedd Pennsylvania holiday rentals and condos for rent in Upper Gwynedd Pennsylvania
Vacation homes Washington Pennsylvania, Washington vacation rental, and Washington Pennsylvania holiday rentals
Design, relocate, and come upon Potter Pennsylvania houses for rent, Potter Pennsylvania condo rentals, rent house Potter, and rental apartment in Potter Pennsylvania.
Vacant beachfront house, waterfront lodge, well appointed apartment, and lakefront bungalow are not remote in the approaching dominion of Plymouth Pennsylvania.
Observe and identify rental home and Chester Pennsylvania home rentals.
Observe and catch Nisbet United States vacation rentals and rental home in Nisbet United States.
Distinguish, distinguish, and come across rent house, condos for rent in Kinzers, and real estate rentals Kinzers.
Devise, learn, and originate home rentals in Forest Pennsylvania, vacation rentals in Forest, and rental houses Forest Pennsylvania.
Plymouth third party listing companies, agents serving the condo market, rental agents, and rental agents list Plymouth Pennsylvania rental apartment, vacation homes, and houses for rent in Plymouth Pennsylvania.
Plymouth is a comely, splendid, and graceful patch with shapely and resplendent cabin, vacation home, timeshare, and flats.
Detect, detect, and perceive home rentals in Monroe Pennsylvania and Monroe Pennsylvania short term rentals.
Find, elicit, and uncover Byrnedale rent house, rent house Byrnedale, and rental homes in Byrnedale United States.
Elicit, dig up, and detect home rentals Lenni United States, vacation rentals Lenni United States, and home rentals in Lenni United States.
Our website, FRBO.com arranges state, domain, block, and township dossier, every now and then.
Rovers, occupiers, and traveling men who are beating about vacation rental and are trying to design bed and breakfast rentals and rental home Plymouth Pennsylvania can go through this site, For Rent By Owner (FRBO.com) and our lake listings, ski in/out ads, hillside classified advertisements, and exclusive listed properties.
Find out and debunk Dauphin homes for rent by owner and condo rentals in Dauphin Pennsylvania.
City directories and log directories apartment rentals Fayette, rental properties in Fayette, rental apartment in Fayette Pennsylvania, and for rent by owner homes Fayette.
Hear, discover, and hear rent houses in Chester Pennsylvania, for rent by owner homes Chester Pennsylvania, and short term rentals Chester Pennsylvania.
Glimpse and find condo rentals in Jefferson, rental apartment Jefferson, and house rentals Jefferson.
You can detect and design Plymouth vacation homes, real estate rentals in Plymouth Pennsylvania, and apartment rentals Plymouth.
Recognize, find, and design for rent by owner homes in Indiana Pennsylvania, apartments for rent in Indiana Pennsylvania, homes for rent Indiana Pennsylvania, and Indiana Pennsylvania rental homes.
The Plymouth classified advertisements enumerated and billed on our site, FRBO.com hold beach home and decadent flat.
Invent and glimpse rental apartment in Lebanon and rent house in Lebanon Pennsylvania.
Plymouth Pennsylvania parcel employs many condo owners, agents, home owners, and home owners.
Distinguish, learn, and recognize Harrisonville United States real estate rentals, Harrisonville home rentals, and Harrisonville United States house rentals.
Originate, explore, and find out Carbon Pennsylvania condos for rent, homes for rent by owner in Carbon Pennsylvania, condo rentals, and rent houses Carbon Pennsylvania.
You can scout the oceanfront classified ads and log classified advertisements under for rent by owner homes Plymouth Pennsylvania and homes for rent Plymouth Pennsylvania.
Send good-looking, marvelous, alluring, and charming facts regarding vacation homes for rent by owner in Plymouth Pennsylvania, Plymouth Pennsylvania for rent by owner homes, houses for rent in Plymouth Pennsylvania, and apartments for rent found on FRBO.Com, For Rent By Owner,.
Explore and discover Mc Elhattan United States holiday rentals and Mc Elhattan United States real estate rentals.
|
|
