Skip to content
×
Pro Members Get
Full Access!
Get off the sidelines and take action in real estate investing with BiggerPockets Pro. Our comprehensive suite of tools and resources minimize mistakes, support informed decisions, and propel you to success.
Advanced networking features
Market and Deal Finder tools
Property analysis calculators
Landlord Command Center
ANNUAL Save 16%
$32.50 /mo
$390 billed annualy
MONTHLY
$39 /mo
billed monthly
7 day free trial. Cancel anytime

Let's keep in touch

Subscribe to our newsletter for timely insights and actionable tips on your real estate journey.

By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions
Copied
Photo
Copied
Photo
Photo
Photo
Photo
See all photos

$1,050,000

Under Contract
759 Old Wagon Trail Cir, Lafayette, CO 80026
4 Beds
3 Baths
2,858 Square Feet
0.34 Acres Lot
Built in 2017
Under Contract
Units n/a
Checked: 2 hours ago
Updated: Sep 11, 2025 at 10:21AM

Investment Summary


Monthly Cash Flow
-$2,806
Cap Rate
2.5%
Cash-on-Cash Return
-13.9%
Debt Coverage Ratio
0.44
Internal Rate of Return (5 years)
-9.5%

Property Description


0.34 Acres Lot
Built in 2017
Under Contract
Units n/a

Gardener's Dream! This incredible home sits on one of the largest lots in the neighborhood and the owners have transformed it into a beautiful garden brimming with plant and pollinator life that you feel like you're in the country. It's the perfect place to connect with nature, grow your own food, and spend time with family and friends. Inside, the home's luxury finishes are enjoyed throughout the home, mostly notably felt in the kitchen, which is most certainly the anchor point of the home. It's oversized eat-in island - serves as a central place to prep, gather, and entertain. From there the plan opens into both the living room with a gas fireplace and the window filled breakfast/dining space. There is also a spacious office in the front of the house. All four bedrooms are on the upper level separated by a large loft for movies, play, or even a home gym. The unfinished basement is pre-plumbed with 9' ceilings and ready for you to make it your own. Step out the front door and on to the path for endless miles of local paths and local parks. Located between the downtowns of Louisville and Lafayette the home is in a fantastic location for enjoying the area and is also only 30min to downtown Denver and less than 15min to Boulder. The home is also equipped with a 6.1kw solar pv system for added efficiency and savings.

Build Your Team


Quickly find investor-friendly professionals who can help you succeed in real estate investing at any stage of the investing journey.

Avatar
Avatar
Avatar

Agents

Match with investor-friendly agents who can help you find, analyze, and close your next deal

Find an Agent
Avatar
Avatar
Avatar

Lenders

Get the best funding…find investor-friendly lenders who specialize in your deal strategy

Find a Lender
Avatar
Avatar
Avatar

Property Managers

Transition to passive investing. Find a trusted property management partnership that lasts.

Find a Property Manager
Avatar
Avatar
Avatar

Tax Pros & Accountants

Taxes and financial reporting made easy—find experts to create tax savings strategies, file taxes, and more

Find a Tax Pro

Location


Property Details


Parking

  • Description: Attached Garage
  • Details: Attached
  • Garage Spaces: 2
  • Spaces Total: 2

Bedroom Information

  • # of Bedrooms: 4

Bathroom Information

  • # of Baths (Full): 2
  • # of Baths (Partial): 1
  • # of Baths (Total): 3.0

Interior Features

  • # of Rooms: 11
  • # of Stories: 2
  • Basement: Yes
  • Basement Description: Bath/Stubbed, Full, Unfinished

Exterior Features

  • Exterior Walls Materials: Marble
  • Roof Material: Composition

HOA

  • Has HOA: Yes
  • Association: Trails at Coal Creek
  • HOA Fee: $65/monthly

Land Information

  • Land Use: Residential
  • Land Use Subtype: Single Family Residential

Lot Information

  • Parcel ID: 157510288016
  • Lot Size: 14756 sqft

Property Information

  • Property Type: Single Family Residence
  • Year Built: 2017

Tax Information

  • Annual Tax: $5,556

Utilities

  • Water & Sewer: Public
  • Heating: Forced Air
  • Cooling: Central Air

Location

  • County: Boulder

Listing Details


Listed by:
David Trow
Compass - Boulder
(303) 880-7255

Source:
REColorado
MLS#: IR1035001
REColorado

Investment Summary


Monthly Cash Flow
-$2,806
Cap Rate
2.5%
Cash-on-Cash Return
-13.9%
Debt Coverage Ratio
0.44
Internal Rate of Return (5 years)
-9.5%

Purchase Details

Find an Agent

Purchase price:
$1,050,000
Amount financed:
-$840,000
Down payment:
$210,000
Closing costs:
$31,500
Rehab costs:
$0
Initial cash invested:
$241,500
Square feet:
2,858
Cost per square foot:
$367
Monthly rent per square foot:
$1.36

Financing Details

Find a Lender

Loan amount:
$840,000
Loan to value ratio:
80.0%
Loan type:
Amortizing
Term:
30 years
Interest rate:
5.875%
Principal & interest:
$4,969
Property tax:
$463
Insurance:
$273
Private mortgage insurance (PMI):
$0
Monthly payment:
$5,705

Operating Income

Find a Property Manager

% Rent Monthly Yearly
Gross rent:
$3,900 $46,800
Vacancy loss: (6%)
6% -$234 -$2,808
Operating income:
$3,666 $43,992

Operating Expenses


% Rent Monthly Yearly
Property taxes: (12%)
12%-$463-$5,556
Insurance: (7%)
7%-$273-$3,276
Property management: (8%)
8%-$312-$3,744
Repairs & maintenance: (5%)
5%-$195-$2,340
Capital expenditures: (5%)
5%-$195-$2,340
HOA fees: (2%)
2%-$65-$780
Total operating expenses: (39%)
39%-$1,503-$18,036

Cash Flow


Monthly Yearly
Net operating income:
$2,163 $25,956
Mortgage payments:
-$4,969 -$59,628
Cash flow:
$2,806 $33,672