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

26181 Sunset Bluff Dr
Canistota, SD 57012

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $699,900
Beds: 4
Baths:
Status: Active
SqFt: 2779 Square Feet
Agency: Keller Williams Realty Sioux Falls

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Microwave, Range, Refrigerator, Garbage Disposer
Architectural Style: Ranch
Construction Materials: Brick
Flooring: Carpet, Tile, Laminate
Heating: Central Furnace, Fireplace
Interior Features: Main Floor Laundry, Vaulted Ceiling, MASTER BATH, Lfd_equipment_13, Master Bed Main Level
Rooms: Office, Basement, Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Dining Room, Kitchen, Laundry, Family Room, Living Room

Window Features

Exterior Features: Deck, Landscaping, Gravel Drive, Covered Front Porch
Patio and Porch Features: Porch, Deck
Roof: Shingle, Composition
View: Lake
Waterfront Features: Waterfront

Neighborhood/Schools

Elementary School/District: Canistota ES/Canistota 43-1
Middle/Junior High School/District: /Canistota 43-1
High School/District: Canistota HS/Canistota 43-1
Subvidision Name: Sunset Bluffs Addn

Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2019
Notes: This beautiful country home overlooks Lake Vermillion and will entice you with its modern design, quality features, and beautiful natural light. The open floor plan affords a jovial entertainment atmosphere and intimate views of the open sky! Whether you’re warming up by the gas fireplace in the living room or taking in a quiet night on the deck, you will enjoy incredible sunsets and wildlife in your backyard. Easy working kitchen has upgraded appliances, tile backsplash, and large center island. Main level master suite has two walk-in closets and a private bath with twin vanities, a soaker tub, and a tile shower. Bonus room on the main works great for office or library corner. Laundry room serves as a drop zone and is conveniently located off the heated 3-stall garage which has a floor drain, water hook-ups, and plenty of storage. Lower level features an open family room, 3 bedrooms, and 2 full baths. This tranquil acre of land is just 30 min west of Sioux Falls on paved roads.
MlsNumber: --


Listing Provided By: Keller Williams Realty Sioux Falls, original listing
Phone: (605) 275-0555
Office Phone: (605) 275-0555
Agent Name: Tony Ratchford
Disclaimer: Copyright © 2024 Realtor Association of the Sioux Empire MLS. 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