NOT LISTED FOR SALE

10240 E Celtic Dr Scottsdale, AZ 85260

Horizons Neighborhood

Estimated Value: $691,000 - $770,000

3 Beds
2.5 Baths
2,156 Sq Ft
$344/Sq Ft Est. Value

Last Sold November 19, 2021

Last sale price $650,000 $301 Per Sq Ft

Est. 14% increase in value since last sale

Current estimated payment $4,207/month

Highlights

  • Fireplace in Primary Bedroom
  • Vaulted Ceiling
  • Granite Countertops
  • Redfield Elementary School Rated A
  • Wood Flooring
  • Private Yard

About This Home

As of February 2022

Beautiful 3 bed, 2.5 bath home that has recently been upgraded throughout. Quartz countertops in the kitchen, new flooring, Stainless appliance package. Check out the fireplace in the family room as well as the two-way fireplace in the Master. Washer and dryer included as well as pool service for a beautiful sparkling and refreshing pool. Wake in the Master Bedroom to the mountain views. Located in an ideal part of Scottsdale!! Come see it today. Please add an additional 2.4% to rent for sales tax and admin fee.

Last Agent to Rent the Property

Jerald Willis

Houston Creek Realty, LLC License #BR548466000 Listed on: 02/21/2022

Last Renter's Agent

Jerald Willis

Houston Creek Realty, LLC License #BR548466000 Listed on: 02/21/2022

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $1,850

Year Built

  • Built in 1990

Lot Details

  • 4,506 Sq Ft Lot
  • Block Wall Fence
  • Artificial Turf
  • Private Yard

Parking

  • 2 Car Garage

Home Design

  • Wood Frame Construction
  • Tile Roof
  • Stucco

Interior Spaces

  • 2,156 Sq Ft Home
  • 2-Story Property
  • Vaulted Ceiling
  • Ceiling Fan
  • Two Way Fireplace
  • Family Room with Fireplace
  • 2 Fireplaces

Kitchen

  • Eat-In Kitchen
  • Breakfast Bar
  • Built-In Microwave
  • Granite Countertops

Flooring

  • Wood
  • Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Fireplace in Primary Bedroom
  • Primary Bathroom is a Full Bathroom
  • 2.5 Bathrooms
  • Double Vanity
  • Bathtub With Separate Shower Stall

Laundry

  • Laundry in unit
  • Dryer
  • Washer

Home Security

  • Intercom
  • Fire Sprinkler System

Schools

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

Utilities

  • Central Air
  • Heating Available
  • Cable TV Available

Additional Features

  • Gazebo
  • Property is near a bus stop

Listing and Financial Details

  • Property Available on 2/21/22
  • $95 Move-In Fee
  • Rent includes pool service - full
  • 12-Month Minimum Lease Term
  • $50 Application Fee
  • Tax Lot 392
  • Assessor Parcel Number 217-50-104

Community Details

Overview

  • Property has a Home Owners Association
  • First Service Res Association, Phone Number (480) 551-4300
  • Built by Hancock Homes
  • Mountainview Ranch Unit 3 Subdivision

Recreation

  • Bike Trail

Home Details

Home Type

Single Family

Est. Annual Taxes

$1,850

Year Built

Built in 1990

Lot Details

0

Parking

2

Rental Info

  • HOA Paid By: Landlord
  • Rent Includes: Pool Service - Full
  • Available Date: 2022-02-21

