28028 N 148TH Street, Scottsdale, AZ 85262 (MLS# 6284701)

28028 N 148TH Street, Scottsdale, AZ 85262

$3,250,000

Virtual Tour

https://www.wellcomemat.com/embed/1g756cfd2b701ga5h?mls=1

Lounge Bar/ Viewing to the Covered Arena

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

Overview

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 M ... (Read more)

Listing Details MLS# 6284701

Location, Tax & Legal

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
Country: US
County Code: Maricopa
Assessor Number: 219-39-171-F
Subdivision: Premier Equestrian Facility
Tax Year: 2020
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

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: 3
Full Bathrooms: 2
Half Bathrooms: Yes
Total Bathrooms: 2.5
Approx SQFT: 2329
Price/SqFt: 1395.44
Horses: Y
Builder Name: Ernie Smith
Year Built: 2003
Approx Lot SqFt: 369600
Approx Lot Acres: 8.485
Flood Zone: Yes
Community Pool Y/N: No
Private Pool Y/N: No
Fireplace YN: Yes
Fireplaces Total: Yes
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

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.

Status Change Info

Off Market Date: 2021-12-10
Under Contract Date: 2021-12-10
Close of Escrow Date: 2021-12-27

Legal Info

Township: 5N
Range: 6E
Section: 32

More Information

Basement

Basement Y/N: N

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

Parking Spaces

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

Residential Propane Tank

Residential Propane Tank: Owned

Sold Info

Loan Type: Carryback
Loan Years: 15
Payment Type: Fixed
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

Const - Finish

Painted: Yes
Stucco: Yes

Roofing

Tile: Yes
Foam: Yes

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: Yes
Email: Yes
Phone Call: Yes

Lockbox Type

None: Yes

Architecture

Territorial/Santa Fe: Yes

Master Bathroom

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

Master Bedroom

Split: Yes

Additional Bedroom

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

Add'l Property Use

Farm: Yes
Ranch: Yes

Fireplace Features

Fireplace Family Rm: Yes
Gas Fireplace: Yes

Flooring

Stone: Yes
Wood: Yes

Window Features

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

Dining Area

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

Heating

Electric: Yes

View

Mountain(s): Yes

Kitchen Features

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

Cooling

Ceiling Fan(s): Yes
Central Air: Yes

Interior Features

9+ Flat Ceilings: Yes

Laundry

Washer Hookup: Yes
Inside: Yes

Other Rooms

Guest Qtrs-Sep Entrn: Yes

Separate Den/Office

Sep Den/Office Y/N: N

Technology

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

Fencing

Wrought Iron: Yes
Wire: Yes

Water Source

Private Well: Yes

Exterior Features

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

Spa

None: Yes

Manufactured Home Features

Other: Yes

Sewer

Septic-In & Connected: Yes

Parking Features

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

New Financing

Cash: Yes
Conventional: Yes
Owner May Carry: Yes

Plumbing

Recirculation Pump: Yes
Electric Hot Wtr Htr: Yes

Utilities

SRP: Yes
Propane: Yes

Existing 1st Loan

Treat as Free&Clear: Yes

Property Description

Corner Lot: Yes

Landscaping

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

Services

County Services: 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

Disclosures

Seller Discl Avail: Yes
Well Disclosure: Yes

Possession

By Agreement: Yes
Subject To Tenant Rights: 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: 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

Last Updated: March - 24 - 2025