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
Price $4,100,000
Status Active
Beds 8
Baths 8 Baths
Home size 8,337 sqft
Lot Size 2.19 ac
Days on Market 85
A standout opportunity for entertainers, car collectors, and those who appreciate elevated luxury living in the hills. This home brings the wow factor with a private indoor basketball court and fitness space, plus a dedicated home theater for the ultimate at home experience. The court also offers flexibility to convert into additional garage bays, perfect for showcasing a prized collection. Designed for both everyday comfort and elevated entertaining, the main level features refined formal living and dining spaces, a spacious family room off the kitchen, a private office, and a luxurious primary suite complete with its own sitting area. Step outside to a resort-style setting with a pool and covered spa, all perfectly positioned to capture breathtaking city lights and mountain views.
Property Type(s): Single Family
Last Updated 3/20/2026 Tract CRESTVIEW AT FOUNTAIN HILLS
Year Built 2007 Community CRESTVIEW AT FOUNTAIN HILLS
Garage Spaces 7.0 County Maricopa

SCHOOLS

Elementary School Fountain Hills Middle School
Jr. High School Fountain Hills Middle School
High School Fountain Hills High School

Additional Details

AIR Ceiling Fan(s), Central Air
AIR CONDITIONING Yes
AMENITIES Gated
APPLIANCES Dishwasher, Disposal, Refrigerator
CONSTRUCTION Frame, Stone, Stucco
EXTERIOR Balcony, Barbecue, Built-in Barbecue, Private Yard
FIREPLACE Yes
GARAGE 7 Space(s), Garage Door Opener, Garage Faces Side, Yes
HEAT Natural Gas
HOA DUES 350|Quarterly
INTERIOR Bidet, Breakfast Bar, Central Vacuum, Double Vanity, Eat-in Kitchen, High Ceilings, Kitchen Island, Pantry, Vaulted Ceiling(s), Wet Bar
LOT 2.19 acre(s)
LOT DESCRIPTION Desert Front, Sprinklers In Front, Sprinklers In Rear
PARKING Garage Door Opener, Circular Driveway, Garage Faces Side
POOL Yes
POOL DESCRIPTION Heated
SEWER Private Sewer
STORIES 3
STYLE Santa Barbara/Tuscan
SUBDIVISION CRESTVIEW AT FOUNTAIN HILLS
TAXES 9689
UTILITIES Cable Available
VIEW Yes
VIEW DESCRIPTION City, City Lights, Mountain(s)

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 Barrett Real Estate
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/13/26 6:46 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