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,450,000
Status Active
Beds 4
Baths 3 Baths
Home size 2,877 sqft
Lot Size 9,148 sqft
Days on Market 14
Newer construction in the highly sought-after Windsor Square neighborhood! Located within the acclaimed Madison School District, this well designed 4 bed, 3 bath residence offers 2,877 SF with a split floorplan, open-concept living, and a two-car garage. Beautiful 9.5'' wide-plank wood flooring flows throughout the main living spaces and high ceilings bring in tons of natural light. The kitchen is outfitted with stunning quartzite countertops, soft-close cabinetry, under-cabinet lighting, an oversized island, 48'' refrigerator, and a 36'' Miele convection oven range featuring steam functionality and an induction cooktop. A beverage center with a new countertop and new refrigerator enhances both entertaining and everyday convenience. The spacious primary suite offers direct backyard access and a spa-inspired bath complete with a soaking tub and oversized walk-in shower. The backyard was designed for year-round enjoyment, featuring a heated saltwater pool and spa completed in 2021 and built-in BBQ. Prime Uptown Phoenix location near dining, shopping, farmers markets, parade routes, and more!
Property Type(s): Single Family
Last Updated 6/3/2026 Tract LAMSON SUB. LOTS 7-10
Year Built 2017 Community LAMSON SUB. LOTS 7-10
Garage Spaces 2.0 County Maricopa

SCHOOLS

Elementary School Madison Richard Simis School
Jr. High School Madison Meadows School
High School Central High School

Additional Details

AIR Ceiling Fan(s), Central Air, ENERGY STAR Qualified Equipment
AIR CONDITIONING Yes
APPLIANCES Dishwasher, Disposal, ENERGY STAR Qualified Dryer, ENERGY STAR Qualified Washer, Gas Range, Induction Cooktop, Microwave, Refrigerator, Water Softener Owned
CONSTRUCTION Frame, Stucco
EXTERIOR Barbecue, Built-in Barbecue
FIREPLACE Yes
GARAGE 2 Space(s), Attached Garage, Direct Access, Garage Door Opener, Yes
HEAT Electric, ENERGY STAR Qualified Equipment
INTERIOR Breakfast Bar, Double Vanity, High Speed Internet, Kitchen Island, Vaulted Ceiling(s)
LOT 9148 sq ft
LOT DESCRIPTION Sprinklers In Front, Sprinklers In Rear
PARKING Garage Door Opener, Direct Access
POOL Yes
POOL DESCRIPTION Heated
SEWER Public Sewer
STORIES 1
STYLE Ranch
SUBDIVISION LAMSON SUB. LOTS 7-10
TAXES 7196
UTILITIES Cable Available
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 The Brokery
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:49 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