• Skip to primary navigation
  • Skip to main content
  • Skip to footer
Client Portal Login (480) 264-0655
  • Email
  • Home
  • What’s My Home Worth
  • Why List With Us?
  • Search MLS
    • Search by City
    • Search by Map
  • Our Listings
  • Contact

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

With a portal you are able to:
  1. Save your searches
  2. Get updates on listings
  3. Track listings
  4. Add notes and messages
  5. Personalize your dashboard

$2,890,000
28413 N 151 Street
Scottsdale, AZ 85262
MLS# 7041118
5 beds  |  5 baths  |  4774 sqft


003_ListerPros
  1 / 105  
003_ListerPros 008_ListerPros 024_IMG_6310 023_IMG_6375 029_IMG_6300 026_IMG_6305 031_IMG_6315 003_IMG_6215 005_IMG_6221 006_IMG_6250 002_IMG_6380 001_IMG_6226 008_IMG_6385 013_IMG_6210 012_IMG_6230 014_IMG_6245 010_IMG_6235 004_IMG_6257 011_IMG_6330 007_IMG_6326 009_IMG_6240 025_IMG_6295 027_IMG_6291 028_IMG_6361 030_IMG_6321 032_IMG_6367 033_IMG_6285 034_IMG_6370 035_IMG_6353 036_IMG_6356 015_IMG_6345 016_IMG_6260 017_IMG_6335 018_IMG_6265 019_IMG_6340 020_IMG_6270 021_IMG_6282 022_IMG_6275 032_ListerPros 033_ListerPros 034_ListerPros 035_ListerPros 036_ListerPros 037_ListerPros 038_ListerPros 039_ListerPros 040_ListerPros 041_ListerPros 044_ListerPros 046_ListerPros 047_ListerPros 049_ListerPros 056_ListerPros 057_ListerPros 058_ListerPros 059_ListerPros 060_ListerPros 061_ListerPros 062_ListerPros 063_ListerPros 064_ListerPros 065_ListerPros 066_ListerPros 067_ListerPros 068_ListerPros 069_ListerPros 070_ListerPros 071_ListerPros ENHANCED_1_15MB SUNSET - TWILIGHT_5 073_ListerPros 074_ListerPros 075_ListerPros 076_ListerPros 077_ListerPros 078_ListerPros 079_ListerPros 080_ListerPros 081_ListerPros 082_ListerPros 083_ListerPros 084_ListerPros backyard Backyard DRONE_1 DRONE_2 DRONE_3 DRONE_4 DRONE_5 DRONE_7 DRONE_8 DRONE_9 DRONE_10 DRONE_11 DRONE_12 DRONE_13 DRONE_14 DRONE_15 DRONE_16 Front Front 006_ListerPros 007_ListerPros 009_ListerPros 010_ListerPros

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.

Details
Maps
Contract Information
List Price: $2,890,000
Status: Active
Current Price: $2,890,000
List Date: 2026-06-12
Type: Exclusive Right To Sell
Ownership: Fee Simple
Co-Ownership (Fractional) Agreement YN: No
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
General Property Description
Dwelling Type: Single Family Residence
Dwelling Styles: Detached
Exterior Stories: 1
# of Interior Levels: 1
# Bedrooms: 5
Full Bathrooms: 4
Half Bathrooms: 1
Total Bathrooms: 5
Approx SQFT: 4774
Price/SqFt: 605.36
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
Showing Notification Methods
Showing Service: Aligned Showings
Basement
Basement Y/N: N
Parking Spaces
Garage Spaces: 3
Slab Parking Spaces: 8
Total Covered Spaces: 3
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
Residential Propane Tank
Residential Propane Tank: Owned
Propane Underground Y/N: Yes
DPR Eligible
DPR Eligible: No
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.
Geo Lat: 33.743467
Geo Lon: -111.754585
Legal Info
Lot Number: 219-39-260
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

Office Phone: 602-610-1900

Office Email: broker@donedealrealty.com

Last Updated: October - 23 - 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.


Search powered by FBS Products

Footer

(480) 264-0655
Contact
  • Email

sitemap   •   admin   •   ©2026 All Rights Reserved  •  Real Estate Website Design by IDXCentral.com