Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 612 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 612 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 612 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

528 W. 3rd St
Flora, IL 62839
Amy Bailey with AMY LEE REALTY LLC, original listing - (618) 662-3170

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $245,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1700 Square Feet
Agency: AMY LEE REALTY LLC
Agency Phone: (618) 662-3170

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2025
Notes: You won't have to worry about the hassle, stress, and time of building as it has all been done and is ready for you! Welcome to your brand-new home at 528 W 3rd Flora IL 62839, a stunning new construction of 2200+/- sq ft under roof, that offers the perfect combination of style, comfort, and convenience. This three-bedroom, two-bathroom home is the epitome of open-concept living, with a range of modern features and finishes that make it the perfect place to call home. As soon as you enter this home, you'll be greeted by a spacious and inviting living room that's perfect for relaxation and entertainment. The kitchen is a cook's dream, with an abundance stylish cabinets and countertops, and a door leading to the beautiful covered back porch, perfect for enjoying the outdoors and entertaining guests. The kitchen flows seamlessly into the living room and dining area, creating an open and airy space that's perfect for hosting family and friends. The amazing large space of the living, dining, and kitchen will amaze you. The bedrooms are all generously sized and feature spacious walk-in closets, and additional closets in throughtout the home. The guest bathroom boasts a tub shower with stylish finishes and a beautiful vanity and sink that's perfect for pampering. The primary bedroom is a true oasis, with plenty of space for relaxation and rest. It boasts an en-suite bathroom with a tub-shower combo, perfect for soaking in after a long day. The other two bedrooms are also spacious and feature ample closet space, making them perfect for guests or family members. The laundry closet is spacious, making laundry a breeze. The two-car attached garage is conveniently located by the front door, and is finished space, making it convenient to unload groceries and supplies. The exterior of the home is just as impressive, with gorgeous farmhouse details and beautiful lighting that makes it stand out in the neighborhood. The covered front porch, gorgeous front door, and sidewalks offer protection from the elements and add to the overall charm of the home. In summary, this stunning new construction home at 528 W 3rd Flora IL 62839 offers the perfect combination of style, comfort, and convenience. Don't miss out on the opportunity to make this home yours and start living your dream life today!
MlsNumber: --
ListingId: 11501310


Listing Provided By: AMY LEE REALTY LLC, original listing
Phone: (618) 662-3170
Office Phone: (618) 662-3170
Agent Name: Amy Bailey
Disclaimer: Copyright © 2025 My State MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App