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
Level up your investing with Pro
Explore exclusive tools and resources to start, grow, or optimize your portfolio.
10+ investment analysis calculators
$1,000+/yr savings on landlord software
Lawyer-reviewed lease forms (annual only)
Unlimited access to the Forums

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

$604,000

For Sale - Active
9147 Harlequin Cir, Frederick, CO 80504
5 Beds
3 Baths
3,209 Square Feet
0.16 Acres Lot
Built in 2003
For Sale - Active
Units n/a
Checked: 19 hours ago
Updated: Nov 10, 2025 at 10:28AM

Investment Summary


Monthly Cash Flow
-$992
Cap Rate
3.7%
Cash-on-Cash Return
-8.6%
Debt Coverage Ratio
0.65
Internal Rate of Return (5 years)
-4.3%

Property Description


0.16 Acres Lot
Built in 2003
For Sale - Active
Units n/a

Peace & privacy welcome you upon entering this semi-custom 5 bed, 3 bath, ranch home. NO HOA or Metro District tax! Top percs: NEW A/C ($12k) 2025, all air ducts & carpets professionally cleaned. NEW Roof 2019 class 4 shingles. Water heater, washer & dryer NEW in 2017. Kitchen is functional & stylish w/stainless appliances, tile counters & backsplash, abundant cabinet/counter space, breakfast bar seating 4-6, & a separate dining room with entrance into the backyard/deck. Soaring vaulted ceilings adorn the open living room with oak floors, backyard views, gas fireplace, & lighted decorative niches. Primary en suite tucked away with private entry to backyard/deck & includes a gorgeous 5-piece bath w/ jetted tub, large tile shower, & walk-in closet. Solar panels installed 2019 & cost $199/month; xadd $23K to offer price for seller-paid solar panels. Fully-fenced backyard is your private oasis with pear, oak, maple, grapes, roses, & irises. Finished basement has large family/rec room, laundry, several storage areas, one lined with shelving. Two additional basement bedrooms, one that functions well as a second primary bedroom with full bath & radiant flooring heat. Oversized 2-car garage with shelving. Total electric, gas, & solar payment for July was only $276. Highly coveted neighborhood has Front Range views & is near great schools, coffee, dining, groceries, & Bella Rosa Golf Course.

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: 5

Bathroom Information

  • # of Baths (Full): 3
  • # of Baths (Total): 3.0

Interior Features

  • # of Rooms: 13
  • # of Stories: 1
  • Basement: Yes
  • Basement Description: Full

Exterior Features

  • Exterior Walls Materials: Stucco
  • Roof Material: Composition

Land Information

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

Lot Information

  • Parcel ID: R0741801
  • Lot Size: 7000 sqft

Property Information

  • Property Type: Single Family Residence
  • Style: Contemporary
  • Year Built: 2003

Tax Information

  • Annual Tax: $3,272

Utilities

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

Location

  • County: Weld

Listing Details


Listed by:
Robin Glasener
RE/MAX Nexus
(720) 352-7376

Source:
REColorado
MLS#: IR1038391
REColorado

Investment Summary


Monthly Cash Flow
-$992
Cap Rate
3.7%
Cash-on-Cash Return
-8.6%
Debt Coverage Ratio
0.65
Internal Rate of Return (5 years)
-4.3%

Purchase Details

Find an Agent

Purchase price:
$604,000
Amount financed:
-$483,200
Down payment:
$120,800
Closing costs:
$18,120
Rehab costs:
$0
Initial cash invested:
$138,920
Square feet:
3,209
Cost per square foot:
$188
Monthly rent per square foot:
$0.97

Financing Details

Find a Lender

Loan amount:
$483,200
Loan to value ratio:
80.0%
Loan type:
Amortizing
Term:
30 years
Interest rate:
5.875%
Principal & interest:
$2,858
Property tax:
$273
Insurance:
$217
Private mortgage insurance (PMI):
$0
Monthly payment:
$3,348

Operating Income

Find a Property Manager

% Rent Monthly Yearly
Gross rent:
$3,100 $37,200
Vacancy loss: (6%)
6% -$186 -$2,232
Operating income:
$2,914 $34,968

Operating Expenses


% Rent Monthly Yearly
Property taxes: (9%)
9%-$273-$3,272
Insurance: (7%)
7%-$217-$2,604
Property management: (8%)
8%-$248-$2,976
Repairs & maintenance: (5%)
5%-$155-$1,860
Capital expenditures: (5%)
5%-$155-$1,860
HOA fees: (n/a)
n/an/an/a
Total operating expenses: (34%)
34%-$1,048-$12,572

Cash Flow


Monthly Yearly
Net operating income:
$1,866 $22,392
Mortgage payments:
-$2,858 -$34,296
Cash flow:
-$992 -$11,904