Welcome to 595 W 174th Place, a beautifully upgraded two-story home in the sought-after Hearthstone community of Broomfield, CO. Built in 2018 by Taylor Morrison, this 4-bedroom, 3-bathroom residence offers 2,252 square feet of thoughtfully designed living space, perfect for modern lifestyles. The heart of the home is the expansive kitchen, featuring upgraded countertops, stainless steel appliances, a gas range with a stainless steel hood, 42" cabinets, a walk-in pantry, and a spacious island with pendant lighting. The open floor plan seamlessly connects the kitchen to the dining area and family room, creating an ideal space for entertaining. A main-floor bedroom and full bathroom provide convenience for guests or can serve as a home office. Upstairs, the oversized primary suite boasts a walk-in closet and a luxurious bathroom with dual sinks, an oversized shower, and a sliding barn door entry. Two additional bedrooms, a full bathroom with dual sinks, a versatile loft area, and a laundry room complete the upper level. Step outside to the 18' x 15' patio, perfect for summer barbecues, and enjoy the landscaped backyard with planter boxes and a sprinkler system. Additional features include central A/C, a 2-car garage with bike racks, a custom built-in mudroom organizer, and a garage keypad entry. Located on a quiet street near parks and walking/bike paths, this home offers easy access to Boulder, Denver, and DIA, as well as nearby shopping and dining options. Hearthstone HOA also provides the community with amazing opportunities to come together, including Food Trucks Bi-Weekly during the summer months and Pancake Breakfasts for everyone to enjoy. Don't miss the opportunity to own this stunning home in a prime location!
Last Agent to Sell the Property
eXp Realty, LLC Brokerage Email: gavin@apollogroup.com,720-456-1400 License #100065814 Listed on: 04/24/2025
$599,000
Location, location, location!! This is an AMAZING home across from the HUGE community park with beautiful mountain views. Enter into the home off of a nice private covered porch that faces the mountains. The kitchen is spacious with a huge center island, granite counters, crisp white cabinetry with crown moulding, a tile backsplash, chic pendant lighting, stainless steel appliances, pantry, gas
Taylor Bunney eXp Realty, LLC
$575,000
Stunning Turn-Key Home Backing to Open Space in Broomfield. Built 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 convenience.The
Elizabeth Boone Camber Realty, LTD
$775,000
A True Gem: Stunning Remodeled Farmhouse on One Acre in a Prime Broomfield Location. This beautifully remodeled farmhouse sits on a serene one-acre lot, offering the perfect blend of modern luxury and country charm. The property features a spacious 2-car attached garage plus an impressive 23x35 detached garage, providing ample space for vehicles, hobbies, and storage. Step inside to
Claire Gilmore MB KELL & COMPANY
$645,000
Highly desired Northmoor neighborhood with tree lined streets and estate sized lots. Newly painted ranch style home with 3 bedrooms, 2 bathroom, 2 car garage, AC. All new wide plank LVP floors, new interior paint, new solid surface countertops, new subway tile backsplash, newer stainless steel appliances, newer light fixtures. Private fully fenced backyard with stunning trees, large level
Claire Gilmore MB KELL & COMPANY
$504,300
Motivated seller= Great opportunity for you in a tranquil Broomfield location. Corner lot, close to two parks, open space and many restaurants. No HOA. Brand new roof with level 4 impact resistant shingles and new gutters. New exterior and interior paint. 2 bedrooms upstairs and 2 bedrooms on the lower level plus a flex space for the new owner to customize as an office, gym, or another bedroom.
Jill Clark Keller Williams DTC
$685,000
Upgraded and ideally located, this spacious home with a 3-car tandem garage offers style and convenience! Just a couple of homes away from the neighborhood park and near I-25—commuting to Denver, DIA, or Northern Colorado is made easy. Inside, enjoy an open main level with a spacious great room, full bathroom, main floor bedroom, and beautiful kitchen. The eat-in kitchen offers a large granite
Team Lassen MB Team Lassen
$699,500
Welcome to this beautifully maintained corner-lot home in sought-after Palisade Park, North Broomfield. Ideally located near Vista Ridge Golf Course, top-rated schools (8/10 GreatSchools), and just 12 mins to Boulder, 25 mins to Denver, with Costco, King Soopers, Safeway, and major shopping/dining within 10 minutes. This sun-filled home faces a large park with open lawn and playground, offering
Shuying Lou Good Neighbor LLC
$750,000
An immaculate former model home with loads of upgrades!Built in 2019 and maintained in nearly new condition, this stunning former model home sits on a desirable corner lot in a quiet corner, just steps from a beautiful park in the highly sought-after Palisade Park community.This thoughtfully designed two-story residence features 4 spacious bedrooms, 3 bathrooms, a versatile loft,
Lora Martinez West and Main Homes Inc
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | $615,000 | First American Title | |
| Warranty Deed | $521,000 | Equity Title Of Colorado | |
| Special Warranty Deed | $435,265 | First American Title |
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $492,000 | New Conventional | |
| Previous Owner | $489,250 | New Conventional | |
| Previous Owner | $415,870 | New Conventional | |
| Previous Owner | $413,502 | New Conventional |
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 05/20/2025 05/20/25 | Sold | $615,000 | +2.5% | $273 / Sq Ft |
| 04/24/2025 04/24/25 | For Sale | $600,000 | -- | $266 / 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 |
|---|---|---|---|---|
| 2025 | $6,707 | $38,380 | $10,050 | $28,330 |
| 2024 | $6,707 | $37,360 | $9,150 | $28,210 |
| 2023 | $6,464 | $42,580 | $10,430 | $32,150 |
| 2022 | $5,336 | $31,080 | $7,510 | $23,570 |
| 2021 | $5,397 | $31,970 | $7,720 | $24,250 |
| 2020 | $5,131 | $30,520 | $7,510 | $23,010 |
| 2019 | $5,150 | $30,740 | $7,560 | $23,180 |
| 2018 | $1,604 | $9,580 | $9,580 | $0 |
G
Seller's Agent in 2025
Gavin Monjaras
eXp Realty, LLC
M
Buyer's Agent in 2025
Maegan Christensen
Weichert Realtors Professionals
Source: REcolorado®
MLS Number: 7841669
APN: 1467-34-1-24-015
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.