28028 N 148TH Street, Scottsdale, AZ 85262

$3,250,000
Property Type: Residential Bedrooms: 3 Baths: 2.5 Square Footage: 2,329 Lot Size (sq. ft.): 369,600 Status: Closed
Current Price: $3,250,000 Last Modified: 3/24/2025

Description

Welcome to Dazzlewood Farms- A Premier Gated professional equestrian facility on 8.48 acres located in beautiful North Scottsdale on Rio Verde Dr. - State of the art Showbarn with Luxury Lounge and viewing area to the Covered Arena -2 offices,kitchen,powder room ,fireplace & entertaining area - -120' X 70' Covered Arena, 5 Turnout Pastures with shade,40' Covered Hot Walker, 60' Covered Round Pen, 100' X 220' Outdoor Arena with Gazebo- 65' X 35 Exhibition Arena Beautiful Custom 24 stall Showbarn with 2 wash racks,tack room, feed room,10 Stall upper barn, 8 stall Mare Motel, 3 stall shed row with wash rack and restroom, Main house with courtyard has 3 large bedrooms and 2.5 baths,Open kitchen to great room with stone fireplace, huge master suite with large walk- in Closet and 3 car garag

Supplements: Modular home has 2 bedrooms and 2 baths with well appointed kitchen and family room. Amazing Views - Outdoor entertaining area off the lounge overlooking the arenas Private well,Holding Tank,R/V Hookups.. Truly one of a kind beautiful property .. COVERED ARENA,SHOW BARN, OUTDOOR ARENA,EXHIBITION ARENA,ROUND PENS All built in 2017 - MAIN HOUSE AND MODULAR HOUSE BOTH REMODELED IN 2017.

More Information MLS# 6284701

Contract Information

Type: Exclusive Right To Sell Ownership: Fee Simple Sold Price: $3,250,000 Status: Closed Current Price: $3,250,000 List Date: 2021-08-26

Location, Tax & Legal

Assessor's Map #: 39 Legal Description (Abbrev): NE4 NE4 NW4 SEC 32 EX N 100F TH/OF Assessor's Parcel #: 171 Assessor Parcel Ltr: F Tax Municipality: Scottsdale Taxes: 3547 Map Code/Grid: H40 House Number: 28028 Compass: N Street Name: 148TH St Suffix: Street City/Town Code: Scottsdale State/Province: AZ Zip Code: 85262 Zip4: 9520 County Code: Maricopa Assessor Number: 219-39-171-F Subdivision: Premier Equestrian Facility Tax Year: 2020

General Property Description

Dwelling Styles: Detached # of Interior Levels: 1 Full Bathrooms: 2 Half Bathrooms: 1 Approx SQFT: 2329 Price/SqFt: 1395.44 Approx Lot SqFt: 369600 Approx Lot Acres: 8.485 Flood Zone: Yes Horses: Y Builder Name: Ernie Smith 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 Shadows High School Community Pool Y/N: No Private Pool Y/N: No Fireplace YN: Yes Fireplaces Total: 1 Dwelling Type: Single Family Residence Exterior Stories: 1 # Bedrooms: 3 Total Bathrooms: 2.5 Year Built: 2003

Legal Info

Range: 6E Section: 32 Township: 5N

Special Listing Cond

N/A: 1

Construction

Wood Frame: 1

Const - Finish

Painted: 1 Stucco: 1

Roofing

Tile: 1 Foam: 1

Association & Fees

HOA Y/N: N PAD Fee Y/N: N Land Lease Fee Y/N: N Ttl Mthly Fee Equiv: 0

Showing Notification Methods

Text: 1 Email: 1 Phone Call: 1

Lockbox Type

None: 1

Architecture

Territorial/Santa Fe: 1

Master Bathroom

Full Bth Master Bdrm: 1 Separate Shwr & Tub: 1 Double Vanity: 1 Private Toilet Room: 1 Tub with Jets: 1

Master Bedroom

Split: 1

Additional Bedroom

Master Bedroom Walk-in Closet: 1 Other Bedroom Walk-in Closet: 1

Add'l Property Use

Farm: 1 Ranch: 1

Fireplace Features

Fireplace Family Rm: 1 Gas Fireplace: 1

Flooring

Stone: 1 Wood: 1

Window Features

Solar Screens: 1 Dual Pane: 1 Low-Emissivity Windows: 1

Dining Area

Eat-in Kitchen: 1 Breakfast Bar: 1 Breakfast Room: 1 Dining in LR/GR: 1

Heating

Electric: 1

View

Mountain(s): 1

Kitchen Features

Dishwasher: 1 Disposal: 1 Kitchen Island: 1 Built-in Microwave: 1 Refrigerator: 1 Wall Oven(s): 1 Electric Cooktop: 1 Granite Counters: 1

Cooling

Ceiling Fan(s): 1 Central Air: 1

Interior Features

9+ Flat Ceilings: 1

Laundry

Washer Hookup: 1 Inside: 1

Basement

Basement Y/N: N

Other Rooms

Guest Qtrs-Sep Entrn: 1

Separate Den/Office

Sep Den/Office Y/N: N

Technology

