Please stand by!
USDAProperties.com is running hot! 🔥 🔥 🔥...

 

 

 

$5,200,000   Price Analysis
Agent Details  share icon     map icon  QR
14541 Stellas Meadow Dr
Broomfield, CO 80023
7 bed 10 bath 9,827 SqFt ($529/SqFt)
1.98 acre lot. Built 2017
Listed 2024-05-25, HOA $25, Taxes $15,151
Ⓧ USDA Ineligible
due to price & location

near Broomfield

It's hard to put into words how perfect this home is.

If you have dreamed it, this home has it! From the elegant foyer with a gorgeous curved staircase to the traditional living room, your guests will be wowed. The gourmet kitchen is every cook's dream with a paneled full Subzero refrigerator and full freezer, Wolf 48 range, double ovens, steam oven, ball ice maker and the most dreamiest of pantries to keep you organized. With the kitchen being the heart of the home, you will enjoy the proximity of the extraordinary room with the attractive gas fireplace, the dining room and the views of the incredible outdoor space - so perfect for entertaining friends and family. There is a pool with a fun waterslide, hot tub, outdoor kitchen and even a basketball court. There is no need to travel when you can have so much fun in your own backyard.

The pool bathroom with attached laundry room makes washing all those pool towels so convenient. The pleasing main floor primary suite has his and her closets and yet another laundry room (4 total) complete with the perfect wrap center counterspace for wrapping gifts and storing ribbons and paper. And shhh. steps away there is even a locked closet for hiding gifts from sneaky spies. If you like to craft or work from home, there is a nice main floor office with built-ins that is tucked out of the way. Upstairs there are four additional bedrooms each with ensuite bathrooms as well as a loft. This grand home comes with not one but two staircases as well as a third staircase from the garage that leads to the basement storage. So convenient. The basement includes another kitchen space perfect for all of your movie nights with your home movie theater with included theater chairs and projector. Anyone dreaming of a slumber party? There is a fun bunkroom with 8 twin beds and an ensuite bathroom and another guest bedroom and bathroom. This home is close to everything but you feel all the privacy of rural living. It's amazng!


Presented by Kaly Bastson at
FATHOM REALTY .
Listing Agent Photo

Property MLS #9743214 from REcolorado

Dishwasher
Disposal
Double Oven
Dryer
Gas Water Heater
Humidifier
Microwave
Range
Range Hood
Refrigerator
Washer
Laundry Features: Common Area, Laundry Closet

Bedrooms: 7
Bedrooms On Basement Level: 2
Bedroom 1 Dimensions: 15.0 x 19.0
Bedroom 2 Dimensions: 16.0 x 13.0
Bedroom 3 Dimensions: 18.0 x 12.0
Bedroom 4 Dimensions: 17.0 x 11.0
Bedroom 5 Dimensions: 17.0 x 19.0
Bedroom 6 Dimensions: 16.0 x 14.0
Primary Bedroom Level: Upper
Bedroom 1 Level: Upper
Bedroom 2 Level: Upper
Bedroom 3 Level: Upper
Bedroom 4 Level: Upper
Bedroom 5 Level: Basement
Bedroom 6 Level: Basement

Total Bathrooms: 10
Full Bathrooms: 3
1/2 Bathrooms: 2
3/4 Bathrooms: 5
Bathrooms On Main Level: 2
Bathrooms On Basement Level: 3

Audio/Video Controls
Built-in Features
Ceiling Fan(s)
Central Vacuum
Entrance Foyer
High Ceilings
High Speed Internet
Kitchen Island
Open Floorplan
Pantry
Primary Suite
Quartz Counters
Smoke Free
Sound System
Spa/Hot Tub
Utility Sink
Vaulted Ceiling(s)
Walk-In Closet(s)
Wet Bar
Furnished Description: Negotiable
Flooring: Carpet, Stone, Tile, Wood
Window Features: Skylight(s), Window Coverings, Window Treatments

Laundry Level: Main
Laundry Width: 15.00
Laundry Length: 6.00
Bathroom (3/4) Level: Main
Bathroom (1/2) Level: Main
Primary Bathroom (Full) Level: Upper
Bathroom (3/4) 2 Level: Upper
Bathroom (3/4) 2 Width: 6.00
Bathroom (3/4) 2 Length: 8.00
Bathroom (Full) Level: Upper
Bathroom (Full) Width: 6.00
Bathroom (Full) Length: 10.00
Bathroom (3/4) 3 Level: Upper
Bathroom (3/4) 3 Width: 8.00
Bathroom (3/4) 3 Length: 10.00
Laundry 2 Level: Upper
Laundry 2 Width: 6.00
Laundry 2 Length: 7.00
Bathroom (Full) 2 Level: Basement
Laundry 3 Level: Basement
Laundry 3 Width: 6.00
Laundry 3 Length: 8.00
Bathroom (3/4) 4 Level: Basement
Gym Level: Basement
Gym Width: 13.00
Gym Length: 19.00
Bathroom (3/4) 5 Level: Upper
Bathroom (1/2) 2 Level: Basement
Game/Recreation Room Dimensions: 17.0 x 13.0
Great Room Dimensions: 18.0 x 22.0
Living Room Dimensions: 14.0 x 16.0
Loft Dimensions: 12.0 x 21.0
Media Room Dimensions: 14.0 x 19.0
Mud Room Dimensions: 14.0 x 12.0
Office/Study Room Dimensions: 14.0 x 11.0
Game/Recreation Room Level: Basement
Great Room Level: Main
Living Room Level: Main
Loft Level: Upper
Media Room Level: Basement
Mud Room Level: Main
Office/Study Room Level: Main
Basement Description: Finished, Partial, Sump Pump

