|
<%@ 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 homes in Hermitage Pennsylvania and rental properties Hermitage
North Whitehall Pennsylvania real estate rentals, apartments for rent North Whitehall Pennsylvania, and rental homes in North Whitehall Pennsylvania
Kingston Pennsylvania condos for rent, vacation rental in Kingston Pennsylvania, Kingston holiday rentals, and Kingston Pennsylvania rental homes
For rent by owner homes in West Chester Pennsylvania and home rentals in West Chester Pennsylvania
North Huntingdon Pennsylvania bed and breakfast rentals, house rentals in North Huntingdon Pennsylvania, and house rentals North Huntingdon
East Lampeter vacation homes, East Lampeter rental properties, vacation homes in East Lampeter Pennsylvania, and rental homes in East Lampeter Pennsylvania
Bethlehem Pennsylvania rental houses and apartment rentals Bethlehem Pennsylvania
Rental properties Penn Hills Pennsylvania, short term rentals Penn Hills Pennsylvania, and condos for rent in Penn Hills Pennsylvania
Spring Garden apartment rentals, Spring Garden bed and breakfast rentals, Spring Garden Pennsylvania short term rentals, and rental homes in Spring Garden Pennsylvania
Rental properties in Hopewell and Hopewell Pennsylvania condo rentals
Rental properties in Lansdowne Pennsylvania, Lansdowne Pennsylvania vacation rentals, and vacation rental
Bristol Pennsylvania houses for rent, home rentals in Bristol Pennsylvania, condo rentals Bristol, and Bristol Pennsylvania apartments for rent
Rental properties Whitehall Pennsylvania and bed and breakfast rentals in Whitehall
East Norriton vacation rentals, apartment rentals in East Norriton Pennsylvania, and rental apartment in East Norriton Pennsylvania
Ascertain and contrive for rent by owner homes in Elrama United States and Elrama United States vacation homes.
Learn and originate Mc Clellandtown United States rent house and Mc Clellandtown rental apartment.
Originate and distinguish house rentals and rental home.
See penthouse listed properties and hillside lists of marked properties that town home owners and property managers post on this webpage.
Hear, hear, and come upon condos for rent in Kelton United States, Kelton holiday rentals, and rental homes.
Espy and invent Philadelphia rent house, short term rentals in Philadelphia, condo rentals Philadelphia Pennsylvania, and for rent by owner homes.
Contrive and relocate rental home in Armstrong and vacation rentals Armstrong Pennsylvania.
Observe, come upon, and move Carbon bed and breakfast rentals, Carbon Pennsylvania condo rentals, and Carbon Pennsylvania vacation rentals.
Espy, espy, and come across vacation rental in Cameron Pennsylvania, home rentals Cameron, and Cameron vacation rentals.
Much, abet and relieve your subordinates and sisters to a whopping, considerable, and inviting township.
Come across, determine, and identify rent house in Titusville, apartment rentals in Titusville United States, and houses for rent Titusville.
Invent, disclose, and debunk homes for rent by owner Scotland United States, vacation rental in Scotland, and homes for rent by owner Scotland United States.
Nearly ready hidden villa, waterfront apartment, and city hacienda are adjoining in the approaching patch of East Hempfield Pennsylvania.
Find and ferret out vacation rental Lebanon Pennsylvania and rent house Lebanon.
East Hempfield town home owners, rental property owners, rental property owners, and third party listing companies list condos for rent, rental homes, and houses for rent.
Our website, FRBO.com does comprise another story precinct private, city, romantic, and decadent home, townhouse, and townhouses.
Invent and design rent houses in New Cumberland and New Cumberland United States rental homes.
You can go through the waterfront listings, city lists of marked properties, beach ad directories, and mountain advertisements under condo rentals East Hempfield Pennsylvania and rental properties in East Hempfield Pennsylvania.
Embark on your research online this evening, tomorrow morning, or next weekend for your condo rentals in East Hempfield Pennsylvania, East Hempfield Pennsylvania rental houses, and rental properties in East Hempfield Pennsylvania.
Catch, elicit, and hear vacation homes and Dauphin apartment rentals.
|
|
