$699,900

24891 Trails End Urbana, MO 65767

Estimated payment $3,867/month

Total Views 670
5 Beds
3 Baths
3,264 Sq Ft
$214 Price per Sq Ft

Highlights

  • Electric Gate
  • Panoramic View
  • No HOA
  • Skyline Elementary School Rated A
  • Ranch Style House
  • Covered Patio or Porch

About This Home

Welcome to this stunning property in Hickory County, offering over 3,200 square feet of living space on 12 beautiful acres just 15 minutes from Lake Pomme de Terre. The home features 5 bedrooms, 3 bathrooms, with the 5th bedroom being non-conforming. This room could serve as an office as well. Inside, you'll find a spacious kitchen with gorgeous cabinetry, a nice-sized pantry, and a large island. The kitchen overlooks the dining room and living room with a beautiful floor to ceiling stone fireplace. The extra-large primary suite includes a sitting area, walk-in closet, and a beautiful primary bath with jetted tub. You will find outside the primary suite the utility room. It offers a sink, cabinetry and exterior door to the back deck.
The finished basement expands your living space with a second family room, a second dining or gaming area with two bedrooms and a bathroom. Step outside to a full-length back deck, perfect for entertaining or enjoying peaceful country views.
Adding even more appeal, the property includes a 40x60 shop with 20x40 guest living quarters. The guest space is stunning, with stained and sealed concrete floors, interior wood finishes, a bedroom with closet, and a beautifully tiled shower. The shop also provides a half bath and plenty of open storage for your boat, RV, or camping gear.
This property truly offers the best of country living with room to grow, entertain, and relax — all in a prime location near the lake.

Listing Agent

Andrea Rogers

Rogers & Associates Realty, LLC License #2016028951 Listed on: 10/07/2025

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $2,000

Year Built

  • Built in 2013

Lot Details

  • 12 Acre Lot
  • Property fronts a private road
  • Partially Fenced Property
  • Barbed Wire
  • Cleared Lot
  • Few Trees

Home Design

  • Ranch Style House
  • Concrete Foundation
  • Wood Siding

Interior Spaces

  • 3,264 Sq Ft Home
  • Ceiling Fan
  • Drapes & Rods
  • Living Room with Fireplace
  • Panoramic Views
  • Washer and Dryer Hookup

Kitchen

  • Electric Cooktop
  • Microwave

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Walk-In Closet
  • In-Law or Guest Suite
  • 3 Full Bathrooms
  • Walk-in Shower

Partially Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Basement Storage

Parking

  • 2 Car Attached Garage
  • Parking Pad
  • Parking Available
  • Garage Door Opener
  • Gravel Driveway
  • Electric Gate

Outdoor Features

  • Covered Patio or Porch

Schools

  • Skyline Elementary School
  • Skyline High School

Utilities

  • Central Heating and Cooling System
  • Private Company Owned Well
  • Septic Tank

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Tax Lot 22
  • Assessor Parcel Number 095022000000009000

Home Details

Home Type

Single Family

Est. Annual Taxes

$2,000

Year Built

Built in 2013

Lot Details

0

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Shop Building Features Shop Building: Yes
  • Lot Size Acres: 12.0
  • Road Frontage Type: Private Road
  • Road Surface Type: Street - Gravel/Stone
  • Water Body Name: None
  • Subdivision Name: N/A
  • Above Grade Finished Sq Ft: 2176.0
  • Architectural Style: 1 Story, Ranch
  • Garage Yn: Yes
  • Living Area: 3264.0
  • New Construction: No
  • Year Built: 2013
  • Appliances Microwave: Yes
  • Appliances Refrigerators: Yes
  • Architecture 1 Story: Yes
  • Special Features: None

