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 = 1544 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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 = 1544 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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 = 1544 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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;

104 Teal Court
Brookfield, MO 64628
Brooklyn Anderson with United Country Graham Agency, LLC, original listing - (660) 646-7653

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $449,000
Beds: 5
Baths: Full: 3, ½: 1
Status: Active
SqFt: 2961 Square Feet
Agency: United Country Graham Agency, LLC
Agency Phone: (660) 646-7653

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2007
Notes: Welcome to this meticulously crafted 2-story residence nestled in the prestigious Remington Estates of Brookfield, Missouri. Situated on a generous 1.5-acre lot, this home, built in 2007, offers over 3,000 square feet of luxurious living space, blending modern amenities with timeless elegance. With 5 potential bedrooms and 3.5 bathrooms, not including a newly completed in-law suite, this home offers unparalleled versatility for family living or investment opportunities. Step inside and be greeted by gleaming hardwood floors throughout the main level, creating a warm and inviting atmosphere. The spacious living room, featuring a cozy gas log fireplace (added in 2023), serves as the perfect gathering space for friends and family. The well-appointed kitchen boasts stainless steel appliances that stay with the home, bar, and a separate dinging area. The main level also includes a convenient laundry room, and upstairs has been recently carpeted for added comfort. The master suite is a true retreat, complete with a walk-in closet and a luxurious ensuite bathroom, ensuring complete relaxation at the end of the day. Additionally, the storage shelves by the upstairs bathroom are a new feature, providing extra space for organization. With ample room for all your family's needs, this home offers the flexibility of up to 5 bedrooms, including an expansive finished attic and basement, allowing for plenty of space for a home office, playroom, or guest rooms. Step outside onto the beautiful patio, where you can enjoy the peace and privacy of the expansive backyard. A standout feature of this property is the 500 sq ft in-law suite, built in 2023, which offers an open floor plan with 1 bedroom, 1 bathroom, and its own laundry hookups. With its separate electric meter, this suite is a fantastic opportunity for multi-generational living or could even serve as a potential rental property for additional income. This home also features a new hot water heater, freshly painted interiors (2023), and a 3-car attached garage, providing plenty of room for storage and parking. Offered at $449,000, this exceptional property is truly a rare find. Don't miss your opportunity to own a beautifully updated home in one of Brookfield's most desirable neighborhoods. Schedule your private tour today!
MlsNumber: --
ListingId: 11449129


Listing Provided By: United Country Graham Agency, LLC, original listing
Phone: (660) 646-7653
Office Phone: (660) 646-7653
Agent Name: Brooklyn Anderson
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