Seller's Agent in 2025
Debra Guy
RE/MAX
(720) 289-7299
1 in this area
276 Total Sales
17786 Olive St Broomfield, CO 80023
North Broomfield Neighborhood
4
Beds
3
Baths
2,477
Sq Ft
7,320
Sq Ft Lot
Highlights
- Primary Bedroom Suite
- Open Floorplan
- Contemporary Architecture
- Black Rock Elementary School Rated A-
- Deck
- Wood Flooring
About This Home
As of August 2025MOUNTAIN VIEWS & BACKS TO DEDICATED OPEN SPACE! Welcome to this stunning and thoughtfully designed 2-story home, perfectly situated to capture unobstructed gorgeous mountain views and offer comfortable, flexible living spaces throughout. With 4 spacious bedrooms, 3 full bathrooms, a dedicated home office, and a versatile loft/media room, this home provides the space and functionality today's homeowners are looking for. Step inside to a bright and inviting main level featuring an open-concept layout ideal for both everyday living and entertaining. The kitchen is the heart of the home and features a large quartz island, abundant cabinetry, and a walk-in pantry. Just off the kitchen is a generous living and dining area that flows effortlessly to the backyard, where you'll find a covered deck ideal for outdoor dining or relaxing with a view. Also on the main level is a bedroom and full bathroom, perfect for guests, or a main-level living option. A private den/office sits near the entryway, providing a quiet space to work from home. Upstairs, the expansive primary suite offers mountain views, a large walk-in closet, and an en-suite bathroom with dual sinks and a separate shower. Two additional bedrooms, a full bathroom, and a spacious loft/media room round out the upper level, creating a perfect spot for a home theater, playroom, or second living space. Additional highlights include an unfinished basement with endless potential, a 3-car garage for all your vehicles and gear, and thoughtful upgrades throughout. This home is located in a welcoming community that features a playground, picnic area, and access to a scenic trail and open space directly behind the property. Just minutes from a golf course, and conveniently located near shopping and dining at Larkridge Shopping Center, this home also offers easy access to commute to both Boulder and Denver. Don't miss your opportunity to own this beautiful, move-in ready home in one of the area's most desirable neighborhoods!
Last Agent to Sell the Property
RE/MAX of Cherry Creek Brokerage Email: DEBRA@GUYTEAMHOMES.COM License #40028617 Listed on: 05/01/2025
Co-Listed By
RE/MAX of Cherry Creek Brokerage Email: DEBRA@GUYTEAMHOMES.COM License #100069420
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $8,514
Year Built
- Built in 2021
Lot Details
- 7,320 Sq Ft Lot
- Property is Fully Fenced
- Private Yard
- Property is zoned PUD
HOA Fees
- $65 Monthly HOA Fees
Parking
- 3 Car Attached Garage
Home Design
- Contemporary Architecture
- Brick Exterior Construction
- Slab Foundation
- Frame Construction
- Composition Roof
- Radon Mitigation System
Interior Spaces
- 2-Story Property
- Open Floorplan
- Ceiling Fan
- Mud Room
- Living Room with Fireplace
- Dining Room
- Den
- Loft
- Utility Room
- Unfinished Basement
- Basement Fills Entire Space Under The House
- Fire and Smoke Detector
Kitchen
- Eat-In Kitchen
- Walk-In Pantry
- Oven
- Range
- Microwave
- Dishwasher
- Kitchen Island
- Quartz Countertops
Flooring
- Wood
- Carpet
- Tile
Bedrooms and Bathrooms
- Primary Bedroom Suite
Laundry
- Laundry Room
- Dryer
- Washer
Outdoor Features
- Deck
- Covered Patio or Porch
Schools
- Erie Elementary And Middle School
- Erie High School
Additional Features
- Ground Level
- Forced Air Heating and Cooling System
Listing and Financial Details
- Exclusions: Seller's personal property and curtains in bedrooms upstairs
- Assessor Parcel Number R8874183
Community Details
Overview
- Association fees include ground maintenance, recycling, snow removal, trash
- Advance HOA, Phone Number (303) 482-2213
- Palisade Park Subdivision
Recreation
- Community Playground
- Park
- Trails
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
May 1, 2025
Closed on
Aug 26, 2025
Sold by
Hernandez David Brian and Lamotta Lindsey Marie
Bought by
Macke David Christopher and Schieler-Macke Andrea Marie
Seller's Agent
Debra Guy
RE/MAX of Cherry Creek
Buyer's Agent
Marion Fisher
WK Real Estate
List Price
$760,000
Sold Price
$735,000
Premium/Discount to List
-$25,000
-3.29%
Views
119
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
45.15%
Original Mortgage
$588,000
Outstanding Balance
$588,000
Interest Rate
6.75%
Mortgage Type
New Conventional
Estimated Equity
$158,036
Purchase Details
Closed on
Jan 8, 2021
Sold by
Calatlantic Group Inc
Bought by
Hernandez David Brian and Lamotta Lindsey Mane
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$523,332
Interest Rate
2.71%
Mortgage Type
New Conventional
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Average Home Value in this Area
Purchase History
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Special Warranty Deed | $735,000 | None Listed On Document | |
| Special Warranty Deed | $572,100 | Lawyers Title |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $588,000 | New Conventional | |
| Previous Owner | $523,332 | New Conventional |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 08/26/2025 08/26/25 | Sold | $735,000 | -2.0% | $297 / Sq Ft |
| 06/16/2025 06/16/25 | Price Changed | $750,000 | -1.3% | $303 / Sq Ft |
| 05/01/2025 05/01/25 | For Sale | $760,000 | -- | $307 / Sq Ft |
Source: REcolorado®
Tax History Compared to Growth
Tax History
| 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 | $8,514 | $47,180 | $11,150 | $36,030 |
| 2024 | $8,514 | $47,080 | $10,340 | $36,740 |
| 2023 | $8,127 | $52,660 | $11,560 | $41,100 |
| 2022 | $7,159 | $41,520 | $8,670 | $32,850 |
| 2021 | $7,210 | $42,710 | $8,920 | $33,790 |
| 2020 | $3,897 | $23,180 | $23,180 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Debra Guy
-
Christopher Harvey
Seller Co-Listing Agent in 2025
Christopher Harvey
RE/MAX
(720) 438-8407
1 in this area
210 Total Sales
-
Marion Fisher
Buyer's Agent in 2025
Marion Fisher
WK Real Estate
(570) 854-5393
1 in this area
29 Total Sales
Map
Source: REcolorado®
MLS Number: 1733290
APN: 1467-27-4-09-004
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.
Nearby Homes
- 583 Olive St
- 17706 Cherokee St
- 513 176th Ave
- 17765 Faraday St
- 638 W 175th Ave
- 17848 Gallup St
- 509 W 175th Ave
- 587 W 174th Ave
- 577 W 174th Ave
- 718 176th Ave
- 581 W 173rd Place
- 17114 Elati St
- 17052 Melody Dr
- 690 W 172nd Place
- 17040 Galapago Ct
- 675 W 171st Place
- 17120 Lipan Dr
- 2550 175th Ave
- 17012 Lipan St
- 2083 Tundra Cir