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 = 2406 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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 = 2406 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 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 = 2406 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 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;

2220 Chevelle Circle
Sturgis, SD 57785-9999
Jim Allison with Allison Real Estate, original listing - (605) 381-3068

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,549,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 3580 Square Feet
Agency: Allison Real Estate
Agency Phone: (605) 381-3068

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2003
Notes: One of the most beautiful and unique homes in the Black Hills is being offered for sale. If entertaining is part of your lifestyle or simply wanting to enjoy the beauty of the Black Hills in solitude, this is your home. If you want the convenience of City living with the advantage of privacy, this is your home. It is located on nearly 5 acres of immaculately landscaped land that combines lush green grass, perennials, native oak, pine, bluespruce and blaze maple trees overlooking Sturgis. The open concept main floor has 9 foot ceilings in kitchen, laundry, primary bedroom andbath. The living room has floor to ceiling trapezoid Pella windows and 20 foot ceiling with unparalleled panoramic view of the Black Hills. Blackwalnut hand scrapped wood floors enhance the living room and primary bedroom. Feet are kept cozy with the in- floor heated porcelain tiled floor. Visitors will tell you there is not another private all-season 1675 square foot enclosed patio in the region to rival the one at this customhome. It can easily seat 30 people not counting the seating at the custom bar which has water, sink, under cabinet refrigerator and ice maker.The lower level features 10 ft ceilings, 2 bedrooms and full bath and huge family room which comes with complete custom built-in entertainmentcenter and wet bar with sink, and 2 under cabinet bar refrigerators. This home also comes with custom exterior Christmas lighting. 3 car heated attached garage 1072 sq ft epoxy floors.
MlsNumber: --
ListingId: 82459


Listing Provided By: Allison Real Estate, original listing
Phone: (605) 381-3068
Office Phone: (605) 381-3068
Agent Name: Jim Allison
Disclaimer: Copyright © 2024 Mt. Rushmore Area Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 2406 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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;
Steph Holdinghausen
ASCIISelling 605 Realty, LLC
Call Today!: (605) 484-6781

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App