Welcome to 615 W 174th Pl in Broomfield—a thoughtfully designed home with modern upgrades and exceptional style. The kitchen is a chef’s dream with stainless steel appliances, a spacious shiplap-accented island with seating, a pantry, a dining nook, updated subway tile backsplash, and updated pendant lighting. The inviting family room offers a custom electric fireplace with shiplap detailing and large sliding glass doors that lead to an added Trex deck, perfect for seamless indoor/outdoor entertaining. The main level also includes a drop zone with a custom board-and-batten wall and wood bench, storage area with crawl space access, and a powder room with a shiplap accent wall. Upstairs, the primary suite provides a serene retreat with a barn door entry to the ensuite bathroom and a walk-in closet. Two additional bedrooms, a full bathroom, and a convenient laundry room with an included washer and dryer complete the upper level. This home comes equipped with smart technology, including a Rachio sprinkler control, Nest thermostat, and Ring doorbell. The 2-car insulated garage adds efficiency and comfort. Located in a fantastic community near local grocery stores, restaurants, and shops, with easy access to I-25, Denver, Boulder, and DIA. Don’t miss the chance to make this stunning property yours!
Last Agent to Sell the Property
RE/MAX Northwest Inc Brokerage Email: psubry@coloradohomesales.com,303-898-7783 License #040024437
Co-Listed By
RE/MAX Northwest Inc Brokerage Email: psubry@coloradohomesales.com,303-898-7783 License #100092787
Home Type
Est. Annual Taxes
Year Built
Lot Details
HOA Fees
Parking
Home Design
Interior Spaces
Kitchen
Flooring
Bedrooms and Bathrooms
Laundry
Outdoor Features
Schools
Utilities
Listing and Financial Details
Overview
Recreation
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 01/30/2025 01/30/25 | Sold | $575,000 | 0.0% | $282 / Sq Ft |
| 01/13/2025 01/13/25 | Pending | -- | -- | -- |
| 01/09/2025 01/09/25 | For Sale | $575,000 | -- | $282 / Sq Ft |
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2024 | $5,927 | $33,020 | $9,040 | $23,980 |
| 2023 | $5,713 | $38,090 | $10,430 | $27,660 |
| 2022 | $4,809 | $28,010 | $7,510 | $20,500 |
| 2021 | $4,863 | $28,810 | $7,720 | $21,090 |
| 2020 | $4,630 | $27,540 | $7,510 | $20,030 |
| 2019 | $4,647 | $27,730 | $7,560 | $20,170 |
| 2018 | $1,604 | $9,580 | $9,580 | $0 |
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $517,500 | New Conventional | |
| Previous Owner | $396,500 | New Conventional | |
| Previous Owner | $401,500 | New Conventional | |
| Previous Owner | $397,200 | New Conventional | |
| Previous Owner | $390,175 | New Conventional |
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Special Warranty Deed | $575,000 | None Listed On Document | |
| Interfamily Deed Transfer | -- | None Available | |
| Interfamily Deed Transfer | -- | None Available | |
| Special Warranty Deed | $410,711 | First American Title |
$544,900
Discover this Rare Brandywine Ranch ready to be loved. This home has been refreshed inside and out. Outside, a brand new front porch and landscaping grants a stunning curb appeal, only enhanced be the freshly painted exterior. Inside, brand new Luxury Vinyl Plank provides a welcoming warmth, contrasting with the clean freshly painted walls. Almost everything in the home has been updated to
Chad Meredith Engel & Volkers Denver
$600,000
Welcome to 542 W 173rd Ave—nestled on a quiet cul-de-sac and backing to peaceful green space, this move-in ready gem combines comfort, space, and style in the heart of Broomfield.This thoughtfully designed home offers 4 spacious bedrooms—including a main-floor office that doubles as a fully conforming bedroom—and 3 full bathrooms across 2,129 square feet of beautifully maintained living
Nicole Wolf Coldwell Banker Realty 56
$585,000
Stunning Turn-Key Home Backing to Open Space in Broomfield! More photos coming 3/21Built in 2021, this beautifully designed two-story home offers modern finishes, a functional layout, and an unbeatable location in Palisade Park. Featuring 3 bedrooms, 2.5 bathrooms, and a versatile bonus space perfect for a home office, reading nook, or playroom, this home is designed for both comfort and
Elizabeth Boone Camber Realty, LTD
$573,000
Nestled in the heart of Palisade Park, this charming 3-bedroom 3-bathroom home is a haven of comfort and modern living. From the moment you arrive, you’re greeted with a beautiful exterior complete with a covered front porch, fragrant rose bushes, video doorbell, and a two-car attached garage. As you step into the inviting foyer, you're welcomed by luxury vinyl floors that seamlessly flow through
Kristina Casinelli USAJ Realty
$577,500
Discover your perfect lifestyle fit in this delightful Palisade Park home. This welcoming 3-bedroom, 3-bathroom residence offers a blend of modern convenience and cozy charm. The inviting exterior features a lovely covered front porch. The Ring video doorbell helps you see all your deliveries and greet anyone at your front door. Step inside to the open-concept main level, where durable luxury
Jason Cassidy Sunstone Real Estate Services
$699,000
Embrace the Colorado Lifestyle in this Stunning Broomfield Home!This is the home you've been dreaming of! Perfectly situated in a thriving community, this beautifully maintained 4-bedroom home boasts a versatile loft, a main-floor office, a NEW ROOF, and FRESH EXTERIOR PAINT. With an unfinished basement ready for your personal touch, this home provides all the space you need now with room to
Morgan Jansen Keller Williams Preferred Realty
$694,000
Seller may consider buyer concessions if made in an offer. Welcome to this beautifully maintained home that exudes comfort and style. The interior boasts a neutral color paint scheme, enhancing the warmth of the fireplace. The kitchen is a chef's dream, complete with all stainless steel appliances, an accent backsplash and a center island. The primary bathroom offers double sinks, a separate tub,
Tara Jones Opendoor Brokerage LLC
$637,663
Take advantage of a FREE ROOFTOP PATIO PLUS $20K LENDER CREDIT when using Berkeley Homes' approved lenders.This beautifully designed home provides the perfect blend of functionality and livability. The ground level features a bedroom with connected full bathroom. The living room is tucked at the back of the home with sprawling windows. The gourmet kitchen offers plenty of room to
Tracy Owens Colorado Mountain Home RE
Source: REcolorado®
MLS Number: 7889121
APN: 1467-34-1-24-017
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
The content relating to real estate for sale in this Web site comes in part from the Internet Data eXchange (“IDX”) program of METROLIST, INC., DBA RECOLORADO®. Real estate listings held by brokers other than Ten-X are marked with the IDX Logo. This information is being provided for the consumers’ personal, non-commercial use and may not be used for any other purpose. All information subject to change and should be independently verified.
This publication is designed to provide information with regard to the subject matter covered. It is displayed with the understanding that the publisher and authors are not engaged in rendering real estate, legal, accounting, tax, or other professional services and that the publisher and authors are not offering such advice in this publication. If real estate, legal, or other expert assistance is required, the services of a competent, professional person should be sought.
The information contained in this publication is subject to change without notice. METROLIST, INC., DBA RECOLORADO MAKES NO WARRANTY OF ANY KIND WITH REGARD TO THIS MATERIAL, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. METROLIST, INC., DBA RECOLORADO SHALL NOT BE LIABLE FOR ERRORS CONTAINED HEREIN OR FOR ANY DAMAGES IN CONNECTION WITH THE FURNISHING, PERFORMANCE, OR USE OF THIS MATERIAL.
PUBLISHER’S NOTICE: All real estate advertised herein is subject to the Federal Fair Housing Act and the Colorado Fair Housing Act, which Acts make it illegal to make or publish any advertisement that indicates any preference, limitation, or discrimination based on race, color, religion, sex, handicap, familial status, or national origin.
METROLIST, INC., DBA RECOLORADO will not knowingly accept any advertising for real estate that is in violation of the law. All persons are hereby informed that all dwellings advertised are available on an equal opportunity basis.
© 2025 METROLIST, INC., DBA RECOLORADO® – All Rights Reserved. 6455 S. Yosemite St., Suite 500 Greenwood Village, CO 80111 USA
ALL RIGHTS RESERVED WORLDWIDE. No part of this publication may be reproduced, adapted, translated, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior written permission of the publisher. The information contained herein including but not limited to all text, photographs, digital images, virtual tours, may be seeded and monitored for protection and tracking.