Listing Details

  • Cross Street: Frank Lloyd Wright & 100th St.
  • Legal Info Range: 5E
  • Property Type: Residential Lease
  • Basement: N
  • Parking Spaces Slab Parking Spaces: 2.0
  • Parking Spaces Total Covered Spaces: 2.0
  • Separate Den Office Sep Den Office: N
  • Year Built: 1990
  • Rental Info H O A Name: First Service Res
  • Non Assistive Animals: Lessor Approval
  • Rental Info Rental Tax Percent: 1.65
  • Initial Move In Costs Admin Fee: 95.0
  • Initial Move In Costs Application Fee: 50.0
  • Lease Term Minimum Lease Term Months: 12
  • Directions: South on 100th St. to 102nd St., the turn East. Then turn North on 100th Pl. The road will turn East and become Celtic Dr. Continue to property on the left (North) side of street.
  • Property Sub Type: Single Family Residence
  • Horses: No
  • Lot Size Acres: 0.1
  • Subdivision Name: MOUNTAINVIEW RANCH UNIT 3
  • Property Attached Yn: No
  • Dining Area:Breakfast Bar: Yes
  • Cooling:Ceiling Fan(s): Yes
  • Technology:Cable TV Avail: Yes
  • Laundry Features Inside: Yes
  • Construction:Wood Frame: Yes
  • Security Features:Fire Sprinkler System: Yes
  • Water Source City Water2: Yes
  • Fireplace Features Fireplace Family Rm2: Yes
  • Fireplace Features Fireplace Master Bdr2: Yes
  • Fireplace Features Two Way Fireplace2: Yes
  • Special Features: None

Interior Features

  • Flooring: Tile, Wood
  • Basement YN: No
  • Furnished: Unfurnished
  • Spa Features: None
  • Appliances: Electric Cooktop, Water Softener
  • Other Equipment: Intercom
  • Possible Bedrooms: 3
  • Total Bedrooms: 3
  • Fireplace Features: Two Way Fireplace, Fireplace Master Bdr, Fireplace Family Rm, 2 Fireplaces
  • Fireplace: Yes
  • Interior Amenities: Granite Counters, Double Vanity, Upstairs, Eat-in Kitchen, Breakfast Bar, Vaulted Ceiling(s), Pantry, Full Bth Master Bdrm, Separate Shwr & Tub
  • Living Area: 2156.0
  • Stories: 2
  • Kitchen Features:Built-in Microwave: Yes
  • Kitchen Features:Granite Countertops: Yes
  • Community Features:BikingWalking Path: Yes
  • Kitchen Features Pantry: Yes
  • Other Rooms:Family Room: Yes
  • Community Features:Near Bus Stop: Yes
  • Kitchen Features:Cook Top Elec: Yes
  • KitchenFeatures:Refrigerator: Yes
  • Master Bathroom:Double Vanity: Yes

Exterior Features

  • Fencing: Block
  • Exterior Features: Private Yard
  • Lot Features: Synthetic Grass Frnt, Synthetic Grass Back
  • Disclosures: Agency Discl Req
  • Construction Type: Stucco, Wood Frame, Painted
  • Other Structures: Gazebo
  • Roof: Tile
  • Exterior Features:Pvt Yrd(s)Crtyrd(s): Yes
  • Exterior Features:Gazebo: Yes

Garage/Parking

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

Utilities

  • Cooling: Central Air, Ceiling Fan(s), Programmable Thmstat
  • Heating: Electric
  • Laundry Features: Dryer Included, Inside, Washer Included
  • Security: Fire Sprinkler System
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Water Source: City Water
  • Heating:Electric: Yes

Condo/Co-op/Association

  • Community Features: Near Bus Stop, Biking/Walking Path
  • Association Name: First Service Res
  • Phone: 480-551-4300
  • Association: Yes
  • Pets Allowed: Lessor Approval

Schools

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

Lot Info

  • Lot Size Sq Ft: 4506.0
  • Parcel #: 217-50-104

Building Info

  • Builder Name: Hancock Homes

Tax Info

  • Tax Book Number: 217.00
  • Tax Lot: 392
  • Tax Map Number: 50.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Sep 30, 2021
Closed on
Nov 15, 2021
Sold by
Ng Pee Taa and Lai Min Ling
Bought by
Mirzaiikondori Nazanin
Seller's Agent
Joe Pampinella
Orchard Brokerage
Buyer's Agent
Glenn Loper
HomeSmart
List Price
$660,000
Sold Price
$650,000
Premium/Discount to List
-$10,000
-1.52%
Current Estimated Value
$740,360

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$90,360
Avg. Annual Appreciation
3.61%
Original Mortgage
$585,000
Outstanding Balance
$538,298
Interest Rate
2.99%
Mortgage Type
New Conventional
Estimated Equity
$203,172

