28713 N 148TH Street, Scottsdale, AZ 85262 (MLS# 5114467)

28713 N 148TH Street, Scottsdale, AZ 85262

$3,200

Virtual Tour

http://www.tourfactory.com/idxr1168435

This home is at the SE corner of Roy Rogers and 148th Street. Feel free to drive by and see the layout of the property.

Property Type: Residential Lease Bedrooms: 3 Baths: 2.5 Square Footage: 3,200 Lot Size (sq. ft.): 108,900 Status: Closed

Current Price: $3,200 Last Modified: 12/25/2025

Description

Spectacular home on 2.5 prime acres with complete horse set-up & pool loaded w/custom detailing to accentuate truly magnificent forever mountain views of Four Peaks & Bartlett Reservoir Dam from Walls of Glass inside the home including the office/study on 2nd level. Entertain in style on expansive terrace with dramatic neg. edge pebtec pool, waterfall, Blt-in BBQ & Frig, B-hive FP, Chef's kitchen w/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 w/bridal path access. See Supplement for pet info.

Supplements: Horses, ponies, and potentially llamas allowed. NO Cats or goats.

More Information MLS# 5114467

General Property Description

Fireplaces Total: 2 Dwelling Styles: Detached # of Interior Levels: 1 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: Desert Sun Academy 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: 1 # Bedrooms: 3 Total Bathrooms: 2.5 Year Built: 1999

Contract Information

Vacation Ready Rental Y/N: N Type: Exclusive Right To Lease Date Available: 2014-06-12 Current Price: $3,200 Sold Price: $3,200 Status: Closed List Date: 2014-05-12

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: 1000 Security Deposit: 3400 Credit Check Amount per Adult: 80 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 Bed Size

King: 1

Master Bathroom

Full Bth Master Bdrm: 1 Separate Shwr & Tub: 1 Double Vanity: 1 Tub with Jets: 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 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

Interior Features

Vaulted Ceiling(s): 1

Basement

Basement Y/N: N

Other Rooms

Family Room: 1

Separate Den/Office

Sep Den/Office Y/N: Y

Technology

High Speed Internet: 1 Security System: 1

Fencing

Other: 1 See Remarks: 1

Water Source

Well - Shared: 1

Exterior Features

Covered Patio(s): 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 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

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

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

Listing Broker: 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 St. (approx. 1/4 mile) Home on NE corner of 148th Street and Roy Rogers. Geo Lat: 33.74641 Geo Lon: -111.76038

Status Change Info

Off Market Date: 2014-08-02 Under Contract Date: 2014-07-31 Close of Escrow Date: 2014-08-01 Sold Price: $3,200

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 Master Bedroom: Split; Downstairs Additional Bedroom: Separate Bedroom Exit; Walk-In Closet Fireplace Features: Fireplace Family Rm; Fireplace Living Rm; 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 Interior Features: Vaulted Ceiling(s) Technology: High Speed Internet; Security System Exterior Features: Covered Patio(s); Built-in BBQ Parking Features: Attch'd Gar Cabinets; 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: Other; See Remarks Property Description: Corner Lot; Street(s) Not Paved Landscaping: Desert Front; Desert Back Horse Features: Corral(s); Stall; Tack Room; Arena; Auto Water; Bridle Path Access Master Bed Size: King 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 Possession (Rentals): Refer to Date Availb Fully Refundable Dep: Security Deposit; Pet Deposit Non-Refundable Dep: Cleaning Deposit Earnest Dep Payable: Listing Broker

Listing Office: RE/MAX Excalibur

Last Updated: December - 25 - 2025