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 $649,000
Status Active
Beds 3
Baths 3 Baths
Home size 2,058 sqft
Lot Size 2,178 sqft
Days on Market 450
NEW HVAC with 10yr warranty just installed and selling price includes most of the furniture!! Located in ''The Overlook,'' in NE Scottsdale, this 3 bedroom, 3 bathroom condo offers a prime location in a well maintained, gated community. It features a large primary suite, with a walk-in closet and en-suite bath. The large secondary suite also features a walk-in closet and en-suite bathroom. The open great room boasts a gas fireplace. The kitchen includes dual ovens, granite countertops, and a reverse osmosis system. There is tiled flooring throughout, including the covered patio, which overlooks a spacious grassy common area and has pool views. There is a one-car garage. In addition to the pool, this community includes a clubhouse with a kitchen, gathering space, and a fitness room. Conveniently located near shopping, dining, Mayo Clinic's Scottsdale campus, Fountain Hills and just a 4-minute drive to Lost Dog Wash Trail.
Property Type(s): Single Family
Last Updated 5/18/2026 Tract MIRAGE MOUNTAIN PHASE 1 CONDOMINIUM
Year Built 2005 Community MIRAGE MOUNTAIN PHASE 1 CONDOMINIUM
Garage Spaces 1.0 County Maricopa

SCHOOLS

Elementary School Anasazi Elementary
Jr. High School Mountainside Middle School
High School Desert Mountain High School

Price History

Prior to Sep 25, '25 $748,000
Sep 25, '25 - Feb 27, '26 $738,000
Feb 27, '26 - May 18, '26 $665,000
May 18, '26 - Today $649,000

Additional Details

AIR Ceiling Fan(s), Central Air
AIR CONDITIONING Yes
AMENITIES Fitness Center, Gated, Pool
APPLIANCES Dishwasher, Disposal, Dryer, Electric Cooktop, Electric Oven, Electric Range, Microwave, Refrigerator, Washer, Water Softener Owned
CONSTRUCTION Frame, Stucco
FIREPLACE Yes
GARAGE 1 Space(s), Detached, Garage Door Opener, Yes
HEAT Natural Gas
HOA DUES 485|Monthly
INTERIOR Double Vanity, Granite Counters, High Speed Internet
LOT 2178 sq ft
PARKING Garage Door Opener, Detached
POOL DESCRIPTION None
SEWER Public Sewer
STORIES 1
SUBDIVISION MIRAGE MOUNTAIN PHASE 1 CONDOMINIUM
TAXES 2845
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 RE/MAX Fine Properties
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 5:31 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