Purchase Details

Listed on
Jan 10, 2018
Closed on
Jan 24, 2018
Sold by
Jordan Valley Assets Llc
Bought by
Ng Pee Taa and Lai Min Ling
Seller's Agent
Cathy Colvin
West USA Realty
Buyer's Agent
Bryan Mealey
West USA Realty
List Price
$410,000
Sold Price
$407,000
Premium/Discount to List
-$3,000
-0.73%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
13.11%
Original Mortgage
$386,650
Interest Rate
3.94%
Mortgage Type
New Conventional

Purchase Details

Closed on
Mar 24, 2014
Sold by
Alter Eyal
Bought by
Jordan Valley Assets Llc

Purchase Details

Closed on
Jun 10, 2008
Sold by
Us Bank Na
Bought by
Alter Eyal

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$262,400
Interest Rate
6.37%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Jun 2, 2008
Sold by
Teretz Tamar
Bought by
Alter Eyal

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$262,400
Interest Rate
6.37%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Mar 18, 2008
Sold by
Kreiss Brad J
Bought by
U S Bank Na

Purchase Details

Closed on
Jan 26, 2006
Sold by
Broadley Mark J
Bought by
Kreiss Brad J

Home Financials for this Owner

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

Purchase Details

Closed on
Nov 12, 2004
Sold by
Geirnaert Ricky
Bought by
Geirnaert Leanne

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$258,000
Interest Rate
5.72%
Mortgage Type
Stand Alone Refi Refinance Of Original Loan

Purchase Details

Closed on
Jul 7, 2004
Sold by
Hill Broadley Laina M
Bought by
Broadley Mark J

Purchase Details

Closed on
Jul 24, 2003
Sold by
Kazemi Hamid R and Karimi Zahra
Bought by
Broadley Mark J and Hill Laina M

Home Financials for this Owner

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

Purchase Details

Closed on
Jan 14, 1999
Sold by
Kazemi Hamid R
Bought by
Kazemi Hamid R and Karimi Zahra

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$95,000
Interest Rate
6.75%

Purchase Details

Closed on
Apr 15, 1998
Sold by
Scott Barbara J and Scott Barbara Jean
Bought by
Scott Barbara J and The Scott Revocable Trust

Purchase Details

Closed on
Jan 19, 1998
Sold by
Cosmescu Vasilie
Bought by
Scott Barbara J and Cosmescu Barbara J

Purchase Details

Closed on
Apr 5, 1996
Sold by
Kazemi Elham
Bought by
Kazemi Hamid R and Geransayeh Zahra Karimi

Purchase Details

