Stay tuned for more...
USDAProperties.com is processing real estate display...

 

 

 

$1,700,000
Agent Details  share icon     map icon  QR
14732 Stellas Meadow Dr
Broomfield, CO 80023
4 bed 5 bath 5,396 SqFt ($315/SqFt)
1.0 acre lot. Built 2010
Listed 2024-04-11, HOA $17, Taxes $9,001
Ⓧ USDA Ineligible
due to price & location

near Broomfield

Latest Value Estimates: $1,686,266 from Quantarium on 2024-04-24. $1,192,000 from Collateral Analytics on 2024-04-17. $1,827,400 from CoreLogic on 2024-04-01. Forecast Estimate Value:$1,755,240 in 2025-04-01 by Quantarium. $1,202,838 in 2025-02-01 by Collateral Analytics. $1,930,928 in 2025-04-01 by CoreLogic.

Immaculate ranch sanctuary situated on an acre of land in the picturesque Green Family Farm Estates!

* No Longer For Sale *
Your browser will attempt to redirect you to the city level in a few seconds.

This stunning home offers unparalleled luxury, boasting mountain and meadow views. The property backs to open space, ensuring privacy and tranquility. Arrive home to the convenience of a circular driveway leading to a fully finished 3-car garage with floor coating, dog wash and ample storage space. Step inside to discover high ceilings and granite countertops throughout, accentuating the open concept living room with large windows and a cozy fireplace, perfect for gathering with loved ones. The vast kitchen is a chef's dream featuring a formal dining space, sizeable island, stainless steel appliances and limitless cabinetry complemented by an elegant backsplash. Double doors lead you to the lovely primary suite that showcases a spa-like ensuite bathroom with dual sinks, oversized step-in shower and a generous walk-in closet.

An additional bedroom with ensuite bathroom and a dedicated home office space with built-ins offer versatility and convenience. The large mudroom area with cabinets, bench and storage walk-in closet, along with the oversized laundry room, ensure practicality meets style. The partially finished basement presents a cozy retreat with a fireplace and wet bar, alongside two conforming bedrooms connected by a Jack-and-Jill bathroom. The unfinished space allows for future expansion and customization. Outside, enjoy serene outdoor spaces including a large front patio, covered bck patio, firepit, raised garden beds, storage shed and direct access to a walking path, all surrounded by attractive landscaping. Conveniently located near McKay Lake and Orchard Town Center, offering a myriad of recreation, shopping and dining options, this property epitomizes luxu rious yet comfortable living in a one-of-a-kind setting.


Presented by Martin Mata at
Redfin Corporation.


Property MLS #4690215 from REcolorado

Bedrooms: 4
Bedrooms On Basement Level: 2
Bedrooms On Main Level: 2
Primary Bedroom Level: Main
Bedroom 1 Level: Main
Bedroom 2 Level: Basement
Bedroom 3 Level: Basement

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

Ceiling Fan(s)
Central Vacuum
Entrance Foyer
Granite Counters
High Ceilings
Jack & Jill Bath
Kitchen Island
Open Floorplan
Primary Suite
Radon Mitigation System
Tile Counters
Utility Sink
Walk-In Closet(s)
Wet Bar
Furnished Description: Unfurnished
Flooring: Carpet, Tile, Wood
Window Features: Window Coverings

Dishwasher
Disposal
Dryer
Gas Water Heater
Microwave
Oven
Range
Range Hood
Refrigerator
Sump Pump
Washer

Bathroom (Full) Level: Main
Primary Bathroom (3/4) Level: Main
Bathroom (1/2) Level: Main
Laundry Level: Main
Bathroom (1/2) 2 Level: Basement
Bathroom (3/4) Level: Basement
Family Room Level: Basement
Living Room Level: Main
Mud Room Level: Main
Office/Study Room Level: Main
Basement Description: Bath/Stubbed, Finished, Full, Interior Entry/Standard, Sump Pump, Unfinished

Cooling Features: Central Air
Fireplace Features: Basement, Living Room
Heating Features: Forced Air, Natural Gas
Number of Fireplaces: 2

Dining Room Level: Main
Kitchen Level: Main

Fire Pit
Garden
Gas Valve
Private Yard
Rain Gutters
Fencing: Full
Patio And Porch Features: Covered, Front Porch, Patio

Attached Garage: Yes
Garage Spaces: 3
Parking Features: Concrete, Dry Walled, Exterior Access Door, Finished, Floor Coating, Insulated, Storage
Parking Total: 3

Lot Description: Cul-De-Sac, Greenbelt, Landscaped, Many Trees, Sprinklers In Front, Sprinklers In Rear
Lot Size Acres: 1.0
Lot Size Square Feet: 43560

View: Meadow, Mountain(s)
Security Features: Carbon Monoxide Detector(s), Security System, Smoke Detector(s)

Association: Yes
Association Fee: 200
Association Fee Frequency: Annually
Calculated Total Monthly Association Fees: 17
Association Name: Ashwood
Association Phone: 3034725137
Pets Allowed: Yes

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.7 miles away.
directions icon Map directions

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

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

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

Annual Tax Amount: 9753.00
Source Listing Status: Closed
County: Broomfield
Directions: Head north on I-25 N. Take exit 226 for 144th Avenue. Use the left lane to take the ramp to Westminster. Turn left onto E 144th Ave. Turn right onto Zuni St. Turn left onto Stellas Meadow Dr. Destination will be on the right.
Tax Year: 2023
Source Property Type: Residential
Source Neighborhood: Green Family Farm Estates
Parcel Number: R8866225
Subdivision: Green Family Farm Estates
Zoning: A-1(A)
Property Subtype: Single Family Residence
Source System Name: C2C

YearAssessments
Building + Land
Total
Tax
2022$58,000 + $21,680
$79,680
$9,001
2021$59,670 + $22,310
$81,980
$9,282
2020$52,500 + $22,310
$74,810
$8,563
2019$52,500 + $22,310
$74,810
$8,567
2018$47,220 + $15,120
$62,340
$7,352
2017$47,220 + $15,120
$62,340
$6,697
2016$41,680 + $15,340
$57,020
$6,286
2015$41,680 + $15,340
$57,020
$6,286
2014$37,150 + $14,610
$51,760
$5,863
2013$37,150 + $14,610
$51,760
$5,663
2011$39,260 + $14,610
$53,870
$5,978
2010$39,260 + $14,610
$53,870
$3,541
2009$unknown + $31,880
$31,880
$3,537
2008$unknown + $80
$80
$13
2007$unknown + $80
$80
$13

Sold 2024-04-30
$1,650,000
REcolorado
Listed 2024-04-11
$1,700,000
REcolorado
Sold 2009-10-22
$185,000
Public Record

Total Square Feet Living: 4167
Year Built: 2010
Above Grade Finished Area: 2698
BelowGradeFinishedArea: 1469
Below Grade Unfinished Area: 1229.00
Common Walls: No Common Walls
Construction Materials: Brick, Frame
Levels: One
Property Age: 14
Roof: Composition
Structure Type: House

Sewer: Public Sewer
Cable Available
Electricity Connected
Internet Access (Wired)
Natural Gas Connected
Phone Available
Water Source: Public

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.