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

26206 Prairie
Sedalia, MO 65301
Rhonda Ahern with PREMIER REALTY GROUP, original listing - (660) 851-2222

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,495,000
Beds: 4
Baths: Full: 4, ½: 2
Status: Active
SqFt: 6798 Square Feet
Agency: PREMIER REALTY GROUP
Agency Phone: (660) 851-2222

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: Experience luxury at its finest in this stunning estate, nestled on 5.83 acres of beautifully landscaped grounds just outside of town. A gated entrance and a long driveway lead to this elegant home, offering the perfect blend of privacy and grandeur. This stunning estate boasts an array of captivating spaces and architectural features. The hearth room is an absolute showstopper, featuring charming exposed beams, wall-to-wall windows, and a breathtaking fireplace. This open and airy space flows effortlessly into the kitchen, which is an entertainer’s delight. Step into a kitchen that truly defines custom elegance. Outfitted with bespoke cabinetry, premium finishes, and an abundance of storage, this gourmet kitchen is a chef’s dream. Modern appliances are seamlessly integrated, offering both functionality and style. Adjacent to the kitchen, you'll find a versatile space housing your home office and also the expansive walk-in pantry, offering both convenience and flexibility. Step right outside the kitchen to discover a fantastic covered patio and bar area that includes a cozy fireplace and a bar. The upper level of this stunning home is dedicated to comfort and privacy, housing four spacious bedrooms, each with its own en-suite bath and generous walk-in closet. The crown jewel is the luxurious primary bedroom suite—a true sanctuary designed for relaxation. This expansive suite features a spa-like primary bath, complete with a walk-in shower, dual vanities, a jetted soaking tub, and an extraordinary three-room walk-in closet, offering abundant storage and dressing space. The lower level of the home features a massive family room complete with a full wet bar and a cozy fireplace, making it ideal for gatherings or quiet evenings in. The family room also offers direct access to the back patio. Adjacent to the family room, a versatile rec room serves as a dance studio, gym, or recreational area, adapting to suit your lifestyle needs. Additionally, the lower level includes another half bath, storm shelter, ample storage space and houses all utilities. This extraordinary property is equipped with a state-of-the-art geothermal system and premium surround sound throughout the home, providing an immersive audio experience in every room. Outdoors, it offers unique amenities, including a private baseball field—perfect for practice or friendly games—and a relaxing hot tub for unwinding after a long day. These exceptional features make this estate a true retreat, blending luxury, recreation, and relaxation seamlessly into one remarkable property. Does this sound like your forever home? Call today for more information!
MlsNumber: --
ListingId: 98932


Listing Provided By: PREMIER REALTY GROUP, original listing
Phone: (660) 287-2080
Office Phone: (660) 851-2222
Agent Name: Rhonda Ahern
Disclaimer: Copyright © 2024 West Central Association of REALTORS®. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 1566 AND i.igate IN ('usahud','mohud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mohud', 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;
Rhonda Ahern
ASCIIPremier Realty Group
Call Today!: (660) 287-2080

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App