NOT LISTED FOR SALE

Estimated Value: $6,524,000 - $8,618,000

7 Beds
6.5 Baths
7,416 Sq Ft
$1,007/Sq Ft Est. Value

Last Sold April 04, 2018

Last sale price $3,760,000 $507 Per Sq Ft

Est. 103% increase in value since last sale

Current estimated payment $43,052/month

94 Days on Market

Highlights

  • Guest House
  • Private Pool
  • Mountain View
  • Cherokee Elementary School Rated A
  • 1.02 Acre Lot
  • Contemporary Architecture

About This Home

As of April 2018

Spectacular New Custom Estate Sleek contemporary Transitional-Quality Built.Dramatic main entrance with Mtn views and soaring ceilings, Grand areas for entertaining.The Kitchen includes the Top of-the-line appliances,2 Islands,opening to Large family room & separate Game room overlooking the Resort Backyard+Detached Guest House!Oversized 5 car Garage-Professionally Designed Estate with the Highest Quality/Finishes

Last Agent to Sell the Property

Hans Horchler

Russ Lyon Sotheby's International Realty License #SA105149000 Listed on: 07/28/2017

Russ Lyon Sotheby's International Realty

Last Buyer's Agent

David Hersh

Realty ONE Group License #SA661144000

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,221

Year Built

  • Built in 2017

Lot Details

  • 1.02 Acre Lot
  • Desert faces the front and back of the property
  • Block Wall Fence
  • Front and Back Yard Sprinklers
  • Sprinklers on Timer
  • Private Yard
  • Grass Covered Lot

Parking

  • 4 Open Parking Spaces
  • 5 Car Garage
  • Side or Rear Entrance to Parking

Home Design

  • Designed by Architecture+Plus Architects
  • Contemporary Architecture
  • Wood Frame Construction
  • Built-Up Roof
  • Foam Roof
  • Stucco

Interior Spaces

  • 7,416 Sq Ft Home
  • 1-Story Property
  • Vaulted Ceiling
  • Gas Fireplace
  • Family Room with Fireplace
  • 3 Fireplaces
  • Living Room with Fireplace
  • Mountain Views

Kitchen

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

Bedrooms and Bathrooms

  • 7 Bedrooms
  • Walk-In Closet
  • Primary Bathroom is a Full Bathroom
  • 6.5 Bathrooms
  • Dual Vanity Sinks in Primary Bathroom
  • Bathtub With Separate Shower Stall

Laundry

  • Laundry in unit
  • Washer and Dryer Hookup

Pool

  • Private Pool
  • Spa

Outdoor Features

  • Covered Patio or Porch
  • Playground

Additional Homes

  • Guest House

Schools

  • Cherokee Elementary School
  • Cocopah Middle School
  • Chaparral High School

Utilities

  • Refrigerated Cooling System
  • Heating System Uses Natural Gas
  • Tankless Water Heater
  • High Speed Internet
  • Cable TV Available

Community Details

  • No Home Owners Association
  • Built by Custom
  • Turquoise Hills Subdivision, Transitional Contemp Floorplan

Listing and Financial Details

  • Tax Lot 27
  • Assessor Parcel Number 168-65-020

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,221

Year Built

Built in 2017

Lot Details

0

Parking

5

Listing Details

  • Cross Street: Doubletree South on 56th Street/Quiet North PV
  • Legal Info Range: 4E
  • Property Type: Residential
  • Architect Architect: Architecture+Plus
  • 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: 5.0
  • Separate Den Office Sep Den Office: N
  • Year Built: 2017
  • Spa Private: Yes
  • Tax Year: 2016
  • Directions: 56th South of Doubletree
  • Master Model: Transitional Contemp
  • Property Sub Type: Single Family - Detached
  • Lot Size Acres: 1.02
  • Subdivision Name: TURQUOISE HILLS
  • Architectural Style: Contemporary
  • Property Attached Yn: No
  • Dining Area:Breakfast Bar: Yes
  • Technology:Cable TV Avail: Yes
  • Technology:High Speed Internet Available: Yes
  • Special Features: None

Interior Features

  • Spa Features: Private
  • Possible Bedrooms: 8
  • Total Bedrooms: 7
  • Fireplace Features: 3+ Fireplace, Family Room, Living Room, Gas
  • Fireplace: Yes
  • Interior Amenities: Walk-In Closet(s), Eat-in Kitchen, Breakfast Bar, 9+ Flat Ceilings, Vaulted Ceiling(s), Kitchen Island, Pantry, Double Vanity, Full Bth Master Bdrm, Separate Shwr & Tub, High Speed Internet
  • Living Area: 7416.0
  • Stories: 1
  • Kitchen Features:RangeOven Gas: Yes
  • Kitchen Features:Dishwasher2: Yes
  • Kitchen Features:Built-in Microwave: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Master Bathroom:Double Sinks: Yes
  • Kitchen Features:Disposal2: Yes
  • Kitchen Features:Refrigerator2: Yes
  • Kitchen Features Pantry: Yes
  • Fireplace:Fireplace Family Rm: Yes
  • Other Rooms:Family Room: Yes
  • Fireplace:Gas Fireplace: Yes
  • Kitchen Features:Walk-in Pantry: Yes
  • Other Rooms:BonusGame Room: Yes
  • Fireplace:Fireplace Living Rm: Yes
  • Other Rooms:Guest Qtrs-Sep Entrn: Yes
  • Fireplace:_three_ Fireplace: Yes
  • Other Rooms:Media Room: Yes
  • Other Rooms:ExerciseSauna Room: Yes

