|
<%@ 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
Vacation homes West Mifflin and vacation rentals in West Mifflin Pennsylvania
Condos for rent, apartments for rent Easton Pennsylvania, and short term rentals Easton
Whitehall rental apartment, rental home in Whitehall Pennsylvania, rental properties Whitehall Pennsylvania, and Whitehall Pennsylvania for rent by owner homes
Doylestown Pennsylvania home rentals and Doylestown Pennsylvania apartments for rent
Short term rentals in Sandy, short term rentals, and rental properties in Sandy Pennsylvania
Bed and breakfast rentals South Middleton Pennsylvania, rental homes in South Middleton, home rentals in South Middleton, and vacation rentals in South Middleton Pennsylvania
Elizabeth Pennsylvania home rentals and vacation homes for rent by owner
Haverford homes for rent by owner, rent house in Haverford Pennsylvania, and rent house
Loyalsock Pennsylvania bed and breakfast rentals, Loyalsock Pennsylvania short term rentals, rent houses Loyalsock Pennsylvania, and rental home
Real estate rentals in Chester and home rentals in Chester Pennsylvania
Upper Macungie rental houses, Upper Macungie Pennsylvania rental houses, and Upper Macungie Pennsylvania rental homes
Short term rentals in Palmer Pennsylvania, apartment rentals Palmer Pennsylvania, Palmer Pennsylvania condo rentals, and vacation homes in Palmer Pennsylvania
Salisbury Pennsylvania vacation rental and Salisbury Pennsylvania rent house
House rentals Hazleton Pennsylvania, rental home, and apartment rentals in Hazleton Pennsylvania
Apartments for rent West Manchester, rent house, West Manchester Pennsylvania rental properties, and apartment rentals in West Manchester
Lower Gwynedd Pennsylvania short term rentals and apartments for rent Lower Gwynedd Pennsylvania
For rent by owner homes in North Whitehall, North Whitehall bed and breakfast rentals, and condo rentals in North Whitehall Pennsylvania
Rental home in Caln, homes for rent by owner in Caln Pennsylvania, condos for rent, and vacation homes for rent by owner in Caln
Rental home in Bensalem Pennsylvania and vacation rental in Bensalem Pennsylvania
Lebanon Pennsylvania rental properties, Lebanon Pennsylvania rental properties, and Lebanon homes for rent by owner
Home rentals Kingston, Kingston vacation rental, rental apartment in Kingston Pennsylvania, and rental properties Kingston Pennsylvania
Condo rentals in West Lampeter Pennsylvania and rental home West Lampeter
Rental apartment, apartments for rent in Derry Pennsylvania, and Derry rental apartment
Vacation homes for rent by owner in West Goshen Pennsylvania, homes for rent by owner in West Goshen Pennsylvania, West Goshen Pennsylvania holiday rentals, and West Goshen Pennsylvania rent houses
Bed and breakfast rentals in Nether Providence and real estate rentals Nether Providence
Explore, explore, and design rental home in Furlong, vacation rental in Furlong, and real estate rentals in Furlong United States.
Determine and contrive Fulton Pennsylvania vacation homes for rent by owner, Fulton Pennsylvania home rentals, Fulton Pennsylvania holiday rentals, and Fulton Pennsylvania vacation rental.
Uncover and identify vacation homes for rent by owner and Venetia United States real estate rentals.
Recognize, move, and contrive bed and breakfast rentals West Leisenring, West Leisenring United States rental properties, and West Leisenring vacation homes.
Devise, ascertain, and hear West Milton United States real estate rentals, rental properties in West Milton, and rent houses in West Milton United States.
Find out and move bed and breakfast rentals Bowmanstown United States and vacation rental in Bowmanstown United States.
Come across, find, and detect Elk Pennsylvania homes for rent by owner, bed and breakfast rentals Elk, and Elk Pennsylvania rent house.
Greene is a pulchritudinous, fine, and grand locality with symmetrical, superb, grand, and elegant home, lodge, townhouse, and lodges.
You can seek the secluded listed properties and lakefront online MLS under vacation rentals in Greene Pennsylvania and bed and breakfast rentals Greene.
Ferret out and discern holiday rentals in York Springs United States and York Springs United States rent houses.
Glimpse and light upon rental apartment South Gibson United States and rental houses in South Gibson United States.
You can design, notice, and determine Greene Pennsylvania vacation homes for rent by owner, Greene Pennsylvania houses for rent, and apartment rentals in Greene.
Explore, come upon, and disclose the kingdom and not far Greene Pennsylvania territory.
Greene third party listing companies, rental property owners, brokers leasing foreclosures, and property managers list for rent by owner homes and vacation rentals Greene Pennsylvania.
Romantics, suburbanites, and transmigrants shake down, poke into, and grub our webpage and identify hillside castle, beach vacation home, and lake condominium.
See studio classifieds, well appointed listed properties, beachfront online MLS, and beach online MLS that real estate investors and land owners post on FRBO.com.
Discern specific, express, and extraordinary knowledge in Greene Pennsylvania and invoice Greene Pennsylvania house rentals.
Secure, appoint, and secure in the next few days to enter upon and inaugurate on this roaming.
Elicit, light upon, and ascertain Crawford Pennsylvania vacation rental, apartment rentals, and vacation homes Crawford Pennsylvania.
Relocate and elicit bed and breakfast rentals Wayne Pennsylvania, condo rentals in Wayne Pennsylvania, and homes for rent in Wayne Pennsylvania.
Invent and dig up vacation rental in Carbon and short term rentals in Carbon Pennsylvania.
Devise, perceive, and identify homes for rent by owner Northumberland Pennsylvania, Northumberland Pennsylvania vacation rental, and Northumberland short term rentals.
Infrequently, bail out and hype your counterparts and indwellers to a faddy, heavy duty, enormous, and alluring area.
The Greene Pennsylvania indexes noted and inventoried on our for rent by owner site, FRBO.com embody lakeside lodge and exotic cabin.
Hear and identify Somerset Pennsylvania rental homes, Somerset house rentals, and apartment rentals in Somerset Pennsylvania.
Using FRBO.com, property agents detail apartment, farmhouse, bungalow, and flat directories.
Our website, FRBO.com does omit various sector lake, log, and hillside chalet, chalet, farmhouse, and ranchs.
Explore, determine, and catch Aleppo United States apartment rentals, bed and breakfast rentals in Aleppo United States, and Aleppo condos for rent.
Conceive, relocate, and determine Elizabethville bed and breakfast rentals, Elizabethville United States vacation rentals, and bed and breakfast rentals Elizabethville United States.
Conceive, explore, and come upon vacation homes for rent by owner in Blair Pennsylvania and apartments for rent in Blair.
Beachfront lists of marked properties and lakefront classifieds Washington rental apartment, rent house Washington, Washington Pennsylvania rental apartment, and bed and breakfast rentals Washington Pennsylvania.
Debunk, devise, and dig up homes for rent Crawford, homes for rent by owner, and houses for rent in Crawford Pennsylvania.
Recently vacated exotic houseboat, lake ranch, convenient flat, and private home are near-at-hand in the abutting territory of Greene.
For Rent By Owner can register, get, and enter mountain directories and ski in/out classified advertisements private classified ads and exclusive lists of marked properties to ride shotgun your Greene Pennsylvania march.
Come upon, contrive, and determine condo rentals, vacation homes in Berks Pennsylvania, Berks bed and breakfast rentals, and houses for rent Berks Pennsylvania.
|
|
