Please stand by.
USDAProperties.com is making sense of this chaotic market...

 

 

 

$1,500,000
Agent Details  share icon     map icon  QR
15201 Huron St
Broomfield, CO 80023
5 bed 5 bath 5,279 SqFt ($284/SqFt)
2.23 acre lot. Built 1977
Listed 2023-07-21, Taxes $6,780
Ⓧ USDA Ineligible
due to price & location

near Broomfield

Latest Value Estimates: $1,485,000 from Collateral Analytics on 2024-04-17. $1,465,200 from CoreLogic on 2024-04-01. $1,570,703 from Quantarium on 2024-04-03. Forecast Estimate Value:$1,507,030 in 2025-02-01 by Collateral Analytics. $1,548,208 in 2025-04-01 by CoreLogic. $1,634,950 in 2025-04-01 by Quantarium.

Welcome!

This one-of-a-kind horse property retreat, a truly eclectic home combines elegance, comfort and a touch of whimsy.Nestled in a picturesque setting, this property offers an array of amenities to meet all your desires.Upon entering this property you are greeted by a charmi ng foyer that exudes character and invites you to explore the wonders within.A uniquely designed main floor that blends three living areas, creating an ideal space for both intimate gatherings and grand entertaining.The natural light floods the area highlighting the unique architectural details & enhancing the overall ambiance.One living area features floor to ceiling fireplace, a large window with vaulted ceilings.The second living area is designed for entertainment with large bar area, natural light and views. This area also houses the indoor jaccuzzi, steam room, & sauna.The third living area is perfect for intimate conversations & enjoying a good book.Spacious dining room for hosting dinner parties & creating lasting memories.The open kitchen with its modern appliances, sleek countertops, custom cabinetry and ample storage space.This home office has built in shelving, & ample desk space.The upper level master suite provides a private sanctuary with fireplace, big layout, open concept bathroom, sunk in jetted tub, offering a peaceful retreat after a long day.Step onto your private balcony with a morning cup of coffee, & soak in the breathtaking views.Two additional spacious bedrooms with plenty of closet space, large windows, & jack-n-jill bathroom.The lower level a spacious family room awaits along with two bedrooms & a bathroom.Beyond the main residence is a barn with horse stalls, a large workshop, equipped with everything you need for your business.The outdoor swimming pool & pool shed for chnging & entertaining.In conclusion this property combines a uniquely home with a range of amenities that cater to every aspect of your lifestyle.The space allowed is not enough, YOU MUST SEE IT TO BELIEVE IT!

Welcome! this one-of-a-kind horse property retreat, a truly eclectic home combines elegance, comfort and a touch of whimsy.Nestled in a picturesque setting, this property offers an array of amenities to meet all your desires.Upon entering this property you are greeted by a charmi ng foyer that exudes character and invites you to explore the wonders within.A uniquely designed main floor that blends three living areas, creating an ideal space for both intimate gatherings and grand entertaining.The natural light floods the area highlighting the unique architectural details & enhancing the overall ambiance.One living area features floor to ceiling fireplace, a large window with vaulted ceilings.The second living area is designed for entertainment with large bar area, natural light and views. This area also houses the indoor jaccuzzi, steam room, & sauna.The third living area is perfect for intimate conversations & enjoying a good book.Spacious dining room for hosting dinner parties & creating lasting memories.The open kitchen with its modern appliances, sleek countertops, custom cabinetry and ample storage space.This home office has built in shelving, & ample desk space.The upper level master suite provides a private sanctuary with fireplace, big layout, open concept bathroom, sunk in jetted tub, offering a peaceful retreat after a long day.Step onto your private balcony with a morning cup of coffee, & soak in the breathtaking views.Two additional spacious bedrooms with plenty of closet space, large windows, & jack-n-jill bathroom.The lower level a spacious family room awaits along with two bedrooms & a bathroom.Beyond the main residence is a barn with horse stalls, a large workshop, equipped with everything you need for your business.The outdoor swimming pool & pool shed for chnging & entertaining.In conclusion this property combines a uniquely home with a range of amenities that cater to every aspect of your lifestyle.The space allowed is not enough, YOU MUST SEE IT TO BELIEVE IT!


Presented by Kent Davis at
Berkshire Hathaway HomeServices Colorado Real Estate, LLC - Northglenn.


Property MLS #3390519 from REcolorado

Dishwasher
Disposal
Double Oven
Microwave
Range Hood
Refrigerator
Self Cleaning Oven
Laundry Features: In Unit

Bedrooms: 5
Bedrooms On Basement Level: 2
Primary Bedroom Dimensions: 15.2 x 15.7
Bedroom 1 Dimensions: 10.2 x 17.4
Bedroom 2 Dimensions: 10.2 x 17.4
Bedroom 3 Dimensions: 11.0 x 14.6
Bedroom 4 Dimensions: 10.4 x 11.3
Primary Bedroom Level: Upper
Bedroom 1 Level: Upper
Bedroom 2 Level: Upper
Bedroom 3 Level: Basement
Bedroom 4 Level: Basement

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

Built-in Features
Ceiling Fan(s)
Entrance Foyer
Five Piece Bath
High Ceilings
Jet Action Tub
Primary Suite
Sauna
Spa/Hot Tub
Utility Sink
Walk-In Closet(s)
Flooring: Carpet, Concrete, Tile, Wood

