NOT LISTED FOR SALE

28207 N 154th St Scottsdale, AZ 85262

Estimated Value: $1,056,000 - $1,275,000

3 Beds
2.5 Baths
3,250 Sq Ft
$356/Sq Ft Est. Value

Last Sold February 07, 2018

Last sale price $515,000 $158 Per Sq Ft

Est. 125% increase in value since last sale

Current estimated payment $6,319/month

627 Days on Market

Highlights

  • Horses Allowed On Property
  • Heated Spa
  • Mountain View
  • Sonoran Trails Middle School Rated A-
  • RV Access or Parking
  • Santa Fe Architecture

About This Home

As of February 2018

Immaculate Custom Home in Scottsdale Rio Verde Foothills! Amazing Mountain views and Open space! Resort Style Living in this expansive 1 level home with a backyard oasis. Master is Split from other bedrooms. Heated pool and spa with Baja step, rockfall, spillway, poolside and patio speakers, wood fire pit. Large open chef kitchen facing the great room with LP gas range, stainless appliances, slab granite counters and LOTS of cabinet space. Wired for Surround theater sound in great room and master bdrm. Central Vac and Cat 5 wiring throughout. Fully air-conditioned 1400+ sq ft 4 car, deep garage/Harley Man Cave, epoxy floors. Bonus Room in the Garage. Tall ceilings, great finishes and textures throughout. RV parking with all hookups. NO HOA!

Last Agent to Sell the Property

Stewart Keene

RE/MAX Alliance Group License #SA577343000 Listed on: 04/19/2016

RE/MAX Alliance Group

Last Buyer's Agent

Judy Brown

Fathom Realty Elite License #BR112294000

Fathom Realty Elite

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $1,913

Year Built

  • Built in 2004

Lot Details

  • 1.01 Acre Lot
  • Desert faces the front and back of the property
  • Wrought Iron Fence
  • Block Wall Fence
  • Backyard Sprinklers
  • Sprinklers on Timer
  • Grass Covered Lot

Parking

  • 4 Car Direct Access Garage
  • Garage Door Opener
  • RV Access or Parking

Home Design

  • Santa Fe Architecture
  • Wood Frame Construction
  • Tile Roof
  • Stucco

Interior Spaces

  • 3,250 Sq Ft Home
  • 1-Story Property
  • Ceiling height of 9 feet or more
  • Ceiling Fan
  • Double Pane Windows
  • Solar Screens
  • Family Room with Fireplace
  • Mountain Views
  • Washer and Dryer Hookup

Kitchen

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

Flooring

  • Carpet
  • Stone
  • Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Primary Bathroom is a Full Bathroom
  • 2.5 Bathrooms
  • Dual Vanity Sinks in Primary Bathroom
  • Hydromassage or Jetted Bathtub
  • Bathtub With Separate Shower Stall

Pool

  • Heated Spa
  • Heated Pool
  • Fence Around Pool

Schools

  • Desert Sun Academy Elementary School
  • Sonoran Trails Middle School
  • Cactus Shadows High School

Utilities

  • Zoned Heating and Cooling System
  • Propane
  • Shared Well
  • High Speed Internet

Additional Features

  • No Interior Steps
  • Fire Pit
  • Horses Allowed On Property

Community Details

  • No Home Owners Association
  • Association fees include no fees
  • Built by Ziehl

Listing and Financial Details

  • Tax Lot Unknown
  • Assessor Parcel Number 219-37-483

Home Details

Home Type

Single Family

Est. Annual Taxes

$1,913

Year Built

Built in 2004

Lot Details

0

Parking

4

Listing Details

  • Cross Street: Rio Verde Drive (Dynamite) & 154th
  • Legal Info Range: 6E
  • Property Type: Residential
  • Ownership: Fee Simple
  • Association Fees Land Lease Fee: N
  • Recreation Center Fee 2: N
  • Recreation Center Fee: N
  • Basement: N
  • Parking Spaces Slab Parking Spaces: 4.0
  • Parking Spaces Total Covered Spaces: 4.0
  • Separate Den Office Sep Den Office: Y
  • Year Built: 2004
  • Spa Private: Yes
  • Tax Year: 2015
  • Directions: East on Dynamite (turns into Rio Verde Drive) look for 154th and turn North (left). Property in on the right.
  • Property Sub Type: Single Family Residence
  • Horses: Yes
  • Lot Size Acres: 1.01
  • Subdivision Name: Metes & Bounds
  • Architectural Style: Territorial/Santa Fe
  • Efficiency: Multi-Zones
  • Property Attached Yn: No
  • Dining Area:Breakfast Bar: Yes
  • Windows:Dual Pane: Yes
  • Cooling:Ceiling Fan(s): Yes
  • Utilities Butane Propane: Yes
  • Cooling:Central Air: Yes
  • Windows:Solar Screens: Yes
  • Fireplace Features Fireplace Family Rm: Yes
  • Kitchen Features:Gas Cooktop: Yes
  • Technology:High Speed Internet: Yes
  • Special Features: None

