Opportunity knocks at this address! Fixer or flip opportunity in Centaur Village North, close to Waneka Lake Park, ready for a complete interior remodel and priced accordingly. On a large .23 acre lot, the exterior and infrastructure are in top condition with excellent paint, newer driveway, & 2019 roof. Other enhancements incl Pella wood windows & sliding glass door, replacement furnace & Carrier A/C, water softener, gas fireplace, & stamped concrete patio. Inside, the main floor full bath has been remodeled with the rest of the home in original condition. The basement family rm has a counter, sink & fireplace. A 4th bdrm, unfinished, non-conforming 5th bdrm or office, and large storage & utility rooms round out the basement. The popcorn ceilings have been tested and are asbestos-free. Only the inside of the shell of this home needs attention, everything else is solid. Lafayette allows assessory dwelling units (ADUs) and additions in SFR zoning. This description was crafted by a human being.
Home Type
Est. Annual Taxes
Year Built
Lot Details
Parking
Home Design
Interior Spaces
Kitchen
Flooring
Bedrooms and Bathrooms
Laundry
Outdoor Features
Schools
Utilities
Community Details
Listing and Financial Details
$669,000
***NEW GREAT PRICE // MOTIVATED SELLER // + LENDER PAID RATE BUY DOWN!! We are offering a lender-paid 1 year temporary rate buydown, meaning that you could have a 1% lower interest rate for the 1st year of your loan! This could equate to a +/- $350-400 per month savings for your buyer (depending on the loan amount and other variables). Contact us for more details***. Welcome to 1245 Ceres Drive
Sarah Piampiano 8z Real Estate
$675,000
Ask us about a rate buy down! Sellers are motivated! Welcome to this beautifully maintained single family home in Hearthwood, ideally situated on a quiet cul de sac just steps away from Waneka Lake Park. With 4 bedrooms, 3 bathrooms, and 2,144 sqft of living space, this 1984-built gem offers a perfect blend of comfort and Colorado charm. Vaulted ceilings and abundant natural light enhance the
Nikki Harper Keller Williams Avenues Realty
$629,900
Nestled in a cul-de-sac, this Churchill Pointe home is perfectly framed by serene parks that allow for picturesque mountain views. Inside, vaulted ceilings and fresh paint enhance the open floorplan. A cozy wood-burning fireplace anchors the living area featuring a wide picture window with views of Long’s Peak. The bright kitchen is a cook's haven with granite countertops, a pantry, breakfast
Jordan Saul Milehimodern
$715,000
Price drop!!! Amazing location 5 minutes to downtown Louisville or Lafayette with so many possibilities. Investors, flippers, or looking for a place to live and keep your horse? House is 1940's ranch, .95 acre lot with zoning A. Property strictly sold "AS IS". The owner will not make any repairs or improvements to property. Septic is a leech field. Buyer to perform their own due diligence on this
Ryan Mogan First Summit Realty
$570,000
Beautifull permitted remodel, so close to Boulder but without the Boulder price tag. Nestled in a serene cul-de-sac, this stunning 3-bedroom, 2-bathroom residence blends elegance and comfort to create the perfect retreat for any family. Step inside to be greeted by an open-concept living area that flows seamlessly into the gourmet kitchen, complete with stainless steel appliances, gas stove,
Luis Ramirez Boutique Homes LLC
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | $880,000 | Chicago Title | |
| Special Warranty Deed | $599,900 | None Listed On Document | |
| Deed | $580,000 | None Listed On Document | |
| Interfamily Deed Transfer | -- | None Available | |
| Quit Claim Deed | -- | -- | |
| Deed | -- | -- | |
| Deed | $102,000 | -- | |
| Warranty Deed | $80,000 | -- |
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $640,000 | New Conventional | |
| Previous Owner | $596,250 | Construction |
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 07/11/2025 07/11/25 | Sold | $880,000 | -2.1% | $686 / Sq Ft |
| 06/06/2025 06/06/25 | For Sale | $899,000 | +55.0% | $701 / Sq Ft |
| 02/20/2025 02/20/25 | Sold | $580,000 | +1.5% | $231 / Sq Ft |
| 02/11/2025 02/11/25 | Pending | -- | -- | -- |
| 02/05/2025 02/05/25 | For Sale | $571,325 | -- | $227 / 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 | $3,207 | $41,600 | $19,700 | $21,900 |
| 2024 | $3,207 | $41,600 | $19,700 | $21,900 |
| 2023 | $3,152 | $42,893 | $19,698 | $26,880 |
| 2022 | $2,575 | $34,360 | $15,380 | $18,980 |
| 2021 | $2,547 | $35,350 | $15,823 | $19,527 |
| 2020 | $2,303 | $32,347 | $12,656 | $19,691 |
| 2019 | $2,271 | $32,347 | $12,656 | $19,691 |
| 2018 | $1,880 | $27,792 | $12,132 | $15,660 |
| 2017 | $1,830 | $32,086 | $13,452 | $18,634 |
| 2016 | $1,657 | $26,006 | $9,791 | $16,215 |
| 2015 | $1,553 | $18,070 | $5,652 | $12,418 |
| 2014 | $874 | $18,070 | $5,652 | $12,418 |
Seller's Agent in 2025
León Ramirez
Compass - Denver
(303) 437-9495
50 Total Sales
Seller's Agent in 2025
Paul Dart
RE/MAX
78 Total Sales
Buyer's Agent in 2025
Andre Mazur
Compass - Boulder
(720) 298-0174
81 Total Sales
Buyer's Agent in 2025
Justin Rafter
(720) 909-9789
29 Total Sales
Source: IRES MLS
MLS Number: 1025856
APN: 1575044-11-022
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.
Information source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules © Copyright IRES.
Listing information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Information deemed reliable but not guaranteed by the MLS.