Seller's Agent in 2024
TEAM KAMINSKY
Landmark Residential Brokerage
(720) 226-8220
41 in this area
1,489 Total Sales
14668 Harvest Dr Longmont, CO 80504
Estimated Value: $554,789 - $612,000
4
Beds
3
Baths
2,767
Sq Ft
$207/Sq Ft
Est. Value
Highlights
- New Construction
- Primary Bedroom Suite
- Deck
- Mead Elementary School Rated A-
- Open Floorplan
- Granite Countertops
About This Home
As of May 2024You’ll love the versatile open-concept layout of the Aspen at Red Barn Meadows. As you enter the home, you'll find a lovely study off the foyer—an ideal spot for privacy and relaxation. A spacious kitchen is situated in the heart of the home—boasting a gracious walk-in pantry, a charming breakfast nook and a large center island. Other main floor highlights include a wide-open great room, a formal dining room and a sizable secondary bedroom with access to a full bathroom. Upstairs, there is a convenient laundry room, an expansive loft and three additional bedrooms, including the lavish primary suite—showcasing a roomy walk-in closet and a deluxe private bath with dual vanities and a walk-in shower. Home is complete and backs up to green space. Own our biggest home in a brand-new up and coming community! Photos are not of this exact property. They are for representational purposes only. Please contact builder for specifics on this property. Don’t miss out on the new reduced pricing good through 4/30/2024. Prices and incentives are contingent upon buyer closing a loan with builders affiliated lender and are subject to change at any time.
Last Agent to Sell the Property
Landmark Residential Brokerage Brokerage Email: team@landmarkcolorado.com,720-248-7653 Listed on: 04/02/2024
Last Buyer's Agent
Other MLS Non-REcolorado
NON MLS PARTICIPANT
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $5,562
Year Built
- Built in 2024 | New Construction
Lot Details
- 6,300 Sq Ft Lot
- Partially Fenced Property
- Front Yard Sprinklers
HOA Fees
- $155 Monthly HOA Fees
Parking
- 2 Car Attached Garage
Home Design
- Frame Construction
- Composition Roof
Interior Spaces
- 2,767 Sq Ft Home
- 2-Story Property
- Open Floorplan
- Double Pane Windows
- Laundry in unit
Kitchen
- Oven
- Microwave
- Dishwasher
- Kitchen Island
- Granite Countertops
- Disposal
Bedrooms and Bathrooms
- Primary Bedroom Suite
- Walk-In Closet
- 3 Full Bathrooms
Home Security
- Smart Thermostat
- Carbon Monoxide Detectors
- Fire and Smoke Detector
Outdoor Features
- Deck
- Covered Patio or Porch
Schools
- Mead Elementary And Middle School
- Mead High School
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
Community Details
- Red Barn Metro District Association, Phone Number (720) 213-6621
- Built by Century Communities
- Red Barn Subdivision, 39209 Aspen Floorplan
Listing and Financial Details
- Assessor Parcel Number R8972739
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Apr 2, 2024
Closed on
May 28, 2024
Sold by
Century Land Holdings Llc
Bought by
Sugai Jeremy and Sugai Greta
Seller's Agent
TEAM KAMINSKY
Landmark Residential Brokerage
Buyer's Agent
Other MLS Non-REcolorado
NON MLS PARTICIPANT
List Price
$569,990
Sold Price
$549,990
Premium/Discount to List
-$20,000
-3.51%
Views
8
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$21,457
Avg. Annual Appreciation
2.73%
Original Mortgage
$439,990
Outstanding Balance
$434,461
Interest Rate
7.1%
Mortgage Type
New Conventional
Estimated Equity
$136,986
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 | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Sugai Jeremy | $549,990 | Parkway Title |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Sugai Jeremy | $439,990 |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 05/28/2024 05/28/24 | Sold | $549,990 | -3.5% | $199 / Sq Ft |
| 04/29/2024 04/29/24 | Pending | -- | -- | -- |
| 04/02/2024 04/02/24 | For Sale | $569,990 | -- | $206 / 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 | $5,562 | $33,550 | $6,750 | $26,800 |
| 2024 | $5,562 | $33,550 | $6,750 | $26,800 |
| 2023 | $73 | $440 | $440 | $29,510 |
| 2022 | $63 | $370 | $370 | $0 |
| 2021 | $9 | $40 | $40 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
TEAM KAMINSKY
-
O
Buyer's Agent in 2024
Other MLS Non-REcolorado
NON MLS PARTICIPANT
Map
Source: REcolorado®
MLS Number: 3987170
APN: R8972739
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
- 5900 Sunrise Place
- 5881 Red Barn Ave
- Powell | Residence 39206 Plan at Red Barn Meadows
- Cimarron | Residence 39102 Plan at Red Barn Meadows
- Ontario | Residence 39205 Plan at Red Barn Meadows
- Marion | Residence 39208 Plan at Red Barn Meadows
- Livingston | Residence 39103 Plan at Red Barn Meadows
- Tahoe | Residence 39209 Plan at Red Barn Meadows
- 14462 Heritage Dr
- 14450 Heritage Dr
- 14438 Heritage Dr
- 14424 Heritage Dr
- 14378 Heritage Dr
- 14366 Heritage Dr
- 14440 Ranch St
- 14434 Ranch St
- 14420 Ranch St
- 14406 Ranch St
- 14398 Ranch St
- 115 Grand View Dr
- 14680 Harvest Dr
- 14584 Harvest Dr
- 5881 Sunrise Place
- 5901 Sunrise Place
- 14789 County Road 13
- 5890 Sunrise Place
- 5870 Sunrise Place
- 5880 Sunrise Place
- 14511 Colorado Blvd
- 14789 County Road 13
- 14795 County Road 13
- 14795 County Road 13
- 14507 County Road 13
- 5871 Red Barn Ave
- 5901 Red Barn Ave Unit 3
- 5901 Red Barn Ave
- 5843 Red Barn Ave
- 5835 Red Barn Ave
- 5817 Red Barn Ave
- 5949 Red Barn Ave