Cooling Features: Central Air
Fireplace Features: Bedroom, Great Room
Heating Features: Forced Air
Number of Fireplaces: 2

Dining Room Dimensions: 17.0 x 13.0
Dining Room Level: Main
Kitchen Dimensions: 20.0 x 18.0
Kitchen Level: Main
2nd Kitchen Dimensions: 12.0 x 18.0
2nd Kitchen Level: Basement

Balcony
Barbecue
Fire Pit
Gas Grill
Lighting
Private Yard
Rain Gutters
Spa/Hot Tub
Fencing: Full
Patio And Porch Features: Covered, Front Porch, Patio
Road Frontage Type: Public Road
Road Responsibility: Public Maintained Road
Road Surface Type: Paved

Pool Features: Outdoor Pool

Builder Model: Custom

Attached Garage: Yes
Garage Spaces: 4
Parking Features: Circular Driveway, Concrete, Floor Coating
Parking Total: 4

Lot Description: Landscaped, Many Trees, Sprinklers In Front, Sprinklers In Rear
Lot Size Acres: 1.98
Lot Size Square Feet: 86379

Association: Yes
Association Fee: 75
Association Fee Frequency: Quarterly
Calculated Total Monthly Association Fees: 25
Association Name: Ashwood
Association Phone: 3032545582
Pets Allowed: Cats OK, Dogs OK

Elementary School: Meridian
Elementary School District: Adams 12 5 Star Schl
High School: Legacy
High School District: Adams 12 5 Star Schl
Middle School: Rocky Top
Middle or Junior School District: Adams 12 5 Star Schl

Meridian Elementary School is a public elementary school located approximately 0.4 miles away.
directions icon Map directions

Legacy High School is a public high school located approximately 1.1 miles away.
directions icon Map directions

Rocky Top Middle School is a public middle school located approximately 3.2 miles away.
directions icon Map directions

Hope Montessori Academy is a private elementary school located approximately 1.4 miles away.
directions icon Map directions

Annual Tax Amount: 17121.00
Source Listing Status: Active
County: Broomfield
Tax Year: 2023
Source Property Type: Residential
Source Neighborhood: Green Family Farm Estates
Parcel Number: R8866248
Subdivision: Green Family Farm Estates
Zoning: A-1(A)
Property Subtype: Single Family Residence
Source System Name: C2C

YearAssessments
Building + Land
Total
Tax
2022$113,270 + $20,850
$134,120
$15,151
2021$116,530 + $21,450
$137,980
$15,622
2020$96,530 + $21,450
$117,980
$13,504
2019$96,530 + $21,450
$117,980
$13,511
2018$98,640 + $14,400
$113,040
$13,331
2017$49,440 + $14,400
$63,840
$6,858
2016$unknown + $35,910
$35,910
$3,959
2015$unknown + $33,800
$33,800
$3,726
2014$unknown + $33,950
$33,950
$3,846
2013$unknown + $32,010
$32,010
$3,502
2011$unknown + $20,700
$20,700
$2,180
2010$unknown + $19,650
$19,650
$3,541
2009$unknown + $31,880
$31,880
$3,537
2008$unknown + $90
$90
$14
2007$unknown + $90
$90
$14

Listed 2024-05-25
$5,200,000
REcolorado
Sold 2015-08-13
$230,000
Public Record
Sold 2014-09-15
$190,000
Public Record
Sold 2006-01-01
$2,400,000
Public Record

Total Square Feet Living: 8518
Year Built: 2017
Above Grade Finished Area: 5962
BelowGradeFinishedArea: 2556
Below Grade Unfinished Area: 1309.00
Construction Materials: Stone, Wood Siding
Direction Faces: North
Foundation Details: Slab
Levels: Two
Property Age: 7
Roof: Composition
Structure Type: House
Architectural Style: Traditional

Sewer: Public Sewer
Electricity Connected
Natural Gas Connected

Other Equipment: Home Theater
Security Features: Carbon Monoxide Detector(s), Security System, Smoke Detector(s), Video Doorbell
Click Thumbnail Images To View Full Size
house_viewhouse_viewhouse_viewunknownliving_room
kitchendining_roomdining_roomdining_roomliving_room
living_roomliving_roomliving_roombathroombathroom
bathroomlaundry_roomunknownunknownlaundry_room
bathroombedroombathroombedroombathroom
bedroombedroombathroomliving_roomunknown
bathroomkitchenliving_roomliving_roomunknown
unknownbedroomunknownbedroombathroom
porchporchporchporchunknown
unknownunknown

The property loan eligibility may be subject to additional requirements beyond geographical location including but not limited to the condition of the property. Speak with a real estate professional to find out more about the eligibility of a specific property.