$710,000
SOLD APR 25, 2025

637 W 174th Ave Broomfield, CO 80023

4 Beds
2.5 Baths
2,455 Sq Ft
0.25 Acres

Recently Sold

$289 Per Sq Ft

11% Below List Price

102 Days on Market

Highlights

  • Primary Bedroom Suite
  • Contemporary Architecture
  • 1 Fireplace
  • Black Rock Elementary School Rated A-
  • Loft
  • High Ceiling

About This Home

As of April 2025

With its prime location and spacious lot, this home is a must-see. Situated on a 10,790-square-foot lot, it offers breathtaking mountain views. Upgraded for both convenience and style, no detail has been overlooked. Start your day with breakfast in the upgraded kitchen, where you can enjoy stunning views through the 12-foot sliding glass doors that open to a large covered outdoor patio. The open floor plan allows for a seamless flow from the kitchen to the living room, which is bathed in natural light and features a cozy gas fireplace and surround sound. The seller has already begun finishing the basement, offering the new owner the opportunity to complete it to their preferences. Ideally located between Denver and Boulder, this home provides easy access to major highways like Interstate 36 and I-25, placing you just a short drive from Denver's cultural, dining, and entertainment options, while also being close to the outdoor lifestyle and activities that Boulder has to offer. Up to $10,000 Lender Incentive If Using Our Preferred Lender. Those Credits Can Be Used To Buy Down The Rate, Cover Closing Costs, OR Cover The Full Cost Of A 2-1 Buydown. (Incentive Based On Loan Amount. $10,000 Is Assuming 80% LTV/$480,000 Loan Amount. This is not a commitment to lend.)

Last Agent to Sell the Property

Carly Roberts

Compass - Denver Brokerage Email: carly.roberts@compass.com,678-517-7258 License #100106806 Listed on: 12/12/2024

Compass - Denver

Last Buyer's Agent

Brad Smith

MB Peak Performance Group License #040015423

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $7,746

Year Built

  • Built in 2019

Lot Details

  • 0.25 Acre Lot
  • Property is Fully Fenced
  • Level Lot
  • Front Yard Sprinklers
  • Property is zoned PUD

HOA Fees

  • $58 Monthly HOA Fees

Parking

  • 3 Car Attached Garage

Home Design

  • Contemporary Architecture
  • Slab Foundation
  • Frame Construction
  • Composition Roof
  • Wood Siding

Interior Spaces

  • 2-Story Property
  • High Ceiling
  • Ceiling Fan
  • 1 Fireplace
  • Double Pane Windows
  • Living Room
  • Home Office
  • Loft
  • Laundry Room

Kitchen

  • Eat-In Kitchen
  • Kitchen Island
  • Granite Countertops

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary Bedroom Suite
  • Walk-In Closet

Basement

  • Sump Pump
  • Bedroom in Basement
  • Stubbed For A Bathroom
  • 1 Bedroom in Basement

Schools

  • Soaring Heights Elementary And Middle School
  • Erie High School

Utilities

  • Forced Air Heating and Cooling System
  • Natural Gas Connected
  • Cable TV Available

Additional Features

  • Front Porch
  • Ground Level

