NOT LISTED FOR SALE

Estimated Value: $2,301,000 - $5,338,000

5 Beds
3.5 Baths
5,009 Sq Ft
$862/Sq Ft Est. Value

Last Sold September 22, 2023

Last sale price $6,000,000 $1,198 Per Sq Ft

Est. 28% decrease in value since last sale

Current estimated payment $24,427/month

8 Days on Market

Highlights

  • Green Energy Generation
  • 0.4 Acre Lot
  • Fireplace in Primary Bedroom
  • Casey Middle School Rated A-
  • Open Floorplan
  • 5-minute walk to Columbine Park

About This Home

As of September 2023

Award-winning modern elegance harmonizes with modern craftsmanship in this North Boulder home designed by StudioB architects in partnership with MD Curated Design. Poised in a park-like setting, a captivating exterior beckons residents inward to a sprawling 5-bedroom, 4-bathroom layout. Eyes are drawn upward to soaring 15-foot ceilings as hardwood flooring artfully conceals radiant floor heating. A bright canvas layered w/ neutrals and warm wood elements balances dramatic black accents throughout. The lines between indoor and out are blurred w/an array of expansive windows & sliding glass walls. Culinary creativity is energized in a sculptural kitchen showcasing Miele appliances and Dorado Soapstone countertops + island. Architectural wall curates the separation between the kitchen and dining room crowned by Juniper Design lighting. Indulge in relaxation in a sunlit primary suite flaunting a bath w/a steam shower. Large mud/laundry room, hidden refrigerator in basement lounge, exceptional landscaping and a home gym are added luxuries. 14.388 kW grid-tied Flushmount PV solar system will produce an estimated 20,408 kWh/yr and meet 109% of your energy needs. Recipient of the following awards: Awards Vista has won: AIA Colorado - Award of Excellence Vista Drive PavilionAIA Colorado - Award of Distinction Vista Drive PavilionLuxe RED Awards - Regional Winner, Contemporary/Modern Architecture, Colorado

Last Agent to Sell the Property

Jennifer Egbert

milehimodern - Boulder Listed on: 08/25/2023

Last Buyer's Agent

Chally Wiener

Compass - Boulder

Compass - Boulder

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $17,964

Year Built

  • Built in 2018

Lot Details

  • 0.4 Acre Lot
  • Cul-De-Sac
  • East Facing Home
  • Southern Exposure
  • Partially Fenced Property
  • Wood Fence
  • Level Lot
  • Sprinkler System
  • Wooded Lot

Parking

  • 2 Car Attached Garage
  • Oversized Parking

Home Design

  • Contemporary Architecture
  • Wood Frame Construction
  • Metal Roof
  • Wood Siding

Interior Spaces

  • 5,009 Sq Ft Home
  • 1-Story Property
  • Open Floorplan
  • Bar Fridge
  • Cathedral Ceiling
  • Skylights
  • Multiple Fireplaces
  • Gas Fireplace
  • Double Pane Windows
  • Window Treatments
  • Living Room with Fireplace
  • Dining Room
  • Home Office
  • Sun or Florida Room
  • Finished Basement

Kitchen

  • Eat-In Kitchen
  • Double Oven
  • Gas Oven or Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Disposal

Flooring

  • Wood
  • Concrete

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Fireplace in Primary Bedroom
  • Walk-In Closet
  • Primary Bathroom is a Full Bathroom
  • Primary bathroom on main floor
  • Steam Shower

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Eco-Friendly Details

  • Energy-Efficient HVAC
  • Green Energy Generation
  • Solar Power System

Schools

  • Columbine Elementary School
  • Casey Middle School
  • Boulder High School

Utilities

  • Humidity Control
  • Central Air
  • Radiant Heating System
  • Water Purifier is Owned
  • High Speed Internet
  • Cable TV Available

Additional Features

  • Garage doors are at least 85 inches wide
  • Patio

Community Details

  • No Home Owners Association
  • Built by MK Construction
  • North Boulder Subdivision

Listing and Financial Details

  • Assessor Parcel Number R0071478

Home Details

Home Type

Single Family

Est. Annual Taxes

$17,964

Year Built

Built in 2018

Lot Details

0

Parking

2

