Please stand by.
USDAProperties.com is sifting through the details...

 

 

 

$775,000   Price Analysis
Agent List  share icon     map icon  QR
597 W 174th Ave
Broomfield, CO 80023
5 bed 4 bath 3,396 SqFt ($228/SqFt)
5,663SqFt lot. Built 2019
Listed 2024-04-27, HOA $57, Taxes $6,592
Ⓧ USDA Ineligible
due to price & location

near Broomfield

MUST SEE THIS turnkey 5 bedroom

4 bathroom home with room with a perfect blend of space, comfort and potential, ideal for those seeking a dream home to call their own. Situated in a tranquil neighborhood with parks and a playground, homeowners will be close to I-25 and minutes from Erie. With 3 1/2 bathrooms, including a primary en-suite, convenience and luxury are seamlessly combined. The main floor welcomes you with an abundance of natural light flowing through large windows, illuminating the open-concept living spaces. The well-appointed kitchen is equipped with modern appliances, ample cabinet space, a walk-in pantry, granite counters and an eat-in island. Adjacent to the kitchen is a mudroom entry from the 3-car tandem garage that provides bonus space for cming and going. Ascend the staircase to discover the expansive bedrooms, each offering comfort and privacy. Don't miss the oversized laundry room on the 2nd floor for convenience. The massive owner's suite is complete with coffered ceilings and a HUGE walk-in closet. For those with a vision for customization, the unfinished basement presents unlimited possibilities. Step outside to the backyard, where a landscaped yard with an oversized concrete patio awaits. Located in the heart of Broomfield, this home is surrounded by parks, schools, shopping and dining options, ensuring every need is met. Don't miss your chance to make 597 W 174th Ave your forever home. Schedule a showing today and experience the epitome of Colorado living!

Click the Virtual Tour link to view the 3D walkthrough. Discounted rate options may be available for qualified buyers of this home.


Presented by Laura Michaud at
Orchard Brokerage LLC.


Property MLS #7406308 from REcolorado

Bedrooms: 5
Primary Bedroom Dimensions: 16.7 x 14.4
Bedroom 1 Dimensions: 15.1 x 11.6
Bedroom 2 Dimensions: 12.1 x 10.4
Bedroom 3 Dimensions: 13.9 x 9.1
Bedroom 4 Dimensions: 10.8 x 12.1
Primary Bedroom Level: Upper
Bedroom 1 Level: Upper
Bedroom 2 Level: Upper
Bedroom 3 Level: Upper
Bedroom 4 Level: Upper

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

Breakfast Nook
Eat-in Kitchen
Entrance Foyer
Five Piece Bath
Granite Counters
Kitchen Island
Pantry
Primary Suite
Solid Surface Counters
Walk-In Closet(s)
Furnished Description: Unfurnished
Flooring: Carpet, Vinyl
Window Features: Double Pane Windows

Dishwasher
Microwave
Oven
Refrigerator
Laundry Features: In Unit

Bathroom (1/2) Level: Main
Bathroom (1/2) Width: 5.80
Bathroom (1/2) Length: 5.70
Laundry Level: Upper
Laundry Width: 8.80
Laundry Length: 9.00
Bathroom (Full) Level: Upper
Bathroom (Full) Width: 12.11
Bathroom (Full) Length: 5.00
Primary Bathroom (Full) Level: Upper
Primary Bathroom (Full) Width: 10.11
Primary Bathroom (Full) Length: 9.40
Bathroom (Full) 2 Level: Upper
Bathroom (Full) 2 Width: 4.90
Bathroom (Full) 2 Length: 7.90
Living Room Dimensions: 17.5 x 16.1
Mud Room Dimensions: 12.2 x 6.9
Office/Study Room Dimensions: 14.4 x 11.4
Living Room Level: Main
Mud Room Level: Main
Office/Study Room Level: Main
Basement Description: Partial, Unfinished

Cooling Features: Central Air
Heating Features: Forced Air

