PerformAction
logo  logo  logo  logo
  • (480) 505-6300
  • Sign In / Sign Up
APP
  • SEARCH
    • Map Search
    • Featured Properties
    • New Listings
    • NEW HOMES
    • Luxury
    • Price Reduced
    • Open Houses
    • Virtual Tours
  • BUYERS
    • OnePoint
    • Mortgage Loans
      • Prosperity Home Mortgage
      • Mortgage Calculator
      • Loan Types
      • Mortgage 101
    • Financing FAQ
    • Relocation Services
    • American Home Shield
    • Hud Homes
  • SELLERS
    • OnePoint
    • SELLING
    • HOME VALUE ESTIMATE
    • LIST WITH US
    • SHORT SALES
    • MARKET REPORTS
    • RELOCATION SERVICES
  • COMMUNITIES
  • LUXURY
  • AGENTS
  • OFFICES
  • ABOUT US
    • Company
    • Leadership
    • Relocation Services
    • OnePoint
    • Charitable Foundation
    • Company Videos
    • Join Our Firm
      • Career Opportunity
      • Experienced Agent
      • Free Reports & Tips
      • Agent Success Story
    • Contact
  • CAREERS
    • Career Opportunity
    • Experienced Agents
    • Free Reports & Tips
    • Agent Success Stories
  • BLOG
    • SEARCH
      • Map Search
      • Featured Properties
      • New Listings
      • NEW HOMES
      • Luxury
      • Price Reduced
      • Open Houses
      • Virtual Tours
    • BUYERS
      • OnePoint
      • Mortgage Loans
        • Prosperity Home Mortgage
        • Mortgage Calculator
        • Loan Types
        • Mortgage 101
      • Financing FAQ
      • Relocation Services
      • American Home Shield
      • Hud Homes
    • SELLERS
      • OnePoint
      • SELLING
      • HOME VALUE ESTIMATE
      • LIST WITH US
      • SHORT SALES
      • MARKET REPORTS
      • RELOCATION SERVICES
    • COMMUNITIES
    • LUXURY
    • AGENTS
    • OFFICES
    • ABOUT US
      • Company
      • Leadership
      • Relocation Services
      • OnePoint
      • Charitable Foundation
      • Company Videos
      • Join Our Firm
        • Career Opportunity
        • Experienced Agent
        • Free Reports & Tips
        • Agent Success Story
      • Contact
    • CAREERS
      • Career Opportunity
      • Experienced Agents
      • Free Reports & Tips
      • Agent Success Stories
    • BLOG
APP
Sign In / Sign Up
Clear Price
Cancel
Done Search

28413 N 151 Street, Scottsdale, AZ 85262 (Sold on )

  • Open House OpenHouseOn
  • New Listing
  • Price Reduced$50,000
  • Virtual Open House
  • PENDING UNDER CONTRACT
  • The seller has accepted an offer on this property.

 $3,200,000

  • Property Info
  • Photos
  • Print
  • Saved Save Listing
  • Share Listing
  • Virtual Tour
more_vert
  • Property Info
  • Photos
  • Print
Photos
  • 5 BedBeds
  • 5 BathBaths
  • 4,774 SqftSqft
  • TypeSingle Family
  • Active
  • MLS# 6989021

Virtual Tours

  • VirtualAdditionalTourImage

Property Description

Brand new custom estate on 1.16 acres in a gated community. This stunning single level 5 bed, 4.5 bath home delivers 4,774 SF with cathedral ceilings, exposed beams, and multi slide glass doors framing panoramic mountain views. The kitchen showcases a cultured marble waterfall island, wood cabinetry, and professional grade appliances open to the great room with modern linear fireplace. Entertain in the formal dining or game room. Primary suite with hardwood floors, floor to ceiling windows, spa bath with his and hers toilets, and custom walk in closet. Two ensuite bedrooms plus Jack and Jill bath for guests. Resort backyard with sparkling pool, water features, and finished landscaping beneath a covered patio. Whole home smart technology with bluetooth speakers, 3 car garage, and RV gate.

Thank you for requesting a showing of this property. A representative will be in touch with you shortly to confirm the requested showing date and time.
Please note that your appointment is not confirmed until someone contacts you.

Request Info / Schedule Showing

Submit

Property Details 28413 N 151 Street, Scottsdale, AZ 85262

General

  • MLS#: 6989021
  • Property Type: Single Family
  • Property Sub Type: Single Family Residence
  • List Date: 02/24/2026
  • Year Built: 2026
  • Subdivision: Rio Mountain Estates
  • County: Maricopa
  • Beds: 5
  • Full Bath: 4
  • Half Bath: 1
  • Total Baths: 5
  • Pool: Outdoor, Heated
  • Community Features: Gated
  • Tax Year: 2025
  • Annual Taxes: $1,850.00
  • Association Fee: $325.00
  • Association Fee Frequency: Quarterly
  • Association Fee Includes: Maintenance Grounds

