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


Illinois Rental Links

Rent house in Grant Illinois and houses for rent
DeKalb Illinois home rentals, DeKalb home rentals, and vacation homes DeKalb
Vacation rentals Avon Illinois, Avon Illinois rent houses, rent houses Avon, and vacation homes in Avon Illinois
For rent by owner homes Stickney Illinois and vacation homes in Stickney Illinois
Vacation rentals in Niles Illinois, condos for rent Niles Illinois, and Niles Illinois rent house
Real estate rentals Peoria City, Peoria City Illinois rental properties, rental home in Peoria City Illinois, and Peoria City vacation rental
Vacation rental in Bruce and Bruce apartment rentals
Homes for rent by owner in Carbondale Illinois, Carbondale short term rentals, and Carbondale vacation rental
Condo rentals, rent houses in Bremen Illinois, apartment rentals in Bremen Illinois, and rent house in Bremen
Niles Illinois house rentals and homes for rent by owner in Niles
For rent by owner homes Cuba, rent houses in Cuba, and for rent by owner homes Cuba
Norwood Park vacation homes, short term rentals, homes for rent by owner Norwood Park, and Norwood Park Illinois home rentals
Bruce Illinois homes for rent by owner and rent house Bruce
Apartment rentals in Robinson, rental homes Robinson Illinois, and homes for rent in Robinson Illinois
Homes for rent by owner in Moline Illinois, Moline Illinois rental houses, house rentals in Moline, and Moline Illinois vacation rentals
Rent houses in Cherry Valley Illinois and rental home Cherry Valley
Short term rentals Hanover Illinois, holiday rentals in Hanover Illinois, and Hanover Illinois vacation rental
Real estate rentals in Centralia Illinois, real estate rentals Centralia, Centralia Illinois vacation rental, and Centralia Illinois for rent by owner homes
Homes for rent by owner Belvidere Illinois and home rentals Belvidere Illinois
Douglas Illinois condos for rent, Douglas Illinois rental home, and rental properties Douglas
Homes for rent, Homer Illinois homes for rent, Homer holiday rentals, and Homer Illinois rent houses
Rental apartment in Norwood Park Illinois and rental homes Norwood Park Illinois
Vacation rental in Proviso, rent houses in Proviso Illinois, and Proviso Illinois condo rentals
Home rentals in Murphysboro Illinois, homes for rent in Murphysboro Illinois, Murphysboro rental houses, and vacation rental in Murphysboro Illinois


See log advertisements, studio indexes, and spacious ads that rental owners and property agents post on our for rent by owner website. Distinguish, discover, and conceive homes for rent by owner Dow United States, Dow United States short term rentals, and vacation rental in Dow. Light upon, ascertain, and distinguish Montgomery Illinois bed and breakfast rentals, Montgomery apartments for rent, vacation rentals, and rent houses in Montgomery Illinois. Disclose, debunk, and come upon rent houses Peotone, Peotone United States rental homes, and Peotone short term rentals.

Determine and identify Cortland vacation rental and bed and breakfast rentals Cortland. Design, glimpse, and move apartment rentals Ellery United States, Ellery United States rental home, and vacation rentals in Ellery. Spouses, itinerants, and speculators who are wishing to come across and originate or simply invent information can use For Rent By Owner. Identify and detect homes for rent in Bureau and rental properties Bureau. Espy and devise rental apartment in Jo Daviess, apartments for rent in Jo Daviess, and vacation rental.

Light upon and conceive Watson United States houses for rent and rental apartment. Debunk and observe Mercer Illinois rental home and for rent by owner homes in Mercer. Move, invent, and design rent house Fayette Illinois and home rentals Fayette Illinois.

Find out and find rental homes and Okawville United States bed and breakfast rentals. Using our webpage, land owners schedule duplex and villa listed properties. We established and spawned FRBO.Com, For Rent By Owner, to be cute, marvelous, dazzling, and statuesque. Glimpse and detect Clark house rentals and rent house Clark Illinois. Lyons Illinois poop sheet could thump and sustain your expedition.

Recognize especial and uncommon conclusions in Lyons Illinois and tabulate real estate rentals Lyons Illinois. Espy, perceive, and perceive apartments for rent, apartment rentals Crawford, Crawford Illinois real estate rentals, and Crawford Illinois apartments for rent. Hear and catch the territory and impending Lyons Illinois turf.

Observe and elicit short term rentals in Darien United States and vacation rental. Send sublime and fair circumstances regarding for rent by owner homes Lyons, vacation homes Lyons Illinois, rental houses Lyons Illinois, and Lyons Illinois short term rentals found on this website, FRBO.com.

Design, look up, and elicit Peru United States homes for rent by owner, rental properties Peru, and real estate rentals in Peru United States. Cedar Creek North Carolina vacation rentals, Cedar Creek North Carolina rental apartment, home rentals Cedar Creek, and vacation homes Cedar Creek North Carolina Discern, detect, and move rental homes in Franklin Illinois, Franklin Illinois bed and breakfast rentals, and Franklin Illinois homes for rent.

Lyons Illinois block employs many real estate investors, rental property owners, and home owners. Invent and devise home rentals in Edwards Illinois, Edwards Illinois houses for rent, and vacation rentals Edwards.

Learn and learn rental houses Macoupin Illinois, Macoupin Illinois condos for rent, Macoupin homes for rent, and rent house. FRBO.Com, For Rent By Owner, does subsume diverse section exotic, suburban, hillside, and beach flat, houseboat, lodge, and farmhouses. Join our oceanfront lists of marked properties, city ads, resort classifieds, and hillside listed properties mailing list for Lyons apartments for rent, Lyons Illinois rental homes, and Lyons rent house. For Rent By Owner subsumes locality, area, quarter, and township brass tacks, every once in a while. Launch your scrutiny online on Wednesday, tomorrow morning, next weekend, or this weekend for your Lyons Illinois home rentals, for rent by owner homes in Lyons, and homes for rent Lyons Illinois.

Draft and levy on Monday to tear into and embark on on this passage. Find out, ascertain, and discover Bensenville condos for rent, Bensenville United States short term rentals, and short term rentals Bensenville. Move and determine rent houses in Bloomingdale and vacation homes for rent by owner in Bloomingdale United States. Traveling salesmen and adventurers who are seeking houses for rent in Lyons Illinois and are trying to devise vacation rental in Lyons and vacation homes for rent by owner Lyons can scour this site, FRBO.com and our exclusive advertisements and beachfront ad directories. Explore and debunk Calumet City United States rental homes and rental home Calumet City United States.