NOT LISTED FOR SALE

5151 Berglund Rd Rapid City, SD 57701

Colonial Pine Hills Neighborhood

Estimated Value: $1,467,000 - $1,940,000

4 Beds
3.5 Baths
4,251 Sq Ft
$388/Sq Ft Est. Value

Last Sold February 02, 2024

Last sale price $1,575,000 $371 Per Sq Ft

Est. 5% increase in value since last sale

Current estimated payment $9,883/month

1 Day on Market

Highlights

  • Newly Remodeled
  • City View
  • Deck
  • Southwest Middle School Rated 9+
  • 14.78 Acre Lot
  • Wooded Lot

About This Home

As of February 2024

This is a rare opportunity to own a truly one-of-a-kind custom home that has never been offered for sale before. Situated on 14.78 acres located in a highly sought-after location. This home was meticulously designed with every detail carefully considered. From the grand entrance to the exquisite finishes such as the custom beans, floor to ceiling stone fireplace, grand staircase, no expense was spared in the design of this home. The spacious living space of this home offers ample room for both entertaining and everyday living. The open concept floorplan seamlessly blends the living room, dining, and kitchen areas, creating a perfect space. The primary suite offers soaking tub, walk-in tile shower, and walk-in-closet. The upper level also offers a loft area with a spiral staircase that leads to an observation room so you can overlook the stunning views of the hills. The lower walkout level features two bedrooms, bathroom, family room, built-in sauna. Come enjoy your new home!

Last Agent to Sell the Property

Yanni Georgas

RE/MAX RESULTS Listed on: 08/21/2023

RE/MAX RESULTS

Co-Listed By

Stephanie Steele

RE/MAX RESULTS

Last Buyer's Agent

OTHER NON-MEMBER

NON-MEMBER FIRM

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $13,758

Year Built

  • Built in 2003 | Newly Remodeled

Lot Details

  • 14.78 Acre Lot
  • Sprinkler System
  • Wooded Lot

Property Views

  • City
  • Trees

Home Design

  • Poured Concrete
  • Composition Roof
  • Hardboard

Interior Spaces

  • 4,251 Sq Ft Home
  • 1.5-Story Property
  • Wet Bar
  • Central Vacuum
  • Vaulted Ceiling
  • Ceiling Fan
  • 3 Fireplaces
  • Gas Fireplace
  • Fire and Smoke Detector
  • Laundry on main level
  • Basement

Kitchen

  • Gas Oven or Range
  • Microwave
  • Dishwasher

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • En-Suite Bathroom
  • Walk-In Closet
  • Bathtub with Shower

Parking

  • 4 Car Garage
  • Garage Door Opener

Outdoor Features

  • Deck

Utilities

  • Forced Air Heating and Cooling System
  • Hot Water Heating System
  • Cistern
  • Shared Well
  • Septic System
  • Cable TV Available

Community Details

  • Skyline Sub Subdivision

Home Details

Home Type

Single Family

Est. Annual Taxes

$13,758

Year Built

Built in 2003 | Newly Remodeled

Lot Details

0

Listing Details

  • Class: RESIDENTIAL
  • Type: Single Family
  • Style: 1.5 Story
  • Lvt Date: 08/21/2023
  • Personal Property: Refrigerator, Range/Oven-Gas-FS
  • View: City, Trees
  • Year Built: 2003
  • Special Features: NewHome
  • Property Sub Type: Detached
  • Stories: 1

Interior Features

  • Features: Ceiling Fan, Dishwasher Built-In, Fireplace, Garage Door Opener, Master Bath, Microwave Oven, Sprinkler System, Central Vac, Smoke Alarm, Wet Bar, Surround Sound, Vaulted Ceiling
  • Flooring: Carpet, Hardwood, Tile
  • Number of Fireplaces: Three
  • Bedrooms: Four
  • Master Bedroom: Size: 16x20, On Level: U
  • Bedroom 2: On Level: U, Size: 12x19
  • Bedroom 3: On Level: B, Size: 17x12
  • Bedroom 4: On Level: B, Size: 10x12
  • Bathroom Description: Shower and Tub, Shower/Tub, Double Lavatory, Walk-in Closet
  • Full Three Quarter Bathrooms: Three
  • Half Bathroom: One
  • Fireplace: Gas Fireplace
  • Basement: Yes
  • Dining Room: Formal, On Level: M, Size: 16x20
  • Kitchen: Size: 10x15, On Level: M
  • Family Room: Size: 19x16, On Level: B
  • Living Room: Size: 19x19, On Level: M
  • Total Finished Sq Ft: 4251
  • Main Floor Laundry: Yes
  • Total Sq Ft: 4251
  • Total Square Foot: 4251
  • Total Square Foot Keyword: 4000+