Sat Dish TV Ownd: 1 Cable TV Avail: 1 Sat Dish Intrnt Ownd: 1 Security System Owned: 1

Fencing

Wrought Iron: 1 Wire: 1

Water Source

Private Well: 1

Exterior Features

Separate Guest House: 1 Covered Patio(s): 1 Patio: 1 Gazebo: 1 Storage: 1 Pvt Yrd(s)/Crtyrd(s): 1

Spa

None: 1

Manufactured Home Features

Other: 1

Sewer

Septic-In & Connected: 1

Parking Spaces

Slab Parking Spaces: 3 Total Covered Spaces: 3 Garage Spaces: 3

Parking Features

Attch'd Gar Cabinets: 1 RV Gate: 1 Separate Strge Area: 1 Side Vehicle Entry: 1 Garage Door Opener: 1 Gated: 1 RV Access/Parking: 1

New Financing

Cash: 1 Conventional: 1 Owner May Carry: 1

Plumbing

Recirculation Pump: 1 Electric Hot Wtr Htr: 1

Utilities

SRP: 1 Propane: 1

Existing 1st Loan

Treat as Free&Clear: 1

Property Description

Corner Lot: 1

Landscaping

Desert Front: 1 Desert Back: 1 Yrd Wtring Sys Front: 1 Yrd Wtring Sys Back: 1 Auto Timer H2O Front: 1 Auto Timer H2O Back: 1

Services

County Services: 1

Horse Features

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

Items Updated

Floor Yr Updated: 2017 Floor Partial/Full: Partial Wiring Yr Updated: 2017 Wiring Partial/Full: Partial Plmbg Yr Updated: 2017 Plmbg Partial/Full: Partial Kitchen Yr Updated: 2017 Kitchen Partial/Full: Full Bath(s) Yr Updated: 2017 Bath(s) Partial/Full: Full

Disclosures

Seller Discl Avail: 1 Well Disclosure: 1

Residential Propane Tank

Residential Propane Tank: Owned

Possession

By Agreement: 1 Subject To Tenant Rights: 1

Association Fee Incl

No Fees: 1

Assoc Rules/Info

None: 1

Sold Info

Loan Type: Carryback Loan Years: 15 Closing Cost Split: Normal - N Payment Type: Fixed Buyer Concession to Seller: 0 Buyer Concession $/%: % Seller Concession to Buyer: 0 Seller Concession $/%: %

Remarks Misc

Cross Street: Pima & Dynamite Directions: East on Dynamite ( Turns into Rio Verde Dr) to 148Th Street - Gated Entrance on Rio Verde Dr - Pull up to gate on south side or go south (Right) on 148Th Street to gate. 2 Entrances. Geo Lat: 33.740375 Geo Lon: -111.762001

Status Change Info

Off Market Date: 2021-12-10 Under Contract Date: 2021-12-10 Close of Escrow Date: 2021-12-27 Sold Price: $3,250,000

Property Features

Special Listing Cond: N/A Add'l Property Use: Farm; Ranch Architecture: Territorial/Santa Fe View: Mountain(s) Master Bathroom: Full Bth Master Bdrm; Separate Shwr & Tub; Double Vanity; Private Toilet Room; Tub with Jets Master Bedroom: Split Additional Bedroom: Master Bedroom Walk-in Closet; Other Bedroom Walk-in Closet Fireplace Features: Fireplace Family Rm; Gas Fireplace Flooring: Stone; Wood Window Features: Solar Screens; Dual Pane; Low-Emissivity Windows Spa: None Dining Area: Eat-in Kitchen; Breakfast Bar; Dining in LR/GR; Breakfast Room Kitchen Features: Electric Cooktop; Disposal; Dishwasher; Built-in Microwave; Refrigerator; Wall Oven(s); Granite Counters; Kitchen Island Laundry: Washer Hookup; Inside Other Rooms: Guest Qtrs-Sep Entrn Interior Features: 9+ Flat Ceilings Technology: Sat Dish TV Ownd; Sat Dish Intrnt Ownd; Cable TV Avail; Security System Owned Exterior Features: Covered Patio(s); Gazebo; Patio; Pvt Yrd(s)/Crtyrd(s); Separate Guest House; Storage Manufactured Home Features: Other Parking Features: Attch'd Gar Cabinets; Garage Door Opener; Gated; RV Access/Parking; RV Gate; Separate Strge Area; Side Vehicle Entry Construction: Wood Frame Const - Finish: Painted; Stucco Roofing: Tile; Foam Cooling: Central Air; Ceiling Fan(s) Heating: Electric Plumbing: Recirculation Pump; Electric Hot Wtr Htr Utilities: SRP; Propane Water Source: Private Well Sewer: Septic-In & Connected Services: County Services Fencing: Wrought Iron; Wire Property Description: Corner Lot Landscaping: Desert Front; Desert 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: By Agreement; Subject To Tenant Rights Association Fee Incl: No Fees Existing 1st Loan: Treat as Free&Clear New Financing: Cash; Conventional; Owner May Carry Disclosures: Seller Discl Avail; Well Disclosure
Listing Office: HomeSmart
IDX
Last Updated: March - 24 - 2025
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.