Trusted Real Estate Experts in Sierra Vista, Fort Huachuca, Benson, and Bisbee Arizona
Sign In

28028 N 148TH Street

Scottsdale, AZ 85262

Territorial/Santa Fe

Scottsdale, AZ 85262

28028 N 148TH Street

$3,250,000

MLS#: 6284701

Status: Closed

Listing provided by: HomeSmart

Listing agent phone: None

Last update: 10 months ago

On site: 4 years ago

Browse Properties
Premier Equestrian Facility - Residential

About

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 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.

Property

Beds

3

Full Baths

None

1/2 Baths

None

Year Built

2003

Sq.Footage

2,329

Features

Features & Amenities

Interior

  • Other Interior Features

    Granite Counters, Double Vanity, Eat-in Kitchen, Breakfast Bar, Kitchen Island, High Ceilings

  • Total Bedrooms

    3

  • Bathrooms

    N/A

  • Basement YN

    NO

  • Cooling YN

    YES

  • Cooling

    Central Air, Ceiling Fan(s)

  • Fireplace YN

    YES

  • Heating YN

    YES

  • Heating

    Electric

  • Pet friendly

    N/A

Exterior

  • Garage

    Yes

  • Garage spaces

    3

  • Construction Materials

    Stone, Stucco, Frame

  • Other Exterior Features

    Private Yard, Storage

  • Parking

    RV Access/Parking, Gated, Garage Door Opener, Garage Faces Side

  • Patio and Porch Features

    Patio

  • Pool

    No

  • View

    Mountain(s)

Area & Lot

  • Lot Features

    Sprinklers In Rear, Sprinklers In Front, Corner Lot, Desert Back, Desert Front

  • Lot Size(acres)

    8.48

  • Lot Size(square feet)

    369600.0

  • Property Type

    Residential

  • Property Sub Type

    Single Family Residence

  • Architectural Style

    Territorial/Santa Fe

Price

  • Sales Price

    $3,250,000

  • Tax Amount

    $3,547

  • Sq. Footage

    2, 329

  • Price/SqFt

    $1,395

HOA

  • Association

    No

School District

  • Elementary School

    Cave Creek Unified District

  • Middle School

    Sonoran Trails Middle School

  • High School

    Cactus Shadows High School

Property Features

  • Stories

    1

  • Accessibility Features

    Therapeutic Whirlpool

  • Ownership

    Fee Simple

  • Sewer

    Septic Tank

  • Tax Lot

    0

  • Water Source

    Private

Schedule

Schedule a Showing

Showing scheduled successfully.

What is 3 + 4 ?


Change time

Mortgage calculator

Estimate your monthly mortgage payment, including the principal and interest, property taxes, and HOA. Adjust the values to generate a more accurate rate.

Your payment

Principal and Interest:

$

Property taxes:

$

HOA fees:

$

Total loan payment:

$

Total interest amount:

$

Location

  • County

    Maricopa

  • Elementary School

    Cave Creek Unified District

  • Middle School

    Sonoran Trails Middle School

  • High School

    Cactus Shadows High School

Listing Courtesy of Adele J Kinney , HomeSmart

RealHub Information is provided exclusively for consumers' personal, non-commercial use, and it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawal. RealHub website owner shall not be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless.

Agent Mandy Gold

Mandy Gold

FOUNDER

Call Mandy today to schedule a private showing.

Phone (520) 335-3204

Email mandy@mandygoldteam.com


* Listings on this website come from the FMLS IDX Compilation and may be held by brokerage firms other than the owner of this website. The listing brokerage is identified in any listing details. Information is deemed reliable but is not guaranteed. If you believe any FMLS listing contains material that infringes your copyrighted work please click here to review our DMCA policy and learn how to submit a takedown request.© 2024 FMLS.

Properties

Related properties

New on site 1 day ago
Positioned on nearly 3 private acres within the gated community of Desert Summit, this North Scottsdale estate delivers the rare combination of luxury, privacy, and breathtaking mountain and city light views. Spanning over 6,300 square feet, the single-level residence was designed for effortless living and unforgettable entertaining, with no interior steps, soaring ceilings, rich stone and wood finishes, custom craftsmanship, and seamless indoor-outdoor flow.The main residence features a thoughtfully designed split floor plan with a private primary retreat, three additional ensuite guest bedrooms, a dedicated executive office, and a state-of-the-art theater room. At the heart of the home, the chef's kitchen opens to expansive living spaces, showcasing slab granite surfaces, custom cabinetry, multiple ovens, a large island, walk-in pantry, and premium appliances.A detached guest house creates endless flexibility for multigenerational living, extended guests, a private office, or caretaker quarters, complete with its own bedroom suite, full kitchen, living area, and garage.Outside, discover a true Arizona resort experience. The south-facing backyard was built for entertaining with a heated pool and spa, covered outdoor living spaces, built-in BBQ, fire pit, and panoramic desert vistas that stretch for miles. From intimate evenings under the stars to large-scale gatherings, every detail was designed to take advantage of Scottsdale's year-round outdoor lifestyle.Additional highlights include a 6-car garage, circular driveway, custom cantera fireplaces, Venetian plaster finishes, central vacuum, smart home wiring, and exceptional privacy within one of North Scottsdale's most desirable gated communities.Luxury estates offering this level of craftsmanship, land, guest accommodations, and views are increasingly difficult to find. Experience the best of North Scottsdale living.
#7036014

