|
<%@ 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 houses and rent houses Norristown
Rental houses in Baldwin Pennsylvania, rent house in Baldwin Pennsylvania, and vacation homes Baldwin
Vacation rentals in Elizabethtown Pennsylvania, Elizabethtown Pennsylvania vacation rental, apartments for rent Elizabethtown Pennsylvania, and Elizabethtown Pennsylvania rent houses
New Kensington rental apartment and rental apartment in New Kensington Pennsylvania
Rental home Washington Pennsylvania, vacation rental Washington, and Washington vacation homes
Rent house, homes for rent, Middle Smithfield for rent by owner homes, and Middle Smithfield Pennsylvania rent house
Condo rentals in Coatesville Pennsylvania and homes for rent by owner
Warren Pennsylvania apartments for rent, Warren Pennsylvania short term rentals, and Warren vacation rental
Apartments for rent, Swatara Pennsylvania vacation rentals, vacation rentals Swatara, and short term rentals Swatara Pennsylvania
Falls Pennsylvania rental homes and Falls Pennsylvania rental home
Condo rentals in Lancaster Pennsylvania, houses for rent in Lancaster Pennsylvania, and rental apartment in Lancaster Pennsylvania
Rent house, Lebanon vacation homes, house rentals Lebanon, and rental apartment in Lebanon
Vacation homes for rent by owner Meadville and rental properties in Meadville
Uncover, relocate, and come upon rental home Huntingdon Pennsylvania, condo rentals Huntingdon Pennsylvania, and Huntingdon apartments for rent.
You can find and ascertain rental home in Plum Pennsylvania, rental homes Plum, and Plum vacation rental.
Troupers, husbands, and trippers run down and probe this extensive website, FRBO.com and recognize lake bungalow, beach bungalow, studio cottage, and city condominium.
Come across, move, and disclose Trafford United States houses for rent, condos for rent in Trafford, and Trafford United States bed and breakfast rentals.
See decadent ads, spacious online MLS, and waterfront online MLS that condo owners and home owners post on our site, FRBO.com.
Identify, learn, and observe homes for rent by owner in Boyers United States, rental home Boyers United States, and short term rentals in Boyers United States.
Discern and look up vacation rentals and home rentals.
Devise and elicit vacation homes for rent by owner Bradford Pennsylvania and Bradford Pennsylvania holiday rentals.
Plum property agents, condo owners, landlords, and home owners list Plum Pennsylvania rental home, rental apartment Plum Pennsylvania, and home rentals Plum Pennsylvania.
You can rifle through the lakefront online MLS and decadent classified ads under homes for rent by owner in Plum Pennsylvania and vacation rentals Plum Pennsylvania.
Discover and detect Potter Pennsylvania rental homes, houses for rent in Potter Pennsylvania, rental apartment, and Potter vacation homes.
Twins and explorers who are hunting Plum Pennsylvania apartment rentals and are trying to contrive rental home Plum Pennsylvania, homes for rent by owner in Plum Pennsylvania, and Plum Pennsylvania homes for rent can beat about our for rent by owner site, FRBO.com and our lakefront classified advertisements, exclusive ad directories, log lists of marked properties, and rustic ads.
Light upon and conceive for rent by owner homes, real estate rentals in Centre, and real estate rentals.
Relocate and distinguish rent house in Gettysburg United States and home rentals Gettysburg United States.
|
|
