$405,000
SOLD OCT 23, 2015

2517 N Terrell Mesa, AZ 85207

Desert Uplands Neighborhood
4 Beds
3.5 Baths
3,940 Sq Ft
0.48 Acres

Recently Sold

$103 Per Sq Ft

36% Below List Price

363 Days on Market

Highlights

  • Private Pool
  • RV Gated
  • City Lights View
  • Franklin at Brimhall Elementary School Rated A
  • Gated Community
  • 0.48 Acre Lot

About This Home

As of August 2016

Remarkable property tucked away in the gated community of Madrid! Immaculately landscaped lot, large open floor plan! Perfect family home, with room for everyone! Large kitchen with breakfast bar and neighboring dining and living areas. Oversized master suite, and large custom walk-in closet! On the opposite end of the main floor you'll find two additional bedrooms, complete with jack-and-jill bathroom, in addition to a full laundry room which leads to your 3-car garage. Fully finished basement, with office, bedroom and full bathroom. Incredible backyard, perfect for entertaining! Pool, spa, built-in-BBQ, covered patio - no expense left behind!

Last Agent to Sell the Property

Katie Rosenquist

HomeSmart License #SA645793000 Listed on: 10/17/2014

HomeSmart

Last Buyer's Agent

Amy Owens

RETSY License #SA115344000

RETSY

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,839

Year Built

  • Built in 2004

Lot Details

  • 0.48 Acre Lot
  • Desert faces the front and back of the property
  • Wrought Iron Fence
  • Artificial Turf
  • Sprinklers on Timer

Parking

  • 3 Car Garage
  • Tandem Parking
  • Garage Door Opener
  • RV Gated

Property Views

  • City Lights
  • Mountain

Home Design

  • Wood Frame Construction
  • Tile Roof
  • Stucco

Interior Spaces

  • 3,940 Sq Ft Home
  • 1-Story Property
  • Ceiling height of 9 feet or more
  • Ceiling Fan
  • Fireplace
  • Double Pane Windows
  • Solar Screens
  • Finished Basement

Kitchen

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

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary Bathroom is a Full Bathroom
  • 3.5 Bathrooms
  • Dual Vanity Sinks in Primary Bathroom
  • Bathtub With Separate Shower Stall

Laundry

  • Laundry in unit
  • Washer and Dryer Hookup

Accessible Home Design

  • Stepless Entry

Pool

  • Private Pool
  • Above Ground Spa
  • Fence Around Pool

Outdoor Features

  • Covered Patio or Porch
  • Fire Pit
  • Built-In Barbecue

Schools

  • Zaharis Elementary School
  • Fremont Junior High School
  • Red Mountain High School

Utilities

  • Refrigerated Cooling System
  • Heating Available
  • High Speed Internet
  • Cable TV Available

Listing and Financial Details

  • Tax Lot 134
  • Assessor Parcel Number 219-31-265

Community Details

Overview

  • Property has a Home Owners Association
  • Madrid Association, Phone Number (480) 844-2224
  • Madrid Subdivision

Recreation

  • Community Playground
  • Bike Trail

Security

  • Gated Community

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,839

Year Built

Built in 2004

Lot Details

0

Parking

3

Listing Details

  • Cross Street: Power & McDowell
  • Legal Info Range: 7E
  • Property Type: Residential
  • HOA #2: N
  • Association Fees Land Lease Fee: N
  • Recreation Center Fee 2: N
  • Recreation Center Fee: N
  • Total Monthly Fee Equivalent: 83.33
  • Basement: Y
  • Updated Floors: Partial
  • Items Updated Floor Yr Updated: 2014
  • Parking Spaces Total Covered Spaces: 3.0
  • Separate Den Office Sep Den Office: Y
  • Year Built: 2004
  • Tax Year: 2013
  • Directions: East to 88th Street, south through gated entrance, left on Northridge, right on Norwood, left on Terrell to home on left.
  • Property Sub Type: Single Family - Detached
  • Lot Size Acres: 0.48
  • Subdivision Name: Madrid
  • Architectural Style: Other (See Remarks)
  • Efficiency: Sunscreen(s)
  • Property Attached Yn: No
  • ResoBuildingAreaSource: Assessor
  • Association Fees:HOA Fee2: 250.0
  • Dining Area:Breakfast Bar: Yes
  • Windows:Dual Pane: Yes
  • Cooling:Ceiling Fan(s): Yes
  • Technology:Cable TV Avail: Yes
  • Technology:High Speed Internet Available: Yes
  • Special Features: None