Listing and Financial Details

  • Exclusions: Sellers Personal Property, all TV`s and wall brackets inside and outside home, Refrigerator in Kitchen, Small Refrigerator in upstairs laundry room, Refrigerator in basement.
  • Assessor Parcel Number R8873546

Community Details

Overview

  • Association fees include snow removal, trash
  • Advance HOA Management, Inc. Association, Phone Number (303) 482-2213
  • Built by Taylor Morrison
  • Palisade Park Filing 4 Rep A Subdivision, Taylor Morrison Plan 4022

Recreation

  • Community Playground
  • Park

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,746

Year Built

Built in 2019

Lot Details

0

HOA Fees

$58 per month

Parking

3

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: Contemporary
  • Structure Type: House
  • Levels: Two
  • Year Built: 2019
  • Above Grade Finished Sq Ft: 2455
  • Entry Location: Ground
  • Exclusions: Sellers Personal Property, all TV`s and wall brackets inside and outside home, Refrigerator in Kitchen, Small Refrigerator in upstairs laundry room, Refrigerator in basement.
  • Living Area: 2455
  • SubdivisionName: Palisade Park Filing 4 Rep A
  • Ownership: Individual
  • Property Attached Yn: No
  • ResoBuildingAreaSource: PublicRecords
  • REC_BasementLevelBathrooms: 0
  • REC_BasementLevelBedrooms: 1
  • REC_BelowGradeUnfinishedArea: 1139.00
  • REC_ExpectedActiveDate: 2024-12-12
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 2
  • REC_UpperLevelBedrooms: 3
  • REC_WaterIncludedYN: 1
  • Ratio Close Price By Original Li: 0.88750
  • Attribution Contact: carly.roberts@compass.com,678-517-7258
  • Special Features: VirtualTour

Interior Features

  • Fireplaces: 1
  • Interior Amenities: Ceiling Fan(s), Eat-in Kitchen, Granite Counters, High Ceilings, Kitchen Island, Pantry, Primary Suite, Walk-In Closet(s)
  • Full Bathrooms: 1
  • Half Bathrooms: 1
  • Common Walls: No Common Walls
  • Basement: Bath/Stubbed, Sump Pump
  • Basement: Yes
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 4
  • Main Level Bathrooms: 1
  • Window Features: Double Pane Windows

Exterior Features

  • Foundation Details: Slab
  • Roof: Composition
  • Construction Materials: Frame, Wood Siding
  • Patio and Porch Features: Front Porch
  • Road Frontage Type: Public
  • Road Surface Type: Paved

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 3
  • Total Parking Spaces: 3
  • REC_ParkingCount: 1

Utilities

  • Utilities: Cable Available, Electricity Connected, Natural Gas Connected
  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Forced Air
  • Water Source: Public

Condo/Co-op/Association

  • HOA Fee Includes: Snow Removal, Trash
  • Association Name: Advance HOA Management, Inc.
  • Association Fee Frequency: Monthly
  • Association Amenities: Park, Playground
  • Association Fee: 57.5
  • Phone: 303-482-2213
  • Association: Yes
  • Senior Community: No

Association/Amenities

  • REC_AssociationFee2Annual: 0.00
  • REC_AssociationFee3Annual: 0.00
  • REC_AssociationFeeAnnual: 690.00
  • REC_AssociationFeeTotalAnnual: 690.00
  • REC_AssociationManagementType: Professionally Managed
  • REC_MultipleAssociationsYN: 0
  • REC_AssociationURL: https://www.advancehoa.com/

Schools

  • Middle Or Junior School: Soaring Heights

Lot Info

  • Parcel Number: R8873546
  • Lot Size Acres: 0.25
  • Fencing: Full
  • Building Area Total: 3594
  • Lot Features: Level, Sprinklers In Front
  • Lot Size Sq Ft: 10790
  • ResoLotSizeUnits: SquareFeet

Building Info

  • Builder Name: Taylor Morrison

Rental Info

  • Furnished: Unfurnished

Tax Info

  • Tax Year: 2023
  • Tax Annual Amount: 7746

MLS Schools

  • Elementary School: Soaring Heights
  • High School: Erie

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Dec 12, 2024
Closed on
Apr 25, 2025
Sold by
Stoltenberg Laura Jane
Bought by
Roth John
Seller's Agent
Carly Roberts
Compass - Denver
Buyer's Agent
Brad Smith
MB Peak Performance Group
List Price
$800,000
Sold Price
$710,000
Premium/Discount to List
-$90,000
-11.25%
Views
187
Current Estimated Value
$713,948

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$3,948
Avg. Annual Appreciation
2.24%
Original Mortgage
$532,500
Outstanding Balance
$532,032
Interest Rate
6.65%
Mortgage Type
New Conventional
Estimated Equity
$181,916

