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

23298 State Highway Ff Highway
Hamilton, MO 64644

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $495,000
Beds: 3
Baths: 3
Status: Active
SqFt: 3292
Agency: Debbie Hahn Real Estate Inc dba Prudential Snook,

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 20 acre(s)
Property Type: Residential
Year Built: 2003
Notes: HERE IT IS! Daviess County, Missouri, a sprawling 20-acre m/l property, with black-top frontage. A charming, 3-bedroom 3-bath, ranch-style home with a detached 4-car garage, and various auxiliary buildings. The focal point of this idyllic homestead is the spacious ranch-style home with a finished basement. A brand NEW ROOF has just been completed on the house. The open-concept living area and large windows flood the space with natural light. A stone fireplace serves as the focal point, providing both warmth and ambiance during chilly evenings. The kitchen is equipped with high-end appliances, custom cabinetry, and oyster shell backsplash that reflects the surrounding room colors. An adjacent dining area provides the perfect setting for intimate gatherings and family meals. The master suite offers a peaceful retreat, complete with en-suite bathroom and ample closet space. Two additional bedrooms and a full bathroom accommodate family and guests. Adjacent to the main residence stands a detached 4-car garage. The spacious shop area provides ample room for woodworking, automotive projects, or any other creative pursuits. A dedicated office space offers a quiet environment for remote work or personal projects. Embracing sustainable living practices, both the main residence and the detached garage are outfitted with solar panels. This eco-friendly feature not only reduces utility costs but also minimizes the property's carbon footprint. One of the property's unique features is a recently built off-grid cabin, overlooking a tranquil pond and offering seclusion, reflection and relaxation. This charming retreat presents an exciting income opportunity, whether utilized as a vacation rental or private getaway for nature enthusiasts. With a rustic design, the cabin appeals to those seeking an authentic rural experience. This picturesque property provides a sanctuary for those seeking a simpler, more connected way of life amidst the beauty of the Missouri countryside.
MlsNumber: 2479950


Listing Provided By: Debbie Hahn Real Estate Inc dba Prudential Snook,, original listing
Name: Debbie Hahn Real Estate Inc dba Prudential Snook,
Phone: (816) 632-2459 xx32
Office Name: Berkshire Hathaway HomeService
Office Phone: (816) 632-2459
Agent Name: Larry Allen
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