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

339 Grant St
Leola, SD 57456

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $275,000
Beds: 4
Baths: 3
Status: Active
SqFt: --
Agency: Hayden Outdoors, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Property Type: Residential
Year Built: 1980
Notes: Country living within city limits! Situated on a 6.73-acre lot in the Town of Leola, SD. This property is ready to be transformed into your dream property. OWNER FINANCING AVAILABLE. There is an additional 47.7 +/- acres that can be purchased with this property. A single-story residence built in the 1980's offers a total of 1947 square feet of living space. 1201 square feet concrete block basement, a convenient 672 square feet attached garage, and an inviting 188 square feet wood deck. Featuring four bedrooms and 2.5 bathrooms, with steel siding and brick facing on the front, back, and garage sides. The basement windows, complete with built-in storm screens, illuminate the interior, complementing the metal roof, soffit, and fascia. Electric baseboard heat and central air conditioning. The property includes a 200 amp breaker box, a 50-gallon hot water heater, and modern plumbing with plastic water and DWV lines. A wood-burning fireplace in the basement. City amenities with electricity, water, and sewer services. The attached 2-stall garage has insulated overhead doors and electric openers, a three-season room, and a large deck. Additionally, a detached garage built in 1982, measuring 26 X 30, with steel siding, metal roof, and two overhead doors. The cold storage pole shed, measuring 32 X 72 X 12, has a dirt floor, was built in 1969 and relocated to its current location in 1996. Home Built in 1980's One Story 1947 square ft 1201 square ft concrete block basement 672 square ft attached garage 188 square ft wood deck Four (4) bedrooms and 2.5 bathrooms Steel siding Brick facing on front, back and garage sides Casement windows with built in storm screens Metal roof, soffit and fascia. Electric baseboard heat Central Air Conditioning 200 amp breaker box 50 gallon hot water heater Plastic water and DWV (Drain, Waste, and Vent) lines Attached 2 stall garage 24' X 28' Two-9' X 7' insulated overhead doors with electric openers 22' X 25' concrete apron Oak Cabinets and Woodwork Wood burning fireplace in basement City electricity, water and sewer Basement office Large Living Room providing a comfortable place for relaxing Spacious Kitchen for Family Style Dining Three Season Room (Addition made around 2004) Large Deck off the front of house Detached Garage 26'' X 30' Steel siding with metal room Two overhead doors Concrete floor Fiberglass doors Built in 1982 Cold Storage Pole Shed 32' X 72' X 12' Dirt Floor Built in 1969 Moved to current location 1996 The perimeter of the property is not fenced. No warranties about the location of the property lines will be made in relationship to the deeded property lines. Property is being sold based on boundaries shown on the legal description. Boundaries shown on accompanying maps are approximate based on the legal description and may not indicate a survey. Maps are not to scale and are for visual aid only. Their accuracy is not guaranteed.
MlsNumber: 11234865


Listing Provided By: Hayden Outdoors, LLC, original listing
Name: Hayden Outdoors, LLC
Phone: (970) 674-1990
Office Name: Hayden Outdoors Real Estate
Office Phone: (970) 674-1990
Agent Name: Kasey Wipf
Disclaimer: Copyright © 2024 My State MLS. 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 = 2405 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;
Real Estate Expert Photo for Sarah Smith
Sarah Smith
ASCIIGeneric Real Estate
Cell: (241) 555-1812
Office: (241) 555-1776

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App