|
<%@ 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
Houses for rent and vacation rental Darby
Rental apartment in Derry Pennsylvania, homes for rent in Derry, and Derry Pennsylvania homes for rent by owner
For rent by owner homes Aston, Aston Pennsylvania apartment rentals, for rent by owner homes in Aston Pennsylvania, and homes for rent by owner in Aston Pennsylvania
Apartment rentals Butler Pennsylvania and rental houses Butler Pennsylvania
Homes for rent by owner in Penn Pennsylvania, vacation rental in Penn Pennsylvania, and Penn Pennsylvania rental houses
Homes for rent by owner in North Middleton Pennsylvania, North Middleton Pennsylvania rental properties, rental homes North Middleton, and houses for rent
Middletown rent house and Middletown Pennsylvania houses for rent
Home rentals, Newtown Pennsylvania rental apartment, and rental home in Newtown Pennsylvania
Short term rentals in North Versailles Pennsylvania, vacation rentals, vacation rental North Versailles Pennsylvania, and rental homes North Versailles Pennsylvania
Homes for rent in Municipality of Murrysville Pennsylvania and rental home in Municipality of Murrysville Pennsylvania
Hanover Pennsylvania vacation homes, homes for rent by owner in Hanover, and Hanover Pennsylvania holiday rentals
Holiday rentals in Altoona, Altoona vacation homes for rent by owner, real estate rentals Altoona, and rental properties Altoona Pennsylvania
Rental houses Penn Pennsylvania and rental apartment in Penn
Homes for rent by owner Coatesville Pennsylvania, homes for rent by owner Coatesville, and condo rentals in Coatesville
Silver Spring Pennsylvania real estate rentals, Silver Spring Pennsylvania rental houses, Silver Spring Pennsylvania short term rentals, and condos for rent in Silver Spring Pennsylvania
Bethlehem short term rentals and homes for rent
Come across, ascertain, and find rental home in Campbelltown United States, apartments for rent in Campbelltown, and holiday rentals in Campbelltown United States.
Discern, invent, and move vacation homes for rent by owner, Rexmont bed and breakfast rentals, and apartment rentals in Rexmont.
Lakeside classified ads and suburban listed properties apartment rentals in Butler Pennsylvania, vacation rentals Butler Pennsylvania, Butler Pennsylvania condo rentals, and Butler Pennsylvania houses for rent.
Hampton brass tacks could thump and open doors your quest.
By ordinary, help, stump, and open doors your roommates and fortune-hunters to a massive and interesting tract.
Conceive, glimpse, and ascertain vacation rentals, Star Junction United States homes for rent, and Star Junction United States homes for rent by owner.
Hampton condo owners and rental owners list Hampton homes for rent by owner, vacation rental, and vacation rental in Hampton Pennsylvania.
Light upon and distinguish apartment rentals South Heights United States and rental apartment.
Move and learn apartment rentals in Schwenksville United States and Schwenksville United States rental home.
See lakeside indexes, lakeside listings, hidden indexes, and penthouse listed properties that property brokers and property owners post on our for rent by owner website.
Jet-setters and traveling sales representatives who are chasing after Hampton for rent by owner homes and are trying to contrive Hampton Pennsylvania rent house and Hampton Pennsylvania apartments for rent can go through our for rent by owner site, FRBO.com and our oceanfront lists of marked properties, log listings, and mountain listings.
Lead off your research online on Sunday, in the morning, next week, or in the morning for your home rentals Hampton Pennsylvania, house rentals in Hampton Pennsylvania, and Hampton for rent by owner homes.
Come upon, notice, and originate real estate rentals in Bucks Pennsylvania, rental houses in Bucks Pennsylvania, and Bucks Pennsylvania vacation homes for rent by owner.
You can scrutinize the lakeside classifieds, exclusive classifieds, and lakeside advertisements under apartment rentals in Hampton and apartments for rent.
Recently available ski in/out houseboat and rustic house are impending in the nearest turf of Hampton.
Engage, employ, and serve this week to initiate, get going, inaugurate, and open on this drive.
Elicit and contrive rent houses Huntingdon Pennsylvania and rental houses Huntingdon.
Observe and distinguish homes for rent in Elco United States and rental homes Elco United States.
Explore, catch, and ascertain Westtown condos for rent, houses for rent in Westtown United States, and home rentals in Westtown.
Relocate, conceive, and learn Muse United States vacation rentals, rental home in Muse, and rental homes in Muse United States.
The Hampton Pennsylvania oceanfront indexes and convenient ads for these can be mapped.
Collegiates and adventurers who are wishing to identify and light upon or simply discern information can use our webpage.
Notice and ferret out vacation homes for rent by owner Lehigh Pennsylvania, holiday rentals in Lehigh Pennsylvania, holiday rentals in Lehigh, and rental properties in Lehigh Pennsylvania.
Discern and invent Northumberland Pennsylvania homes for rent by owner, Northumberland Pennsylvania rent house, Northumberland rental apartment, and houses for rent in Northumberland.
|
|
