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
Unbranded Virtual Tour
Photo
Photo
See all photos

$1,443,000

For Sale - Active
5201 E Duquesne Ln, Flagstaff, AZ 86004
6 Beds
4 Baths
3,472 Square Feet
0.63 Acres Lot
Built in 1983
For Sale - Active
Units n/a
Checked: 17 hours ago
Updated: Jun 11, 2025 at 03:07AM

Investment Summary


Monthly Cash Flow
-$4,506
Cap Rate
2.5%
Cash-on-Cash Return
-16.3%
Debt Coverage Ratio
0.40
Internal Rate of Return (5 years)
-11.8%

Property Description


0.63 Acres Lot
Built in 1983
For Sale - Active
Units n/a

Bring the Whole Family—Room to Roam and Relax in This Iconic Flagstaff Mountain Retreat! Welcome to Big R Lodge, a breathtaking 5,000 sq. ft. mountain-style home nestled in the heart of Flagstaff, Arizona. This one-of-a-kind property blends the warmth of a rustic lodge with modern comfort, offering six spacious bedrooms and three full bathrooms—perfect for large families, multigenerational living, or continued use as a high-performing vacation rental. Step inside to soaring vaulted knotty pine ceilings, cozy fireplaces, and charming mountain décor that creates a true cabin ambiance. Designed with space and functionality in mind, the home features two full kitchens, three separate levels of living areas, and a fun kids' cave to keep young ones and older ones too entertained. The spacious game room is a favorite for guests of all ages, and the private hot tub on the oversized back deck is ideal for relaxing under the stars. The outdoor setting is just as impressiveenjoy a large, beautifully landscaped lot with a rock waterfall feature, mature trees, and a huge backyard that offers endless possibilities for entertainment or quiet retreat. Whether you're looking for a permanent home, a mountain getaway, or an income-producing short-term rental, Big R Lodge delivers on every level. Don't miss your chance to own one of Flagstaff's most beloved lodge-style properties.

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: Open, Covered, Garage
  • Details: Garage Door Opener
  • Garage Spaces: 2
  • Spaces Total: 2

Bedroom Information

  • # of Bedrooms: 6

Bathroom Information

  • # of Baths (Total): 4.0

Interior Features

  • # of Rooms: 6
  • # of Stories: 2
  • Fireplace: Yes

Exterior Features

  • Roof Material: Composition

HOA

  • Has HOA: Yes
  • Association: Contntl Country Club
  • HOA Fee: $744/annually

Land Information

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

Lot Information

  • Parcel ID: 11409131
  • Lot Size: 27545 sqft

Property Information

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

Tax Information

  • Annual Tax: $4,323

Utilities

  • Water & Sewer: Public
  • Heating: Natural Gas
  • Cooling: Ceiling Fan(s)

Location

  • County: Coconino

Listing Details


Listed by:
Kelly Broaddus
eXp Realty
(928) 606-6749

Source:
Arizona Regional Multiple Listing Service (ARMLS)
MLS#: 6877652
Arizona Regional Multiple Listing Service (ARMLS)

Investment Summary


Monthly Cash Flow
-$4,506
Cap Rate
2.5%
Cash-on-Cash Return
-16.3%
Debt Coverage Ratio
0.40
Internal Rate of Return (5 years)
-11.8%

Purchase Details

Find an Agent

Purchase price:
$1,443,000
Amount financed:
-$1,154,400
Down payment:
$288,600
Closing costs:
$43,290
Rehab costs:
$0
Initial cash invested:
$331,890
Square feet:
3,472
Cost per square foot:
$416
Monthly rent per square foot:
$1.44

Financing Details

Find a Lender

Loan amount:
$1,154,400
Loan to value ratio:
80.0%
Loan type:
Amortizing
Term:
30 years
Interest rate:
6.810%
Principal & interest:
$7,534
Property tax:
$360
Insurance:
$350
Private mortgage insurance (PMI):
$0
Monthly payment:
$8,244

Operating Income

Find a Property Manager

% Rent Monthly Yearly
Gross rent:
$5,000 $60,000
Vacancy loss: (6%)
6% -$300 -$3,600
Operating income:
$4,700 $56,400

Operating Expenses


% Rent Monthly Yearly
Property taxes: (7%)
7%-$360-$4,323
Insurance: (7%)
7%-$350-$4,200
Property management: (8%)
8%-$400-$4,800
Repairs & maintenance: (5%)
5%-$250-$3,000
Capital expenditures: (5%)
5%-$250-$3,000
HOA fees: (1%)
1%-$62-$744
Total operating expenses: (33%)
33%-$1,672-$20,067

Cash Flow


Monthly Yearly
Net operating income:
$3,028 $36,336
Mortgage payments:
-$7,534 -$90,408
Cash flow:
$4,506 $54,072