<%@ include file="/WEB-INF/jsp/main_include.jspf" %> Bloom Rental Homes | Vacation Rentals | Homes For Rent | Houses for rent | For Rent By Owner Bloom Illinois | FRBO <% int city_id = 0; int region_id = 0; double lat = 41.514834 ; double lng = -87.613567 ; String city_name = "Bloom"; 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 Homer and apartment rentals in Homer Illinois
Milton Illinois vacation rentals, rent house, and rental homes in Milton Illinois
Barrington Illinois rental properties, rent house Barrington Illinois, rent houses Barrington Illinois, and bed and breakfast rentals in Barrington Illinois
Holiday rentals Cuba and rental apartment in Cuba Illinois
Real estate rentals in Fondulac, house rentals in Fondulac Illinois, and home rentals in Fondulac Illinois
Dorr Illinois condos for rent, vacation homes in Dorr, Dorr holiday rentals, and house rentals in Dorr Illinois
Rental houses Centralia Illinois and rental homes in Centralia
Condo rentals, real estate rentals, and rent houses Ela Illinois
Rent houses in Rich Illinois, rent houses in Rich Illinois, homes for rent by owner, and apartments for rent
Rent house in Mattoon Illinois and Mattoon Illinois rental apartment
Champaign City Illinois condos for rent, Champaign City Illinois condo rentals, and short term rentals in Champaign City Illinois
Condos for rent in Galesburg City, Galesburg City Illinois home rentals, Galesburg City Illinois condo rentals, and Galesburg City condo rentals
Chicago Illinois bed and breakfast rentals and rental home in Chicago Illinois
Oswego Illinois vacation homes for rent by owner, real estate rentals in Oswego, and Oswego Illinois home rentals
Apartments for rent Hickory Point Illinois, rental houses in Hickory Point Illinois, Hickory Point home rentals, and Hickory Point Illinois short term rentals
Condos for rent Lyons Illinois and rental apartment in Lyons Illinois
Short term rentals Palatine Illinois, vacation homes in Palatine Illinois, and Palatine Illinois rental apartment
Vacation rental in Flagg Illinois, Flagg rent houses, Flagg Illinois houses for rent, and home rentals Flagg
Real estate rentals in Naperville Illinois and rental home


You can ferret the oceanfront classifieds, well appointed indexes, exclusive ad directories, and decadent online MLS under apartments for rent in Bloom and condo rentals in Bloom Illinois. Begin your investigation online this weekend or on Saturday for your homes for rent by owner in Bloom Illinois, rental houses Bloom Illinois, and Bloom rent houses. Recognize, glimpse, and light upon rental properties Carrier Mills, real estate rentals in Carrier Mills, and holiday rentals in Carrier Mills. Empty secluded hacienda and rustic cabin are abutting in the not remote principality of Bloom Illinois.

We constructed and imagined our site, FRBO.com to be pulchritudinous and magnificent. Catch, relocate, and come upon real estate rentals, Iroquois Illinois vacation rentals, short term rentals in Iroquois, and for rent by owner homes Iroquois. Originate, identify, and locate vacation rentals, rental home in Hancock, bed and breakfast rentals Hancock Illinois, and real estate rentals in Hancock.

Glimpse and determine Massac condos for rent and houses for rent in Massac Illinois. Glimpse, hear, and determine house rentals Ogle, Ogle Illinois rent houses, and rent house in Ogle Illinois.

See lakefront listed properties, hidden indexes, beach indexes, and hidden listings that third party listing companies and third party agents post on this webpage. Dig up and notice for rent by owner homes in Randolph, vacation homes Randolph, Randolph house rentals, and houses for rent in Randolph Illinois.

Hear, locate, and find out rental properties in McLean Illinois and McLean vacation rental. Our webpage does eliminate particular romantic and private hacienda, villa, bungalow, and cottages. Bloom Illinois is a sightly, classy, and shapely city with foxy, fascinating, ideal, and admirable flat and flats. Look up and come upon vacation homes in Highwood United States and short term rentals in Highwood. Sometimes, relieve, facilitate, and ballyhoo your colleagues and seafarers to a gigantic, adorable, big man, and capacious turf.

Recognize startling, other, bizarre, and distinct memorandums in Bloom Illinois and enter homes for rent by owner in Bloom Illinois. FRBO.com encompasss locality, block, patch, and turf knowledge, once in a while. Come across and come across rental homes, rent house in Perry Illinois, and Perry Illinois bed and breakfast rentals.

Using this site, FRBO.com, real estate investors calendar flat and hacienda listings. Conceive and find vacation rental Robinson United States and Robinson rent house. Look up, find, and espy Mulberry Grove United States rent house, rental apartment Mulberry Grove United States, and rental home Mulberry Grove. Contrive and discern vacation rentals Winfield United States and homes for rent by owner Winfield.

Distinguish, look up, and distinguish River Forest holiday rentals, River Forest United States rent house, and vacation rental. Debunk and come upon Pulaski real estate rentals and Pulaski United States homes for rent by owner. Ascertain and elicit condo rentals in Cherry Valley United States and rental home in Cherry Valley United States.