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

$550,000

Sale Pending
5249 Mt Arapaho Cir, Frederick, CO 80504
3 Beds
3 Baths
2,193 Square Feet
0.19 Acres Lot
Built in 2002
Sale Pending
Units n/a
Checked: 20 hours ago
Updated: Jun 28, 2025 at 03:29AM

Investment Summary


Monthly Cash Flow
-$1,231
Cap Rate
3.6%
Cash-on-Cash Return
-11.7%
Debt Coverage Ratio
0.57
Internal Rate of Return (5 years)
-7.3%

Property Description


0.19 Acres Lot
Built in 2002
Sale Pending
Units n/a

New exterior paint and expansive back patio. New AC units, radon system, sump pump. BACKS TO OPEN SPACE! One of a few homes in the neighborhood that BACKS TO RECREATION AREA & MILAVEC RESERVOIR that is being developed into a spectacular park w/ splash pad, baseball diamonds, nature viewing areas, bike & hiking trails, pickle ball courts & much more. We listened to feedback & did all the work for you with all new exterior paint & brand new back patio to sit & ENJOY THE STARS OVER THE RESERVOIR FROM YOUR NEW PATIO! This home will sit closer to the trails & wildlife viewing areas so construction of the park won't be a nuisance. ENJOY THE FIREWORKS OVER THE RESERVOIR from your new back patio every July 4th! IMAGINE THE ENTERTAINING YOU CAN DO & the family bbq's on your huge back patio every spring & summer or the quiet mornings watching the sunrise w/ coffee in hand! See mock ups of NEW PARK COMING in photos & at the house during showings. Step inside & you are greeted w/ a large sun bathed front living room that would be a GREAT HOME OFFICE. Follow the hardwood floors to the back living room w/ GAS FIREPLACE, dining area & large kitchen looking out over the backyard. The pantry is huge!!! The laundry room is on the main floor & steps out to the 2 car garage. Gorgeous UPDATED LUXURY VINYL PLANK FLOORING throughout the upstairs! There is a HUGE LOFT area that could be converted to additional bedroom. The huge primary ensuite bedroom has french doors, DOUBLE WALK IN CLOSETS & a 5 piece ensuite bathroom with so much NATURAL LIGHT! 2 additional bedrooms upstairs w/ reservoir & open space views & a full bathroom round out the upstairs. The basement has large egress windows, stub in for bathroom & is ready for you to finish the way you like. Radon system, 2 new AC units (1 for each floor) & 2 furnaces recently cleaned & serviced & sump pump for your peace of mind. WATCH THE TOUR @ LINK https://youtu.be/urmq1WBgGWM

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: Garage Door Opener
  • Details: Concrete, Storage, Attached
  • Garage Spaces: 2
  • Spaces Total: 2

Bedroom Information

  • # of Bedrooms: 3

Bathroom Information

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

Interior Features

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

Exterior Features

  • Exterior Walls Materials: Wood
  • Roof Material: Composition

HOA

  • Has HOA: Yes
  • Association: Flagstaff Management
  • HOA Fee: $110/annually

Land Information

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

Lot Information

  • Parcel ID: R0028801
  • Lot Size: 8276 sqft

Property Information

  • Property Type: Single Family Residence
  • Style: Traditional
  • Year Built: 2002

Tax Information

  • Annual Tax: $3,392

Utilities

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

Location

  • County: Weld

Listing Details


Listed by:
Chantel Campbell
Madison & Company Properties
(303) 408-4263

Source:
REColorado
MLS#: 5880248
REColorado

Investment Summary


Monthly Cash Flow
-$1,231
Cap Rate
3.6%
Cash-on-Cash Return
-11.7%
Debt Coverage Ratio
0.57
Internal Rate of Return (5 years)
-7.3%

Purchase Details

Find an Agent

Purchase price:
$550,000
Amount financed:
-$440,000
Down payment:
$110,000
Closing costs:
$16,500
Rehab costs:
$0
Initial cash invested:
$126,500
Square feet:
2,193
Cost per square foot:
$251
Monthly rent per square foot:
$1.28

Financing Details

Find a Lender

Loan amount:
$440,000
Loan to value ratio:
80.0%
Loan type:
Amortizing
Term:
30 years
Interest rate:
6.810%
Principal & interest:
$2,871
Property tax:
$283
Insurance:
$196
Private mortgage insurance (PMI):
$0
Monthly payment:
$3,350

Operating Income

Find a Property Manager

% Rent Monthly Yearly
Gross rent:
$2,800 $33,600
Vacancy loss: (6%)
6% -$168 -$2,016
Operating income:
$2,632 $31,584

Operating Expenses


% Rent Monthly Yearly
Property taxes: (10%)
10%-$283-$3,392
Insurance: (7%)
7%-$196-$2,352
Property management: (8%)
8%-$224-$2,688
Repairs & maintenance: (5%)
5%-$140-$1,680
Capital expenditures: (5%)
5%-$140-$1,680
HOA fees: (0%)
0%-$9-$108
Total operating expenses: (35%)
35%-$992-$11,900

Cash Flow


Monthly Yearly
Net operating income:
$1,640 $19,680
Mortgage payments:
-$2,871 -$34,452
Cash flow:
$1,231 $14,772