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

10115 S 1625 Road
Stockton, MO 65785
Ashley Burres with Billy Bruce Realty, original listing - (417) 326-2106

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $499,900
Beds: 3
Baths: Full: 2, ½: 2
Status: Active
SqFt: 2873 Square Feet
Agency: Billy Bruce Realty
Agency Phone: (417) 326-2106

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1979
Notes: Tucked away on 5+ peaceful acres just north of Stockton, this stunning, newly renovated, salt box style home offers modern amenities, thoughtful design, and plenty of space--inside and out. Inside, the kitchen is both spacious and functional, featuring brand-new LG ThinQ stainless steel appliances, including a three-door refrigerator, gas range with built-in air fryer, microwave, and dishwasher. A large granite island with a sink anchors the open-concept kitchen, living, and dining areas, making it perfect for entertaining. The main floor also includes a primary suite with a spa-like bath, featuring a walk-in shower, lighted mirror, walk-in closet, built-in Wi-Fi audio system, and granite countertops. A full hall bath is also located on the main floor, along with a large laundry room.Upstairs, you'll find two spacious bedrooms, each with large closets, plus a half bath and a cozy loft area perfect for reading or relaxing. The home also features a finished walkout basement with a safe room, half bath, mechanical room (with a new HVAC system, water heater, water softener, and whole-house filtration system), and a second living area that could easily serve as a fourth bedroom or office.An enclosed sunroom connects the home to the oversized two-car attached garage, which includes a floored attic for extra storage. Outside, the oversized deck provides the perfect place to enjoy beautiful sunrises, breathtaking sunsets, and daily visits from local wildlife. Across the large, tree-lined front yard, you'll find a 40x40 shop building with concrete floor, 220 power, and a new overhead door. Property also features a circle driveway and a charming, matching treehouse.With new siding, windows, insulation, and sheetrock, this home was completely renovated from top to bottom in 2022--offering the feel of new construction with the peace and privacy of country living, all just off blacktop and minutes from the crystal clear waters of Stockton Lake.
MlsNumber: --
ListingId: 60287803


Listing Provided By: Billy Bruce Realty, original listing
Phone: (417) 955-5496
Office Phone: (417) 326-2106
Agent Name: Ashley Burres
Disclaimer: Copyright © 2025 Southern Missouri Regional MLS, LLC (SOMO). 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