NOT LISTED FOR SALE

10340 E Celtic Dr Unit III Scottsdale, AZ 85260

Horizons Neighborhood

Estimated Value: $717,000 - $841,000

3 Beds
2.5 Baths
2,013 Sq Ft
$388/Sq Ft Est. Value

Last Sold April 05, 2018

Last sale price $450,000 $224 Per Sq Ft

Est. 74% increase in value since last sale

Current estimated payment $4,265/month

1 Day on Market

Highlights

  • Private Pool
  • Mountain View
  • Contemporary Architecture
  • Redfield Elementary School Rated A
  • Fireplace in Primary Bedroom
  • Wood Flooring

About This Home

As of April 2018

Looking for a designer home with all the finishes seen on HGTV? This beautifully remodeled open floorplan home includes new kitchen with quartz countertop and island table, 24x24 porcelain sandstone flooring, spacious downstairs master bedroom with fireplace, fabulous marble master bathroom, hardwood flooring up the stairs and in large loft space with custom desk. Oversize lot in prestigious Mountainview Ranch with fabulous ZEN desert landscape and newly plastered private pool. Conveniently located close to restaurants, shopping and schools.

Last Agent to Sell the Property

Gina Gullquist

HomeSmart License #BR586897000 Listed on: 03/07/2018

HomeSmart

Co-Listed By

Eric Redleaf

eXp Realty License #SA638370000

Last Buyer's Agent

Connie Colla

RETSY License #BR656708000

RETSY

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $2,189

Year Built

  • Built in 1989

Lot Details

  • 7,376 Sq Ft Lot
  • Desert faces the front and back of the property
  • Block Wall Fence
  • Corner Lot

HOA Fees

  • $31 Monthly HOA Fees

Parking

  • 2 Car Garage

Home Design

  • Contemporary Architecture
  • Wood Frame Construction
  • Tile Roof
  • Stucco

Interior Spaces

  • 2,013 Sq Ft Home
  • 2-Story Property
  • Ceiling height of 9 feet or more
  • Ceiling Fan
  • Mountain Views

Kitchen

  • Eat-In Kitchen
  • Built-In Microwave

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Primary Bedroom on Main
  • Fireplace in Primary Bedroom
  • Remodeled Bathroom
  • 2.5 Bathrooms
  • Dual Vanity Sinks in Primary Bathroom

Pool

  • Private Pool

Schools

  • Cheyenne Elementary School
  • Desert Canyon Middle School
  • Desert Mountain High School

Utilities

  • Refrigerated Cooling System
  • Heating Available

Community Details

  • Association fees include ground maintenance
  • First Service Resid Association, Phone Number (480) 551-4300
  • Built by Watt Hancok
  • Mountainview Ranch Unit 3 Lot 289 559 Tr A D Subdivision

Listing and Financial Details

  • Tax Lot 398
  • Assessor Parcel Number 217-50-110

Home Details

Home Type

Single Family

Est. Annual Taxes

$2,189

Year Built

Built in 1989

Lot Details

7,376 Sq Ft Lot

HOA Fees

$31 per month

Parking

2

Listing Details

  • Cross Street: 100th St. & Frank Lloyd Wright
  • Legal Info Range: 5E
  • Property Type: Residential
  • Ownership: Fee Simple
  • HOA #2: N
  • Association Fees Land Lease Fee: N
  • Recreation Center Fee 2: N
  • Recreation Center Fee: N
  • Total Monthly Fee Equivalent: 31.0
  • Basement: N
  • Updated Partial or Full Bathrooms: Full
  • Bathrooms Year Updated: 2016
  • Updated Floors: Full
  • Items Updated Floor Yr Updated: 2016
  • Updated Kitchen: Full
  • Items Updated Kitchen Yr Updated: 2013
  • Updated Pool: Full
  • Items Updated Pool Yr Updated: 2017
  • Parking Spaces Slab Parking Spaces: 2.0
  • Parking Spaces Total Covered Spaces: 2.0
  • Separate Den Office Sep Den Office: Y
  • Year Built: 1989
  • Tax Year: 2017
  • Property Sub Type: Single Family - Detached
  • Horses: No
  • Lot Size Acres: 0.17
  • Co List Office Mls Id: cril02
  • Co List Office Phone: 602-889-2135
  • Subdivision Name: MOUNTAINVIEW RANCH UNIT 3 LOT 289-559 TR A-D
  • Architectural Style: Contemporary
  • Property Attached Yn: No
  • ResoBuildingAreaSource: Owner
  • General Property Description:PriceSqFt: 223.54
  • Association Fees:HOA Fee2: 31.0
  • Cooling:Ceiling Fan(s): Yes
  • Special Features: None