Dining Room Dimensions: 12.1 x 8.1
Dining Room Level: Main
Kitchen Dimensions: 14.1 x 11.1
Kitchen Level: Main

Private Yard
Rain Gutters
Patio And Porch Features: Covered, Front Porch, Patio
Road Frontage Type: Public Road
Road Responsibility: Public Maintained Road
Road Surface Type: Paved

Builder Model: Golden

Attached Garage: Yes
Garage Spaces: 3
Parking Total: 3

Lot Size Acres: 0.13
Lot Size Square Feet: 5663

Association: Yes
Association Amenities: Park, Playground
Association Fee: 57
Association Fee Frequency: Monthly
Association Fee Includes: Maintenance Grounds, Recycling, Snow Removal, Trash
Calculated Total Monthly Association Fees: 57
Association Name: Hearthstone Community Association, Inc c/o Advance
Association Phone: 3034822213

Elementary School: Black Rock
Elementary School District: St. Vrain Valley RE-1J
High School: Erie
High School District: St. Vrain Valley RE-1J
Middle School: Erie
Middle or Junior School District: St. Vrain Valley RE-1J

Black Rock Elementary School is a public elementary school located approximately 1.5 miles away.
directions icon Map directions

Erie High School is a public high school located approximately 2.8 miles away.
directions icon Map directions

Erie Middle School is a public middle school located approximately 4.3 miles away.
directions icon Map directions

Vista Ridge Academy is a private elementary and middle school located approximately 1.4 miles away.
directions icon Map directions

Annual Tax Amount: 8083.00
Source Listing Status: Active
County: Broomfield
Directions: Please use GPS.
Tax Year: 2023
Source Property Type: Residential
Exclusions: Personal Property
Source Neighborhood: Palisade Park Filing 4 Rep A
Parcel Number: R8873542
Subdivision: Palisade Park Filing 4 Rep A
Zoning: PUD
Property Subtype: Single Family Residence
Source System Name: C2C

YearAssessments
Building + Land
Total
Tax
2022$30,890 + $7,510
$38,400
$6,592
2021$31,780 + $7,720
$39,500
$6,667
2020$29,540 + $7,510
$37,050
$6,228
2019$2,950 + $7,510
$10,460
$1,765
2018$unknown + $9,580
$9,580
$1,603
2017$unknown + $10
$10
$6

Price Changed 2024-05-10
$775,000
REcolorado
Listed 2024-04-27
$779,000
REcolorado
Sold 2019-10-08
$537,762
Public Record
Listing removed 2019-10-01
$0
REcolorado
Price Changed 2019-08-05
$537,762
REcolorado
Price Changed 2019-07-08
$534,342
REcolorado
Price Changed 2019-06-10
$537,342
REcolorado
Price Changed 2019-05-20
$534,342
REcolorado
Price Changed 2019-05-01
$529,872
REcolorado
Price Changed 2019-03-28
$526,232
REcolorado
Price Changed 2019-03-18
$536,232
REcolorado
Price Changed 2019-02-15
$531,515
REcolorado
Price Changed 2019-02-04
$534,315
REcolorado
Price Changed 2019-01-31
$533,315
REcolorado
Listed 2019-01-25
$497,600
REcolorado

Total Square Feet Living: 2808
Year Built: 2019
Above Grade Finished Area: 2808
Builder Name: Taylor Morrison
Below Grade Unfinished Area: 588.00
Construction Materials: Frame, Wood Siding
Direction Faces: South
Levels: Two
Property Age: 5
Roof: Architectural Shingles
Structure Type: House
Architectural Style: Traditional

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

Security Features: Carbon Monoxide Detector(s), Smoke Detector(s)
Click Thumbnail Images To View Full Size
garagegaragegarageunknownunknown
unknownliving_roomliving_roomliving_roomdining_room
dining_roomkitchenkitchenkitchenkitchen
kitchenunknownbathroombedroombedroom
bedroombedroomunknownbathroomliving_room
bedroombedroomlaundry_roomporchporch
house_viewhouse_viewhouse_viewroad_viewfloor_plan
floor_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.