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

$1,950,000

For Sale - Active
9842 E Celtic Dr, Scottsdale, AZ 85260
5 Beds
5 Baths
4,509 Square Feet
0.33 Acres Lot
Built in 2005
For Sale - Active
Units n/a
Checked: 3 hours ago
Updated: May 26, 2025 at 06:16PM

Investment Summary


Monthly Cash Flow
-$6,494
Cap Rate
1.7%
Cash-on-Cash Return
-17.4%
Debt Coverage Ratio
0.30
Internal Rate of Return (5 years)
-12.8%

Property Description


0.33 Acres Lot
Built in 2005
For Sale - Active
Units n/a

LOCATED IN THE PRIVATE, GATED, EXCLUSIVE COMMUNITY OF MADRID, this fantastic home has it all! OPEN SPLIT FLOOR PLAN featuring vaulted ceilings, large rooms, and bathed in natural light. Meticulously maintained. AMAZING CHEF KITCHEN with double ovens, gas range, large sub-zero refrigerator and walk-in pantry. Backyard features lush mature greenery with a nice size pool and spa, built-in gas BBQ, raised planters, fire pit, and multiple covered patios. AWESOME LOCATION convenient to the 101 freeway, tons of eateries, and hiking trails. This is definitely a wonderful house ready for its next owner. The neighborhood is very friendly and quiet. In fact, if you're looking for a peaceful and private property, this is definitely a great option to consider. Tour today and see for yourself!

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: Attch'd Gar Cabinets, Dir Entry frm Garage, Electric Door Opener, Extnded Lngth Garage
  • Details: Garage Door Opener, Direct Access
  • Garage Spaces: 3
  • Spaces Total: 2

Bedroom Information

  • # of Bedrooms: 5

Bathroom Information

  • # of Baths (Total): 5.0

Interior Features

  • # of Stories: 1
  • Fireplace: Yes

Exterior Features

  • Exterior Walls Materials: Wood
  • Roof Material: Tile
  • Pool: Yes

HOA

  • Has HOA: Yes
  • Association: Madrid HOA
  • HOA Fee: $660/quarterly

Land Information

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

Lot Information

  • Parcel ID: 21750763
  • Lot Size: 14450 sqft

Property Information

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

Tax Information

  • Annual Tax: $6,775

Utilities

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

Location

  • County: Maricopa

Listing Details


Listed by:
Jeff Fields
Russ Lyon Sotheby's International Realty
(480) 269-3123

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

Investment Summary


Monthly Cash Flow
-$6,494
Cap Rate
1.7%
Cash-on-Cash Return
-17.4%
Debt Coverage Ratio
0.30
Internal Rate of Return (5 years)
-12.8%

Purchase Details

Find an Agent

Purchase price:
$1,950,000
Amount financed:
-$1,560,000
Down payment:
$390,000
Closing costs:
$58,500
Rehab costs:
$0
Initial cash invested:
$448,500
Square feet:
4,509
Cost per square foot:
$432
Monthly rent per square foot:
$1.13

Financing Details

Find a Lender

Loan amount:
$1,560,000
Loan to value ratio:
80.0%
Loan type:
Amortizing
Term:
30 years
Interest rate:
5.875%
Principal & interest:
$9,228
Property tax:
$565
Insurance:
$357
Private mortgage insurance (PMI):
$0
Monthly payment:
$10,150

Operating Income

Find a Property Manager

% Rent Monthly Yearly
Gross rent:
$5,100 $61,200
Vacancy loss: (6%)
6% -$306 -$3,672
Operating income:
$4,794 $57,528

Operating Expenses


% Rent Monthly Yearly
Property taxes: (11%)
11%-$565-$6,775
Insurance: (7%)
7%-$357-$4,284
Property management: (8%)
8%-$408-$4,896
Repairs & maintenance: (5%)
5%-$255-$3,060
Capital expenditures: (5%)
5%-$255-$3,060
HOA fees: (4%)
4%-$220-$2,640
Total operating expenses: (40%)
40%-$2,060-$24,715

Cash Flow


Monthly Yearly
Net operating income:
$2,734 $32,808
Mortgage payments:
-$9,228 -$110,736
Cash flow:
$6,494 $77,928