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

3 Redbird Drive
Agency, MO 64401
Patty Farr with RE/MAX House of Dreams, original listing - (816) 858-9009

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $875,000
Beds: 5
Baths: Full: 3
Status: Active
SqFt: 2520 Square Feet
Agency: RE/MAX House of Dreams
Agency Phone: (816) 858-9009

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 29 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1995
Notes: Stunning 5-Bedroom Home on 29 Acres OWN 2 PRIVATE LAKES W 3 DOCKS & PIER!! A dream come true. Escape to your own private oasis!This beautifully remodeled five-bedroom home sprawls across 29 acres (+/-) & boasts incredible features that redefine luxury living.The interior has been thoughtfully redesigned w an open floor plan, including a newly remodeled kitchen that features custom cabinets, quartzite countertops, & brand-new appliances.Enjoy the new 4-season sunroom that floods the home w natural light, perfect for enjoying your surroundings year-round.The great room & hall feature new stained hardwood floors, inviting warmth & elegance throughout.Three full baths available.The home also boasts new carpeting, lighting, & outlets in every room, ensuring a modern feel throughout.Gather around the new fireplace, features windows on either side for optimum views of the lake & nature.The larger dining room window, taken from Andersen, enhances the space beautifully.There are three porches, sunroom, & gazebo over looking the 2nd lake. You can see the Sunset & Sunrises. This amazing property has Hunter Douglas remote shades!The property is complemented by breathtaking landscaping, including a stunning patio area that’s perfect for morning coffee or entertaining guests.A 20x20 dock extends into a picturesque 10-acre lake, providing a tranquil retreat right in your backyard.Additional storage and workspace can be found in the shed, complete with a newly added garage featuring concrete flooring, a new garage door, and upgraded water lines and electricity.A newly added hydrant near the shed and 200-amp service make the property functional for various uses.<br /> This home is a true gem, combining modern updates with serene outdoor living. Each room has been carefully remodeled, making it a perfect family home or a serene retreat.Don’t miss out on this exceptional property with breathtaking views and endless opportunities for entertainment!
MlsNumber: --
ListingId: 2532717


Listing Provided By: RE/MAX House of Dreams, original listing
Phone: (816) 405-7712
Office Phone: (816) 858-9009
Agent Name: Patty Farr
Disclaimer: Copyright © 2025 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.


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 = 1497 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;
Real Estate Expert Photo for Cindy Hymes
Cindy Hymes
ASCIIThe St. Joseph Real Estate Group
Call Today!: (816) 244-8343

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App