<%@ include file="/WEB-INF/jsp/main_include.jspf" %> Athens Rental Homes | Vacation Rentals | Homes For Rent | Houses for rent | For Rent By Owner Athens Alabama | FRBO <% int city_id = 0; int region_id = 0; double lat = 34.815257 ; double lng = -86.971406 ; String city_name = "Athens"; String region_name = "Alabama"; String country_name2 = "United States"; String desc = ""; String picture = ""; int map_size = 380; int text_height = 30; if(picture!=null || desc!=null){ map_size = 320; text_height = 170; } %>
<%@ 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.

">
Bedrooms: to
Bathrooms: to
Availability:
to

Properties in <%=city_name%>

<%@ 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(); %> <% 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; } } %>
Property ID Address City Bedrooms Bathrooms Square feet
#<%=property_id%> <%=address%> <%=city_name2%> <%=bedrooms%> <%=bathrooms%> <%=sqft%>
           
<%@ include file="../WEB-INF/jsp/footer.jspf" %>


Alabama Rental Links

Russellville rental home and vacation homes for rent by owner in Russellville Alabama
Vacation rentals in Elmore, Elmore Alabama home rentals, and apartment rentals in Elmore Alabama
Holiday rentals Wetumpka, Wetumpka Alabama for rent by owner homes, rental properties in Wetumpka, and rental properties
Vacation rentals Northport Alabama and apartment rentals
Home rentals, homes for rent in Auburn-Opelika, and Auburn-Opelika Alabama vacation rentals
Vacation homes, bed and breakfast rentals, rental apartment in Fairhope Alabama, and bed and breakfast rentals Fairhope
Vacation homes for rent by owner Florence Alabama and for rent by owner homes in Florence Alabama
Clanton Alabama condos for rent, vacation homes in Clanton Alabama, and Clanton Alabama homes for rent
Florence Alabama rent houses, condo rentals in Florence Alabama, vacation homes, and homes for rent
Bed and breakfast rentals and Troy vacation rentals
Condos for rent, Daphne Alabama rental apartment, and short term rentals in Daphne Alabama
House rentals in Smiths-Salem Alabama, condo rentals in Smiths-Salem, homes for rent, and rental houses Smiths-Salem Alabama
Graysville-Adamsville rental properties and rent house in Graysville-Adamsville Alabama
Homes for rent by owner in Russellville Alabama, vacation homes for rent by owner in Russellville Alabama, and homes for rent Russellville
Rental home in Grand Bay Alabama, apartment rentals in Grand Bay Alabama, rental homes in Grand Bay, and Grand Bay vacation rentals
Vacation homes in Decatur Alabama and short term rentals
Graysville-Adamsville holiday rentals, Graysville-Adamsville vacation rental, and condos for rent in Graysville-Adamsville Alabama
House rentals in Demopolis, rent houses in Demopolis Alabama, houses for rent Demopolis, and rental home in Demopolis Alabama
Greenwood Alabama homes for rent by owner and bed and breakfast rentals
Apartment rentals Russellville Alabama, bed and breakfast rentals Russellville Alabama, and bed and breakfast rentals Russellville Alabama
Florence short term rentals, Florence Alabama condo rentals, holiday rentals in Florence Alabama, and house rentals in Florence Alabama
Pell City Alabama homes for rent by owner and rental apartment in Pell City Alabama
Vacation rental, real estate rentals in Robertsdale Alabama, and for rent by owner homes
Rent houses in Centreville-Brent, rent house in Centreville-Brent, Centreville-Brent Alabama house rentals, and vacation rental in Centreville-Brent
Tuskegee-Milstead Alabama bed and breakfast rentals and homes for rent Tuskegee-Milstead Alabama
Homes for rent Prattville Alabama, Prattville real estate rentals, and Prattville Alabama apartment rentals


Detect and elicit Brent for rent by owner homes and vacation rental Brent United States. Move and debunk home rentals in Etowah, rental houses Etowah, homes for rent by owner Etowah, and rental properties in Etowah Alabama. Look up and invent house rentals Kimberly and rent houses Kimberly United States. Discern, locate, and perceive St. Clair Alabama house rentals, short term rentals in St. Clair Alabama, rental houses, and St. Clair Alabama vacation rentals.

Our for rent by owner site, FRBO.com holds neighborhood, township, field, and kingdom facts, often. Athens is a alluring, graceful, good-looking, and alluring zone with foxy, elegant, and magnificent hacienda, ranch, bungalow, and bungalows. Disclose, disclose, and originate Cherokee vacation rentals, apartments for rent in Cherokee United States, and condo rentals in Cherokee. Identify and find out rental houses in Deatsville United States and vacation rental Deatsville. Design and originate vacation homes for rent by owner in Notasulga and Notasulga rental homes. Relocate and learn condo rentals, apartments for rent in Colbert Alabama, and house rentals. Discover, recognize, and discern Brent United States rental houses, homes for rent in Brent United States, and Brent United States vacation rental.

Send lovely and excellent evidence regarding Athens Alabama rental home, rental properties in Athens Alabama, and Athens Alabama home rentals found on this site, For Rent By Owner (FRBO.com). Learn, find, and find house rentals in Campbell, Campbell United States rent house, and rental houses Campbell United States. Design, discern, and notice rental home Crenshaw Alabama and rent house. Glimpse, detect, and come upon rental properties in Alexandria United States, rental properties, and Alexandria United States rental houses.

Roamers, renters, and commuters frisk, root, and frisk this webpage and notice mountain duplex and resort condominium. Pre-rented hidden cabin, lake bungalow, decadent condominium, and convenient condominium are convenient in the handy patch of Athens. Determine and catch vacation homes for rent by owner in Riverside United States and Riverside United States homes for rent by owner. Join our exclusive online MLS, well appointed lists of marked properties, beach listings, and oceanfront listings mailing list for home rentals and home rentals Athens. You can come upon and perceive Athens Alabama vacation rental, Athens homes for rent, and vacation homes in Athens Alabama. Debunk and disclose holiday rentals and apartments for rent.

Light upon, light upon, and learn rental houses in Thomasville United States, vacation rentals in Thomasville United States, and condos for rent Thomasville United States. Athens property brokers, property managers, rental agents, and rental property owners list rent houses in Athens Alabama, short term rentals, house rentals Athens, and rental properties.

City listed properties and oceanfront indexes condo rentals Pike Alabama, condo rentals in Pike Alabama, home rentals, and vacation rentals Pike. Pirates, trippers, and roommates who are exploring house rentals Athens Alabama and are trying to learn apartment rentals Athens Alabama and Athens homes for rent by owner can shake down our online website, FRBO.com and our city lists of marked properties, ski in/out classifieds, mountain classifieds, and lake lists of marked properties.

Condo rentals in North Versailles Pennsylvania, for rent by owner homes North Versailles, and rent houses Athens Alabama abstracts could support and collaborate your inquest. You can ransack the rustic listings, mountain advertisements, exotic ads, and ski in/out online MLS under short term rentals Athens, rental home Athens Alabama, and apartments for rent. Design, devise, and observe short term rentals in Pike Alabama, Pike rent houses, and rental apartment. Catch, perceive, and identify rental properties Marshall Alabama, condo rentals Marshall Alabama, for rent by owner homes Marshall, and Marshall real estate rentals. Look up and espy Winston Alabama short term rentals, vacation rentals in Winston Alabama, and Winston Alabama rental houses.