Interior Features

  • Basement: Finished
  • Flooring: Carpet, Tile, Wood
  • Spa Features: Above Ground
  • Accessibility Features: Zero-Grade Entry
  • Possible Bedrooms: 6
  • Total Bedrooms: 4
  • Fireplace Features: Fire Pit
  • Fireplace: Yes
  • Interior Amenities: Eat-in Kitchen, Breakfast Bar, 9+ Flat Ceilings, Kitchen Island, Pantry, Double Vanity, Full Bth Master Bdrm, Separate Shwr & Tub, High Speed Internet, Granite Counters
  • Living Area: 3940.0
  • Stories: 1
  • Window Features: Double Pane Windows
  • Kitchen Features:RangeOven Elec: Yes
  • Kitchen Features:Dishwasher2: Yes
  • Kitchen Features:Built-in Microwave: Yes
  • Community Features:Gated Community2: Yes
  • Kitchen Features:Granite Countertops: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Master Bathroom:Double Sinks: Yes
  • Community Features:BikingWalking Path: Yes
  • Kitchen Features:Disposal2: Yes
  • Kitchen Features Pantry: Yes
  • Other Rooms:Family Room: Yes
  • Kitchen Features:Wall Oven(s): Yes
  • Community Features:Children_squote_s Playgrnd: Yes
  • Other Rooms:BonusGame Room: Yes
  • Fireplace:Firepit: Yes
  • Kitchen Features:Multiple Ovens: Yes
  • Basement Description:Finished2: Yes

Exterior Features

  • Fencing: Wrought Iron
  • Exterior Features: Covered Patio(s), Patio, Built-in Barbecue
  • Lot Features: Desert Back, Desert Front, Synthetic Grass Back, Auto Timer H2O Front, Auto Timer H2O Back
  • Pool Features: Fenced, Private
  • View: City Lights, Mountain(s)
  • Disclosures: Agency Discl Req, Seller Discl Avail
  • Construction Type: Painted, Stucco, Frame - Wood
  • Roof: Tile
  • Construction:Frame - Wood: Yes
  • Exterior Features:Covered Patio(s): Yes
  • Exterior Features:Built-in BBQ: Yes
  • Exterior Features:Patio: Yes

Garage/Parking

  • Total Covered Spaces: 3.0
  • Parking Features: Electric Door Opener, RV Gate, Tandem
  • Attached Garage: No
  • Garage Spaces: 3.0
  • Parking Features:Electric Door Opener: Yes
  • Parking Features:RV Gate: Yes
  • Parking Features:Tandem Garage: Yes

Utilities

  • Cooling: Refrigeration, Ceiling Fan(s)
  • Heating: Electric
  • Laundry Features: Inside, Wshr/Dry HookUp Only
  • Security: Gated Community
  • Water Source: City Water
  • Heating:Electric: Yes

Condo/Co-op/Association

  • Community Features: Playground, Biking/Walking Path
  • Amenities: Management, Rental OK (See Rmks)
  • Association Fee Frequency: Quarterly
  • Association Name: Madrid
  • Phone: 480-844-2224
  • Association: Yes

Association/Amenities

  • Association Fees:HOA YN2: Y
  • Association Fees:HOA Transfer Fee2: 250.0
  • Association Fees:HOA Paid Frequency: Quarterly
  • Association Fees:HOA Name4: Madrid
  • Association Fees:HOA Telephone4: 480-844-2224
  • 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_: $
  • Association Fee Incl:Street Maint: Yes

Schools

  • Elementary School: Zaharis Elementary
  • High School: Red Mountain High School
  • Middle Or Junior School: Fremont Junior High School

Lot Info

  • Land Lease: No
  • Lot Size Sq Ft: 20885.0
  • Parcel #: 219-31-265
  • ResoLotSizeUnits: SquareFeet

Building Info

  • Builder Name: Unknown

Tax Info

  • Tax Annual Amount: 3839.0
  • Tax Book Number: 219.00
  • Tax Lot: 134
  • Tax Map Number: 31.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Oct 9, 2017
Sold by
Schofield Mark A and Bos Karla J
Bought by
Schofield Mark A and Bos Karla J
Current Estimated Value
$1,270,025

Purchase Details

Listed on
May 3, 2016
Closed on
Jul 11, 2016
Sold by
Owens Amy
Bought by
Bos Karla J and Schofield Mark A
Seller's Agent
Amy Owens
RETSY
Buyer's Agent
BEVERLY BERRETT
Berkshire Hathaway HomeServices Arizona Properties
List Price
$675,000
Sold Price
$630,000
Premium/Discount to List
-$45,000
-6.67%