Listing Details

  • Year Built: 2018
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 0.4
  • Road Frontage Type: City Street
  • Road Surface Type: Paved, Asphalt
  • Subdivision Name: North Boulder
  • Architectural Style: Contemporary/Modern, Ranch
  • Garage Yn: Yes
  • Unit Levels: One
  • New Construction: No
  • Efficiency: Southern Exposure, HVAC, Energy Survey Complete, Energy Rated
  • Building Stories: 1
  • Power Production Type: Photovoltaics
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: No
  • IRESDS_Total Sq Ft: 5009
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 1

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Gas Range/Oven, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Water Purifier Owned, Disposal
  • Accessibility Features: Level Lot, Main Floor Bath, Main Level Bedroom, Main Level Laundry
  • Has Basement: 90%+ Finished Basement
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 5
  • Fireplace Features: 2+ Fireplaces, Gas, Living Room, Primary Bedroom
  • Fireplace: Yes
  • Flooring: Wood Floors
  • Interior Amenities: Study Area, High Speed Internet, Eat-in Kitchen, Separate Dining Room, Cathedral/Vaulted Ceilings, Open Floorplan, Pantry, Walk-In Closet(s), Kitchen Island, Steam Shower, 9ft+ Ceilings, Sun Space
  • Window Features: Window Coverings, Skylight(s), Double Pane Windows
  • Room Bedroom3 Features: Wood Floor
  • Dining Room Features: Wood Floor
  • IRESDS_HasFamilyRoom: No
  • Room Bedroom4 Level: Basement
  • Living Room Living Room Level: Main
  • Room Bedroom4 Features: Concrete Floor
  • Master Bedroom Master Bedroom Level: Main
  • Room Bedroom3 Level: Main
  • Room Bedroom2 Level: Main
  • Room Bedroom2 Features: Wood Floor
  • Master Bedroom Features: Wood Floor
  • Room Bedroom5 Level: Basement
  • Room Bedroom5 Features: Concrete Floor
  • Room Kitchen Features: Wood Floor
  • Living Room Features: Wood Floor
  • Dining Room Dining Room Level: Main
  • Master Bathroom Features: Full Primary Bath, Luxury Features Primary Bath, 5 Piece Primary Bath
  • ResoLivingAreaSource: Assessor

Exterior Features

  • Roof: Metal
  • Builder Name: MK Construction
  • Fencing: Partial, Wood
  • Lot Features: Lawn Sprinkler System, Cul-De-Sac, Wooded, Level, Within City Limits
  • View: Foothills View
  • Waterfront: No
  • Construction Type: Wood/Frame, Wood Siding
  • Direction Faces: East
  • Patio And Porch Features: Patio
  • Property Condition: Not New, Previously Owned

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 2
  • Garage Spaces: 2
  • Parking Features: >8' Garage Door, Oversized
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Central Air
  • Electric: Electric, Xcel Energy
  • Heating: Radiant, Humidity Control
  • Utilities: Natural Gas Available, Electricity Available, Other, Cable Available
  • Laundry Features: Washer/Dryer Hookups, Main Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Sewer: City Sewer
  • Water Source: City Water, Boulder Water
  • Gas Company: Natural Gas, Xcel Energy

Condo/Co-op/Association

  • Senior Community: No
  • Association: No

Schools

  • Elementary School: Columbine
  • HighSchool: Boulder
  • Junior High Dist: Boulder Valley Dist RE2
  • Middle Or Junior School: Casey

Lot Info

  • Zoning: RES
  • Lot Size Sq Ft: 17231
  • Parcel #: R0071478
  • ResoLotSizeUnits: SquareFeet

Green Features

  • Green Building Verification Type: HERS Score = 6

Tax Info

  • Tax Year: 2022
  • Tax Annual Amount: 17964

Multi Family

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 25, 2023
Closed on
Sep 22, 2023
Sold by
J King Limited
Bought by
Louis Robert Cohen Family Trust
Seller's Agent
Jennifer Egbert
milehimodern - Boulder
Buyer's Agent
Chally Wiener
Compass - Boulder
List Price
$6,000,000
Sold Price
$6,000,000
Views
17
Current Estimated Value
$4,317,027

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$1,682,973
Avg. Annual Appreciation
-13.39%

