x
Showing 1 of 0
Save

28216 N 148th Street
Scottsdale AZ 85262 US

$915,000real estate property listed by Realty Executives real estate property listing

Active Listing ID 6786512
bed icon
4 bed
bath icon
2.00 Bath (2 Full)
lot icon
Lot: 1.75 Acres
home icon
Other

$915,000real estate property listed by Realty Executives real estate property listing

Active Listing ID 6786512
Save

28216 N 148th Street This cypress-wood home on 1-3/4 acres in N. Scottsdale has a PRIVATE WELL and breathtaking mountain views. The Main Floor boasts Two Bdrms + Office + One Bath, while the Second Level hosts the Primary Suite + Loft. The living area is accented by chicory wood floors, doors, and ceilings, with a breathtaking stone fireplace framed by a full wall of glass and plantation shutters. Enjoy double-gated entries to the property and exceptional equestrian amenities which include 6 covered 30'x15' stalls with water, a tack shed, a 1/3-acre riding arena with metal pole fencing, and a 60'x100' covered big-rig pull-thru with lighting. Additional features include 2 covered 20'x30' concrete pads, a casita structure with stubbed water, an enclosed poultry shed, owned solar panels, and 30-amp RV power. This stunning residence features an open-concept layout, dramatic floor-to-ceiling windows, and an abundance of natural light. The kitchen boasts a spacious center island with butcher block counters and bar seating, complemented by stainless steel appliances, a farmhouse sink, granite countertops, and a stone backsplash. The property has plenty of parking spaces for toys, trailers, and RVs, making this property perfect for equestrian and outdoor enthusiasts. Embrace tranquility away from city noise. Enjoy morning coffee on your expansive front porch. Pamper your horses and give your dogs room to run. With no HOA restrictions, the sky's the limit for adding on or customizing the space to your heart's content.

Collapse all

Property Features

  • Facts
  • Lot Size: 1.75 Acres
  • Property Type: Residential
  • Property Sub-type: Other
  • Features
  • Full Bathrooms: 2
  • Exterior Finish: Corner Lot, Dirt Back, Storage
  • Floor Covering: Wood
  • Roof Type: Composition
  • Heating Fuels: Fireplace
  • Additional Features
  • Fireplace

School Information

  • School
  • Desert Sun Academy(Elementary)
  • Sonoran Trails Middle School(MiddleSchool)
  • Cactus Shadows High School(HighSchool)

Property

  • propertytype: Residential
  • propertysubtype: Other
  • listprice: 915000
  • unparsedaddress: 28216 N 148th Street
  • postalcity: Scottsdale
  • stateorprovince: AZ
  • country: US
  • postalcode: 85262
  • bathroomsfull: 2
  • bathroomshalf: 0
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 1.75
  • lotsizeunits: Acres
  • lotsizearea: 1.75
  • livingarea: 2610
  • livingareaunits: Square Feet
  • latitude: 33.742009
  • longitude: -111.761463
  • listagentfullname: Ben Koerner
  • listagentemail: benkoerner@gmail.com
  • listagentkey: 3yd-ARMLSAZ-bk002
  • listagentmlsid: bk002
  • listagentpreferredphone: 6026479151
  • listagentofficephone: 4808392600
  • listofficekey: 3yd-ARMLSAZ-reax15
  • listofficemlsid: reax15
  • disclaimer: Copyright © 2025 Arizona Regional Multiple Listing Service, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: ARMLSAZ
  • yearbuilt: 2000
  • listingcontractdate: 2024-11-20
  • listagenturl: http://www.RealtyExecutivesPhoenix.com
  • countyorparish: Maricopa
  • parcelnumber: 219-39-062-U
  • elementaryschool: Desert Sun Academy
  • highschool: Cactus Shadows High School
  • elementaryschooldistrict: Cave Creek Unified District
  • middleorjuniorschooldistrict: Cave Creek Unified District
  • highschooldistrict: Cave Creek Unified District
  • flooring: Wood
  • heating: Fireplace
  • fireplaceyn: True
  • transactiontype: ForSale
  • storiestotal: 0
  • parkingtotal: 0
  • parkingfeatures: RV
  • roof: Composition
  • view: City, Mountain
  • waterfrontyn: False
  • franchiseaffiliation: Realty Executives International
  • interiorfeatures: Master Downstairs, Eat-in Kitchen, Vaulted Ceiling(s), Kitchen Island, 3/4 Bath Master Bdrm, Double Vanity
  • exteriorfeatures: Corner Lot, Dirt Back, Storage
  • architecturalstyle: Ranch
  • rooms: Bathroom 1, Bathroom 2, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4
  • otherstructures: Storage
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: False
  • internetconsumercommentyn: False
  • location: -111.76146, 33.74201
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"Realty Executives", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"benkoerner@gmail.com", "ListBrokerageCity":"Scottsdale", "ListBrokerageCountry":"US", "ListBrokerageEmail":"RhondaPeters@RealtyExecsAZ.com", "ListBrokerageLogoUrl":"http://brokerlogos.listhub.net/ARMLSAZ/c5ababc320fc835a0120fd2b8de3004e/20100526131334966.png", "ListBrokerageName":"Realty Executives", "ListBrokeragePhone":"(602) 957-0444", "ListBrokeragePostalCode":"85255", "ListBrokerageStateOrProvince":"AZ", "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"21040 N. Pima Road", "ListBrokerageWebsiteUrl":"http://www.RealtyExecutivesPhoenix.com", "ListOfficeAddress1":"2133 E Warner Rd", "ListOfficeAddress2":"Suite 105", "ListOfficeBrokerMlsId":"dl247", "ListOfficeCity":"Tempe", "ListOfficeCountry":"US", "ListOfficeEmail":"dpatricklewis@gmail.com", "ListOfficePostalCode":"85284", "ListOfficeStateOrProvince":"AZ", "ListPriceCurrencyType":"USD", "ListingTitle":"Single Family - Detached, Ranch - Scottsdale, AZ", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/28216-N-148th-St_Scottsdale_AZ_85262_M26799-59883?f=listhub&s=ARMLSAZ&m=6786512&c=rexren", "MLSModificationTimestamp":"2025-01-14T13:18:06Z", "Neighborhoods":[], "PostalCode":null, "RawPropertySubType":"Single Family - Detached", "RawPropertyType":"Residential", "RoomCount":null, "StateOrProvince":null, "Taxes":[{"TaxAnnualAmount":1751, "TaxDescription":null, "TaxYear":"2023"}], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 1/15/2025 12:26:14 AM GMT
Source Updated Date: 2/21/2025 6:51:39 AM GMT

Courtesy of: Ben Koerner, Realty Executives, benkoerner@gmail.com

Copyright © 2025 Arizona Regional Multiple Listing Service, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.