Bathroom (Full) Level: Main
Bathroom (Full) Width: 6.00
Bathroom (Full) Length: 14.40
Laundry Level: Main
Laundry Width: 9.80
Laundry Length: 10.70
Bathroom (Full) 2 Level: Main
Bathroom (Full) 2 Width: 9.50
Bathroom (Full) 2 Length: 6.50
Primary Bathroom (Full) Level: Upper
Primary Bathroom (Full) Width: 17.90
Primary Bathroom (Full) Length: 8.40
Bathroom (Full) 3 Level: Upper
Bathroom (Full) 3 Width: 6.10
Bathroom (Full) 3 Length: 12.00
Family Room 2 Level: Basement
Family Room 2 Width: 10.40
Family Room 2 Length: 22.60
Bathroom (3/4) Level: Basement
Bathroom (3/4) Width: 4.70
Bathroom (3/4) Length: 7.11
Utility Room Level: Basement
Utility Room Width: 11.70
Utility Room Length: 8.10
Bonus Room 4 Level: Basement
Bonus Room 4 Width: 11.70
Bonus Room 4 Length: 4.40
Extra Room-1 Dimensions: 16.1 x 13.9
Extra Room-3 Dimensions: 9.5 x 11.0
Family Room Dimensions: 14.0 x 22.0
Great Room Dimensions: 18.1 x 21.0
Living Room Dimensions: 22.2 x 15.7
Office/Study Room Dimensions: 15.4 x 11.6
Extra Room-1 Level: Main
Extra Room-2 Level: Main
Extra Room-3 Level: Main
Family Room Level: Main
Great Room Level: Main
Living Room Level: Main
Office/Study Room Level: Main
Basement Description: Finished

Cooling Features: Central Air
Fireplace Features: Family Room, Living Room, Primary Bedroom
Heating Features: Natural Gas
Number of Fireplaces: 3

Dining Room Dimensions: 23.3 x 15.7
Dining Room Level: Main
Kitchen Dimensions: 13.4 x 16.9
Kitchen Level: Main

Balcony
Private Yard
Spa/Hot Tub
Fencing: Full
Patio And Porch Features: Covered, Deck, Front Porch, Patio
Road Frontage Type: Public Road
Road Responsibility: Public Maintained Road
Road Surface Type: Dirt, Paved

Pool Features: Outdoor Pool
Spa Features: Steam Room

Lot Description: Many Trees, Secluded
Lot Size Acres: 2.23
Lot Size Square Feet: 97139

Garage Spaces: 2
Parking Features: Driveway-Dirt
Parking Total: 2

View: Meadow, Mountain(s), Plains
Security Features: Smoke Detector(s)

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

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

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

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

Horse Amenities: Loafing Shed, Pasture, Tack Room

Calculated Total Monthly Association Fees: 0

Annual Tax Amount: 6780.00
Source Listing Status: Active
County: Adams
Tax Year: 2022
Source Property Type: Residential
Exclusions: Sellers Personal Property in home and all out buildings
Source Neighborhood: Lay Subdivision
Parcel Number: R0178849
Subdivision: Lay Subdivision
Zoning: A-1
Property Subtype: Single Family Residence
Source System Name: C2C

YearAssessments
Building + Land
Total
Tax
2022$42,680 + $16,440
$59,120
$6,780
2021$43,910 + $16,920
$60,830
$7,002
2020$38,060 + $16,920
$54,980
$6,386
2019$38,060 + $16,920
$54,980
$6,391
2018$39,280 + $11,230
$50,510
$6,040
2017$39,280 + $11,230
$50,510
$5,511
2016$32,520 + $8,690
$41,210
$4,618
2015$32,520 + $8,690
$41,210
$4,607
2014$18,130 + $8,070
$26,200
$3,015
2013$18,130 + $8,070
$26,200
$2,908
2011$18,130 + $8,280
$26,410
$2,972
2010$18,130 + $8,280
$26,410
$2,976
2009$18,130 + $8,280
$26,410
$2,972
2008$15,440 + $8,280
$23,720
$2,656
2007$15,440 + $8,280
$23,720
$2,534

Listed 2023-07-21
$1,500,000
REcolorado
Sold 2013-12-31
$475,000
IRES
Relisted 2013-11-14
$499,900
IRES
Listing removed 2013-09-09
$499,900
IRES
Price Changed 2013-09-03
$499,900
IRES
Price Changed 2013-08-21
$529,900
IRES
Listed 2013-06-07
$559,900
IRES
Sold 2000-08-25
$525,000
Public Record
Sold 1991-07-03
$289,000
Public Record

Irrigation Source: Ditch

Total Square Feet Living: 5279
Year Built: 1977
Above Grade Finished Area: 4363
BelowGradeFinishedArea: 916
Construction Materials: Frame
Direction Faces: East
Foundation Details: Slab
Levels: Two
Property Age: 47
Roof: Composition
Structure Type: House

Electric: 110V, 220 Volts
Sewer: Septic Tank
Electricity Connected
Internet Access (Wired)
Natural Gas Available
Water Source: Well
Click Thumbnail Images To View Full Size
unknownhouse_viewkitchenkitchenliving_room
living_roomunknownkitchenunknownlaundry_room
dining_roomdining_roomliving_roomliving_roomliving_room
bedroombathroombedroombedroomunknown
bedroombedroombedroombedroombedroom
living_roomunknownunknownunknownpool
unknownunknownunknownunknownfloor_plan
floor_planfloor_planfloor_planfloor_planfloor_plan

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.