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
Copied
Photo
Copied
Photo
Photo
Photo
Photo
See all photos

$3,350,000

For Sale - Active
15102 Prairie Pl, Broomfield, CO 80023
5 Beds
6 Baths
5,592 Square Feet
1.39 Acres Lot
Built in 2014
For Sale - Active
Units n/a
Checked: 1 day ago
Updated: Jun 24, 2025 at 03:12AM

Investment Summary


Monthly Cash Flow
-$15,332
Cap Rate
0.8%
Cash-on-Cash Return
-23.9%
Debt Coverage Ratio
0.12
Internal Rate of Return (5 years)
-19.0%

Property Description


1.39 Acres Lot
Built in 2014
For Sale - Active
Units n/a

Nestled on 1.39 acres, this stunning luxury home commands attention with a dramatic circular drive. Welcoming front courtyard with linear firepit invites relaxation while enjoying panoramic mountain and city vistas. Step inside to discover an interior that seamlessly blends elegance and functionality. Upon entering, a light-filled front sitting room welcomes you. Formal dining room sets the stage for unforgettable gatherings. Adjacent, chef's dream kitchen, features stylish quartz island, and Thermador appliances. Cozy breakfast nook has glass doors to the backyard patio creating a seamless indoor-outdoor living experience. Expansive great room is graced with wall of windows, two-story coffered ceilings and fireplace. Secluded study offers backyard views and tranquil ambiance. Convenient powder room and generously sized mud-laundry room complete this level. Ascend to the upper level to discover a primary sanctuary featuring cozy sitting nook, and spa-inspired bath. Three additional en-suite bedrooms offer comfort and privacy, while a second laundry room adds convenience. Lower level features spacious rec room with wet bar and climate-controlled wine cellar designed to showcase any discerning wine connoisseur's collection. Exercise room provides dedicated space for fitness enthusiasts, while an additional guest bedroom offers flexibility. Step outside to an extensive park-like landscaped yard the ideal setting for sports, play and outdoor adventures. Imagine hosting summer barbecues on the expansive patio complete with firepit. Ample space remains for the addition of a future pool, and possible accessory building, further enhancing the outdoor living experience. Oversize four car garage has space for cars, toys and more. Enjoy the tranquility of spacious living with convenient proximity to shopping, dining, entertainment, public, private schools and effortless access to Denver, Boulder, DIA, and Northern Colorado. This is more than just a home, it's a lifestyle.

Build Your Team


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

Agents

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

Find an Agent

Lenders

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

Find a Lender

Property Managers

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

Find a Property Manager

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: Oversized
  • Details: Circular Driveway, Concrete, Oversized, Attached
  • Garage Spaces: 4
  • Spaces Total: 4

Bedroom Information

  • # of Bedrooms: 5

Bathroom Information

  • # of Baths (Full): 4
  • # of Baths (Partial): 1
  • # of Baths (Total): 6.0

Interior Features

  • # of Rooms: 22
  • # of Stories: 2
  • Basement: Yes
  • Basement Description: Sump Pump, Finished, Full, Interior Entry
  • Fireplace: Yes

Exterior Features

  • Exterior Walls Materials: Stucco
  • Roof Material: Concrete

HOA

  • Has HOA: Yes
  • Association: Spruce Meadows Homeowners Association
  • HOA Fee: $1,000/annually

Land Information

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

Lot Information

  • Parcel ID: 157317104003
  • Lot Size: 60548 sqft

Property Information

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

Tax Information

  • Annual Tax: $19,490

Utilities

  • Water & Sewer: Public
  • Heating: Forced Air
  • Cooling: Ceiling Fan(s), Central Air

Location

  • County: Broomfield

Listing Details


Listed by:
Bonnie Peterson
Keller Williams Preferred Realty
(303) 775-2250

Source:
REColorado
MLS#: 9734000
REColorado

Investment Summary


Monthly Cash Flow
-$15,332
Cap Rate
0.8%
Cash-on-Cash Return
-23.9%
Debt Coverage Ratio
0.12
Internal Rate of Return (5 years)
-19.0%

Purchase Details

Find an Agent

Purchase price:
$3,350,000
Amount financed:
-$2,680,000
Down payment:
$670,000
Closing costs:
$100,500
Rehab costs:
$0
Initial cash invested:
$770,500
Square feet:
5,592
Cost per square foot:
$599
Monthly rent per square foot:
$1.00

Financing Details

Find a Lender

Loan amount:
$2,680,000
Loan to value ratio:
80.0%
Loan type:
Amortizing
Term:
30 years
Interest rate:
6.810%
Principal & interest:
$17,489
Property tax:
$1,624
Insurance:
$392
Private mortgage insurance (PMI):
$0
Monthly payment:
$19,505

Operating Income

Find a Property Manager

% Rent Monthly Yearly
Gross rent:
$5,600 $67,200
Vacancy loss: (6%)
6% -$336 -$4,032
Operating income:
$5,264 $63,168

Operating Expenses


% Rent Monthly Yearly
Property taxes: (29%)
29%-$1,624-$19,490
Insurance: (7%)
7%-$392-$4,704
Property management: (8%)
8%-$448-$5,376
Repairs & maintenance: (5%)
5%-$280-$3,360
Capital expenditures: (5%)
5%-$280-$3,360
HOA fees: (1%)
1%-$83-$996
Total operating expenses: (55%)
55%-$3,107-$37,286

Cash Flow


Monthly Yearly
Net operating income:
$2,157 $25,884
Mortgage payments:
-$17,489 -$209,868
Cash flow:
$15,332 $183,984