Work with a dedicated Real Estate Advisor who will take your financial preferences and help you select and acquire properties that fit your criteria. Learn more

9858 E Celtic Drive Scottsdale, AZ 85260

5 Beds 6 Baths 4,842 sqft Built 2005

$1,415,000

List Price

$6,550

$6.3K - $6.8K

Rent Est.

PROPERTY INFO

SINGLE-FAMILY
March 20, 2021 RECENTLY ADDED
FACTS
  • Single Family
  • Built In 2005
  • Price/Sqft : $292.23
  • 3 Days on Market
  • MLS # : 6197184
  • Updated Date : 03/20/2021 at 18:30
CONSTRUCTION
  • Beds : 5
  • Floor Size : 4,842 sqft
  • Baths : 5 full , 1 half
Listing Agent

Realty Executives

Listing Agent's Description

Madrid -Popular Gated enclave of just 61 homes. RARE opportunity to own in this high demand north Scottsdale neighborhood. ONE LEVEL - 5 bedrooms- 5.5 bathrooms ,Owner suite PLUS 2 ensuite guest rooms one with private courtyard entrance , 2 Jack and Jill bedrooms. PLUS OFFICE - PLUS Appx 14 X 24 BONUS ROOM AND 3 car garage!5th bedroom is used as a Home theater room. EXTRAS include paver stone driveway, elevated bath vanities T/O, granite counter tops, gas cooktop, additional interior wall and attic insulation , audio pre wire at original build.Original owner rarely used as second home.All the rooms you need , space for home gym / office / guest quarters / secondary home office/ rec room etc... Larger 14,700 SF lot. Madrid ! Located close to all the top medical campus's in Arizona.

SEE MORE

PRICE & RENT TRENDS

Neighborhood: Madrid

NeighborhoodNIR Market*CityMarket2010Year20002019200k300k400k500k600k700k800k900k1000k1100k1200kPrice in $122k1210k

* NIR Market: Aggregated price or rent trend of all neighborhoods with same NIR

Neighborhood: Madrid

NeighborhoodNIR Market*CityMarket2010Year20002019 Q215002000250030003500400045005000550060006500Rent in $10456951

* NIR Market: Aggregated price or rent trend of all neighborhoods with same NIR

SCHOOLS

NAME EDUCATIONAL LEVEL SCHOOL TYPE # OF STUDENTS # OF TEACHERS GREATSCHOOLS RATING
Redfield Elementary School Primary Regular 513 33 8
Desert Canyon Middle School Middle Regular 566 29 8
Desert Mountain High School High Regular 2,247 94 8

Redfield Elementary School

  • Education Level: Primary
  • # of students: 513
  • # of teachers: 33
8
GreatSchools Rating

Desert Canyon Middle School

  • Education Level: Middle
  • # of students: 566
  • # of teachers: 29
8
GreatSchools Rating

Desert Mountain High School

  • Education Level: High
  • # of students: 2,247
  • # of teachers: 94
8
GreatSchools Rating
 

$1,273,500$1,556,500$1,415,000

PURCHASE PRICE

$5,895$7,205$6,550

RENT

DOWN PAYMENT
FINANCING

FINANCIALS

PROJECTED BASIC MONTHLY INCOME STATEMENT

INCOME Rent $6,550
EXPENSES Loan Payment -$4,915
Property Tax -$662
Property Insurance -$121
HOA -$50
Property Management Fees -$99
CASH FLOW
$703

This is the estimated cash flow generated during a typical maintenance-free month. It is recommended that investors set aside 15% of earned rent to cover both maintenance and periods of vacancy.

$1,415,000

PROJECTED PRICE

$6,550

PROJECTED RENT

0.46%

PROJECTED RENT / PRICE RATIO

ASSUMPTIONS

Expense Inflation 2.50%
Rental Growth Year (1-5) 3.17%
Appreciation Year (1-5) 3.8%
Maintenance Year (1-5) 8.00%
Vacancy 6.60%
Length of Stay Years 2