Scottsdale

11659 E CAVEDALE Drive

5 Beds

5 Baths

5,841 Sq.Ft.

$3,400,000

MLS#: 7036014

New on site 2 days ago
Nestled in a private cul-de-sac on the 4th tee of the renowned Jack Nicklaus Signature golf course in guard-gated Desert Highlands, this custom 2000 built residence offers casual elegance and timeless desert luxury on a spacious 0.75 acre lot. Boasting approx. 6,361 sq. feet, the home features 4 bedrooms and 4 1/2 bathrooms, including a secluded primary suite, three guest suites, plus an office. An open and spacious great room flows seamlessly, creating an inviting atmosphere for both relaxed living and elegant entertaining. The home showcases picture windows throughout that frame mountain, golf course and city light views while preserving a sense of privacy. Step into the welcoming courtyard, accented by a magnificent curved copper water feature, fireplace and a private casita .
#7022926

Scottsdale

10040 E HAPPY VALLEY Road 299

4 Beds

4 Baths

6,361 Sq.Ft.

$2,925,000

MLS#: 7022926

Some properties hold you still the moment you arrive. This hilltop 5 acre horse ranch -- adjacent 5.8 acres available -- borders Tonto Nat'l Forest with Granite Mountain filling the horizon. The centerpiece is a custom 60x80 steel barn with six 20x20 covered stalls, a reclaimed wood tack room, 120x200 professional arena with announcer's booth, 60-foot round pen, and solar entry gates. A second engineered facility (comp. Nov. 2024) adds 10 covered pens, 39 configurable gates, tack and supplement rooms, and a private well. Suitable for cattle or horses. Inside, wagon wheel timber beams crown the great room, a chef's kitchen delivers 6-burner gas, double ovens, and chiseled granite, and the primary suite opens to mnt views and a fireplace over the jacuzzi tub.
#7031869

Scottsdale

32905 N 140TH Street

3 Beds

2 Baths

3,002 Sq.Ft.

$2,875,000

MLS#: 7031869

Coming Soon | Stunning Remodeled DC Ranch Estate with Private Courtyard & Resort Backyard Exquisitely remodeled Camelot home in the gated community of DC Ranch blending timeless luxury with sophisticated modern design. Open-concept floor plan features premium marble surfaces, custom cabinetry, designer lighting, private office/den, wet bar, and expansive entertaining spaces. A stunning custom wine wall leads to a private courtyard with fireplace, creating a serene retreat at the heart of the home. Chef's kitchen includes Sub-Zero refrigeration, oversized marble island, butler's pantry, and multiple ovens. Downstairs primary suite offers a spa-inspired bath and custom closet. Upstairs features a spacious media/lounge area, ensuite guest room, Jack-and-Jill suite, and flexible bonus space w Coming Soon | Stunning Remodeled DC Ranch Estate with Private Courtyard & Resort Backyard Exquisitely remodeled estate in the gated community of DC Ranch by renowned builder Camelot Homes. This exceptional North Scottsdale residence blends timeless luxury with sophisticated modern design, offering beautifully curated indoor/outdoor living spaces and refined finishes throughout. The open-concept floor plan showcases custom cabinetry, premium marble surfaces, statement lighting, private office/den, wet bar, and expansive entertaining areas. A stunning custom wine wall leads to a private courtyard with fireplace, creating a serene retreat at the heart of the home. The chef's kitchen is truly spectacular, featuring Sub-Zero refrigeration, multiple ovens, Bosch dishwasher, oversized marble island, butler's pantry, and seamless flow into the home's main gathering spaces. The downstairs primary suite offers a true spa-inspired retreat with Carrara marble flooring, dual marble vanities, soaking tub, oversized walk-in shower, and a spacious custom-designed closet. An additional guest bedroom and full bath on the main level provide ideal accommodations for visitors or multigenerational living. Step outside to a resort-style backyard designed for unforgettable Arizona living -- complete with breathtaking sunset views, heated pool with Baja shelf, tiled spa, water features, expansive outdoor dining and lounge spaces, porcelain pavers, mature landscaping, and turf play area. Residents enjoy access to the DC Ranch Community Center with pools, fitness, tennis, and a vibrant calendar of events. Nearby dining, golf, hiking, DC Ranch Marketplace, and top-rated schools complete the unparalleled North Scottsdale lifestyle. An extraordinary opportunity in one of North Scottsdale's most sought-after gated communities. Coming Soon -- luxury buyers will not want to miss this one.
#7031463