Purchase Details

Closed on
Jun 17, 2019
Sold by
Taylor Morrison Of Colorado Inc
Bought by
Stoltenberg Laura Jane

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$399,072
Interest Rate
4.1%
Mortgage Type
New Conventional
Source: Public Records

Similar Homes in Broomfield, CO

  • 17706 Cherokee St, Broomfield, CO 80023

    $599,000

    • 4 Beds
    • 3.5 Baths
    • 2,416 Sq Ft
    • 17706 Cherokee St
    • Broomfield, CO

    Location, location, location!! This is an AMAZING home across from the HUGE community park with beautiful mountain views. Enter into the home off of a nice private covered porch that faces the mountains. The kitchen is spacious with a huge center island, granite counters, crisp white cabinetry with crown moulding, a tile backsplash, chic pendant lighting, stainless steel appliances, pantry, gas

    Taylor Bunney eXp Realty, LLC

    Section Image
  • 17632 Datura St, Broomfield, CO 80023

    $875,000

    • 5 Beds
    • 4.5 Baths
    • 3,910 Sq Ft
    • 17632 Datura St
    • Broomfield, CO

    This Palisade Park beauty isn’t just a home—it’s a game changer. From the charming front porch that begs for morning coffee hangs to the sleek, open layout inside, every inch is designed to impress. You’ll love the oversized kitchen with rich cabinetry and a massive island that’s made for entertaining. And here’s the twist—there’s a kitchenette and living space, perfect for multi-gen living,

    Kelly Dolph Keller Williams Foothills Realty

    Section Image
  • 718 176th Ave, Broomfield, CO 80023

    $575,000

    • 3 Beds
    • 2.5 Baths
    • 2,088 Sq Ft
    • 718 176th Ave
    • Broomfield, CO

    Stunning Turn-Key Home Backing to Open Space in Broomfield. Built in 2021, this beautifully designed two-story home offers modern finishes, a functional layout, and an unbeatable location in Palisade Park. Featuring 3 bedrooms, 2.5 bathrooms, and a versatile bonus space perfect for a home office, reading nook, or playroom, this home is designed for both comfort and convenience.The

    Elizabeth Boone Camber Realty, LTD

    Section Image
  • 15229 Navajo St, Broomfield, CO 80023

    $775,000

    • 3 Beds
    • 2 Baths
    • 1,550 Sq Ft
    • 15229 Navajo St
    • Broomfield, CO

    A True Gem: Stunning Remodeled Farmhouse on One Acre in a Prime Broomfield Location. This beautifully remodeled farmhouse sits on a serene one-acre lot, offering the perfect blend of modern luxury and country charm. The property features a spacious 2-car attached garage plus an impressive 23x35 detached garage, providing ample space for vehicles, hobbies, and storage. Step inside to

    Claire Gilmore MB KELL & COMPANY

    Section Image
  • 1067 E 15th Ave, Broomfield, CO 80020

    $645,000

    • 3 Beds
    • 2 Baths
    • 1,411 Sq Ft
    • 1067 E 15th Ave
    • Broomfield, CO

    Highly desired Northmoor neighborhood with tree lined streets and estate sized lots. Newly painted ranch style home with 3 bedrooms, 2 bathroom, 2 car garage, AC. All new wide plank LVP floors, new interior paint, new solid surface countertops, new subway tile backsplash, newer stainless steel appliances, newer light fixtures. Private fully fenced backyard with stunning trees, large level

    Claire Gilmore MB KELL & COMPANY

    Section Image
  • 638 W 175th Ave, Broomfield, CO 80023

    $790,000

    • 5 Beds
    • 3.5 Baths
    • 2,623 Sq Ft
    • 638 W 175th Ave
    • Broomfield, CO

    Enduring elegance meets modern comfort in this stunning 5-bedroom, 3.5-bathroom home, built in 2019 and meticulously maintained across 2,728 sq ft of light-filled living space. Step into a welcoming open layout where luxury vinyl plank flooring flows seamlessly throughout, leading to a gourmet kitchen designed for everyday living and entertaining—featuring granite countertops, stainless steel

    Frank Griffin Flat Rate Realty Group LLC

    Section Image
  • 577 W 174th Ave, Broomfield, CO 80023

    $685,000

    • 5 Beds
    • 3 Baths
    • 2,808 Sq Ft
    • 577 W 174th Ave
    • Broomfield, CO

    Upgraded and ideally located, this spacious home with a 3-car tandem garage offers style and convenience! Just a couple of homes away from the neighborhood park and near I-25—commuting to Denver, DIA, or Northern Colorado is made easy. Inside, enjoy an open main level with a spacious great room, full bathroom, main floor bedroom, and beautiful kitchen. The eat-in kitchen offers a large granite

    Team Lassen MB Team Lassen

    Section Image
  • 509 W 175th Ave, Broomfield, CO 80023

    $699,500

    • 4 Beds
    • 3.5 Baths
    • 2,808 Sq Ft
    • 509 W 175th Ave
    • Broomfield, CO

    Welcome to this beautifully maintained corner-lot home in sought-after Palisade Park, North Broomfield. Ideally located near Vista Ridge Golf Course, top-rated schools (8/10 GreatSchools), and just 12 mins to Boulder, 25 mins to Denver, with Costco, King Soopers, Safeway, and major shopping/dining within 10 minutes. This sun-filled home faces a large park with open lawn and playground, offering

    Shuying Lou Good Neighbor LLC

    Section Image
  • 515 176th Ave, Broomfield, CO 80023

    $720,000

    • 3 Beds
    • 2 Baths
    • 1,835 Sq Ft
    • 515 176th Ave
    • Broomfield, CO

    Seller is offering $5000 in concessions!! Step into effortless style and comfort in this beautiful ranch-style home in the Palisade Park neighborhood in Broomfield—backing directly to a large neighborhood park! From the charming front porch to the tranquil backyard views, every inch of this home feels intentionally designed for everyday living and entertaining. Inside, the open-concept layout

    Erin Johnson Berkshire Hathaway HomeServices Colorado Real Estate, LLC - Brighton

    Section Image

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 Type Sale Price Title Company
Warranty Deed $710,000 None Listed On Document
Special Warranty Deed $599,927 First American Title
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $532,500 New Conventional
Previous Owner $399,072 New Conventional
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
04/25/2025 04/25/25 Sold $710,000 -2.7% $289 / Sq Ft
03/20/2025 03/20/25 Price Changed $729,999 -2.7% $297 / Sq Ft
02/27/2025 02/27/25 Price Changed $750,000 -2.6% $305 / Sq Ft
02/14/2025 02/14/25 Price Changed $770,000 -2.5% $314 / Sq Ft
01/30/2025 01/30/25 Price Changed $789,999 -1.3% $322 / Sq Ft
12/12/2024 12/12/24 For Sale $800,000 -- $326 / Sq Ft
Source: REcolorado®

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 $8,037 $44,960 $10,050 $34,910
2024 $8,037 $44,770 $9,290 $35,480
2023 $7,746 $50,260 $10,430 $39,830
2022 $6,352 $37,000 $7,510 $29,490
2021 $6,425 $38,060 $7,720 $30,340
2020 $6,081 $36,170 $7,510 $28,660
2019 $1,752 $10,450 $7,560 $2,890
2018 $1,604 $9,580 $9,580 $0
Source: Public Records

Agents Affiliated with this Home

See All Agents

Map

Source: REcolorado®

MLS Number: 6471772

REcolorado®

APN: 1467-34-1-21-006