Exterior Features

  • Construction: Preowned/Resale
  • Construction: Hardboard
  • New Construction: Completed
  • Foundation: Basement, Poured Concrete
  • Driveway Exposure: East
  • Patio Deck1: Deck
  • Patio Deck1 Size: 20x12
  • Roofing: Composition

Garage/Parking

  • Garage Type: Attached, Detached
  • Garage Size: 936 sq ft
  • Garage Capacity: Four or More

Utilities

  • Air Conditioner: Central
  • Air Conditioner: Yes
  • Electric Services: 220V Service, Breaker
  • Flood Insurance: Not Required
  • Heating: Hot Water, Forced Air
  • Utilities: Cable Connected, BHE-Electric, MDU- Gas, Septic, Shared Well, Cistern

Lot Info

  • Acreage: 10-20 Acres
  • Lot Type: Hills/Wooded
  • Number Of Acres: 14.78

Tax Info

  • Year: 2022
  • Taxes: 13757.58

MLS Schools

  • School District: Rapid City

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 21, 2023
Closed on
Feb 2, 2024
Seller's Agent
Yanni Georgas
RE/MAX RESULTS
Buyer's Agent
OTHER NON-MEMBER
NON-MEMBER FIRM
List Price
$1,575,000
Sold Price
$1,575,000
Views
20
Current Estimated Value
$1,647,491

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$72,491
Avg. Annual Appreciation
2.62%
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
-- $1,575,000 --
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
02/02/2024 02/02/24 Sold $1,575,000 0.0% $371 / Sq Ft
11/21/2023 11/21/23 Off Market $1,575,000 -- --
08/22/2023 08/22/23 Pending -- -- --
08/21/2023 08/21/23 For Sale $1,575,000 -- $371 / Sq Ft
Source: Black Hills Association of REALTORS®

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $14,605 $1,385,200 $350,500 $1,034,700
2024 $14,605 $1,274,000 $314,400 $959,600
2023 $14,925 $1,273,500 $314,400 $959,100
2022 $13,758 $1,113,100 $273,400 $839,700
2021 $14,381 $1,025,200 $273,400 $751,800
2020 $13,918 $960,200 $273,400 $686,800
2019 $13,229 $941,500 $273,400 $668,100
2018 $13,338 $905,200 $236,400 $668,800
2017 $12,152 $936,100 $236,400 $699,700
2016 $12,488 $810,300 $236,400 $573,900
2015 $12,488 $813,400 $236,400 $577,000
2014 $12,308 $785,300 $236,400 $548,900
Source: Public Records

Agents Affiliated with this Home

  • Yanni Georgas

    Seller's Agent in 2024

    Yanni Georgas

    RE/MAX

    (605) 341-4300

    21 in this area

    203 Total Sales

    Yanni Georgas
    Section Image
  • Stephanie Steele

    Seller Co-Listing Agent in 2024

    Stephanie Steele

    RE/MAX

    (605) 484-2814

    21 in this area

    177 Total Sales

    Stephanie Steele
    Section Image

  • O

    Buyer's Agent in 2024

    OTHER NON-MEMBER

    NON-MEMBER FIRM

See All Agents

Map

Source: Black Hills Association of REALTORS®

MLS Number: 165281

Black Hills Association of REALTORS®

APN: 0035406

South Dakota Pennington County Rapid City 57701 Colonial Pine Hills

5151 Berglund Rd, Rapid City, SD

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Black Hills Association of REALTORS® IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

Nearby Homes