Scottsdale

9840 E BUTEO Drive

5 Beds

4 Baths

5,203 Sq.Ft.

$3,675,000

MLS#: 7031463

This Bing Hu designed home is the epitome of luxury and craftsmanship in the highly sought after community of Desert Mountain. The entire home has been totally reimagined and recreated using the finest materials and finishes, expertly crafted by Tarver Construction. Every detail has been thoughtfully customized to evoke a sense of warmth and style. The open floor plan kitchen and great room invite gatherings with friends and family. The Primary Suite offers privacy and tranquility while being enveloped in lavish ambiance. Three well-appointed guest suites will not disappoint. The outdoor living spaces offer spectacular golf course, mountain and sunset views complementing the expansive private patio with a heated pool & spa, gas fire pit and outdoor gas grill. A membership is not included.
#7032131

Scottsdale

9937 E TAOS Drive

4 Beds

4 Baths

3,858 Sq.Ft.

$2,850,000

MLS#: 7032131

Final opportunity to own in the prestigious Emerald Hills community by Cachet Homes. Situated on an expansive ¾-acre homesite in Scottsdale's highly sought-after Shea Corridor, this brand-new luxury estate--scheduled for completion in Spring 2026--offers 4,909 square feet of refined single-level living. The thoughtfully designed floor plan features 4 bedrooms, 4.5 bathrooms, and a detached pool house complete with its own full kitchen, bath, and living space--ideal for guests or extended stays. At the heart of the home, a chef's kitchen impresses with dual islands, a wet bar, a separate service kitchen, and an expansive walk-in pantry. Step outside to a resort-style backyard showcasing a sparkling pool and spa, lush landscaping, and views of the McDowell Mountains. All just moments from premier golf, scenic hiking and biking trails, upscale shopping, and top-rated schools--offering the very best of Scottsdale living.
#7018870

Scottsdale

12399 E GOLD DUST Avenue

4 Beds

4 Baths

4,909 Sq.Ft.

$3,800,000

MLS#: 7018870

Tucked away on a quiet cul-de-sac with views of Camelback Mountain, this beautifully remodeled home delivers the ultimate Scottsdale lifestyle with exceptional indoor/outdoor living. A retractable glass wall opens to a stunning backyard featuring travertine hardscape, lush turf, a pebble-finish pool with waterfall, and a private Hot Springs spa with custom stone surround. The chef's kitchen is thoughtfully designed with premium Thermador appliances, custom cabinetry, induction cooktop with pot filler, honed granite countertops, and an oversized walk-in pantry. Natural light pours throughout the home from expansive floor-to-ceiling windows, skylights, and an inviting open-concept layout centered around a dramatic wood-burning fireplace. The luxurious primary retreat offers a private sitting area, French doors to the spa, and a custom-designed dressing closet. The spa-inspired bath includes marble finishes, dual vanities, soaking tub, private water closet, and an oversized walk-in shower with dual showerheads. A standout feature is the versatile attached guest quarters with private entrance, dedicated parking, kitchenette, living area, walk-in closet, and full bath. Ideal for guests, multigenerational living, home office, rental income, nanny quarters, or private retreat. Located just minutes from Old Town Scottsdale and Fashion Square, this exceptional property combines luxury, functionality, and location in one unforgettable home.
#7031487

Scottsdale

7470 E SAN MIGUEL Avenue

4 Beds

3 Baths

4,010 Sq.Ft.

$2,700,000

MLS#: 7031487

A complete reimagining in the heart of Scottsdale's coveted Cactus Corridor, this 5 bedroom, 3 full bath, 2 half bath residence blends timeless architecture with warm organic design. Thoughtfully reworked to appeal to a wide range of buyers, the floor plan offers seamless flow, generous living spaces, and an effortless indoor-outdoor lifestyle. Curated finishes include custom cabinetry, natural stone surfaces, wood flooring throughout, and a premium Thermador appliance package. Nearly every major component of the home has been upgraded, including new AC units, tankless water heaters, and extensive interior and exterior improvements, creating a true turnkey experience. Set on an exceptional Cactus Corridor lot, the backyard was designed for both everyday living and entertaining, featuring a newly constructed pool, expansive outdoor spaces, and mature desert surroundings that create a private resort-like setting. A rare opportunity to own a fully renovated home in one of Scottsdale's most desirable locations.
#7019529

Scottsdale

12525 N 85TH Street

5 Beds

3 Baths

5,192 Sq.Ft.

$3,790,000

MLS#: 7019529