Closed on
Aug 24, 1994
Sold by
Cosmescu Vasilie and Cosmescu Barbara J
Bought by
Cosmescu Barbara J and Cosmescu Revocable Living Trust
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
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
Mirzaiikondori Nazanin $650,000 Grand Canyon Title Agency
Ng Pee Taa $407,000 First Arizona Title Agency L
Jordan Valley Assets Llc -- None Available
Alter Eyal $328,000 First American Title Ins Co
Alter Eyal -- First American Title Ins Co
U S Bank Na $373,500 Security Title Agency
Kreiss Brad J $470,000 First American Title
Geirnaert Leanne -- --
Broadley Mark J -- --
Broadley Mark J -- --
Broadley Mark J $287,000 Fidelity National Title
Kazemi Hamid R -- Security Title Agency
Scott Barbara J -- --
Scott Barbara J -- --
Kazemi Hamid R -- --
Kazemi Elham -- --
Cosmescu Barbara J -- United Title Agency
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Mirzaiikondori Nazanin $585,000
Previous Owner Ng Pee Taa $170,000
Previous Owner Ng Pee Taa $364,290
Previous Owner Ng Pee Taa $385,000
Previous Owner Ng Pee Taa $386,000
Previous Owner Ng Pee Taa $386,650
Previous Owner Alter Eyal $262,400
Previous Owner Alter Eyal $262,400
Previous Owner Alter Eyal $262,400
Previous Owner Kreiss Brad $30,500
Previous Owner Kreiss Brad K $501,500
Previous Owner Kreiss Brad J $376,000
Previous Owner Broadley Mark J $258,000
Previous Owner Broadley Mark J $258,300
Previous Owner Kazemi Hamid R $95,000
Closed Kazemi Hamid R $50,000
Closed Kreiss Brad J $94,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
02/28/2022 02/28/22 Rented $5,000 0.0% --
02/21/2022 02/21/22 For Rent $5,000 0.0% --
11/19/2021 11/19/21 Sold $650,000 -1.5% $301 / Sq Ft
10/19/2021 10/19/21 Pending -- -- --
10/12/2021 10/12/21 For Sale $660,000 0.0% $306 / Sq Ft
10/08/2021 10/08/21 Pending -- -- --
09/28/2021 09/28/21 For Sale $660,000 +62.2% $306 / Sq Ft
02/02/2018 02/02/18 Sold $407,000 -0.7% $189 / Sq Ft
01/17/2018 01/17/18 Pending -- -- --
01/09/2018 01/09/18 For Sale $410,000 0.0% $190 / Sq Ft
04/01/2015 04/01/15 Rented $1,800 0.0% --
03/16/2015 03/16/15 Under Contract -- -- --
02/24/2015 02/24/15 For Rent $1,800 0.0% --
10/01/2013 10/01/13 Rented $1,800 0.0% --
10/01/2013 10/01/13 Under Contract -- -- --
08/08/2013 08/08/13 For Rent $1,800 -- --
Source: Arizona Regional Multiple Listing Service (ARMLS)

Tax History Compared to Growth

Source: Public Records

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 $1,850 $40,958 -- --
2024 $2,298 $39,007 -- --
2023 $2,298 $49,900 $9,980 $39,920
2022 $2,190 $39,380 $7,870 $31,510
2021 $2,375 $36,280 $7,250 $29,030
2020 $2,354 $34,400 $6,880 $27,520
2019 $2,286 $32,230 $6,440 $25,790
2018 $2,233 $30,860 $6,170 $24,690
2017 $2,466 $29,760 $5,950 $23,810
2016 $2,419 $28,820 $5,760 $23,060
2015 $2,303 $28,650 $5,730 $22,920
Source: Public Records

Agents Affiliated with this Home

  • J

    Landlord's Agent in 2022

    Jerald Willis

    Houston Creek Realty, LLC

    (602) 540-4897

    11 Total Sales

    Section Image
  • Joe Pampinella

    Seller's Agent in 2021

    Joe Pampinella

    Orchard Brokerage

    (602) 953-4000

    1 in this area

    200 Total Sales

    Section Image
  • Glenn Loper

    Buyer's Agent in 2021

    Glenn Loper

    HomeSmart

    (480) 839-3400

    2 in this area

    65 Total Sales

    Section Image

  • C

    Seller's Agent in 2018

    Cathy Colvin

    West USA Realty

  • B

    Buyer's Agent in 2018

    Bryan Mealey

    West USA Realty

    (480) 628-1465

    2 in this area

    42 Total Sales

    Section Image

  • S

    Seller's Agent in 2015

    Sarah Rotem

    West USA Realty

    Section Image
See All Agents

Map

Source: Arizona Regional Multiple Listing Service (ARMLS)

MLS Number: 6358448

Arizona Regional Multiple Listing Service (ARMLS)

APN: 217-50-104

Arizona Maricopa County Scottsdale 85260 Horizons

10240 E Celtic Dr, Scottsdale, AZ

This home is located at 10240 E Celtic Dr, Scottsdale, AZ 85260 since 21 February 2022 and is currently priced at $741,470. This property was built in 1990. 10240 E Celtic Dr is a home located in Maricopa County with nearby schools including Redfield Elementary School, Desert Canyon Middle School, and Desert Mountain High School.

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Arizona Regional Multiple Listing Service (ARMLS) All information should be verified by the recipient and none is guaranteed as accurate by ARMLS

Listing Information presented by local MLS brokerage: Ten-X, local REALTOR®- Arlene Richardson - (888)-952-6393

Nearby Homes