29319 N 152ND Street, Scottsdale, AZ 85262 (MLS# 6171760)

29319 N 152ND Street, Scottsdale, AZ 85262

$3,466,250
Property Type: Residential Bedrooms: 7 Baths: 6.5 Square Footage: 5,226 Lot Size (sq. ft.): 399,445 Status: Closed
Current Price: $3,466,250 Last Modified: 2/18/2026

Overview

Description

Exquisite 9+ acre horse property surrounded by breathtaking mountain views. Casa Del Caballo offers beautiful 8 stall show barn with living quarters for ranch hands, 9 turn out corrals, hot walker, round pen, large show arena, dressage arena & 16 stall mare motel. 7 bed 6.5 bath estate home features private gated entry, attached two bed with kitchen Casita, pavered walkway and courtyard. Dramatic wood/beamed ceilings, wall of windows, beautiful hardwood floors, and many fireplaces. Chef's kitchen w/ gourmet appliances, gorgeous granite counters, hand carved cabinetry and large pantry. Master retreat boasts walk in closets, workout rm & spa-like en suite. Generous sized bedrooms, ample closets/storage, & upscale baths with bidets. Heated salt pool w/waterfall and slide, children play area,

Listing Details MLS# 6171760

Location, Tax & Legal

Map Code/Grid
H40
House Number
29319
Compass
N
Street Name
152ND
St Suffix
Street
City/Town Code
Scottsdale
State/Province
AZ
Zip Code
85262
Zip4
7925
County Code
Maricopa
Assessor Number
219-37-028
Subdivision
Rio Verde Foothills
Tax Year
2019
Assessor's Map #
37
Legal Description (Abbrev)
NW4 SW4 NW4 EX W 55' 9.17 AC
Assessor's Parcel #
28
Tax Municipality
Maricopa - COUNTY
Taxes
8338

Contract Information

Type
Exclusive Right To Sell
Ownership
Fee Simple

General Property Description

Dwelling Type
Single Family Residence
Dwelling Styles
Detached
Exterior Stories
Yes
# of Interior Levels
Yes
# Bedrooms
7
Full Bathrooms
6
Half Bathrooms
Yes
Total Bathrooms
6.5
Approx SQFT
5226
Price/SqFt
663.27
Guest House SqFt
1388
Horses
Y
Builder Name
Custom
Year Built
2003
Approx Lot SqFt
399445
Approx Lot Acres
9.17
Flood Zone
Yes
Community Pool Y/N
No
Private Pool Y/N
Yes
Fireplace YN
Yes
Fireplaces Total
3
Elementary School District
Cave Creek Unified District
High School District
Cave Creek Unified District
Elementary School
Desert Sun Academy
Jr. High School
Sonoran Trails Middle School
High School
Cactus High School

Remarks Misc

Cross Street
Rio Verde Dr & 152nd St
Directions
From Dynamite and Alma School Rd, go east on Dynamite to 152nd St. North on 152nd St. Rancho Valle Del Sol is on on the east side of 152nd Street.

Status Change Info

Off Market Date
2021-05-19
Under Contract Date
2021-04-19
Close of Escrow Date
2021-05-24

Legal Info

Township
5N
Range
6E
Section
28
Lot Number
n/a

More Information

Basement

Basement Y/N
N

Items Updated

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

Parking Spaces

Garage Spaces
4
Slab Parking Spaces
4
Total Covered Spaces
4

Solar Panels

Ownership
Owned Outright

Sold Info

Loan Type
Other
Payment Type
Other
Closing Cost Split
Normal - N
Buyer Concession $/%
$
Seller Concession $/%
$
Buyer Concession to Seller
0
Seller Concession to Buyer
0

Special Listing Cond

N/A
Yes

Construction

Wood Frame
Yes
Adobe
Yes

Const - Finish

Painted
Yes
Stucco
Yes
Stone
Yes

Roofing

Foam
Yes

Pmt & Rate Info

Down Payment
0
Total Asum Mnth Pmts
0

Association & Fees

HOA Y/N
N
PAD Fee Y/N
N
Cap Improvement/Impact Fee
0
Cap Improvement/Impact Fee $/%
$
Cap Improvement/Impact Fee 2
0
Cap Improvement/Impact Fee 2 $/%
$
Land Lease Fee Y/N
N
Rec Center Fee Y/N
N
Rec Center Fee 2 Y/N
N
Ttl Mthly Fee Equiv
0

Showing Notification Methods

Text
Yes
Email
Yes
Phone Call
Yes

Lockbox Type

None
Yes

Architecture

Ranch
Yes
Territorial/Santa Fe
Yes
Spanish
Yes

Master Bathroom

Full Bth Master Bdrm
Yes
Separate Shwr & Tub
Yes
Double Vanity
Yes
Private Toilet Room
Yes
Bidet
Yes

Master Bedroom

Split
Yes

Additional Bedroom

Master Bedroom Walk-in Closet
Yes
Master Bedroom Sitting Room
Yes

Add'l Property Use

Farm
Yes
Ranch
Yes

Fireplace Features

Fireplace Living Rm
Yes
Fireplace Master Bdr
Yes
Two Way Fireplace
Yes
Gas Fireplace
Yes
Freestnd Fireplace
Yes
Exterior Fireplace
Yes
Fire Pit
Yes

Flooring

Tile
Yes
Wood
Yes

Window Features

Dual Pane
Yes
Mechanical Sun Shds
Yes
Wood Frames
Yes

Private Pool Features

Fenced
Yes
Heated
Yes
Variable Speed Pump
Yes

Community Features

Children's Playgrnd
Yes
Horse Facility
Yes

Dining Area

Formal
Yes
Eat-in Kitchen
Yes
Breakfast Bar
Yes
Dining in LR/GR
Yes

Heating

Electric
Yes

View

Mountain(s)
Yes

Kitchen Features

Built In Recycling
Yes
Dishwasher
Yes
Disposal
Yes
Gas Oven
Yes
Gas Range
Yes
Kitchen Island
Yes
Built-in Microwave
Yes
Multiple Ovens
Yes
Non-laminate Counter
Yes
Pantry
Yes
Refrigerator
Yes
Reverse Osmosis
Yes
Walk-in Pantry
Yes
Wall Oven(s)
Yes
Gas Cooktop
Yes
Granite Counters
Yes

Cooling

Ceiling Fan(s)
Yes
Programmable Thmstat
Yes
Central Air
Yes

Interior Features

Skylight(s)
Yes
Vaulted Ceiling(s)
Yes
Central Vacuum
Yes
Wet Bar
Yes
No Interior Steps
Yes
Water Softener Owned
Yes
Water Purifier
Yes

Laundry

Washer Included
Yes
Dryer Included
Yes
220 V Dryer Hookup
Yes
Inside
Yes

Other Rooms

Family Room
Yes
Library-Blt-in Bkcse
Yes
Guest Qtrs-Sep Entrn
Yes
Exercise/Sauna Room
Yes
Separate Workshop
Yes
Media Room
Yes

Separate Den/Office

Sep Den/Office Y/N
Y

Technology

Cable TV Avail
Yes
High Speed Internet
Yes
Security System Owned
Yes

Fencing

Block
Yes
Wrought Iron
Yes

Water Source

Private Well
Yes

Exterior Features

Separate Guest House
Yes
Built-in BBQ
Yes
Playground
Yes
Covered Patio(s)
Yes
Patio
Yes
Screened in Patio(s)
Yes
Storage
Yes
Private Street(s)
Yes
Pvt Yrd(s)/Crtyrd(s)
Yes

Spa

None
Yes

Sewer

Septic Tank
Yes

Parking Features

Attch'd Gar Cabinets
Yes
Over Height Garage
Yes
Separate Strge Area
Yes
Circular Driveway
Yes
Direct Access
Yes
Extended Length Garage
Yes
Garage Door Opener
Yes
RV Access/Parking
Yes

New Financing

Cash
Yes
Conventional
Yes

Energy/Green Feature

Solar Panels
Yes
Multi-Zones
Yes

Plumbing

Recirculation Pump
Yes
Electric Hot Wtr Htr
Yes

Utilities

SRP
Yes
Propane
Yes

Existing 1st Loan

Treat as Free&Clear
Yes

Landscaping

Desert Front
Yes
Desert Back
Yes
Natural Desert Front
Yes
Natural Desert Back
Yes
Synthetic Grass Back
Yes
Yrd Wtring Sys Front
Yes
Yrd Wtring Sys Back
Yes
Auto Timer H2O Front
Yes
Auto Timer H2O Back
Yes

Services

Other (See Remarks)
Yes

Horse Features

Corral(s)
Yes
Stall
Yes
Barn
Yes
Tack Room
Yes
Arena
Yes
Auto Water
Yes
Hot Walker
Yes
Bridle Path Access
Yes

Unit Style

All on One Level
Yes

Disclosures

Seller Discl Avail
Yes
Agency Discl Req
Yes

Possession

Close of Escrow
Yes

Association Fee Incl

No Fees
Yes

Assoc Rules/Info

None
Yes

Property Features

Special Listing Cond: N/A Add'l Property Use: Farm; Ranch Architecture: Ranch; Territorial/Santa Fe; Spanish View: Mountain(s) Master Bathroom: Full Bth Master Bdrm; Separate Shwr & Tub; Double Vanity; Private Toilet Room; Bidet Master Bedroom: Split Additional Bedroom: Master Bedroom Walk-in Closet; Master Bedroom Sitting Room Fireplace Features: Fireplace Living Rm; Fireplace Master Bdr; Two Way Fireplace; Gas Fireplace; Freestnd Fireplace; Exterior Fireplace; Fire Pit Flooring: Tile; Wood Window Features: Dual Pane; Mechanical Sun Shds; Wood Frames Private Pool Features: Fenced; Heated; Variable Speed Pump Spa: None Community Features: Children's Playgrnd; Horse Facility Dining Area: Formal; Eat-in Kitchen; Breakfast Bar; Dining in LR/GR Kitchen Features: Gas Oven; Gas Range; Gas Cooktop; Disposal; Dishwasher; Built-in Microwave; Refrigerator; Reverse Osmosis; Built In Recycling; Wall Oven(s); Multiple Ovens; Pantry; Walk-in Pantry; Granite Counters; Non-laminate Counter; Kitchen Island Laundry: Washer Included; Dryer Included; 220 V Dryer Hookup; Inside Other Rooms: Family Room; Library-Blt-in Bkcse; Guest Qtrs-Sep Entrn; Exercise/Sauna Room; Separate Workshop; Media Room Interior Features: Skylight(s); Vaulted Ceiling(s); Central Vacuum; Wet Bar; No Interior Steps; Water Softener Owned; Water Purifier Technology: Cable TV Avail; High Speed Internet; Security System Owned Exterior Features: Built-in BBQ; Playground; Covered Patio(s); Patio; Private Street(s); Pvt Yrd(s)/Crtyrd(s); Screened in Patio(s); Separate Guest House; Storage Parking Features: Circular Driveway; Attch'd Gar Cabinets; Direct Access; Extended Length Garage; Garage Door Opener; Over Height Garage; RV Access/Parking; Separate Strge Area Construction: Wood Frame; Adobe Const - Finish: Painted; Stucco; Stone Roofing: Foam Cooling: Central Air; Ceiling Fan(s); Programmable Thmstat Heating: Electric Plumbing: Recirculation Pump; Electric Hot Wtr Htr Utilities: SRP; Propane Water Source: Private Well Sewer: Septic Tank Services: Other (See Remarks) Fencing: Wrought Iron; Block Landscaping: Desert Front; Desert Back; Natural Desert Front; Natural Desert Back; Synthetic Grass Back; Yrd Wtring Sys Front; Yrd Wtring Sys Back; Auto Timer H2O Front; Auto Timer H2O Back Horse Features: Corral(s); Stall; Barn; Tack Room; Arena; Auto Water; Hot Walker; Bridle Path Access Showing Notification Methods: Text; Email; Phone Call Lockbox Type: None Possession: Close of Escrow Unit Style: All on One Level Association Fee Incl: No Fees Existing 1st Loan: Treat as Free&Clear New Financing: Cash; Conventional Disclosures: Seller Discl Avail; Agency Discl Req
Listing Office: Aeris House Properties, LLC
IDX
Last Updated: February - 18 - 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.

G-K5LCBKP82P