Home Financials for this Owner

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

Purchase Details

Listed on
Oct 17, 2014
Closed on
Oct 21, 2015
Sold by
Boonlorn Jaime L
Bought by
Owens Amy
Seller's Agent
Katie Rosenquist
HomeSmart
Buyer's Agent
Amy Owens
RETSY
List Price
$629,000
Sold Price
$405,000
Premium/Discount to List
-$224,000
-35.61%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
71.40%
Original Mortgage
$305,000
Interest Rate
3.85%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jul 31, 2006
Sold by
Tischler Jaime L
Bought by
Tischler Jaime L and The Jaime L Boonlorn Revocable Trust

Purchase Details

Closed on
May 24, 2004
Sold by
Tischler Robert W
Bought by
Tischler Jaime L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$196,550
Interest Rate
5.92%
Mortgage Type
Stand Alone First
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 Type Sale Price Title Company
Interfamily Deed Transfer -- None Available
Warranty Deed $630,000 First Arizona Title Agency
Warranty Deed $405,000 Great American Title Agency
Interfamily Deed Transfer -- None Available
Interfamily Deed Transfer -- Dhi Title Of Arizona Inc
Corporate Deed $381,567 Dhi Title Of Arizona Inc
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Previous Owner $566,500 New Conventional
Previous Owner $305,000 New Conventional
Previous Owner $196,550 Stand Alone First
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/18/2016 08/18/16 Sold $630,000 -3.1% $160 / Sq Ft
07/09/2016 07/09/16 Pending -- -- --
06/06/2016 06/06/16 Price Changed $649,900 -2.9% $165 / Sq Ft
05/19/2016 05/19/16 Price Changed $669,000 -0.9% $170 / Sq Ft
05/03/2016 05/03/16 For Sale $675,000 +66.7% $171 / Sq Ft
10/23/2015 10/23/15 Sold $405,000 -18.8% $103 / Sq Ft
08/31/2015 08/31/15 Price Changed $499,000 -4.0% $127 / Sq Ft
08/27/2015 08/27/15 Price Changed $520,000 -1.9% $132 / Sq Ft
06/17/2015 06/17/15 Price Changed $530,000 -2.8% $135 / Sq Ft
05/24/2015 05/24/15 Price Changed $545,000 -0.9% $138 / Sq Ft
03/21/2015 03/21/15 Price Changed $550,000 -8.3% $140 / Sq Ft
01/14/2015 01/14/15 Price Changed $600,000 -4.6% $152 / Sq Ft
10/16/2014 10/16/14 For Sale $629,000 -- $160 / Sq Ft
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 $5,131 $67,849 -- --
2024 $6,114 $64,618 -- --
2023 $6,114 $75,380 $15,070 $60,310
2022 $5,976 $61,370 $12,270 $49,100
2021 $6,056 $58,380 $11,670 $46,710
2020 $5,969 $54,620 $10,920 $43,700
2019 $5,537 $50,630 $10,120 $40,510
2018 $5,337 $49,480 $9,890 $39,590
2017 $5,160 $52,000 $10,400 $41,600
2016 $5,653 $53,130 $10,620 $42,510
2015 $4,713 $50,900 $10,180 $40,720
Source: Public Records

Agents Affiliated with this Home

  • Amy Owens

    Seller's Agent in 2016

    Amy Owens

    RETSY

    (602) 723-0500

    37 Total Sales

    Amy Owens
    Section Image
  • BEVERLY BERRETT

    Buyer's Agent in 2016

    BEVERLY BERRETT

    Berkshire Hathaway HomeServices Arizona Properties

    (480) 329-8185

    110 Total Sales

    BEVERLY BERRETT
    Section Image
  • Katie Rosenquist

    Seller's Agent in 2015

    Katie Rosenquist

    HomeSmart

    (480) 528-2070

    85 Total Sales

    Katie Rosenquist
    Section Image
See All Agents

Map

Source: Arizona Regional Multiple Listing Service (ARMLS)

MLS Number: 5186630

Arizona Regional Multiple Listing Service (ARMLS)

APN: 219-31-265

Arizona Maricopa County Mesa 85207 Desert Uplands

2517 N Terrell, Mesa, AZ

This home is located at 2517 N Terrell, Mesa, AZ 85207 and is currently priced at $405,000, approximately $102 per square foot. This property was built in 2004. 2517 N Terrell is a home located in Maricopa County with nearby schools including Franklin at Brimhall Elementary School, Zaharis Elementary School, and Franklin West Elementary 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