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,995,000
Status Active
Beds 2
Baths 3 Baths
Home size 2,265 sqft
Lot Size n/a
Days on Market 82
Beautifully renovated residence at the Scottsdale Waterfront Residences, offering a rare 2 bedroom + Den, upper-floor location with two private balconies, a desirable split floor plan, and stunning mountain and canal views. Exceptional finishes are showcased throughout, including a redesigned kitchen with quartz countertops, custom cabinetry, and Viking appliances. The living space is anchored by a newly designed gas fireplace and enhanced with custom electronic shades, including blackout features for added comfort. The primary suite serves as a private retreat, featuring a fully renovated bath and its own balcony overlooking the canal and iconic fountain below taking in the peaceful setting of the surrounding views. This home is truly move-in ready. Simply arrive, settle in, and begin enjoying effortless downtown living. The home comes with 2 side-by-side parking spaces and 1 large storage unit. Residents of the Waterfront enjoy premier amenities including a fitness center, rooftop pool and spa, club room, wine cellar, and outdoor BBQ areas, along with the convenience of concierge services.
Property Type(s): Single Family
Last Updated 3/23/2026 Tract SCOTTSDALE WATERFRONT RESIDENCES
Year Built 2007 Community SCOTTSDALE WATERFRONT RESIDENCES
Garage Spaces 2.0 County Maricopa

SCHOOLS

Elementary School Hopi Elementary School
Jr. High School Ingleside Middle School
High School Arcadia High School

Additional Details

AIR Ceiling Fan(s), Central Air
AIR CONDITIONING Yes
AMENITIES Fitness Center, Gated, Pool, Sidewalks
APPLIANCES Built-In Electric Oven, Dishwasher, Disposal, Dryer, Gas Cooktop, Gas Oven, Gas Range, Microwave, Refrigerator, Washer, Water Softener Owned
CONSTRUCTION Stone, Stucco
EXTERIOR Balcony, Storage
FIREPLACE Yes
GARAGE 2 Space(s), Direct Access, Electric Vehicle Charging Station(s), Garage Door Opener, Yes
HEAT Electric, Heat Pump
INTERIOR Breakfast Bar, Double Vanity, High Ceilings, High Speed Internet, Kitchen Island, Pantry
LOT DESCRIPTION Waterfront
PARKING Gated, Garage Door Opener, Direct Access, Assigned, Community Structure, Permit Required, Valet, Common, Electric Vehicle Charging Station(s)
SEWER Public Sewer
STORIES 1
STYLE Contemporary
SUBDIVISION SCOTTSDALE WATERFRONT RESIDENCES
TAXES 7478
UTILITIES Cable Available
VIEW Yes
VIEW DESCRIPTION City, City Lights, Mountain(s)
WATER Public
WATERFRONT Yes

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 RETSY
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:17 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