227 Powderhorn Trl
Broomfield, CO 80020
- 4 beds
- 4 baths
- 2,998 sqft
- 6,970 sqft lot
- $327 per sqft
- 1988 build
- – on site
More homes
Welcome to The Overlook! Experience majestic views at an affordable price! This stunning home at 227 Powderhorn Trail offers breathtaking views of the Front Range, including Sterns Lake and nearby Boulder County Open Spaces. Every day brings new surprises with vistas of hot air balloons, majestic Bald Eagles, and a variety of wildlife, along with active bike riders and walkers. This home has been extensively updated, featuring all-new appliances, modern light fixtures, stylish ceiling fans, and elegant granite countertops in the kitchen, complemented by designer paint throughout. The expansive family room boasts a vaulted ceiling, enhancing the open and airy feel while showcasing stunning mountain views. The newly constructed walkout basement includes a bedroom, a three-quarter bath, and versatile entertainment/workout space. Recent upgrades also include a new furnace and air conditioner for optimal comfort. Enjoy professionally landscaped front and backyard spaces, complete with multiple gardens on the west side and a charming rock garden in the front yard. Enjoy your new custom rot iron deck with cable spinding! Contact us today to schedule a viewing and discover the beauty and tranquility that The Overlook has to offer! Please wear botties upon entering the house. Please diligently leave feedback. Sellers may need some notice to remove a little dog.
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Apr 26, 2025
•
MLS# 4062386 —
The Building
-
Year Built:1988
-
New Construction:false
-
Construction Materials:Wood Siding
-
Total SqFt:2,998 Sqft
-
Building Area Total:1960
-
Roof:Composition
-
Levels:Two
-
Basement:Full
-
Stories:2
-
Window Features:Double Pane Windows
-
Patio And Porch Features:Patio
-
Above Grade Finished Area:1960
-
Below Grade Finished Area:1038
Interior
-
Interior Features:Central Vacuum
-
Fireplace:true
-
Fireplace Features:Family/Recreation Room Fireplace
-
Kitchen Level:Main
-
Dining Room Level:Main
-
Family Room Level:Main
Room Dimensions
-
Living Area:2998
-
Living Area Units:Square Feet
-
Living Area Source:Assessor
-
Kitchen Length:15
-
Kitchen Area:225
-
Kitchen Width:15
-
Dining Room Area:121
-
Dining Room Length:11
-
Dining Room Width:11
-
Family Room Area:264
-
Family Room Length:12
-
Family Room Width:22
-
Master Bedroom Area:204
-
Master Bedroom Width:17
-
Master Bedroom Length:12
Financial & Terms
-
Listing Terms:Cash
Location
-
Coordinates:-105.075882, 39.944363
-
Latitude:39.944363
-
Longitude:-105.075882
The Property
-
Property Type:Residential
-
Property Subtype:Residential-Detached
-
Lot Features:Gutters
-
Lot Size Acres:0.16
-
Lot Size SqFt:6,970 Sqft
-
Lot Size Area:6970
-
Lot Size Units:Square Feet
-
Zoning:R-PUD
-
View:Foothills View
-
Exclusions:Sellers personal property.
-
Horse:false
-
Fencing:Fenced
-
Exterior Features:Balcony
-
Waterfront:false
-
Has Water Rights:No
Listing Agent
- Contact info:
- No listing contact info available
Taxes
-
Tax Year:2024
-
Tax Annual Amount:$4,489
Beds
-
Bedrooms Total:4
-
Bedroom 2 Level:Upper
-
Bedroom 3 Level:Upper
-
Bedroom 4 Level:Basement
-
Master Bedroom Level:Upper
Baths
-
Total Baths:4
-
Three Quarter Baths:1
-
Full Baths:2
-
Half Baths:1
-
Master Bath Features:Full Primary Bath, 5 Piece Primary Bath
The Listing
-
Special Listing Conditions:Private Owner
Heating & Cooling
-
Heating:Forced Air
-
Heating:true
-
Cooling:Central Air
-
Cooling:true
Utilities
-
Sewer:City Sewer
-
Water Source:City Water
Schools
-
Elementary School:Aspen Creek K-8
-
Middle School:Aspen Creek K-8
-
High School:Broomfield
-
High School District:Boulder Valley RE 2
The Community
-
Community Features:Park
-
Association:true
-
Subdivision Name:Outlook
-
Association Fee:$50
-
Association Fee Frequency:Monthly
-
Association Fee Includes:Trash
-
Spa:false
-
Senior Community:false
Parking
-
Garage Spaces:2
-
Garage:true
-
Garage Type:Attached
-
Attached Garage:true
-
Covered Spaces:2
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
4/25/25
Apr 25, 2025
|
Sold | IRES | $981,000 | 0.1% |
3/26/25
Mar 26, 2025
|
Pending | IRES | $980,000 | |
3/20/25
Mar 20, 2025
|
Listed / Active | IRES | $980,000 |