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 $875,000
Status Active
Beds 3
Baths 2 Baths
Home size 1,772 sqft
Lot Size 10,455 sqft
Days on Market 40
Mid-Century meets modern minutes from Old Town. This 3-bed, 2-bath icurrently operates as a successful STR, yet lives beautifully as a primary residence. The open concept kitchen features a farmhouse sink, upgraded appliances, quartz, separate dining and opens to living room. A spacious additional great room showcases two walls of slider doors, creating easy indoor-outdoor living opening to a patio on one side and pool on the other. The low-maintenance yard with artificial turf is perfect for entertaining. Additional highlights include an interior laundry room, attached garage, and a second detached garage that could be converted into a casita, game room, or extra storage. Located within walking distance to shopping and dining. This is one of most livable zip codes in the valley!
Property Type(s): Single Family
Last Updated 5/1/2026 Tract JUANITA ''Y'' OLMO FRONTIER PLACE
Year Built 1956 Community JUANITA ''Y'' OLMO FRONTIER PLACE
Garage Spaces 2.0 County Maricopa

SCHOOLS

Elementary School Pima Elementary School
Jr. High School Tonalea Middle School
High School Coronado High School

Additional Details

AIR Ceiling Fan(s), Central Air
AIR CONDITIONING Yes
APPLIANCES Dishwasher, Disposal, Dryer, Gas Range, Microwave, Refrigerator, Washer
CONSTRUCTION Block, Stucco
GARAGE 2 Space(s), Attached Garage, Detached, Garage Door Opener, Yes
HEAT Natural Gas
INTERIOR Breakfast Bar, Double Vanity, High Speed Internet, Kitchen Island
LOT 10454 sq ft
LOT DESCRIPTION Desert Front
PARKING Garage Door Opener, Detached
POOL Yes
POOL DESCRIPTION Heated
SEWER Public Sewer
STORIES 1
STYLE Ranch
SUBDIVISION JUANITA ''Y'' OLMO FRONTIER PLACE
TAXES 1870
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 eXp Realty
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 1:54 PM 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