$2,990,900
28413 N 151 Street
Scottsdale, AZ 85262
MLS# 7041118
5 beds  |  5 baths


008_ListerPros
  1 / 87  
008_ListerPros 003_ListerPros Front 013_ListerPros 014_ListerPros 015_ListerPros 016_ListerPros 018_ListerPros 019_ListerPros 020_ListerPros 021_ListerPros 022_ListerPros 023_ListerPros 024_ListerPros 025_ListerPros 026_ListerPros 027_ListerPros 028_ListerPros 030_ListerPros 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 055_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
Type: Exclusive Right To Sell
Ownership: Fee Simple
Co-Ownership (Fractional) Agreement YN: No
List Price: $2,990,900
Status: Active
Current Price: $2,990,900
List Date: 2026-06-12
Location, Tax & Legal
Assessor's Map #: 39
Assessor's Parcel #: 260
Tax Municipality: Maricopa - COUNTY
Taxes: 1850
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 Styles: Detached
# of Interior Levels: 1
Full Bathrooms: 4
Half Bathrooms: 1
Approx SQFT: 4774
Price/SqFt: 626.5
Approx Lot SqFt: 50862
Approx Lot Acres: 1.168
Horses: N
Builder Name: Unknown
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
Community Pool Y/N: No
Private Pool Y/N: Yes
Fireplace YN: Yes
Fireplaces Total: 2
Dwelling Type: Single Family Residence
Exterior Stories: 1
# Bedrooms: 5
Total Bathrooms: 5
Year Built: 2026
Special Listing Cond
Owner/Agent: 1
Construction
Wood Frame: 1
Const - Finish
Metal Siding: 1
Stucco: 1
Stone: 1
Construction Status
New Construction: 1
Complete Spec Home: 1
Roofing
Tile: 1
Association & Fees
HOA Y/N: Y
HOA Disclosure/Addendum Affirmation: Yes
HOA Transfer Fee: 400
HOA Fee: 325
HOA Paid Frequency: Quarterly
HOA Name: Rio Mountain Estates
HOA Telephone: 602-906-4932
HOA Management Company: AAM
HOA Management Phone: 602-957-9191
Special Assessment HOA: No
HOA 2 Y/N: N
PAD Fee Y/N: N
Cap Improvement/Impact Fee: 0
Cap Improvement/Impact Fee $/%: $
Prepaid Association Fees HOA: 325
Disclosure Fees HOA: 0
Other Fees HOA: 325
Other Fees Description: Reserve Fee
Land Lease Fee Y/N: N
Rec Center Fee Y/N: N
Ttl Mthly Fee Equiv: 108.33
Showing Notification Methods
Showing Service: Aligned Showings
Lockbox Type
Supra: 1
Master Bathroom
Full Bth Master Bdrm: 1
Separate Shwr & Tub: 1
Double Vanity: 1
Private Toilet Room: 1
2 Master Baths: 1
Master Bedroom
Split: 1
Additional Bedroom
2 Master Bedrooms: 1
Separate Bedroom Exit: 1
Master Bedroom Walk-in Closet: 1
Other Bedroom Walk-in Closet: 1
Fireplace Features
Insert: 1
Flooring
Tile: 1
Window Features
Screens: 1
Dual Pane: 1
Private Pool Features
Outdoor: 1
Heated: 1
Community Features
Gated: 1
Dining Area
Formal: 1
Eat-in Kitchen: 1
Breakfast Bar: 1
Breakfast Nook: 1
Heating
Ceiling: 1
Propane: 1
Kitchen Features
Built-In Gas Oven: 1
Dishwasher: 1
Disposal: 1
Gas Oven: 1
Gas Range: 1
Built-in Microwave: 1
Pantry: 1
Refrigerator: 1
Walk-in Pantry: 1
Gas Cooktop: 1
Cooling
Central Air: 1
Interior Features
Vaulted Ceiling(s): 1
Water Softener Owned: 1
Soft Water Loop: 1
Laundry
Washer Included: 1
Dryer Included: 1
Inside: 1
Basement
Basement Y/N: N
Other Rooms
Family Room: 1
Great Room: 1
Bonus/Game Room: 1
Separate Den/Office
Sep Den/Office Y/N: N
Road Access Type
Private Road: 1
Road Surface Type
Asphalt: 1
Road Responsibility
City Maintained Road: 1
Technology
Pre-Wire Srnd Snd: 1
Cable TV Avail: 1
Sat Dish Intrnt Lsd: 1
Smart Home: 1
Fencing
Back Yard: 1
Block: 1
Water Source
Pvt Water Company: 1
Exterior Features
Covered Patio(s): 1
Patio: 1
RV Hookup: 1
Private Street(s): 1
Spa
Private: 1
Sewer
Septic Tank: 1
Parking Spaces
Slab Parking Spaces: 8
Total Covered Spaces: 3
Garage Spaces: 3
Parking Features
Electric Vehicle Charging Station(s): 1
RV Gate: 1
Attached Garage: 1
Garage Door Opener: 1
Gated: 1
New Financing
Cash: 1
VA: 1
Conventional: 1
FHA: 1
Plumbing
Propane Hot Wtr Htr: 1
Utilities
SRP: 1
Existing 1st Loan
Treat as Free&Clear: 1
Landscaping
Gravel/Stone Front: 1
Desert Front: 1
Synthetic Grass Back: 1
Auto Timer H2O Front: 1
Auto Timer H2O Back: 1
Irrigation Front: 1
Irrigation Back: 1
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
Unit Style
All on One Level: 1
Disclosures
Seller Discl Avail: 1
Residential Propane Tank
Residential Propane Tank: Owned
Propane Underground Y/N: Yes
Possession
Close of Escrow: 1
Association Fee Incl
Common Area Maint: 1
Assoc Rules/Info
Pets OK (See Rmrks): 1
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

Last Updated: June - 12 - 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.