Title Page Background
DEBUG FN args: Array ( [0] => 1601 [1] => [2] => [3] => agent ) BEFORE: Site: 1601 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1601 Igate: njhud LocID: 1601 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1601 AND i.igate IN ('mohud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mohud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1601 [1] => [2] => [3] => lender ) BEFORE: Site: 1601 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1601 Igate: njhud LocID: 1601 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1601 AND i.igate IN ('mohud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mohud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1601 [1] => [2] => [3] => other ) BEFORE: Site: 1601 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1601 Igate: njhud LocID: 1601 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1601 AND i.igate IN ('mohud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mohud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

835 West Commercial Street
Mansfield, MO 65704

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $550,000
Beds: 5
Baths:
Status: Active
SqFt: 3844 Square Feet
Agency: Keller Williams

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Microwave
Architectural Style: Other
Construction Materials: Metal Siding
Cooling: Ceiling Fan(s)
Flooring: Carpet, Tile, Wood, Engineered Wood, Hardwood, Laminate
Heating: Forced Air, Fireplace
Interior Features: Walk-in Closet(s), Walk-in Shower, Laminate Counters, Smoke Detector(s), Quartz Counters, W/D Hookup, Internet - Cable
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5

Window Features

Exterior Features: Rain Gutters
Parking Features: Garage, Paved or Surfaced, Driveway
Roof: Composition

Neighborhood/Schools

Elementary School/District: Mansfield
Middle/Junior High School/District:
High School/District: Mansfield
Subvidision Name: N/A

Description/Comments


Lot Size: 7 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1979
Notes: Wonderful 3 bed/2.5 bath home on 7.7 acres with a 2bed/1bath guest house! This property has been completely remodeled and offers a circle asphalt driveway, large beautiful trees, 2 stone fireplaces, a 50x100' barn, and so much more! Inside, you will love the open floor plan living room and kitchen. The kitchen offers Quartz counters, stainless appliances, and custom Walnut cabinets w/soft close drawers/doors. Primary bedroom suite features exterior access to the covered porch, a dual sink vanity, walk-in closet, and walk-in titled shower! 2 more bedrooms w/walk-in closets share a full hall bathroom. You will love the convenience of a large laundry room with extra cabinet and counter space. Completing the main house is a 2nd living area with stone fireplace, wet bar, powder room, and mud room with a wall of storage cabinets. Entertaining will be incredible on the large back porch w/built-in charcoal grill and gravel entertaining area. Down a separate gravel driveway is a guest house with 2 beds/1bath and an attached garage space. It has an open floor plan full kitchen + living area and would make a perfect in-law quarters or rental income opportunity! Also on the property is a large metal sided barn, and two sheds. Other features include: a new well pump, newer water heater, furnace/AC, roof, insulated siding, windows, doors, and a backyard retaining wall. located only 30 second to Hwy 60. Call to schedule a tour today!
MlsNumber: --


Listing Provided By: Keller Williams, original listing
Phone: (417) 883-4900
Office Phone: (417) 883-4900
Agent Name: Adam Graddy
Disclaimer: Copyright © 2024 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