Interior Features

  • Interior Features: Walk-in Pantry, Smart Home, Double Vanity, Eat-in Kitchen, Breakfast Bar, Vaulted Ceiling, Pantry, 2 Master Baths, Full Bth Master Bdrm, Separate Shwr & Tub
  • Flooring: Tile
  • Laundry: Inside
  • Spa: Private
  • Fireplace: Insert

Exterior Features

  • Exterior Features: Private Street(s), RV Hookup

Schools

  • Elementary: Horseshoe Trails Elementary School
  • Middle or Junior: Horseshoe Trails Elementary School
  • High: Cactus Shadows High School
  • School District: Cave Creek Unified District

Structure

  • Roof: Tile
  • Garage Spaces: 3
  • Parking: Attached Garage, Gated, RV Gate, Garage Door Opener, Electric Vehicle Charging Station(s)
  • Construction Type: Stucco, Metal Siding, Wood Frame, Stone

Size & Lot

  • Total Sq.Ft: 4,774
  • Acres: 1.17
  • Lot Size: 1.1700
  • Approx Lot SqFt: 50,862
  • Lot Features: Desert Front, Gravel/Stone Front, Synthetic Grass Back, Auto Timer H2O Front, Auto Timer H2O Back, Irrigation Front, Irrigation Back

Utilities

  • Cooling: Central Air
  • Heat Source: Ceiling, Propane
  • Sewer: Septic Tank

Estimated Monthly Mortgage Calculator

This calculator is provided for informational purposes. You should not make any decisions based simply on the information provided. Values indicated are estimates and may not be accurate and are only to be used as a guide. This calculator should not be relied upon in any way as the sole source of information. Please consult your financial, tax or legal advisers for an accurate assessment of your mortgage payments and any advice relating to your personal circumstances.