Interior Features

  • Flooring: Carpet, Stone, Tile
  • Basement YN: No
  • Spa Features: Heated, Private
  • Appliances: Gas Cooktop
  • Possible Bedrooms: 4
  • Total Bedrooms: 3
  • Fireplace Features: Fire Pit, 1 Fireplace, Family Room
  • Fireplace: Yes
  • Interior Amenities: High Speed Internet, Granite Counters, Double Vanity, Eat-in Kitchen, Breakfast Bar, 9+ Flat Ceilings, No Interior Steps, Kitchen Island, Full Bth Master Bdrm, Separate Shwr & Tub, Tub with Jets
  • Living Area: 3250.0
  • Stories: 1
  • Window Features: Solar Screens, Dual Pane
  • Kitchen Features:Built-in Microwave: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Master Bathroom:Double Sinks: Yes
  • Other Rooms:Great Room: Yes
  • Kitchen Features:Wall Oven(s): Yes
  • Other Rooms:ExerciseSauna Room: Yes
  • Fireplace Features:Fire Pit: Yes
  • Kitchen Features:Granite Counters: Yes

Exterior Features

  • Fencing: Block, Wrought Iron
  • Lot Features: Sprinklers In Rear, Desert Back, Desert Front, Grass Back, Auto Timer H2O Back
  • Pool Features: Fenced, Heated
  • Pool Private: Yes
  • View: Mountain(s)
  • Disclosures: Agency Discl Req, Seller Discl Avail
  • Construction Type: Stucco, Wood Frame, Painted
  • Roof: Tile
  • Construction:Frame - Wood: Yes

Garage/Parking

  • Total Covered Spaces: 4.0
  • Parking Features: RV Access/Parking, RV Gate, Garage Door Opener, Extended Length Garage, Direct Access, Attch'd Gar Cabinets
  • Attached Garage: No
  • Garage Spaces: 4.0
  • Open Parking Spaces: 4.0
  • Parking Features:Attch_squote_d Gar Cabinets: Yes
  • Parking Features:RV Gate: Yes
  • Parking Features:Garage Door Opener: Yes
  • Parking Features:Direct Access: Yes
  • Parking Features:Extended Length Garage: Yes
  • Parking Features:RV AccessParking: Yes

Utilities

  • Utilities: Propane
  • Cooling: Central Air, Ceiling Fan(s)
  • Heating: Electric
  • Laundry Features: Wshr/Dry HookUp Only
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Water Source: Shared Well
  • Heating:Electric: Yes

Condo/Co-op/Association

  • Association: No

Association/Amenities

  • Association Fees:HOA YN2: N
  • Association Fees:PAD Fee YN2: N
  • Association Fees:Cap ImprovementImpact Fee _percent_: $
  • Association Fees:Cap ImprovementImpact Fee 2 _percent_: $
  • Association Fee Incl:No Fees: Yes

Fee Information

  • Association Fee Includes: No Fees

Schools

  • Elementary School: Desert Sun Academy
  • High School: Cactus Shadows High School
  • Junior High Dist: Cave Creek Unified District
  • Middle Or Junior School: Sonoran Trails Middle School

Lot Info

  • Horse Amenities: Other, See Remarks
  • Land Lease: No
  • Lot Size Sq Ft: 43836.0
  • Parcel #: 219-37-483

Green Features

  • Green Water Conservation: Recirculation Pump

Building Info

  • Builder Name: Ziehl

Tax Info

  • Tax Annual Amount: 1913.0
  • Tax Book Number: 219.00
  • Tax Lot: Unknown
  • Tax Map Number: 37.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Jun 19, 2024
Sold by
Ramos Jaime and Dillard Jenifer E
Bought by
Ramos-Dillard Family Revocable Trust and Ramos
Current Estimated Value
$1,157,659