Price reduced
Experience elevated desert living in this exceptional Scottsdale estate, perfectly positioned on an expansive private lot with a circular driveway and impeccable curb appeal. Designed with luxury in mind, this stunning residence showcases high-end finishes throughout, ceilings accented with gorgeous rich wood beams, an immense amount of natural lighting coming through the large front and back windows, and a thoughtfully designed split floorplan offering ultimate privacy. Retreat to the lavish primary suite with a spa-inspired bath designed for relaxation and sophistication. Large, tiled shower with separate soaking tub, his and her sinks, and a primary walk-in closet that would be the envy of anyone who sees it. Both the primary bedroom and closet offer separate entrances to your backyard, and laundry is conveniently located both by the primary and secondary bedrooms. Two secondary bedrooms include their own en-suite bathroom with glass enclosed showers, providing comfort and convenience for family and guests alike, and all bedrooms have walk-in closets. The chef's kitchen features stunning custom white cabinetry and granite counters accented by a large island with black granite counter and cabinets, and stainless-steel appliances with built-in ovens. Your pantry is a room of its own with numerous shelves and separate sink for convenience. Added cabinetry with beverage cooler in your dinette area allows for a coffee bar, liquor display cabinet, and more. This seamlessly opens to your elegant living and entertaining spaces with fireplace. Enjoy movie nights in the theatre room, which also can be used as a dedicated home gym or office. Attached to the main home is an oversized four-car garage with epoxy flooring and in the backyard is a separate two-car garage accessible through the RV gate, which also leads to the expansive RV parking area. Enjoy breathtaking sunsets and views from your backyard complete with a sparkling private pool and ample space to entertain, relax, and take in the Arizona lifestyle.
#7029691

Scottsdale

12621 N 80TH Place

4 Beds

4 Baths

3,524 Sq.Ft.

$2,665,000

MLS#: 7029691

IMMEDIATE GOLF MEMBERSHIP AT CLOSE OF ESCROW. Welcome to #665, an artfully designed sanctuary by Lash McDaniel, featuring soft rounded walls + large expanses of glass framing the beauty of the Sonoran Desert and stunning mountain views. The main home features quality craftsmanship and attention to detail by United West, casita by RJ Gurley Construction. 4,027 square feet of open, sunlit living featuring a private master retreat with backyard access, two guest bedrooms in the main house each with ensuite baths, den/office with adjacent bath + a 2-room casita. Outdoor living with oversized heated spa + cascading water feature serve as the ultimate backyard centerpiece. Large covered patio with multiple dining/conversation terraces to enjoy the beautiful Arizona sunsets. Designated a top 'Platinum Club of America'' golf club, Desert Highlands amenities include a Jack Nicklaus Signature championship golf course, 18-hole putting course, award winning clubhouse featuring ''Jacks'' gastropub, state of the art fitness center, Highlands Racquet Club featuring grass, clay & pickleball courts,& more. A $ 205,000 membership fee is due from buyer at close of escrow
#7030318

Scottsdale

10040 E HAPPY VALLEY Road 665

4 Beds

5 Baths

4,027 Sq.Ft.

$2,650,000

MLS#: 7030318

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 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.

28028 N 148TH Street

Message successfully sent.

I agree to receive email communication and understand I can unsubscribe at any time.

I agree to be contacted by The Mandy Gold Team | Haymore Real Estate LLC via call, email, and text for real estate services. To opt out, you can reply 'stop' at any time or reply 'help' for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. Privacy Policy

- property

Send a message

Message successfully sent.

Reason for contacting?

I agree to receive email communication and understand I can unsubscribe at any time.

I agree to be contacted by The Mandy Gold Team | Haymore Real Estate LLC via call, email, and text for real estate services. To opt out, you can reply 'stop' at any time or reply 'help' for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. Privacy Policy

Sign In Sign Out

Virtual Assistant

Would you like to take the next step with this property? We can help you schedule a showing or virtual tour, or send you more details.

Yes, I would like more information.

Thank You for Your Reply, One of Our Agents will contact you as soon as possible

No, maybe later.

Thank you, you can always contact me via email, phone number or through the contact form.

Realhub AI

Lucy - Your AI-Powered Realtor

Update Your Temporary Password

Personalize your search

Enter your email and we'll notify you immediately when new listings match what you're looking for.

or enter email address

Already have an account ? Login here

Continue your home search

I agree to receive communications and understand I can unsubscribe at any time.

I agree to be contacted by The Mandy Gold Team | Haymore Real Estate LLC via call, email, and text for real estate services. To opt out, you can reply 'stop' at any time or reply 'help' for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. Privacy Policy

Already have an account ? Login here

We use cookies

We use cookies primarily for analytics to enhance your experience. By accepting, you agree to our use of these cookies. You can manage your preferences or learn more about our cookies policy.

Privacy Policy Terms of Service