Similar Listings

    • Open House
    • Price Reduced
    • New Listing
    • Pending
    • Pending Under Contract
    • Coming Soon
    • Virtual Open House
    • Virtual Tour
    • Sold
    • Leased
    29360 N 108TH Place, Scottsdale
    $4,000,000
    MLS# 6966287Single Family
    5,004 Sq. Ft.
    4 BEDS5 BATHS
    Request Info
    Delete
    29360 N 108TH Place, ScottsdaleDetails
      • Open House
      • Price Reduced
      • New Listing
      • Pending
      • Pending Under Contract
      • Coming Soon
      • Virtual Open House
      • Virtual Tour
      • Sold
      • Leased
      29206 N 101st Street, Scottsdale
      $4,000,000
      MLS# 6969751Single Family
      7,436 Sq. Ft.
      5 BEDS7 BATHS
      Request Info
      Delete
      29206 N 101st Street, ScottsdaleDetails
        • Open House
        • Price Reduced
        • New Listing
        • Pending
        • Pending Under Contract
        • Coming Soon
        • Virtual Open House
        • Virtual Tour
        • Sold
        • Leased
        39221 N 104th Place, Scottsdale
        $4,000,000
        MLS# 6988269Single Family
        4,500 Sq. Ft.
        3 BEDS4 BATHS
        Request Info
        Delete
        39221 N 104th Place, ScottsdaleDetails
          • Open House
          • Price Reduced
          • New Listing
          • Pending
          • Pending Under Contract
          • Coming Soon
          • Virtual Open House
          • Virtual Tour
          • Sold
          • Leased
          9997 E RISING SUN Court, Scottsdale
          $4,000,000
          MLS# 6999185Single Family
          8,465 Sq. Ft.
          5 BEDS7 BATHS
          Request Info
          Delete
          9997 E RISING SUN Court, ScottsdaleDetails
            • Open House
            • Price Reduced$496,000
            • New Listing
            • Pending
            • Pending Under Contract
            • Coming Soon
            • Virtual Open House
            • Virtual Tour
            • Sold
            • Leased
            35636 N 142nd Place, Scottsdale
            $3,999,000
            MLS# 6967003Single Family
            1,568 Sq. Ft.
            1 BEDS1 BATHS
            Request Info
            Delete
            35636 N 142nd Place, ScottsdaleDetails
              • Open House
              • Price Reduced$30,000
              • New Listing
              • Pending
              • Pending Under Contract
              • Coming Soon
              • Virtual Open House
              • Virtual Tour
              • Sold
              • Leased
              37200 N CAVE CREEK Road #1019, Scottsdale
              $3,995,000
              MLS# 6984038Single Family
              3,604 Sq. Ft.
              4 BEDS5 BATHS
              Request Info
              Delete
              37200 N CAVE CREEK Road #1019, ScottsdaleDetails
                • Open House
                • Price Reduced
                • New Listing
                • Pending
                • Pending Under Contract
                • Coming Soon
                • Virtual Open House
                • Virtual Tour
                • Sold
                • Leased
                41633 N 102ND Way, Scottsdale
                $3,995,000
                MLS# 6976326Single Family
                4,002 Sq. Ft.
                4 BEDS4 BATHS
                Request Info
                Delete
                41633 N 102ND Way, ScottsdaleDetails
                  • Open House
                  • Price Reduced$100,000
                  • New Listing
                  • Pending
                  • Pending Under Contract
                  • Coming Soon
                  • Virtual Open House
                  • Virtual Tour
                  • Sold
                  • Leased
                  9467 E SUNDANCE Trail, Scottsdale
                  $3,995,000
                  MLS# 6461596Single Family
                  4,900 Sq. Ft.
                  5 BEDS6 BATHS
                  Request Info
                  Delete
                  9467 E SUNDANCE Trail, ScottsdaleDetails
                    • Open House
                    • Price Reduced
                    • New Listing
                    • Pending
                    • Pending Under Contract
                    • Coming Soon
                    • Virtual Open House
                    • Virtual Tour
                    • Sold
                    • Leased
                    9645 E HORIZON Drive, Scottsdale
                    $3,995,000
                    MLS# 6921300Single Family
                    4,077 Sq. Ft.
                    4 BEDS4 BATHS
                    Request Info
                    Delete
                    9645 E HORIZON Drive, ScottsdaleDetails
                      • Open House
                      • Price Reduced$330,000
                      • New Listing
                      • Pending
                      • Pending Under Contract
                      • Coming Soon
                      • Virtual Open House
                      • Virtual Tour
                      • Sold
                      • Leased
                      29694 N 105TH Way, Scottsdale
                      $3,995,000
                      MLS# 6929392Single Family
                      5,341 Sq. Ft.
                      4 BEDS5 BATHS
                      Request Info
                      Delete
                      29694 N 105TH Way, ScottsdaleDetails
                        • Open House
                        • Price Reduced$400,000
                        • New Listing
                        • Pending
                        • Pending Under Contract
                        • Coming Soon
                        • Virtual Open House
                        • Virtual Tour
                        • Sold
                        • Leased
                        36483 N 101ST Way, Scottsdale
                        $3,995,000
                        MLS# 6953005Single Family
                        5,032 Sq. Ft.
                        4 BEDS5 BATHS
                        Request Info
                        Delete
                        36483 N 101ST Way, ScottsdaleDetails
                          • Open House
                          • Price Reduced
                          • New Listing
                          • Pending
                          • Pending Under Contract
                          • Coming Soon
                          • Virtual Open House
                          • Virtual Tour
                          • Sold
                          • Leased
                          10615 E Honey Mesquite Dr Drive, Scottsdale
                          $3,995,000
                          MLS# 7005365Single Family
                          3,325 Sq. Ft.
                          3 BEDS4 BATHS
                          Request Info
                          Delete
                          10615 E Honey Mesquite Dr Drive, ScottsdaleDetails
                          Logo
                          • Anthem Office
                          • Corporate Services
                          • Gilbert Office
                          • Goodyear Office
                          • North Scottsdale Office
                          • Northwest Office
                          • Prescott Office
                          • Scottsdale Office
                          • Sedona Office
                          • Tucson Office
                          (480) 505-6300
                          customerservice@bhhsaz.com
                          Arizona Properties
                          16100 N 71st Street, Suite 400
                          Scottsdale AZ 85254
                          Do Not Sell My Personal Information
                          DMCA.com Protection Status
                          Privacy Policy California Privacy Notice Legal Copyright Notice Commitment to Accessibility Affiliated Business Arrangement Disclosure Agent Login
                          © 2026 Berkshire Hathaway HomeServices Arizona Properties is a member of the franchise system of BHH Affiliates LLC. BHHS and the BHHS symbol are registered service marks of Columbia Insurance Company, a Berkshire Hathaway affiliate. BHH Affiliates LLC and BHHSCP do not guarantee accuracy of all data including measurements, conditions, and features of property. Information is obtained from various sources and will not be verified by broker or MLS. Buyer is advised to independently verify the accuracy of that information. Equal Housing Opportunity. © 2026 Berkshire Hathaway HomeServices Arizona Properties. All rights reserved. U.S. Reg. Copyright TX-5-910-991, TX-5-910-992, TX-5-910-993, and TX-5-910-994. Equal Housing Opportunity.
                          • Comparison List   0

                          Berkshire Hathaway HomeServices Arizona Properties is powered by Burrow Services, Inc.