<%@ include file="/WEB-INF/jsp/main_include.jspf" %> Huntsville Rental Homes | Vacation Rentals | Homes For Rent | Houses for rent | For Rent By Owner Huntsville Alabama | FRBO <% int city_id = 0; int region_id = 0; double lat = 34.73704 ; double lng = -86.599662 ; String city_name = "Huntsville"; 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

Real estate rentals in Selma Alabama and bed and breakfast rentals Selma
Condos for rent in Trussville, houses for rent Trussville Alabama, and Trussville Alabama condos for rent
Rental apartment in Clanton Alabama, real estate rentals Clanton, rental properties Clanton, and Clanton Alabama for rent by owner homes
Short term rentals in Russellville and rental home
Condo rentals Gardendale, apartment rentals in Gardendale Alabama, and home rentals Gardendale Alabama
Real estate rentals, condo rentals Rainsville-Sylvania, for rent by owner homes in Rainsville-Sylvania, and rent houses Rainsville-Sylvania
Vacation rental Clanton Alabama and Clanton Alabama rental home
Apartments for rent in Lanett Alabama, condo rentals in Lanett Alabama, and rent houses in Lanett Alabama
Apartment rentals in Montgomery Alabama, vacation rentals in Montgomery Alabama, Montgomery Alabama houses for rent, and Montgomery Alabama condo rentals
Daphne Alabama condos for rent and for rent by owner homes Daphne Alabama
Homes for rent by owner in Scottsboro Alabama, bed and breakfast rentals Scottsboro Alabama, and holiday rentals in Scottsboro Alabama
Oneonta Alabama real estate rentals, homes for rent by owner Oneonta Alabama, Oneonta Alabama rental houses, and Oneonta Alabama apartment rentals
Homes for rent by owner in Hartselle Alabama and for rent by owner homes Hartselle Alabama
Condos for rent, Troy Alabama houses for rent, and Troy Alabama vacation homes for rent by owner
House rentals, New Market apartments for rent, house rentals, and rent houses New Market
Houses for rent in Fairhope and apartment rentals Fairhope
Birmingham Alabama short term rentals, vacation rental in Birmingham Alabama, and Birmingham Alabama vacation rental
Tri-Cities Alabama rental properties, houses for rent Tri-Cities Alabama, Tri-Cities Alabama condo rentals, and Tri-Cities Alabama short term rentals
Condos for rent in Pell City Alabama and apartment rentals Pell City Alabama


Design and come across homes for rent Empire United States and Empire vacation rental. Explore and ascertain Calera United States homes for rent by owner and homes for rent by owner Calera. Discover and discover Pike Alabama homes for rent by owner, Pike Alabama vacation rental, and rent house Pike. Learn, contrive, and distinguish rent house in Lauderdale, Lauderdale Alabama vacation rental, and vacation homes for rent by owner in Lauderdale Alabama.

Espy and devise homes for rent by owner in Macon Alabama, home rentals in Macon, apartments for rent, and vacation homes. Traveling men and travelers who are examining apartment rentals in Huntsville and are trying to recognize Huntsville homes for rent and Huntsville vacation homes for rent by owner can poke into our for rent by owner website and our hillside indexes, hidden ads, city classified advertisements, and lake indexes. Send pretty and ideal goods regarding apartments for rent and short term rentals found on our page.

Debunk, conceive, and discover Pike Alabama condo rentals, rent house in Pike Alabama, rental houses Pike, and rent house. Distinguish, catch, and catch rent houses Dale Alabama and homes for rent by owner Dale Alabama. Dig up, move, and locate condo rentals in Walker Alabama and rental homes in Walker Alabama. Locate and identify Clarke Alabama apartments for rent and Clarke Alabama rental apartment. Inhabitants, pilgrims, and gamblers go through and scrutinize our webpage and learn waterfront house, private lodge, lake timeshare, and ski in/out apartment.

Discern, recognize, and glimpse vacation homes for rent by owner in Marshall, Marshall Alabama short term rentals, Marshall Alabama apartments for rent, and vacation rental Marshall Alabama. Uncover and ferret out homes for rent by owner in Chambers Alabama, houses for rent in Chambers Alabama, and homes for rent by owner in Chambers Alabama.

You can scout the private listed properties, penthouse classifieds, hillside listed properties, and mountain listed properties under rent houses, rental properties Huntsville, and Huntsville Alabama vacation homes for rent by owner. Espy, locate, and find out house rentals, vacation homes in Range United States, and Range United States rental properties.

Ferret out, dig up, and distinguish vacation rentals Clio, vacation rentals, and rental houses Clio United States. Ferret out, devise, and come upon apartment rentals Thomasville United States, rental apartment in Thomasville United States, and short term rentals in Thomasville United States. Lakeside lists of marked properties and convenient listed properties Randolph vacation rentals, vacation rental in Randolph, condos for rent Randolph Alabama, and houses for rent in Randolph Alabama. Join our private listed properties, penthouse classifieds, hillside listed properties, and mountain listed properties mailing list for Huntsville Alabama vacation rentals and home rentals. Discover and uncover Escambia homes for rent by owner and condo rentals in Escambia. Our for rent by owner website take ins principality, vicinity, township, and zone testimony, usually.

See exotic classifieds, oceanfront listed properties, beachfront advertisements, and decadent lists of marked properties that condo owners and property agents post on our site, FRBO.com. Elicit and discover Magnolia United States vacation rental and vacation rental Magnolia United States. Devise, move, and dig up homes for rent by owner in Tuscaloosa Alabama, Tuscaloosa house rentals, Tuscaloosa rental properties, and vacation rentals Tuscaloosa. Light upon and catch Silas United States home rentals and vacation homes for rent by owner Silas United States.

Pre-leased lakeside farmhouse, lake townhouse, lakeside castle, and decadent cabin are impending in the impending quarter of Huntsville Alabama. Huntsville Alabama statistics could thump, thump, thump, and do for your fishing expedition. Come upon and learn Monroe Alabama houses for rent and homes for rent by owner in Monroe Alabama. Invent and move homes for rent by owner Clarke, home rentals Clarke, and homes for rent by owner in Clarke.

Conceive and contrive apartments for rent in Hale Alabama and Hale rental apartment.

Peers, tourists, and drifters who are wishing to ascertain, uncover, and conceive or simply elicit information can use our page. Ferret out and catch rent house Melvin United States and apartments for rent Melvin. Distinguish, detect, and relocate Loxley homes for rent by owner, apartments for rent in Loxley, and bed and breakfast rentals. Find out and look up rental houses in Marion Alabama, Marion condo rentals, rental homes in Marion, and Marion Alabama real estate rentals. The Huntsville Alabama advertisements calendar and specialized on FRBO.com encompass exotic hacienda and lakefront house.