28413 N 151 Street, Scottsdale, AZ 85262 (MLS# 7041118)

28413 N 151 Street, Scottsdale, AZ 85262

$2,900,000
Property Type: Residential Bedrooms: 5 Baths: 5 Square Footage: 4,774 Lot Size (sq. ft.): 50,862 Status: Active
Current Price: $2,900,000 Last Modified: 9/02/2026

Overview

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.

Listing Details MLS# 7041118

Location, Tax & Legal

House Number
28413
Compass
N
Street Name
151
St Suffix
Street
City/Town Code
Scottsdale
State/Province
AZ
Zip Code
85262
Country
US
County Code
Maricopa
Assessor Number
219-39-260
Subdivision
Rio Mountain Estates
Tax Year
2025

Contract Information

Type
Exclusive Right To Sell
Ownership
Fee Simple
Co-Ownership (Fractional) Agreement YN
No

General Property Description

Dwelling Type
Single Family Residence
Dwelling Styles
Detached
Exterior Stories
Yes
# of Interior Levels
Yes
# Bedrooms
5
Full Bathrooms
4
Half Bathrooms
Yes
Total Bathrooms
5
Approx SQFT
4774
Price/SqFt
607.46
Horses
N
Builder Name
Unknown
Year Built
2026
Approx Lot SqFt
50862
Approx Lot Acres
1.168
Community Pool Y/N
No
Private Pool Y/N
Yes
Fireplace YN
Yes
Fireplaces Total
2
Elementary School District
Cave Creek Unified District
High School District
Cave Creek Unified District
Elementary School
Horseshoe Trails Elementary School
Jr. High School
Horseshoe Trails Elementary School
High School
Cactus Shadows High School

Remarks Misc

Cross Street
Rio Verde & 152nd Street
Directions
East on Rio Verde, North (Left) on 152nd, Street, West (Left) on Monumen thru gate, South (Left) on 151st Street, North (left) on Rio Mountain Ct to lot 7, just before reaching Rio Mountain Ct.

Legal Info

Lot Number
219-39-260

Basement

Basement Y/N
N

More Information

Items Updated

Floor Yr Updated
2026
Floor Partial/Full
Full
Wiring Yr Updated
2026
Wiring Partial/Full
Full
Plmbg Yr Updated
2026
Plmbg Partial/Full
Full
Ht/Cool Yr Updated
2026
Ht/Cool Partial/Full
Full
Roof Yr Updated
2026
Roof Partial/Full
Full
Kitchen Yr Updated
2026
Kitchen Partial/Full
Full
Bath(s) Yr Updated
2026
Bath(s) Partial/Full
Full
Rm Adtn Yr Updated
2026
Rm Adtn Partial/Full
Full
Pool Yr Updated
2026
Pool Partial/Full
Full

Parking Spaces

Garage Spaces
3
Slab Parking Spaces
8
Total Covered Spaces
3

Residential Propane Tank

Residential Propane Tank
Owned
Propane Underground Y/N
Yes

Showing Notification Methods

Showing Service
Aligned Showings

DPR Eligible

DPR Eligible
No

Property Features

Special Listing Cond: Owner/Agent Master Bathroom: Full Bth Master Bdrm; Separate Shwr & Tub; Double Vanity; Private Toilet Room; 2 Master Baths Master Bedroom: Split Additional Bedroom: 2 Master Bedrooms; Separate Bedroom Exit; Master Bedroom Walk-in Closet; Other Bedroom Walk-in Closet Fireplace Features: Insert Flooring: Tile Window Features: Screens; Dual Pane Private Pool Features: Outdoor; Heated Spa: Private Community Features: Gated Dining Area: Formal; Eat-in Kitchen; Breakfast Bar; Breakfast Nook Kitchen Features: Built-In Gas Oven; Gas Oven; Gas Range; Gas Cooktop; Disposal; Dishwasher; Built-in Microwave; Refrigerator; Pantry; Walk-in Pantry Laundry: Washer Included; Dryer Included; Inside Other Rooms: Family Room; Great Room; Bonus/Game Room Interior Features: Vaulted Ceiling(s); Water Softener Owned; Soft Water Loop Technology: Pre-Wire Srnd Snd; Sat Dish Intrnt Lsd; Cable TV Avail; Smart Home Exterior Features: Covered Patio(s); Patio; Private Street(s); RV Hookup Parking Features: Attached Garage; Electric Vehicle Charging Station(s); Garage Door Opener; Gated; RV Gate Road Access Type: Private Road Road Surface Type: Asphalt Road Responsibility: City Maintained Road Construction: Wood Frame Const - Finish: Metal Siding; Stucco; Stone Construction Status: Complete Spec Home; New Construction Roofing: Tile Cooling: Central Air Heating: Ceiling; Propane Plumbing: Propane Hot Wtr Htr Utilities: SRP Water Source: Pvt Water Company Sewer: Septic Tank Fencing: Back Yard; Block Landscaping: Gravel/Stone Front; Desert Front; Synthetic Grass Back; Auto Timer H2O Front; Auto Timer H2O Back; Irrigation Front; Irrigation Back Lockbox Type: Supra Possession: Close of Escrow Unit Style: All on One Level Association Fee Incl: Common Area Maint Existing 1st Loan: Treat as Free&Clear New Financing: Cash; VA; FHA; Conventional Disclosures: Seller Discl Avail
IDX
Listing Office: Done Deal
Last Updated: September - 02 - 2026
Copyright 2026 Arizona Regional Multiple Listing Service, Inc. All rights reserved. Information Not Guaranteed and Must Be Confirmed by End User. Site contains live data.

Looking to Buy or Sell in the Phoenix Area

G-Y568ZD5VNW