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 = 1511 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 = 1511 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 = 1511 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;

2962 Nw Prairie View Road
Gower, MO 64454
Brandi Perkins with Berkshire Hathaway HomeService, original listing - (816) 632-2459

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $999,000
Beds: 5
Baths: Full: 3
Status: Active
SqFt: 3900 Square Feet
Agency: Berkshire Hathaway HomeService
Agency Phone: (816) 632-2459

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 25 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Welcome to a unique luxury estate on 25 pristine acres, featuring an early 1900's home exuding timeless elegance and charm. This meticulously maintained property offers a blend of historic significance and modern luxury, making it an ideal retreat for those seeking a sophisticated and tranquil lifestyle. Step inside and be transported to a bygone era. The home showcases original woodwork, hardwood floors, and period-specific architectural elements, including light fixtures and hardware. High ceilings, spacious rooms, and abundant natural light create an inviting atmosphere throughout. The eat-in kitchen features updated appliances, custom cabinetry, and ample counter space. The formal dining room, with its pocket doors and antique chandelier, is perfect for gatherings. Relax in the expansive living room by the fireplace. The estate boasts five bedrooms and 3 bathrooms, each uniquely designed with historic charm and modern comforts. The primary suite offers a luxurious retreat with an en-suite bathroom, featuring a double vanity and walk-in shower. Additional bedrooms provide ample space for family and guests, while vintage-inspired bathrooms are functional and aesthetically pleasing. For equestrian enthusiasts, the property includes a beautifully maintained barn with horse stalls on the lower level, ample space for horse care and storage, and rolling pastures offering endless opportunities for riding and exploring.<br /> Adding to the estate's historical significance is an original schoolhouse, preserved as a nod to the county's rich history. This charming building can serve as a guesthouse, studio, or private retreat. The estate's 25 acres are a picturesque blend of manicured lawns, mature trees, and open fields. Situated in a serene, private setting, this luxury estate offers a peaceful retreat within a 40-minute drive to Kansas City and the airport. This extraordinary estate is a rare find, offering a unique combination of historical significance and luxury living.
MlsNumber: --
ListingId: 2494471


Listing Provided By: Berkshire Hathaway HomeService, original listing
Phone: (816) 724-0166
Office Phone: (816) 632-2459
Agent Name: Brandi Perkins
Disclaimer: Copyright © 2024 Heartland Multiple Listing Service. 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