Best Scottsdale Realtor

Top Scottsdale Realtor for Golf Homes - Compare Golf Communities

  • Home
  • Search
    • Search by Price
      • $500,000 – $750,000
      • $750,000 – $1 Million
      • $1-2 million
      • $2 Million Plus
    • Golf Homes
    • Gated Homes
    • New Homes
    • Homes with Casitas
    • Condos   
      • Golf Condos
      • Search Condos by Price
        • $300,000 – $500,000
        • $500,000 – $750,000
        • $750,000 – $1,000,000
        • $1,000,000 Plus
      • Condo Communities
    • Communities
  • Golf Clubs
    • Golf Homes
    • Golf Condos
    • Golf Map
  • Blog
  • Market Trends   
    • Articles
    • What’s My Home Worth?
  • Meet Carmen
    • Meet Lisa
    • About Us
    • Recent Sales
    • Reviews
  • Contact Us
Homes For Sale
Request More Info Schedule a Showing Share Print
View Virtual Tour
Price $5,700,000
Status Active
Beds 6
Baths 11 Baths
Home size 8,225 sqft
Lot Size 30,057 sqft
Days on Market 232
Elegant and Prestigious :: completely rebuilt in 2022 of a 1920 registered historic home. With more than 7,000 sq feet of finished decks, it's a perfect venue for upscale gatherings, grand events, and raising your family. Upon entering through a stunning oversized glass pivot door, you're greeted by a chic glass floor walkway above with state-of-the-art custom accent lighting that leads you through expansive living areas. The heart of the home is a chef's kitchen designed for the most discerning culinary enthusiasts, featuring custom Heston refrigerators, a 17-element stove, and a custom wine refrigerator. Equipped with floor-to-ceiling folding glass doors, providing an indoor/outdoor experience that captivates the modern yet timeless elegance of this magnificent estate. The wine bar, cigar/china room and sleek elevator add a touch of new age convenience to the home's historic character. Hand-selected imported Burmese wood floors lead you to the dining area adorned with crystal chandeliers, all equipped with lift systems for easy cleaning. Guests may enter through the historic entrance greeting them an impressive backlit opal floor and custom spiral glass staircase. For relaxation, retreat to the master suite, complete with a hot tub on the private patio, a mini kitchen, and a wine room. Each bedroom features its own ensuite bathroom and independent AC zone. The property is also equipped with smart home technology throughout, making it easy to set the perfect ambiance for any event. Outside, the Malibu-style backyard features a vast pool with a swim-up bar, custom waterfall and tanning bubbler platform, white sand lounge areas, and an outdoor kitchen equipped for any occasion. The pool also features a spa and a cold plunge. A spa building with a steam shower, sauna, and locker room complements the lifestyle, while a gym with sliding glass doors offers an indoor-outdoor fitness experience. The guest house provides privacy for visitors, with a fully equipped kitchen, custom tile flooring, and sliding glass doors. Every inch of this home has been redesigned with both luxury and functionality in mind, from the hidden TV in the living room to the automatic wine bar and custom-built closets. With its 800-panel APS installation, all-new commercial-grade utilities, and smart home systems, this estate blends historic appeal with cutting-edge functionality. Advanced soundproofing insulation ensures serenity throughout. Reimagined for modern living, this distinguished estate is a work of art honoring the history of Phoenix, while offering the perfect balance of elegance, technology and comfort.
Property Type(s): Single Family
Last Updated 10/24/2025 Tract LOS OLIVOS RESUB
Year Built 2022 Community LOS OLIVOS RESUB
Garage Spaces 3.0 County Maricopa

SCHOOLS

Elementary School Ralph Waldo Emerson Elementary School
Jr. High School Phoenix #1 iAcademy
High School North High School

Additional Details

AIR Central Air, ENERGY STAR Qualified Equipment
AIR CONDITIONING Yes
APPLIANCES Dishwasher, Disposal, Dryer, Gas Cooktop, Microwave, Refrigerator, Washer, Water Purifier
BASEMENT Partial, Unfinished, Yes
CONSTRUCTION Block, Brick Veneer, Ducts Professionally Air-Sea, Low VOC Insulation, Spray Foam Insulation, Stucco
EXTERIOR Balcony, Guest House, Other, Playground, Private Yard, Storage
GARAGE 3 Space(s), Attached Garage, Detached, Direct Access, Electric Vehicle Charging Station(s), Garage Door Opener, Yes
HEAT ENERGY STAR Qualified Equipment, Natural Gas
INTERIOR Breakfast Bar, Central Vacuum, Double Vanity, Eat-in Kitchen, Elevator, Granite Counters, High Ceilings, High Speed Internet, Kitchen Island, Pantry, See Remarks, Smart Home, Vaulted Ceiling(s), Wet Bar
LOT 0.69 acre(s)
LOT DESCRIPTION Sprinklers In Front, Sprinklers In Rear
PARKING Gated, Garage Door Opener, Direct Access, Detached, Electric Vehicle Charging Station(s)
POOL Yes
POOL DESCRIPTION Fenced, Heated, Lap
SEWER Public Sewer
STORIES 2
STYLE Contemporary, Spanish
SUBDIVISION LOS OLIVOS RESUB
TAXES 7770
UTILITIES Cable Available
VIEW Yes
VIEW DESCRIPTION City, Trees/Woods
WATER Public

Location

 

Contact us about this Property

 / 
We respect your online privacy and will never spam you. By submitting this form with your telephone number you are consenting for Carmen Brodeur to contact you even if your name is on a Federal or State "Do not call List".

Listed with Compass
The ARMLS logo indicates a property listed by a real estate brokerage other than Trillium Properties LLC.
All information should be verified by the recipient and none is guaranteed as accurate by ARMLS.

Copyright 2026 Arizona Regional Multiple Listing Service, Inc. All rights reserved.

Data last updated 6/9/26 10:47 AM PDT.

This IDX solution is (c) Diverse Solutions 2026.

Share on Twitter Twitter
Share on Facebook Facebook
Share by Email Email
Email a Friend
Carmen Brodeur Scottsdale RealtorVoted in the Top 3 Real Estate Agents in Arizona by the readers of Ranking Arizona Magazine, 2015-2025. Her background as an Attorney gives her special expertise with contracts and negotiations. Carmen has a proven track record of success with buyers and sellers in Scottsdale.

Find me on

  • Email
  • Facebook
  • Instagram
  • LinkedIn

Your Scottsdale Real Estate Connection

Whether you are buying or selling, we are committed to providing you with exceptional service. Put our experience to work for you. Contact Carmen Brodeur today at Carmen@TopScottsdaleHomes.com

Our Office

We are conveniently located in North Scottsdale.

Trillium Properties, LLC
20715 N. Pima Road, Suite 108
Scottsdale AZ 85255
(602) 791-0536
Carmen@TopScottsdaleHomes.com
 
Best Scottsdale Realtor      Ranking Arizona Best Real Estate Agent       Scottsdale Real Estate Agent
Copyright © 2026 - All Rights Reserved,     Do Not Copy     Log in