PROJECTED ACCUMULATED WEALTH

30 YEAR PROJECTION

  • Cash Flow
  • Appreciation
  • Principal
11530$0.0$1.0M$2.0M$3.0M$4.0M

PROJECTED ANNUAL CASH FLOW

11530$0.0$10k$20k$30k$40k$50k$60k$70k$80k

PROJECTED PROPERTY VALUE

30 YEAR PROJECTION

  • Appreciation
  • Principal
  • Loan Balance
11530$0.0$500k$1.0M$1.5M$2.0M$2.5M$3.0M$3.5M

TOTAL CASH OUT OF POCKET

TOTAL OUT OFPOCKET$380,725

INVESTMENT

$380,725

Down Payment
$353,750
Rehab Estimate
$5,750
Closing Costs
$21,225

LOAN DETAILS

25%

DOWN PAYMENT

HOMEUNION RECOMMENDS:

A 35% down payment or higher enables the proceeds from the asset to cover all costs.

$4,915

MONTHLY LOAN PAYMENT

30 yr
Term
3.75%
Interest
25.00%
Down Payment
Term 30 Years
Interest 3.75%
Down Payment $353,750
Loan Amount $1,061,250
See What Happens When You Reinvest Cash Flow

8.17

YEARS SAVED

$153,611

INTEREST SAVED

CASH FLOW REINVESTMENT

The time & interest saved by applying each month's positive cash flow towards loan principal pay down.

  • $6,550

    LIST RENT
  • $1.35

    LIST RENT PER SQFT
  • $6,521

    COMP ESTIMATED VALUE
  • $1.35

    COMP AVG. RENT PER SQFT
Comps Range
$4,500
1$4,5002$6,5503$6,7004$7,000
$7,000
RENT COMPS ANALYSIS
  • 9858 E Celtic Drive Scottsdale, AZ 2
    • 5 beds 6 baths ∙ 4,842 Sqft ∙ Built 2005 5 beds 6 baths ∙ 4,842 Sqft ∙ Built 2005
    • Rent
    • Rent Per SQFT
    •  
    • $6,550
    • $1.35
    •  
  • 9907 E Celtic Drive Scottsdale, AZ 1
    • 4 beds 5 baths ∙ 4,510 Sqft ∙ Built 2005 4 beds 5 baths ∙ 4,510 Sqft ∙ Built 2005
    LEASED 08/01/09
    • Rent
    • Rent Per SQFT
    •  
    • $4,500
    • $1.00
    •  
  • 9874 E Gray Road Scottsdale, AZ 3
    • 5 beds 5 baths ∙ 4,509 Sqft ∙ Built 2004 5 beds 5 baths ∙ 4,509 Sqft ∙ Built 2004
    LEASED 12/01/19
    • Rent
    • Rent Per SQFT
    •  
    • $6,700
    • $1.49
    •  
  • 9939 E Gray Road Scottsdale, AZ 4
    • 5 beds 6 baths ∙ 4,509 Sqft ∙ Built 2004 5 beds 6 baths ∙ 4,509 Sqft ∙ Built 2004
    LEASED 11/11/19
    • Rent
    • Rent Per SQFT
    •  
    • $7,000
    • $1.55
    •  
PROPERTY LISTING DETAILS
Richard L Amos
Realty Executives
Brandon Graham
1.866.250.5610
Mynd Property Management
LC664597000
Arizona Regional Multiple Listing Service, Inc. ( ARMLS)
MLS #: 6197184
Last Updated: 03/20/2021
support@investimateroi.com

Indicates a property listed by a real estate brokerage other than HomeUnion/Investimate by Mynd. All information should be verified by the recipient and none is guaranteed as accurate by ARMLS. Copyright (c) 2021 Arizona Regional Multiple Listing Service, Inc. All rights reserved.

BESbswy