Exterior Features

  • Fencing: Block
  • Exterior Features: Covered Patio(s), Playground, Patio, Private Yard
  • Lot Features: Sprinklers In Rear, Sprinklers In Front, Desert Back, Desert Front, Grass Back, Auto Timer H2O Front, Auto Timer H2O Back, Irrigation Front, Irrigation Back
  • Pool Features: Private
  • View: Mountain(s)
  • Disclosures: Other (See Remarks)
  • Construction Type: Painted, Stucco, Frame - Wood
  • Other Structures: Guest House
  • Roof: Built-Up, Foam
  • Construction:Frame - Wood: Yes
  • Exterior Features:Covered Patio(s): Yes
  • Exterior Features:Childrens Play Area: Yes
  • Exterior Features:Patio: Yes
  • Exterior Features:Pvt Yrd(s)Crtyrd(s): Yes
  • Exterior Features:Separate Guest House: Yes

Garage/Parking

  • Total Covered Spaces: 5.0
  • Parking Features: Side Vehicle Entry
  • Attached Garage: No
  • Garage Spaces: 5.0
  • Open Parking Spaces: 4.0
  • Parking Features:Side Vehicle Entry: Yes

Utilities

  • Cooling: Refrigeration
  • Heating: Natural Gas
  • Laundry Features: Inside, Wshr/Dry HookUp Only
  • Water Source: City Water
  • Heating:Natural Gas: Yes

Condo/Co-op/Association

  • Amenities: Other
  • 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

Schools

  • Elementary School: Cherokee Elementary School
  • High School: Chaparral High School
  • Middle Or Junior School: Cocopah Middle School

Lot Info

  • Land Lease: No
  • Lot Size Sq Ft: 44546.0
  • Parcel #: 168-65-020
  • ResoLotSizeUnits: SquareFeet

Green Features

  • Green Water Conservation: Tankless Ht Wtr Heat

Building Info

  • Builder Name: Custom

Tax Info

  • Tax Annual Amount: 5221.0
  • Tax Book Number: 168.00
  • Tax Lot: 27
  • Tax Map Number: 65.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Mar 8, 2024
Sold by
Maffi Bonnie
Bought by
Royal Palm Llc
Current Estimated Value
$7,626,776

Purchase Details

Closed on
Mar 7, 2024
Sold by
Odin New Horizon Real Estate Fund Lp
Bought by
Maffi Terry and Maffi Bonnie J

Purchase Details

Closed on
Feb 20, 2024
Sold by
Maffi Terry
Bought by
Maffi Bonnie J

Purchase Details

Closed on
Oct 30, 2017
Sold by
Rfg Real Estate Llc
Bought by
Maffi Terry and Maffi Bonnie

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$3,008,000
Interest Rate
4.87%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Closed on
Nov 23, 2016
Sold by
Bjan Family Enterprises Llc
Bought by
Rfg Real Estate Llc

Purchase Details

Listed on
Nov 1, 2014
Closed on
Apr 21, 2015
Sold by
Cummings Marilyn D
Bought by
Bjan Family Enterprises Llc
Seller's Agent
Kathryn Cummings
Russ Lyon Sotheby's International Realty
Buyer's Agent
Jonathan Wall
DPR Realty LLC
List Price
$1,100,000
Sold Price
$892,799
Premium/Discount to List
-$207,201
-18.84%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
23.41%

Purchase Details

Closed on
Apr 3, 1994
Sold by
Cummings Howard H
Bought by
Cummings Marilyn D

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$140,000
Interest Rate
7.59%
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
Royal Palm Llc $6,540,500 Premier Title Agency
Maffi Terry -- None Listed On Document
Maffi Terry -- None Listed On Document
Maffi Bonnie J -- None Listed On Document
Maffi Terry $3,760,000 First American Title Insuran
Rfg Real Estate Llc $995,000 First Arizona Title Agency
Bjan Family Enterprises Llc $892,799 First Arizona Title Agency
Cummings Marilyn D -- United Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Royal Palm Llc $5,000,000
Previous Owner Maffi Terry $0
Previous Owner Maffi Terry $3,008,000
Previous Owner Cummings Marilyn D $300,000
Previous Owner Cummings Marilyn D $559,000
Previous Owner Cummings Marilyn D $100,000
Previous Owner Cummings Marilyn D $140,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
04/04/2018 04/04/18 Sold $3,760,000 -3.2% $507 / Sq Ft
10/28/2017 10/28/17 Pending -- -- --
07/26/2017 07/26/17 For Sale $3,884,000 +335.0% $524 / Sq Ft
04/27/2015 04/27/15 Sold $892,799 -10.3% $304 / Sq Ft
01/05/2015 01/05/15 Price Changed $995,000 -9.5% $338 / Sq Ft
11/01/2014 11/01/14 For Sale $1,100,000 -- $374 / 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 $15,541 $264,355 -- --
2024 $15,326 $251,766 -- --
2023 $15,326 $424,070 $84,810 $339,260
2022 $14,702 $369,810 $73,960 $295,850
2021 $15,629 $329,170 $65,830 $263,340
2020 $15,529 $297,580 $59,510 $238,070
2019 $14,993 $273,980 $54,790 $219,190
2018 $6,951 $147,990 $147,990 $0
2017 $5,332 $69,310 $13,860 $55,450
2016 $5,221 $67,170 $13,430 $53,740
2015 $4,954 $67,170 $13,430 $53,740
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: 5638771

Arizona Regional Multiple Listing Service (ARMLS)

APN: 168-65-020