Interior Features

  • Flooring: Carpet, Tile, Wood
  • Basement YN: No
  • Spa Features: None
  • Total Bedrooms: 3
  • Fireplace Features: 1 Fireplace, Master Bedroom
  • Fireplace: Yes
  • Interior Amenities: Master Downstairs, Eat-in Kitchen, 9+ Flat Ceilings, Pantry, 3/4 Bath Master Bdrm, Double Vanity
  • Living Area: 2013.0
  • Stories: 2
  • ResoLivingAreaSource: Owner
  • Kitchen Features:RangeOven Elec: Yes
  • Kitchen Features:Built-in Microwave: Yes
  • Master Bathroom:Double Sinks: Yes
  • Kitchen Features Pantry: Yes
  • Other Rooms:Great Room: Yes
  • Kitchen Features:Non-laminate Counter: Yes
  • Kitchen Features:Reverse Osmosis: Yes
  • Kitchen Features:Walk-in Pantry: Yes
  • Other Rooms:Loft: Yes
  • Fireplace:Fireplace Master Bdr: Yes

Exterior Features

  • Fencing: Block
  • Lot Features: Corner Lot, Desert Back, Desert Front
  • Pool Features: Private
  • Pool Private: Yes
  • View: Mountain(s)
  • Disclosures: Agency Discl Req, Seller Discl Avail
  • Construction Type: Painted, Stucco, Frame - Wood
  • Roof: Tile
  • Construction:Frame - Wood: Yes

Garage/Parking

  • Total Covered Spaces: 2.0
  • Garage Spaces: 2.0
  • Open Parking Spaces: 2.0

Utilities

  • Cooling: Ceiling Fan(s), Refrigeration
  • Heating: Electric
  • Water Source: City Water
  • Heating:Electric: Yes

Condo/Co-op/Association

  • Amenities: None
  • Association Fee: 31.0
  • Association Fee Frequency: Monthly
  • Association Name: First Service Resid
  • Phone: 480-551-4300
  • Association: Yes

Association/Amenities

  • Association Fees:HOA YN2: Y
  • Association Fees:HOA Transfer Fee2: 155.0
  • Association Fees:HOA Paid Frequency: Monthly
  • Association Fees:HOA Name4: First Service Resid
  • Association Fees:PAD Fee YN2: N
  • Association Fees:Cap ImprovementImpact Fee _percent_: $
  • Association Fee Incl:Common Area Maint3: Yes
  • Association Fees:Cap ImprovementImpact Fee 2 _percent_: $

Fee Information

  • Association Fee Includes: Maintenance Grounds

Schools

  • Elementary School: Cheyenne Elementary School
  • High School: Desert Mountain High School
  • Junior High Dist: Scottsdale Unified District
  • Middle Or Junior School: Desert Canyon Middle School

Lot Info

  • Land Lease: No
  • Lot Size Sq Ft: 7376.0
  • Parcel #: 217-50-110
  • ResoLotSizeUnits: SquareFeet

Building Info

  • Builder Name: Watt Hancok

Tax Info

  • Tax Annual Amount: 2189.0
  • Tax Book Number: 217.00
  • Tax Lot: 398
  • Tax Map Number: 50.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Mar 7, 2018
