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 $1,250,000
Status Active
Beds 4
Baths 4 Baths
Home size 4,169 sqft
Lot Size 9,584 sqft
Days on Market 39
Lovingly remodeled and custom built by the original owner, this exceptional corner-lot home blends craftsmanship, comfort, and thoughtful design throughout. A private courtyard with a custom iron gate creates a warm and inviting entrance. Inside, vaulted ceilings elevate the main living space, where a gourmet kitchen anchors the heart of the home with island seating, stainless steel appliances, gas cooktop, double ovens, wine cooler, and abundant built-in shelving for both beauty and function. A generous walk-in pantry and custom cabinetry open to a spacious family room designed for gathering and everyday living. The main level offers two well-appointed bedrooms connected by a Jack-and-Jill bathroom. Upstairs, you'll find a versatile den or office, a large en-suite bedroom, and a truly spectacular primary retreat with soaring ceilings, breathtaking mountain views, and two oversized walk-in closets with extensive built-ins. The backyard is made for Arizona living with a huge covered patio, built-in BBQ, gas heater for cooler evenings, RV gate, desert landscaping, and low-maintenance AstroTurf. Garage and storage room are air conditioned. The location is epic, near some of the Valley's favorite restaurants and minutes from anywhere in the city.
Property Type(s): Single Family
Last Updated 6/8/2026 Tract MAYFAIR MANOR
Year Built 2008 Community MAYFAIR MANOR
Garage Spaces 2.0 County Maricopa

SCHOOLS

Elementary School Madison #1 Elementary School
Jr. High School Madison #1 Elementary School
High School North High School

Price History

Prior to Jun 8, '26 $1,275,000
Jun 8, '26 - Today $1,250,000

Additional Details

AIR Ceiling Fan(s), Central Air
AIR CONDITIONING Yes
APPLIANCES Built-In Electric Oven, Dishwasher, Disposal, Dryer, Electric Oven, Gas Cooktop, Gas Range, Microwave, Refrigerator, Washer
CONSTRUCTION Frame, Stucco
EXTERIOR Balcony, Barbecue, Built-in Barbecue
FIREPLACE Yes
GARAGE 2 Space(s), Attached Garage, Garage Door Opener, Yes
HEAT Electric, Natural Gas
INTERIOR Bidet, Breakfast Bar, Double Vanity, Eat-in Kitchen, High Speed Internet, Kitchen Island, Pantry, Vaulted Ceiling(s)
LOT 9583 sq ft
LOT DESCRIPTION Corner Lot, Desert Front
PARKING Garage Door Opener
SEWER Public Sewer
STORIES 2
SUBDIVISION MAYFAIR MANOR
TAXES 7342
UTILITIES Cable Available
VIEW Yes
VIEW DESCRIPTION Mountain(s)
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 9:40 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