Purchase Details

Listed on
Apr 19, 2016
Closed on
Jan 9, 2018
Sold by
Mckenzie Kellene M
Bought by
Ramos Jaime and Dillard Jenifer E
Seller's Agent
Stewart Keene
RE/MAX Alliance Group
Buyer's Agent
Judy Brown
Fathom Realty Elite
List Price
$525,000
Sold Price
$515,000
Premium/Discount to List
-$10,000
-1.9%

Home Financials for this Owner

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

Purchase Details

Listed on
Jul 21, 2012
Closed on
Nov 8, 2012
Sold by
Hill Daniel and Hill Jolene
Bought by
Mckenzie Kellene M
Seller's Agent
Ron Baker
DPR Realty LLC
Buyer's Agent
Stewart Keene
RE/MAX Alliance Group
List Price
$539,000
Sold Price
$514,000
Premium/Discount to List
-$25,000
-4.64%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
0.04%
Original Mortgage
$411,200
Interest Rate
3.34%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jan 26, 2010
Sold by
Veros Darrin Michael and Veros Aimee Rene
Bought by
Hill Daniel and Hill Jolene

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$348,912
Interest Rate
5.5%
Mortgage Type
FHA

Purchase Details

Closed on
Nov 19, 2003
Sold by
Winders Jon and Ziehl Rich
Bought by
Winders Jon and Ziehl Rich

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$302,000
Interest Rate
3%
Mortgage Type
Construction

Purchase Details

Closed on
Nov 3, 2003
Sold by
Ziehl Rick and Winders Jon
Bought by
Veros Darrin Michael and Veros Aimee Renee

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$302,000
Interest Rate
3%
Mortgage Type
Construction
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
Ramos-Dillard Family Revocable Trust -- None Listed On Document
Ramos Jaime $515,000 First American Title Insuran
Mckenzie Kellene M $514,000 Driggs Title Agency Inc
Hill Daniel $355,350 Fidelity Natl Title Ins Co
Winders Jon -- --
Veros Darrin Michael $85,000 Fidelity National Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Ramos Jaime $412,000
Previous Owner Mckenzie Kellene M $411,200
Previous Owner Hill Daniel $348,912
Previous Owner Veros Darrin Michael $302,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
02/07/2018 02/07/18 Sold $515,000 -2.8% $158 / Sq Ft
01/06/2018 01/06/18 Pending -- -- --
12/18/2017 12/18/17 Price Changed $530,000 +1.0% $163 / Sq Ft
12/18/2017 12/18/17 For Sale $525,000 +1.9% $162 / Sq Ft
04/20/2017 04/20/17 Off Market $515,000 -- --
04/17/2017 04/17/17 Pending -- -- --
03/21/2017 03/21/17 Price Changed $525,000 -2.8% $162 / Sq Ft
02/23/2017 02/23/17 Price Changed $539,900 -1.8% $166 / Sq Ft
01/29/2017 01/29/17 Price Changed $550,000 -3.3% $169 / Sq Ft
01/20/2017 01/20/17 Price Changed $569,000 -1.0% $175 / Sq Ft
10/10/2016 10/10/16 Price Changed $574,500 -0.9% $177 / Sq Ft
06/14/2016 06/14/16 Price Changed $579,900 -1.7% $178 / Sq Ft
04/19/2016 04/19/16 For Sale $589,900 +14.8% $182 / Sq Ft
11/16/2012 11/16/12 Sold $514,000 -1.7% $158 / Sq Ft View Prior Sale
09/27/2012 09/27/12 Pending -- -- --
09/18/2012 09/18/12 Price Changed $523,000 -3.0% $161 / Sq Ft
07/21/2012 07/21/12 For Sale $539,000 -- $166 / 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 $2,178 $57,589 -- --
2024 $2,084 $54,847 -- --
2023 $2,084 $70,750 $14,150 $56,600
2022 $2,042 $53,310 $10,660 $42,650
2021 $2,291 $52,770 $10,550 $42,220
2020 $2,259 $48,920 $9,780 $39,140
2019 $2,190 $47,450 $9,490 $37,960
2018 $2,109 $47,560 $9,510 $38,050
2017 $2,032 $45,760 $9,150 $36,610
2016 $2,021 $45,260 $9,050 $36,210
2015 $1,913 $42,830 $8,560 $34,270
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: 5430829

Arizona Regional Multiple Listing Service (ARMLS)

APN: 219-37-483