Closed on
Mar 29, 2018
Sold by
Hallmark Julie
Bought by
Shefrin Elissa Marie
Seller's Agent
Gina Gullquist
HomeSmart
Buyer's Agent
Connie Colla
RETSY
List Price
$449,000
Sold Price
$450,000
Premium/Discount to List
$1,000
0.22%
Current Estimated Value
$780,837

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$330,837
Avg. Annual Appreciation
7.25%
Original Mortgage
$405,000
Outstanding Balance
$347,969
Interest Rate
4.4%
Mortgage Type
New Conventional
Estimated Equity
$432,868

Purchase Details

Listed on
May 24, 2013
Closed on
Jun 21, 2013
Sold by
Zhong Liyun
Bought by
Hallmark Julie
Seller's Agent
Yuanli ( John ) Zhang
Gold Trust Realty
Buyer's Agent
Gina Gullquist
HomeSmart
List Price
$319,900
Sold Price
$310,000
Premium/Discount to List
-$9,900
-3.09%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
8.11%
Original Mortgage
$232,500
Interest Rate
2.87%
Mortgage Type
New Conventional

Purchase Details

Closed on
Nov 8, 2011
Sold by
Yang Min
Bought by
Zhong Liyun

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$185,600
Interest Rate
3.95%
Mortgage Type
New Conventional

Purchase Details

Closed on
Oct 19, 2011
Sold by
Wilmingotn Finance
Bought by
Zhong Liyun

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$185,600
Interest Rate
3.95%
Mortgage Type
New Conventional

Purchase Details

Closed on
Aug 18, 2011
Sold by
Pennymac Mortgage Investment Trust Holdi
Bought by
Wilmington Finance and Pmc Reo Financing Trust

Purchase Details

Closed on
Jun 7, 2011
Sold by
Braha Eric and Braha Pauline J
Bought by
Pennymac Mortgage Investment Trust Holdi

Purchase Details

Closed on
May 28, 1997
Sold by
Scheuer Angelika and Goldsmith Barbara J
Bought by
Braha Eric and Braha Pauline J

Purchase Details

Closed on
Apr 25, 1997
Sold by
Lloyd Richard E and Lloyd Shirley K
Bought by
Lloyd Richard E and Lloyd Shirley K
Source: Public Records
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Shefrin Elissa Marie $450,000 Great American Title Agency
Hallmark Julie $310,000 Great American Title Agency
Zhong Liyun -- Fidelity National Title Ins
Zhong Liyun $241,500 Fidelity National Title Ins
Wilmington Finance -- None Available
Pennymac Mortgage Investment Trust Holdi $237,000 None Available
Braha Eric $167,500 Lawyers Title Of Arizona Inc
Lloyd Richard E -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Shefrin Elissa Marie $405,000
Previous Owner Hallmark Julie $232,500
Previous Owner Zhong Liyun $185,600
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
04/05/2018 04/05/18 Sold $450,000 +0.2% $224 / Sq Ft
03/08/2018 03/08/18 Pending -- -- --
03/07/2018 03/07/18 For Sale $449,000 +44.8% $223 / Sq Ft
06/26/2013 06/26/13 Sold $310,000 -3.1% $155 / Sq Ft View Prior Sale
05/29/2013 05/29/13 Pending -- -- --
05/23/2013 05/23/13 For Sale $319,900 -- $160 / Sq Ft
Source: Arizona Regional Multiple Listing Service (ARMLS)

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $2,545 $42,553 -- --
2024 $2,388 $40,527 -- --
2023 $2,388 $52,620 $10,520 $42,100
2022 $2,276 $41,150 $8,230 $32,920
2021 $2,468 $37,710 $7,540 $30,170
2020 $2,446 $35,630 $7,120 $28,510
2019 $2,375 $33,370 $6,670 $26,700
2018 $2,320 $32,160 $6,430 $25,730
2017 $2,189 $30,650 $6,130 $24,520
2016 $2,147 $29,860 $5,970 $23,890
2015 $2,063 $29,700 $5,940 $23,760
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Arizona Regional Multiple Listing Service (ARMLS)

MLS Number: 5733456

Arizona Regional Multiple Listing Service (ARMLS)

APN: 217-50-110

Your Personal Tour Guide

Ask me questions while you tour the home.