Interior Features

  • Appliances: Cooktop-Electric, Microwave, Refrigerator
  • Fireplace Features: Living Room
  • Fireplace Features Fireplace: Yes
  • Interior Amenities: Walk-In Closet(s), W/D Hookup, Walk-In Shower
  • Basement: Plumbed, Concrete, Storage Space, Partially Finished, Walk-Out Access, Full
  • Window Features: Drapes
  • Full Bathrooms: 3
  • Total Bedrooms: 5
  • Below Grade Sq Ft: 1088.0
  • Fireplace Features:Living Room: Yes
  • Interior Features:WD Hookup: Yes
  • Interior Features:Walk-In Closet(s): Yes
  • Interior Features:Walk-In Shower: Yes
  • Other Rooms:Bedroom-Master (Main Floor): Yes
  • Basement:Full2: Yes
  • Basement Type:Partially Finished3: Yes
  • Basement Type:Concrete5: Yes
  • Basement Type:Plumbed3: Yes
  • Basement Type:Walk-Out Access: Yes
  • Appliances:Cooktop-Electric: Yes
  • Basement Type:Storage Space: Yes
  • Other Rooms:In-law Quarters: Yes
  • Shop Building Features:Plumbed: Yes

Exterior Features

  • Construction Materials: Wood Siding
  • Fencing: Barbed: 5 Wire, Partial
  • Patio And Porch Features: Covered, Rear Porch, Front Porch
  • View: Panoramic
  • Waterfront: No
  • General Property Description:WaterfrontView: None
  • Construction Materials:Wood Siding: Yes
  • Patio and Porch Features:Covered2: Yes
  • View:Panoramic: Yes
  • Patio and Porch Features:Front Porch: Yes
  • Patio and Porch Features:Rear Porch: Yes
  • Lot Features:Acreage: Yes
  • Lot Features:Cleared: Yes
  • Lot Features:Trees: Yes
  • Window Features:Drapes: Yes

Garage/Parking

  • Parking Features: Parking Spaces, Parking Pad, Gravel, Gated, Garage Door Opener, Electric Gate
  • Total Parking Spaces: 2.0
  • General Property Description:_pound_ Attached Garage Spaces: 2.0
  • Parking Features:Garage Door Opener: Yes
  • Parking Features:Parking Spaces: Yes
  • Parking Features:Gravel: Yes
  • Parking Features:Parking Pad: Yes
  • Parking Features:Electric Gate: Yes
  • Parking Features:Gated: Yes

Utilities

  • Cooling: Central, Ceiling Fans
  • Heating: Central
  • Sewer: Septic Tank
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Water Source: Well - Private
  • Heating:Central2: Yes
  • Sewer Septic Tank: Yes
  • Heating Source:Electric2: Yes

Condo/Co-op/Association

  • Association: No

Association/Amenities

  • Home Association Info:Home OwnersCondo Owners Association: None

Schools

  • Middle Or Junior School: Skyline

Lot Info

  • Lot Features: Cleared, Acreage, Trees
  • Lot Size Sq Ft: 522720.0
  • Parcel #: 095022000000009000

Tax Info

  • Tax Year: 2024
  • Tax Annual Amount: 2000.0
  • Tax Tract: 22

MLS Schools

  • Elementary School: Skyline
  • High School: Skyline

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $493 $12,010 $0 $0
2023 $488 $11,000 $0 $0
2022 $451 $11,000 $0 $0
2021 $452 $10,090 $0 $0
2020 $451 $10,090 $0 $0
2019 $452 $10,090 $0 $0
2018 $402 $10,090 $0 $0
2017 $402 $10,090 $0 $0
2016 $343 $9,580 $0 $0
2015 -- $8,610 $0 $0
2014 -- $8,610 $0 $0
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
10/07/2025 10/07/25 For Sale $699,900 +1174.9% $214 / Sq Ft
09/24/2021 09/24/21 Sold -- -- -- View Prior Sale
08/12/2021 08/12/21 Pending -- -- --
08/09/2021 08/09/21 For Sale $54,900 -83.1% $17 / Sq Ft
03/01/2021 03/01/21 Sold -- -- -- View Prior Sale
10/20/2020 10/20/20 Pending -- -- --
04/18/2020 04/18/20 For Sale $325,000 +3086.6% $100 / Sq Ft
12/02/2016 12/02/16 Sold -- -- -- View Prior Sale
11/16/2016 11/16/16 Pending -- -- --
08/29/2016 08/29/16 For Sale $10,199 -- $3 / Sq Ft
Source: Southern Missouri Regional MLS

Purchase History

Date Type Sale Price Title Company
Trustee Deed $17,135 None Available
Interfamily Deed Transfer -- None Available
Source: Public Records

Source: Southern Missouri Regional MLS

MLS Number: 60306576

Southern Missouri Regional MLS

APN: 09-5.0-22-000-000-009000