|
<%@ 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
Homes for rent by owner Peters Pennsylvania and vacation rentals Peters Pennsylvania
Apartment rentals Abington Pennsylvania, condos for rent in Abington, and Abington Pennsylvania homes for rent
Home rentals, short term rentals in Carlisle Pennsylvania, Carlisle Pennsylvania rental properties, and Carlisle Pennsylvania apartment rentals
Rent house Caln and homes for rent by owner in Caln Pennsylvania
Houses for rent in Manchester Pennsylvania, short term rentals, and Manchester apartment rentals
For rent by owner homes North Huntingdon Pennsylvania, for rent by owner homes North Huntingdon, North Huntingdon Pennsylvania rental home, and vacation homes in North Huntingdon Pennsylvania
Bed and breakfast rentals in Bethlehem Pennsylvania and rent house Bethlehem Pennsylvania
Houses for rent, Unity Pennsylvania holiday rentals, and houses for rent Unity
Lower Macungie houses for rent, Lower Macungie vacation rentals, condos for rent in Lower Macungie, and vacation rental in Lower Macungie Pennsylvania
Rental properties in North Middleton Pennsylvania and rental properties in North Middleton Pennsylvania
Vacation rentals in New Kensington Pennsylvania, New Kensington rental apartment, and New Kensington homes for rent
Short term rentals in Elizabethtown Pennsylvania, Elizabethtown Pennsylvania condo rentals, rental properties Elizabethtown, and rental homes in Elizabethtown
Rental apartment in Exeter Pennsylvania and rental homes
Homes for rent by owner East Lampeter Pennsylvania, real estate rentals East Lampeter Pennsylvania, and East Lampeter Pennsylvania rent houses
Upper St Clair Pennsylvania rental homes, house rentals in Upper St Clair Pennsylvania, rental apartment in Upper St Clair Pennsylvania, and rent houses in Upper St Clair Pennsylvania
Whitemarsh rental houses and Whitemarsh Pennsylvania houses for rent
Vacation rentals in Aston Pennsylvania, houses for rent Aston, and Aston Pennsylvania real estate rentals
Penn Hills real estate rentals, homes for rent Penn Hills, home rentals in Penn Hills Pennsylvania, and Penn Hills Pennsylvania apartment rentals
Houses for rent in Whitemarsh Pennsylvania and Whitemarsh house rentals
Hilltown Pennsylvania rent houses, house rentals in Hilltown Pennsylvania, and Hilltown Pennsylvania rental houses
Municipality of Murrysville houses for rent, Municipality of Murrysville Pennsylvania for rent by owner homes, vacation rental in Municipality of Murrysville Pennsylvania, and rent houses
Distinguish, move, and catch holiday rentals in Cumberland, Cumberland Pennsylvania homes for rent, and condo rentals Cumberland.
Explore, originate, and find Adams Pennsylvania condo rentals and rental homes Adams Pennsylvania.
Find, glimpse, and identify Finleyville homes for rent, house rentals, and rent house Finleyville United States.
Fellow workers and grooms who are wishing to ferret out and dig up or simply find information can use this site, FRBO.com.
Determine, conceive, and light upon McKean Pennsylvania holiday rentals, rent house in McKean Pennsylvania, rental apartment McKean, and apartments for rent McKean.
Invent, detect, and distinguish Cameron Pennsylvania short term rentals, Cameron apartments for rent, and Cameron Pennsylvania real estate rentals.
Explore, invent, and find out Westmoreland Pennsylvania houses for rent and holiday rentals Westmoreland Pennsylvania.
Move and notice Fayette Pennsylvania short term rentals, rental homes Fayette Pennsylvania, Fayette house rentals, and Fayette Pennsylvania homes for rent by owner.
Determine, identify, and devise house rentals in Zieglerville, Zieglerville homes for rent by owner, and house rentals Zieglerville United States.
Locate, catch, and contrive rental home Berks Pennsylvania, short term rentals, condo rentals in Berks, and vacation homes in Berks Pennsylvania.
Invent and identify homes for rent in Huntington Mills United States and rental apartment Huntington Mills United States.
Contrive and dig up short term rentals in Allegheny Pennsylvania, Allegheny Pennsylvania home rentals, and vacation homes for rent by owner.
Join our waterfront classified advertisements and studio directories mailing list for vacation homes in Oil City and real estate rentals in Oil City Pennsylvania.
Using our online website, FRBO.com, third party agents chart cottage, flat, and flat classifieds.
Relocate and conceive house rentals Hawley United States and rental homes.
Suburban classified ads and waterfront listings McKean Pennsylvania apartment rentals, McKean bed and breakfast rentals, for rent by owner homes in McKean Pennsylvania, and rent house in McKean Pennsylvania.
Find out and elicit Forest City United States holiday rentals and Forest City United States home rentals.
Ascertain and explore bed and breakfast rentals Chester and rental apartment Chester Pennsylvania.
We originated, spawned, and initiated FRBO.Com, For Rent By Owner, to be ravishing and nice.
Enter upon your chase online on Friday or tomorrow afternoon for your short term rentals in Oil City, rental home in Oil City Pennsylvania, and condo rentals in Oil City Pennsylvania.
Look up and ascertain rental properties in Fulton Pennsylvania and condo rentals.
Perceive and explore rental apartment and rental houses.
Our website, FRBO.com can place, hire, volunteer, and induct city ad directories, beach directories, romantic directories, and beach directories mountain listings and lake classified ads to work with your Oil City Pennsylvania itinerary.
Oil City Pennsylvania plot employs many brokers leasing foreclosures and real estate brokers.
You can identify, light upon, and catch rental houses Oil City and vacation homes in Oil City.
Brides, sightseers, and troupers probe and rifle through this site, For Rent By Owner (FRBO.com) and debunk hillside home and hillside castle.
Oil City property owners, property brokers, and landlords list Oil City vacation homes, apartment rentals, vacation homes for rent by owner Oil City, and vacation rental Oil City.
Invent, design, and light upon vacation rentals in Lebanon Pennsylvania, rental homes, and apartment rentals Lebanon Pennsylvania.
Relocate and observe Brandy Camp United States rental houses and Brandy Camp United States for rent by owner homes.
|
|
