$3,400
Scottsdale, AZ 85262
MLS# 5290149
Status: Closed
3 beds | 2.5 baths
1 / 63
Property Description
Spectacular home on 2.5 prime acres with complete horse setup and pool loaded with custom detailing to accentuate truly magnificent forever mountain views of Four Peaks and Bartlett Reservoir Dam from walls of glass inside the home including office/study on the 2nd level. Entertain in style on expansive terrace with dramatic neg. edge pebble tec pool,waterfall,blt-in BBQ & Frig. B-hive FP, Chef's kitchen with custom Alder cabs, granite tops, double ovens, kitchen island & counter, master split, prof landscaping, circle drive, surround sound in & out, tumbled stone baths, two 2-way FP's, vigas & close to Tonto National Forest for riding/hiking with bridle path access.
Details
Maps
General Property Description
Fireplaces Total: 2
Dwelling Styles: Detached
# of Interior Levels: 2
Approx SQFT: 3200
Approx Lot SqFt: 108900
Horses: Y
Builder Name: Puccillo
Elementary School District: Cave Creek Unified District
High School District: Cave Creek Unified District
Elementary School: Horseshoe Trails Elementary School
Jr. High School: Sonoran Trails Middle School
High School: Cactus Shadows High School
Community Pool Y/N: No
Private Pool Y/N: Yes
Fireplace YN: Yes
Dwelling Type: Single Family Residence
Exterior Stories: 2
# Bedrooms: 3
Total Bathrooms: 2.5
Year Built: 1999
Contract Information
Vacation Ready Rental Y/N: N
Type: Exclusive Right To Lease
Date Available: 2015-08-02
Current Price: $3,400
Sold Price: $3,400
Status: Closed
List Date: 2015-06-05
Location & Legal
Tax Municipality: Maricopa - COUNTY
Assessor's Book #: 219
Assessor's Map #: 39
Assessor's Parcel #: 89
Assessor Parcel Ltr: B
Legal Info
Range: 6E
Section: 29
Township: 5N
Lot Number: -
Special Listing Cond
Owner/Agent: 1
Construction
Wood Frame: 1
Const - Finish
Painted: 1
Stucco: 1
Roofing
Built-Up: 1
Foam: 1
Rolled: 1
Initial Move-in Costs
Earnest Deposit: 2500
Security Deposit: 3400
Credit Check Amount per Adult: 0
Cleaning Deposit/Fee: 300
Pet Deposit/Fee: 500
Pre-Paid Lst Mth Rnt: 0
Rental Info
Pets: Non-Assistive Animals: Lessor Approval
HOA Y/N: N
Furnished?: Unfurnished
Architecture
Territorial/Santa Fe: 1
Master Bathroom
Full Bth Master Bdrm: 1
Separate Shwr & Tub: 1
Double Vanity: 1
Tub with Jets: 1
Walk-in Shower: 1
Master Bedroom
Split: 1
Downstairs: 1
Additional Bedroom
Separate Bedroom Exit: 1
Walk-In Closet: 1
Fireplace Features
Fireplace Family Rm: 1
Fireplace Living Rm: 1
Fireplace Master Bdr: 1
Two Way Fireplace: 1
Flooring
Carpet: 1
Tile: 1
Window Features
Dual Pane: 1
Private Pool Features
Fenced: 1
Play Pool: 1
Spa - Private
None: 1
Dining Area
Formal: 1
Eat-in Kitchen: 1
Breakfast Bar: 1
Dining in LR/GR: 1
Dining in FR: 1
Heating
Electric: 1
View
Mountain(s): 1
Kitchen Features
Dishwasher: 1
Disposal: 1
Electric Cooktop: 1
Granite Counters: 1
Kitchen Island: 1
Multiple Ovens: 1
Refrigerator: 1
Walk-in Pantry: 1
Wall Oven(s): 1
Cooling
Ceiling Fan(s): 1
Central Air: 1
Laundry Features
Dryer Included: 1
Inside: 1
Washer Included: 1
Basement
Basement Y/N: N
Other Rooms
Family Room: 1
Bonus/Game Room: 1
Separate Den/Office
Sep Den/Office Y/N: Y
Technology
High Speed Internet: 1
Security System: 1
Fencing
Wrought Iron: 1
Other: 1
See Remarks: 1
Water Source
Well - Shared: 1
Exterior Features
Covered Patio(s): 1
Patio: 1
Built-in BBQ: 1
Sewer
Septic-In & Connected: 1
Parking Spaces
Slab Parking Spaces: 0
Total Covered Spaces: 3
Garage Spaces: 3
Parking Features
Attch'd Gar Cabinets: 1
Direct Access: 1
Garage Door Opener: 1
RV Access/Parking: 1
Energy/Green Feature
Multi-Zones: 1
Plumbing
Electric Hot Wtr Htr: 1
Utilities
SRP: 1
Propane: 1
Property Description
Corner Lot: 1
Street(s) Not Paved: 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
Horse Features
Corral(s): 1
Stall: 1
Tack Room: 1
Arena: 1
Auto Water: 1
Bridle Path Access: 1
Forms Required
Credit Report Other: 1
Rent Includes
Water: 1
Garbage Collection: 1
Pool Service - Full: 1
Gardening Service: 1
Pest Control Svc: 1
Disclosures
Rental Disc Avail: 1
Rent Payable
Owner: 1
Window Coverings
Blinds: 1
Fully Refundable Dep
Security Deposit: 1
Pet Deposit: 1
Lease Term
Minimum Lease Term (Months): 12
Non-Refundable Dep
Cleaning Deposit: 1
Earnest Dep Payable
Owner: 1
Possession (Rentals)
Refer to Date Availb: 1
Location Legal
Map Code/Grid: H40
House Number: 28713
Compass: N
Street Name: 148th
St Suffix: Street
City/Town Code: Scottsdale
State/Province: AZ
Zip Code: 85262
Zip4: 6860
County Code: Maricopa
Subdivision: NW4 SW4 NW4 SE4 Section 29
Assessor Number: 219-39-089-B
Remarks Misc
Cross Street: Rio Verde Drive and 148th Street
Directions: North on 148th Street to the SE corner of 148th St. and Roy Rogers. (approximately 1/4 mile).
Geo Lat: 33.74641
Geo Lon: -111.76038
Status Change Info
Off Market Date: 2015-07-12
Under Contract Date: 2015-07-10
Close of Escrow Date: 2015-08-01
Sold Price: $3,400
Property Features
Special Listing Cond: Owner/Agent
Architecture: Territorial/Santa Fe
Master Bathroom: Full Bth Master Bdrm; Separate Shwr & Tub; Double Vanity; Tub with Jets; Walk-in Shower
Master Bedroom: Split; Downstairs
Additional Bedroom: Separate Bedroom Exit; Walk-In Closet
Fireplace Features: Fireplace Family Rm; Fireplace Living Rm; Fireplace Master Bdr; Two Way Fireplace
Flooring: Carpet; Tile
Window Features: Dual Pane
Private Pool Features: Fenced; Play Pool
Spa - Private: None
Dining Area: Formal; Eat-in Kitchen; Dining in LR/GR; Dining in FR; Breakfast Bar
View: Mountain(s)
Kitchen Features: Dishwasher; Disposal; Electric Cooktop; Granite Counters; Kitchen Island; Multiple Ovens; Refrigerator; Walk-in Pantry; Wall Oven(s)
Laundry Features: Dryer Included; Inside; Washer Included
Other Rooms: Family Room; Bonus/Game Room
Technology: High Speed Internet; Security System
Exterior Features: Patio; Covered Patio(s); Built-in BBQ
Parking Features: Attch'd Gar Cabinets; Direct Access; Garage Door Opener; RV Access/Parking
Construction: Wood Frame
Const - Finish: Painted; Stucco
Roofing: Built-Up; Foam; Rolled
Cooling: Ceiling Fan(s); Central Air
Heating: Electric
Plumbing: Electric Hot Wtr Htr
Utilities: SRP; Propane
Water Source: Well - Shared
Sewer: Septic-In & Connected
Fencing: Wrought Iron; Other; See Remarks
Property Description: Corner Lot; Street(s) Not Paved
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; Tack Room; Arena; Auto Water; Bridle Path Access
Disclosures: Rental Disc Avail
Window Coverings: Blinds
Forms Required: Credit Report Other
Rent Includes: Water; Garbage Collection; Pool Service - Full; Gardening Service; Pest Control Svc
Rent Payable: Owner
Possession (Rentals): Refer to Date Availb
Fully Refundable Dep: Security Deposit; Pet Deposit
Non-Refundable Dep: Cleaning Deposit
Earnest Dep Payable: Owner
Listing Office: RE/MAX Excalibur
Last Updated: December - 30 - 2025
Copyright 2025 Arizona Regional Multiple Listing Service, Inc. All rights reserved. Information Not Guaranteed and Must Be Confirmed by End User. Site contains live data.