12687 N 102ND Street, Scottsdale, AZ 85260 (MLS# 6513979)

12687 N 102ND Street, Scottsdale, AZ 85260

$2,875,000

Don't Miss this Stunning, One-of-a-Kind Estate!

Virtual Tour

https://listing.snap2close.com/ut/12687_N_102nd_Street.html

OFFERING THE BEST OF BOTH WORLDS... A Stunning Home Up Front & a Ton of Fun Out Back...

Follow the Circular Driveway to this Grand Entrance...

This Impressive, Curved Staircase is made from Hand-Cut Slabs of Stone & Steel...

Featuring 22' Ceilings, A Wall of Windows & a Timeless Limestone & Cantera Fireplace

You're Sure to Love the Soaring Ceilings & Dramatic Views

Spacious, Open Floorplan Offers Soaring Ceilings & Special Details Throughout

Open the French Doors & Let the Party Flow Outside!

Stylish Dining Room Impresses with Designer Lighting, Tray Ceilings & Views...

Spacious Great Room Features a Stunning 15-ft Floating Wall of Fire...

Dramatic Entertainment Wall Includes a new 86" Sony 4K Television!

This Magnificent Floating Wall of Fire is Truly Special...

There's Room for Everyone in this HUGE Great Room!

Everywhere you look... there's thoughtful details & impeccable craftsmanship...

This versatile sitting area is big enough for a pool table!

A casual dining spot offers pool & kitchen views

This casual dining area is a perfect spot for breakfast or an evening card game!

Gourmet Kitchen Includes Thomasville Cabinetry, an 8' Island, plus TWO of almost every Appliance!

Beverage Station is Perfect for Entertaining or a Morning Cappuccino!

You're Sure to Get Spoiled with Two Miele Dishwashers & a Top-of-the-Line Wolf Induction Cooktop!

This Walk-in Pantry is Just One of THREE PANTRIES!!!

This is Just One of THREE LAUNDRY ROOMS!!!

Includes White Oak Flooring, Custom Built-ins & New 4K Sony Television!

Large Sitting Area w/ Stone Fireplace, Gorgeous Butted-Glass Windows & Motorized Shades

This Luxe Spa Bath includes a Wet room Wrapped in Textured Quartzite & Invisible glass...

This Sculptural Stone Tub offer Air Jets for Relaxation...

Oversized Shower offers Multiple Rain Shower Heads & Floating Bench

Glowing Crystallo Quartzite Counters... Custom Mirrors... Designer Lighting & More...

Stylish Guest Bath Offers Contemporary Brushed Bronze Finishes & Impeccable Tile Work!

This Spectacular Guest Bath Shower is Straight Out of a Magazine!

This Additional Downstairs Bedroom makes a Great Gym, Office or ???

An Additional Primary Suite Offers a Large Private Deck, Stunning Views, HUGE closet & Spa Bath

A Double-Door Entry, Tray Ceilings, & Cushy New Textured Carpets...

The Perfect Spot for Morning Coffee, Happy Hour, or Evening Stargazing...

Private Deck offers Tree-top & Mountain Views...

Spectacular Views from your Private Deck!

Views... Views... Views... From the Luxurious Soaking Tub!

Resort-Quality Bath offers Large Format Tile, Dual Vanities, & Tons of Storage!

You're Sure to Enjoy this Steamy Quartzite Shower!

Large Loft Makes a Great Office, Game Room or ???

Bedroom #3 Offers City Light Views, Walk-in Closet & Private Bath Entrance

Bath #3 features TONS of Storage... including TWO Linen Cabinets!

Bedroom #4 Enjoys City Light Views & Built-ins w/Room for a Bed in Between!

You Can Enjoy the Tranquil Pebble-Tec Pool & Spa Year-round!

This Curved Stone Firepit is THE PLACE to be on a Chilly Evening...

This estate includes mature landscaping, exotic plantings, fruit trees & PRIVACY!

This Estate includes More Than 1500 sq' of Paver Paths & Stone Patios...

Features a built-in BBQ, Refrigerator, & enough Counter Space for 8 of your Closest Friends!

This Oversized Shady Patio Runs the Full Length of the Home!

Stroll Down this Path to your Very Own Field of Dreams!

Hidden from the House... is your Very Own Secret Ball Park...

Welcome to Your Own Private Ballpark! Perfect for a variety of sports, parties & events!

Calling ALL Athletes! Professional Quality Turf Baseball Field is also Great for Soccer, Softball, Golf, Football, Yoga & more...

Watch the Fun in Comfort... from this Spectator Viewing Deck

Private Professional-Quality Turf Baseball Field w/View Decks & More...

This Ballpark is perfect for hosting large events & parties!

Property Type: Residential Bedrooms: 5 Baths: 4 Square Footage: 4,945 Lot Size (sq. ft.): 46,316 Status: Closed

Current Price: $2,875,000 List Date: 2/07/2023 Last Modified: 4/28/2025

Overview

Description

SIMPLY SPECTACULAR PRIVATE RESORT! Newly remodeled - Your clients will love this stunning custom home that shows like new... because it practically is!! Magnificent and beautifully manicured large 1+ acre lot offers picturesque mountain views from the great room, kitchen and BOTH master bedrooms. Yes, 2 master Suites! This stylish, open floor plan offers unparalleled detail and craftsmanship that you would expect in homes $4 million and up. From the European white oak flooring to the stunning 15-foot fire wall, this home is not to be missed. Lush grounds offer complete privacy along with more than 1500 sq feet of stone patios. Meander down a paver path and over the bridge to your own private Field of Dreams!! Yes... this home includes its own private baseball field & ballpark!

Supplements: THE BALLPARK: Kids and athletes alike will LOVE this professional-quality baseball field complete with raised viewing deck, backstop, & maintenance-free artificial turf! Perfect for baseball, whiffle ball, practicing golf shots, football, soccer, yoga, & elaborate events! MASTERFULLY DESIGNED: This home is ready for those who appreciate unpa ... (Read more)

Listing Details MLS# 6513979

Location, Tax & Legal

Map Code/Grid: L38
House Number: 12687
Compass: N
Street Name: 102ND
St Suffix: Street
City/Town Code: Scottsdale
State/Province: AZ
Zip Code: 85260
Zip4: 4640
Country: US
County Code: Maricopa
Assessor Number: 217-23-962
Subdivision: WINDROSE ACRES LOT 1-5
Tax Year: 2022
Assessor's Map #: 23
Legal Description (Abbrev): LOT 4 WINDROSE ACRES LOT 1-5 MCR 031339
Assessor's Parcel #: 962
Tax Municipality: Scottsdale
Taxes: 6158

Contract Information

Type: Exclusive Right To Sell
Ownership: Fee Simple

General Property Description

Dwelling Type: Single Family Residence
Dwelling Styles: Detached
Exterior Stories: 2
# of Interior Levels: 2
# Bedrooms: 5
Total Bathrooms: 4
Approx SQFT: 4945
Price/SqFt: 581.4
Horses: N
Model: Custom
Builder Name: CUSTOM
Year Built: 1988
Approx Lot SqFt: 46316
Approx Lot Acres: 1.063
Flood Zone: No
Community Pool Y/N: No
Private Pool Y/N: Yes
Fireplace YN: Yes
Fireplaces Total: 3
Elementary School District: Scottsdale Unified District
High School District: Scottsdale Unified District
Elementary School: Cheyenne Traditional Elementary School
Jr. High School: Mountainside Middle School
High School: Desert Mountain High School

Remarks Misc

Cross Street: Cactus Rd & 104th St
Directions: From Cactus Rd - North on 104th, West on Charter Oak, Charter Oak curves North into 102nd St. Home on right.

Status Change Info

Off Market Date: 2023-03-28
Under Contract Date: 2023-02-21
Close of Escrow Date: 2023-03-27

Legal Info

Township: 3N
Range: 5E
Section: 17
Lot Number: 4
Cnty Rcrd Bk & Pg #: 313-39

More Information

Basement

Basement Y/N: N

Items Updated

Floor Yr Updated: 2023
Floor Partial/Full: Full
Wiring Yr Updated: 2022
Wiring Partial/Full: Partial
Plmbg Yr Updated: 2022
Ht/Cool Yr Updated: 2022
Ht/Cool Partial/Full: Full
Roof Yr Updated: 2023
Roof Partial/Full: Full
Kitchen Yr Updated: 2023
Kitchen Partial/Full: Full
Bath(s) Yr Updated: 2023
Bath(s) Partial/Full: Full
Rm Adtn Yr Updated: 2023
Rm Adtn Partial/Full: Full
Pool Yr Updated: 2018

Parking Spaces

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

Distance To Street

Distance To Street Comments: Huge front yard. Home sits far back off the street.

Sold Info

Loan Type: Conventional
Closing Cost Split: Normal - N
Buyer Concession $/%: $
Seller Concession to Buyer: 2500
Seller Concession $/%: $
Buyer Concession to Seller: 0

Special Listing Cond

Owner/Agent: Yes

Construction

Wood Frame: Yes

Const - Finish

Painted: Yes
Stucco: Yes
Stone: Yes

Roofing

Built-Up: Yes
Tile: 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

Contemporary: Yes
Santa Barbara/Tuscan: Yes

Master Bathroom

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

Master Bedroom

Split: Yes
Upstairs: Yes
Downstairs: Yes

Additional Bedroom

2 Master Bedrooms: Yes
Separate Bedroom Exit: Yes
Master Bedroom Walk-in Closet: Yes
Other Bedroom Walk-in Closet: Yes
Master Bedroom Sitting Room: Yes

Fireplace Features

Fireplace Family Rm: Yes
Fireplace Living Rm: Yes
Fireplace Master Bdr: Yes
Gas Fireplace: Yes
Fire Pit: Yes

Flooring

Carpet: Yes
Stone: Yes
Tile: Yes
Wood: Yes

Window Features

Dual Pane: Yes
Mechanical Sun Shds: Yes
Tinted Windows: Yes

Private Pool Features

Heated: Yes

Dining Area

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

Heating

Electric: Yes
ENERGY STAR Qualified Equipment: Yes

View

City Lights: Yes
Mountain(s): Yes

Kitchen Features

Dishwasher: Yes
Disposal: Yes
Engy Star (See Rmks): Yes
Kitchen Island: Yes
Built-in Microwave: Yes
Multiple Ovens: Yes
Non-laminate Counter: Yes
Pantry: Yes
Range/Oven Elec: Yes
Refrigerator: Yes
Reverse Osmosis: Yes
Walk-in Pantry: Yes
Wall Oven(s): Yes
Electric Cooktop: Yes

Cooling

Ceiling Fan(s): Yes
ENERGY STAR Qualified Equipment: Yes
Programmable Thmstat: Yes
Central Air: Yes

Interior Features

Skylight(s): Yes
Vaulted Ceiling(s): Yes
9+ Flat Ceilings: Yes
Fire Sprinkler System: Yes
Water Softener Owned: Yes
Soft Water Loop: Yes
Water Purifier: Yes

Laundry

Washer Included: Yes
Dryer Included: Yes
Engy Star (See Rmks): Yes
Washer Hookup: Yes
Inside: Yes

Other Rooms

Family Room: Yes
Great Room: Yes
Loft: Yes
Exercise/Sauna Room: Yes

Separate Den/Office

Sep Den/Office Y/N: N

Accessibility Feat.

Hard/Low Nap Floors: Yes
Bath Lever Faucets: Yes
Lever Handles: Yes
Remote Devices: Yes
Mltpl Entries/Exits: Yes

Technology

Pre-Wire Srnd Snd: Yes
Pre-Wire Sat Dish: Yes
Sat Dish Intrnt Ownd: Yes
High Speed Internet: Yes
Security System Owned: Yes

Fencing

Block: Yes

Water Source

City Water: Yes

Exterior Features

Balcony: Yes
Built-in BBQ: Yes
Playground: Yes
Sport Court(s): Yes
Covered Patio(s): Yes
Patio: Yes
Pvt Yrd(s)/Crtyrd(s): Yes
Other: Yes

Spa

Private: Yes
Heated: Yes

Sewer

Sewer - Public: Yes

Parking Features

Attch'd Gar Cabinets: Yes
Electric Vehicle Charging Station(s): Yes
RV Gate: Yes
Separate Strge Area: Yes
Side Vehicle Entry: 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

Multi-Zones: Yes
ENERGY STAR Light Fixture: Yes

Plumbing

Electric Hot Wtr Htr: Yes
Engy Star Ht Wtr Htr: Yes

Utilities

APS: Yes
Propane: Yes

Existing 1st Loan

Treat as Free&Clear: Yes

Property Description

Adjacent to Wash: Yes

Landscaping

Desert Front: Yes
Desert Back: Yes
Grass 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

City Services: 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: Owner/Agent Architecture: Contemporary; Santa Barbara/Tuscan View: City Lights; Mountain(s) Master Bathroom: Full Bth Master Bdrm; Separate Shwr & Tub; Double Vanity; Private Toilet Room; 2 Master Baths; Tub with Jets Master Bedroom: Split; Upstairs; Downstairs Additional Bedroom: 2 Master Bedrooms; Separate Bedroom Exit; Master Bedroom Walk-in Closet; Other Bedroom Walk-in Closet; Master Bedroom Sitting Room Fireplace Features: Fireplace Family Rm; Fireplace Living Rm; Fireplace Master Bdr; Gas Fireplace; Fire Pit Flooring: Carpet; Stone; Tile; Wood Window Features: Dual Pane; Mechanical Sun Shds; Tinted Windows Private Pool Features: Heated Spa: Private; Heated Dining Area: Formal; Eat-in Kitchen; Breakfast Bar; Dining in LR/GR; Dining in FR; Breakfast Room Kitchen Features: Range/Oven Elec; Electric Cooktop; Disposal; Dishwasher; Built-in Microwave; Refrigerator; Engy Star (See Rmks); Reverse Osmosis; Wall Oven(s); Multiple Ovens; Pantry; Walk-in Pantry; Non-laminate Counter; Kitchen Island Laundry: Washer Included; Dryer Included; Engy Star (See Rmks); Washer Hookup; Inside Other Rooms: Family Room; Great Room; Loft; Exercise/Sauna Room Interior Features: Skylight(s); Vaulted Ceiling(s); 9+ Flat Ceilings; Fire Sprinkler System; Water Softener Owned; Soft Water Loop; Water Purifier Technology: Pre-Wire Srnd Snd; Pre-Wire Sat Dish; Sat Dish Intrnt Ownd; High Speed Internet; Security System Owned Exterior Features: Balcony; Built-in BBQ; Playground; Covered Patio(s); Patio; Pvt Yrd(s)/Crtyrd(s); Sport Court(s); Other Parking Features: Circular Driveway; Attch'd Gar Cabinets; Direct Access; Electric Vehicle Charging Station(s); Extended Length Garage; Garage Door Opener; RV Access/Parking; RV Gate; Separate Strge Area; Side Vehicle Entry Construction: Wood Frame Const - Finish: Painted; Stucco; Stone Roofing: Built-Up; Tile Cooling: Central Air; Ceiling Fan(s); Programmable Thmstat; ENERGY STAR Qualified Equipment Heating: Electric; ENERGY STAR Qualified Equipment Plumbing: Electric Hot Wtr Htr; Engy Star Ht Wtr Htr Utilities: APS; Propane Water Source: City Water Sewer: Sewer - Public Services: City Services Fencing: Block Property Description: Adjacent to Wash Landscaping: Desert Front; Desert Back; Grass Back; Synthetic Grass Back; Yrd Wtring Sys Front; Yrd Wtring Sys Back; Auto Timer H2O Front; Auto Timer H2O Back Showing Notification Methods: Text; Email; Phone Call Lockbox Type: None Possession: Close of Escrow 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: Keller Williams Arizona Realty

Last Updated: April - 28 - 2025