Search


$3,200
28713 N 148TH Street
Scottsdale, AZ 85262
MLS# 5114467
Status: Closed
3 beds  |  2.5 baths


001_Front 1
  1 / 49  
001_Front 1 005_Foyer 020_Kitchen 1 024_Island 026_Breakfast 1 032_Master 036_Master Bath 1 052_Pool 1 056_Views 3 069_Stables 004_Front Entry 007_Living 2 009_Living 3 010_Living View 011_Family 1 013_Family 2 014_Fireplace 016_Family View 017_Dining 1 022_Granite 026_Breakfast 1 027_Master Bath 2 028_Powder 029_Stairwell 030_Office 1 034_Master Sitting 035_Walkin 038_Master Bath 3 040_Laundry 043_Guest A2 047_Guestbath 048_Covered Patio 049_Covered Patio 2 051_Backyard 057_Landscape 058_Kiva 060_Patio 2 061_Yard 062_Dog Run 063_Deck View 066_Corral 1 070_Stalls Nice size arena Round pen 3 stall barn with breezeway area. 073_Tack Room where horse facilities are on property. 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. South side of home.

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

Details
Maps
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
Supplements
Horses, ponies, and potentially llamas allowed. NO Cats or goats.

IDX
Listing Office: RE/MAX Excalibur

Last Updated: December - 25 - 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.