Property Map
Street View
Courtesy of Orchard Brokerage LLC {attribution_contact}
Description
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 coming 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 endless 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.
Property Details and Features
Property Access
- Road Frontage Type: “Public”
- Road Responsibility: “Public Maintained Road”
- Road Surface Type: “Paved”
Appliances & Equipment
- “Dishwasher”, “Microwave”, “Oven”, “Refrigerator”
Basement
- Basement
- “Partial”, “Unfinished”
- Bathrooms: 0
- Bedrooms: 0
Bathrooms
- 4 total baths
- 1 half bath
- 3 full baths
- 1 bathroom on the main level
- 3 bathrooms on the upper level
Bedrooms
- 5 total bedrooms
- 5 bedrooms on the upper level
Building
- Above Grade Finished Area: 2808
- Architectural Style: “Traditional”
- Below Grade Finished Area: 0
- Below Grade Unfinished Area: 588.00
- Construction Materials: “Frame”, “Wood Siding”
- Direction Faces: South
- Levels: “Two”
- Living Area: 2808
- Occupant Type: Tenant
- Room Count: 16
- Structure Type: “House”
- Total Area: 3396
- Built in 2019
Cooling
- Cooling: “Central Air”
Disclosures
- Attribution Contact: laura.michaud@orchard.com,970-817-1508
- Exclusions: Personal Property
- Restrictions Covenants
- Restrictions Covenants: Other
Exterior Features
- Features: “Private Yard”, “Rain Gutters”
- Patio And Porch Features: “Covered”, “Front Porch”, “Patio”
Floors
- Flooring: “Carpet”, “Vinyl”
Garage
- Attached Garage
- 3 garage spaces
Heating
- Heating: “Forced Air”
Home Owner’s Association
- Home Owners Association
- Association Name: Hearthstone Community Association, Inc c/o Advance
- Association Fee: $58
- Association Fee Total Annual: $690
- Association Fee Annual: 690.00
- Association Fee Frequency: Monthly
- Association Management Type: Professionally Managed
- Association Fee Includes: “Maintenance Grounds”, “Recycling”, “Snow Removal”, “Trash”
- Association Amenities: “Park”, “Playground”
- Association Fee 2 Annual Expense: 0.00
- Association Fee 3 Annual Expense: 0.00
Heating & Cooling
- Description: Dual HV/AC & Furnace
Interior Features
- Features: “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: Unfurnished
Laundry
- Features: “In Unit”
Listing
- Listing Id: REC7406308
- Standard Status: Active
- Mls Status: Active
- Listing Contract Date: 2024-04-27
- Listing Terms: “1031 Exchange”, “Cash”, “Conventional”, “FHA”, “VA Loan”
- Original List Price: $779,000
- Special Listing Conditions: “None”
Location
- County Or Parish: Broomfield
- Subdivision Name: Palisade Park Filing 4 Rep A
Lot
- Acres: 0.13
- Area: 0.13
- Parcel Number: R8873542
- Square Feet: 5662.8
Energy Saving
- Green Verification Count: 0
Owner Pays
- Ownership: Individual
Parking
- Parking Total: 3
- Carport Spaces: 0
- Offstreet Spaces: 0
- Reserved Spaces: 0
- RV Spaces: 0
- Parking Count: 1
Property
- Livable Structure Count: 0
- Out Building Count: 0
- Property Sub Type: Single Family Residence
- Zoning: PUD
Roof
- Roof: “Architecural Shingle”
Schools
- Elementary School: Black Rock
- Elementary School District: St. Vrain Valley RE-1J
- Middle Or Junior School: Erie
- Middle Or Junior School District: St. Vrain Valley RE-1J
- High School: Erie
- High School District: St. Vrain Valley RE-1J
Security Features
- Features: “Carbon Monoxide Detector(s)”, “Smoke Detector(s)”
Sewer
- Sewer: “Public Sewer”
Taxes
- Annual Amount: 8083
- Legal Description: SUBD: PALISADE PARK FILING NO 4 REPLAT A LOT: 20 BLOCK: 1 S: 34 T: 1N R: 68W
- Tax Year: 2023
Utilities
- Power Production Count: 0
- Utilities: “Electricity Connected”, “Internet Access (Wired)”, “Phone Available”
- Water Included
- Water Source: “Public”
Windows
- Window Features: “Double Pane Windows”