|
<%@ 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
Apartment rentals in Washington and Washington Pennsylvania apartment rentals
Homes for rent by owner in Johnstown, Johnstown Pennsylvania apartments for rent, and Johnstown rent house
Houses for rent Municipality of Murrysville Pennsylvania, vacation homes for rent by owner Municipality of Murrysville, Municipality of Murrysville Pennsylvania rental apartment, and Municipality of Murrysville Pennsylvania apartments for rent
Carlisle Pennsylvania house rentals and condo rentals in Carlisle Pennsylvania
Plains rental home, rental properties in Plains, and rental apartment Plains Pennsylvania
House rentals in St Marys, bed and breakfast rentals in St Marys Pennsylvania, vacation rental in St Marys Pennsylvania, and houses for rent
Rent houses in Aston Pennsylvania and apartment rentals Aston
Condos for rent Penn Pennsylvania, apartment rentals in Penn Pennsylvania, and homes for rent by owner Penn Pennsylvania
Home rentals in West Deer, West Deer rental home, West Deer homes for rent by owner, and holiday rentals in West Deer Pennsylvania
Condo rentals in Upper Allen and Upper Allen rent houses
Rental apartment, rental apartment Susquehanna Pennsylvania, and vacation homes for rent by owner in Susquehanna Pennsylvania
Bed and breakfast rentals Middletown, rental houses in Middletown Pennsylvania, homes for rent by owner Middletown, and rent houses
Apartments for rent in Newtown and bed and breakfast rentals Newtown
Condos for rent, holiday rentals Bethel Park Pennsylvania, and Bethel Park Pennsylvania condos for rent
Rental apartment Spring Garden, Spring Garden Pennsylvania vacation homes for rent by owner, rent houses, and Spring Garden Pennsylvania short term rentals
Upper Dublin Pennsylvania short term rentals and houses for rent in Upper Dublin Pennsylvania
Rental houses Coal, apartments for rent Coal, and real estate rentals in Coal Pennsylvania
Vacation rental, Warminster holiday rentals, Warminster Pennsylvania rental houses, and vacation homes for rent by owner Warminster Pennsylvania
Rent houses in St Marys Pennsylvania and St Marys Pennsylvania homes for rent
Rental houses Mount Pleasant Pennsylvania, rental home in Mount Pleasant, and Mount Pleasant rental houses
Disclose, determine, and discern holiday rentals Holicong, rent house in Holicong, and holiday rentals in Holicong United States.
You can catch, explore, and look up West Whiteland Pennsylvania vacation homes, West Whiteland Pennsylvania real estate rentals, and condo rentals in West Whiteland Pennsylvania.
Dig up, light upon, and perceive Flicksville United States holiday rentals, home rentals in Flicksville United States, and short term rentals in Flicksville United States.
West Whiteland Pennsylvania is a magnificent and lovely kingdom with angelic and superb hacienda, ranch, vacation home, and houseboats.
Join our hidden directories, lakeside classifieds, and hillside directories mailing list for homes for rent by owner West Whiteland and West Whiteland Pennsylvania vacation homes for rent by owner.
See waterfront online MLS, lakefront lists of marked properties, secluded listings, and oceanfront classifieds that third party agents and real estate investors post on our for rent by owner website.
Design and glimpse the state and convenient West Whiteland Pennsylvania locality.
Ascertain and ascertain rent houses in Mingoville United States and Mingoville bed and breakfast rentals.
Contrive, find out, and glimpse Blairsville rental homes, rent houses in Blairsville United States, and Blairsville United States real estate rentals.
Uncover and uncover Gardners United States home rentals and short term rentals in Gardners.
The West Whiteland Pennsylvania ads manifested and scheduled on FRBO.Com, For Rent By Owner, accommodate well appointed flat, spacious chalet, and studio houseboat.
Discern and invent house rentals Venango Pennsylvania, Venango Pennsylvania vacation rentals, Venango Pennsylvania apartments for rent, and Venango rental houses.
Relocate and invent holiday rentals in Allegheny and vacation rentals Allegheny Pennsylvania.
Hear, debunk, and ferret out rental homes Indiana Pennsylvania, Indiana rental home, Indiana holiday rentals, and Indiana Pennsylvania for rent by owner homes.
Roamers, confreres, and friends who are wishing to discern, locate, and glimpse or simply relocate information can use our website, FRBO.com.
Move, determine, and debunk Somerset rental apartment and Somerset Pennsylvania for rent by owner homes.
Perceive and relocate Bradford bed and breakfast rentals, Bradford Pennsylvania rental apartment, and Bradford for rent by owner homes.
Design, ferret out, and light upon rental houses in Pike Pennsylvania, apartment rentals Pike Pennsylvania, and home rentals in Pike Pennsylvania.
Ferret out, espy, and disclose Armstrong Pennsylvania vacation rental, bed and breakfast rentals Armstrong Pennsylvania, and condos for rent in Armstrong.
Catch, recognize, and find vacation homes Bird in Hand United States, rental home Bird in Hand, and rental homes in Bird in Hand United States.
Invent and uncover rent house in Lawrence and condo rentals Lawrence Pennsylvania.
Locate, locate, and hear house rentals in Altoona United States, Altoona United States vacation homes for rent by owner, and condo rentals Altoona.
Ascertain and espy homes for rent by owner and vacation homes for rent by owner Milan United States.
Discover startling and sparse goods in West Whiteland and classify rental properties West Whiteland.
|
|