Purchase Details

Listed on
Aug 25, 2023
Closed on
Aug 9, 2023
Sold by
Jenna-King Shepherd Lifetime Trust
Bought by
J King Limited
Seller's Agent
Jennifer Egbert
milehimodern - Boulder
Buyer's Agent
Chally Wiener
Compass - Boulder
List Price
$6,000,000
Sold Price
$6,000,000
Views
17

Purchase Details

Closed on
Apr 28, 2023
Sold by
Eat-2103 Llc
Bought by
Jenna King-Shephard Lifetime Trust

Purchase Details

Listed on
Mar 26, 2021
Closed on
Apr 30, 2021
Sold by
Azria Serge
Bought by
King Shepherd Jenna and King Ella T
Seller's Agent
Jennifer Egbert
milehimodern - Boulder
Buyer's Agent
Amanda Salzman
Compass - Boulder
List Price
$4,500,000
Sold Price
$4,215,000
Premium/Discount to List
-$285,000
-6.33%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
0.51%
Original Mortgage
$4,219,705
Interest Rate
3.1%
Mortgage Type
Credit Line Revolving

Purchase Details

Listed on
Aug 1, 2017
Closed on
Sep 27, 2017
Sold by
Dreiling Linda M and The Schiel Legacy Trust
Bought by
Azria Serge
Seller's Agent
Matt Makowski
One Stop Realty, Inc.
Buyer's Agent
Jennifer Egbert
milehimodern - Boulder
List Price
$1,169,000
Sold Price
$1,069,000
Premium/Discount to List
-$100,000
-8.55%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
46.54%

Purchase Details

Closed on
Dec 27, 2001
Sold by
Schiel Ben J and Schiel Apollonia A
Bought by
The Ben J & Apollonia A Schiel Revocable

Purchase Details

Closed on
Nov 15, 1976
Bought by
Schiel Legacy Trust
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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
Louis Robert Cohen Family Trust $6,000,000 First American Title
J King Limited -- None Listed On Document
Eat-2103 Llc -- None Listed On Document
Jenna King-Shephard Lifetime Trust -- None Listed On Document
King Shepherd Jenna $4,215,000 Fidelity National Title
Azria Serge $1,060,000 Heritage Title Co
The Ben J & Apollonia A Schiel Revocable -- --
Schiel Legacy Trust $13,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner King Shepherd Jenna $4,219,705
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
09/22/2023 09/22/23 Sold $6,000,000 0.0% $1,198 / Sq Ft
09/02/2023 09/02/23 Pending -- -- --
08/25/2023 08/25/23 For Sale $6,000,000 +42.3% $1,198 / Sq Ft
07/29/2022 07/29/22 Off Market $4,215,000 -- --
04/30/2021 04/30/21 Sold $4,215,000 -6.3% $842 / Sq Ft View Prior Sale
04/01/2021 04/01/21 For Sale $4,500,000 0.0% $899 / Sq Ft
04/01/2021 04/01/21 Pending -- -- --
03/26/2021 03/26/21 For Sale $4,500,000 +321.0% $899 / Sq Ft
01/28/2019 01/28/19 Off Market $1,069,000 -- --
09/29/2017 09/29/17 Sold $1,069,000 -8.6% $445 / Sq Ft View Prior Sale
09/10/2017 09/10/17 Pending -- -- --
08/01/2017 08/01/17 For Sale $1,169,000 -- $487 / Sq Ft
Source: IRES MLS

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 $22,517 $234,988 $85,188 $149,800
2024 $22,517 $234,988 $85,188 $149,800
2023 $22,124 $255,317 $90,209 $168,793
2022 $17,130 $193,446 $68,089 $125,357
2021 $17,130 $199,014 $70,049 $128,965
2020 $14,304 $164,329 $93,880 $70,449
2019 $9,926 $115,802 $93,880 $21,922
2018 $5,080 $58,594 $46,872 $11,722
2017 $4,921 $64,779 $51,820 $12,959
2016 $4,616 $53,324 $42,666 $10,658
2015 $4,371 $43,907 $21,810 $22,097
2014 $3,022 $43,907 $21,810 $22,097
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: IRES MLS

MLS Number: 995102

IRES MLS

APN: 1463194-38-002