28713 N 148th Street, Scottsdale, AZ 85262

$3,400
Property Type: Residential Lease Bedrooms: 3 Baths: 2.5 Square Footage: 3,200 Lot Size (sq. ft.): 108,900 Status: Closed
Current Price: $3,400 Last Modified: 7/09/2025

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.

More Information MLS# 5290149

Contract Information

Current Price: $3,400 Vacation Ready Rental Y/N: N Sold Price: $3,400 Status: Closed List Date: 2015-06-05 Type: Exclusive Right To Lease Date Available: 2015-08-02

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

General Property Description

Dwelling Type: Single Family Residence Dwelling Styles: Detached Exterior Stories: 2 # of Interior Levels: 2 # Bedrooms: 3 # Bathrooms: 2.5 Approx SQFT: 3200 Approx Lot SqFt: 108900 Horses: Y Builder Name: Puccillo Year Built: 1999 Community Pool Y/N: No Private Pool Y/N: Yes 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

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

Legal Info

Township: 5N Range: 6E Section: 29 Lot Number: -

Initial Move-in Costs

Earnest Deposit: 2500 Security Deposit: 3400 Cleaning Deposit/Fee: 300 Pet Deposit/Fee: 500

Rental Info

Pets: Non-Assistive Animals: Lessor Approval HOA Y/N: N Furnished?: Unfurnished

Basement

Basement Y/N: N

Parking Spaces

Garage Spaces: 3 Total Covered Spaces: 3

Lease Term

Minimum Lease Term (Months): 12

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: 2 Fireplaces; Fireplace Family Rm; Fireplace Living Rm; Fireplace Master Bdr; Two Way Fireplace Flooring: Carpet; Tile Windows: Dual Pane Private Pool Features: Private; Fenced; Play Pool Spa - Private: None Dining Area: Formal; Eat-in Kitchen; Dining in LR/GR; Dining in FR; Breakfast Bar 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 & Cnctd Fencing: Wrought Iron; Other; See Remarks Property Description: Corner Lot; Mountain View(s); 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: July - 09 - 2025
28713 N 148th Street, Scottsdale, AZ 85262- MLS# 5290149
Copyright 2024 Arizona Regional Multiple Listing Service, Inc. All rights reserved. Information Not Guaranteed and Must Be Confirmed by End User. Site contains live data.