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

$924,900

For Sale - Active
8839 Shetland Dr, Frederick, CO 80504
5 Beds
5 Baths
5,001 Square Feet
0.25 Acres Lot
Built in 2008
For Sale - Active
Units n/a
Checked: 2 hours ago
Updated: Jun 21, 2025 at 03:28AM

Investment Summary


Monthly Cash Flow
-$3,118
Cap Rate
2.2%
Cash-on-Cash Return
-17.6%
Debt Coverage Ratio
0.35
Internal Rate of Return (5 years)
-13.0%

Property Description


0.25 Acres Lot
Built in 2008
For Sale - Active
Units n/a

Stunning former model home with countless upgrades & design features. Walk trails to Bella Rosa golf course and lake Milavec, plus private neighborhood pool. A grand staircase greets you as you enter this beautiful home. The huge open kitchen has granite counters, double oven, separate cooktop, dishwasher, refrigerator, microwave (all appliances included) plus expansive counter and cabinet space, walk-in pantry, wrap around bar, and huge separate eat-in area. The kitchen opens to the bright family room w/cozy fireplace, soaring ceilings and lookout to upstairs. Formal dining room off the kitchen w/coffered ceilings. Main level suite with design features, walk-in closet and 3/4 bath. Main level also boasts a large private office w/french doors, and a living room w/vaulted ceiling. The upper level has a large open loft w/built-in desk; roomy bedrooms 2 & 3 with a jack-and-jill full bath/double sinks. The masterpiece of the upper level is the huge primary bedroom with breathtaking views, fireplace, large walk-in closet plus luxury 5 piece bath w/quartz counters and freestanding designer soak tub. The finished basement has a large bedroom w/walk-in closet, 3/4 bath, huge media room - projector & surround system included; fitness area, and three separate storage rooms. The beautiful professionally landscaped backyard looks out to open space with walking trail. Huge wrap around patio includes gazebo and landscaped walk to built-in firepit. Oversized garage with finished floor, cabinets, shop vac, EV HOOKUP, TV and shelves included. Home has dual zone heat and AC for added comfort. H2O heater, furnace and roof have all been replaced in last 5 years. Tons of upgrades and designer features throughout this stunner! Current mortgage is Assumable VA loan. Veteran must qualify first to confirm assumption is possible.

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
  • Details: Oversized, Attached
  • Garage Spaces: 3
  • Spaces Total: 3

Bedroom Information

  • # of Bedrooms: 5

Bathroom Information

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

Interior Features

  • # of Rooms: 17
  • # of Stories: 1
  • Basement: Yes

Exterior Features

  • Exterior Walls Materials: Wood
  • Roof Material: Composition

HOA

  • Has HOA: Yes
  • Association: Moore Farms
  • HOA Fee: $693/annually

Land Information

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

Lot Information

  • Parcel ID: R1993403
  • Lot Size: 10911 sqft

Property Information

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

Tax Information

  • Annual Tax: $5,263

Utilities

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

Location

  • County: Weld

Listing Details


Listed by:
Cindy Campbell
RE/MAX Alliance-Longmont
(303) 881-7413

Source:
REColorado
MLS#: IR1035769
REColorado

Investment Summary


Monthly Cash Flow
-$3,118
Cap Rate
2.2%
Cash-on-Cash Return
-17.6%
Debt Coverage Ratio
0.35
Internal Rate of Return (5 years)
-13.0%

Purchase Details

Find an Agent

Purchase price:
$924,900
Amount financed:
-$739,920
Down payment:
$184,980
Closing costs:
$27,747
Rehab costs:
$0
Initial cash invested:
$212,727
Square feet:
5,001
Cost per square foot:
$185
Monthly rent per square foot:
$0.64

Financing Details

Find a Lender

Loan amount:
$739,920
Loan to value ratio:
80.0%
Loan type:
Amortizing
Term:
30 years
Interest rate:
6.810%
Principal & interest:
$4,829
Property tax:
$439
Insurance:
$224
Private mortgage insurance (PMI):
$0
Monthly payment:
$5,492

Operating Income

Find a Property Manager

% Rent Monthly Yearly
Gross rent:
$3,200 $38,400
Vacancy loss: (6%)
6% -$192 -$2,304
Operating income:
$3,008 $36,096

Operating Expenses


% Rent Monthly Yearly
Property taxes: (14%)
14%-$439-$5,263
Insurance: (7%)
7%-$224-$2,688
Property management: (8%)
8%-$256-$3,072
Repairs & maintenance: (5%)
5%-$160-$1,920
Capital expenditures: (5%)
5%-$160-$1,920
HOA fees: (2%)
2%-$58-$696
Total operating expenses: (41%)
41%-$1,297-$15,559

Cash Flow


Monthly Yearly
Net operating income:
$1,711 $20,532
Mortgage payments:
-$4,829 -$57,948
Cash flow:
$3,118 $37,416