Title Page Background
DEBUG FN args: Array ( [0] => 486 [1] => [2] => [3] => agent ) BEFORE: Site: 486 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 486 Igate: njhud LocID: 486 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 = 486 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 486 [1] => [2] => [3] => lender ) BEFORE: Site: 486 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 486 Igate: njhud LocID: 486 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 = 486 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 486 [1] => [2] => [3] => other ) BEFORE: Site: 486 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 486 Igate: njhud LocID: 486 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 = 486 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

2445 East Bb Highway
El Dorado Springs, MO 64744

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $990,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 5618 Square Feet
Agency: Shannon & Assoc Real Estate & Auctions, LLC
Agency Phone: (417) 876-2900

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Refrigerator, Garbage Disposer, Dryer
Architectural Style: Contemporary
Construction Materials: Brick
Cooling: Ceiling Fan(s)
Flooring: Carpet, Tile, Other
Heating: Forced Air
Interior Features: High Ceilings, Walk-in Closet(s), Walk-in Shower, Crown Molding, W/D Hookup
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3

Window Features

Exterior Features: Rain Gutters, Barbed: 5 Wire, Cross Fenced, Full Fence
Fencing: Fenced, Barbed Wire, Cross Fenced
Parking Features: Garage, Covered, Driveway, Workshop
Roof: Composition

Neighborhood/Schools

Elementary School/District: El Dorado Springs
Middle/Junior High School/District:
High School/District: El Dorado Springs
Subvidision Name: N/A

Description/Comments


Lot Size: 60 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2008
Notes: Are you ready for everything you have been looking for and more?!? This one checks the boxes for all your needs and wants! This spectacular property sits on 60 acres that is not only perimeter fenced but also cross-fenced. This 2008 well-built brick home has space galore with 2,809 square feet on the main level PLUS another 2,809 square feet of space in the unfinished walk-out basement that has been plumbed to add a bathroom, if you wish. 3 bedroom, 2.5 bath home with 10' ceilings! There is so much entertaining space!! The oversized living room also has a sitting area with breath-taking columns. The kitchen is immaculate with granite countertops, a kitchen island and a walk-in pantry! Plenty of dining space offered with a breakfast area and also a formal dining room. The master suite is spacious with a good sized master bathroom with an over-sized walk-in shower, jetted tub, double vanity and a big walk-in closet! The covered front porch wraps around the house and provides space to enjoy the outdoors through-out any season. The back provides a large concrete patio area and covered parking. This property seriously has it all! A 2,100 square foot outbuilding with 4 garage bays that provides enough space for a work-shop as well. The barn is animal ready with its cattle corral. The pasture land is absolutely beautiful with a picturesque pond. You can see the love that was put into everything this property has to offer. Paved highway frontage that is only 20 minutes away from Stockton Lake. Schedule an appointment to see this one.
MlsNumber: --
ListingId: 60261801


Listing Provided By: Shannon & Assoc Real Estate & Auctions, LLC, original listing
Phone: (417) 876-2900
Office Phone: (417) 876-2900
Agent Name: Kamber Cain
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