Showing 1 of 0

28216 N 148th Street
Scottsdale AZ 85262 US


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


Active Listing ID 6684580

28216 N 148th Street Welcome home! This one-of-a-kind cypress-wood home rests on a sprawling 1.74-acre North Scottsdale HORSE PROPERTY w/ picturesque mountain views. Amazing location with a rural feel yet the conveniences of city living. Double-gated entries with powered gates and gorgeous ironwork, exceptional equestrian amenities, and parking for all your toys, trailers, and RV. Horse facilities include 6 - 30'x15' covered horse stalls w/ water plumbed to each stall, a tack shed, an approx. 1/3rd acre riding arena w/ metal pole fencing, and a 60'x100' covered big-rig pull-thru w/ lighting. Addt'l highlights include 2 - 20'x30' covered concrete pads, a casita structure w/ stubbed water, an enclosed poultry shed, owned solar panels, 30 amp RV power, and a PRIVATE WELL. The residence features an open concept, dramatic floor-to-ceiling windows, and an abundance of natural light. Living space highlights include chicory wood floors, doors, and ceilings, and a stunning stone fireplace beautifully framed by a full wall of glass and plantation shutters. The kitchen showcases a sizable center island with butcher block counters and bar seating, stainless appliances, a farmhouse sink, granite counters over the remainder of the kitchen, and a stone backsplash. In addition to the kitchen and living space, the main floor hosts 2 bedrooms, an office, and a laundry room. Upstairs you'll find an en-suite bedroom with a spacious loft and dramatic overlook. This property is a RARE find! 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 and 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

School Information

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


  • propertytype: Residential
  • propertysubtype: Other
  • listprice: 959000
  • 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 © 2024 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-03-30
  • 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
  • fireplaceyn: False
  • 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
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: False
  • internetconsumercommentyn: False
  • location: -111.761463, 33.742009
  • customfields: {"AlternatePrices":[], "Expenses":[], "Neighborhoods":[], "ListPriceCurrencyType":"USD", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/28216-N-148th-St_Scottsdale_AZ_85262_M26799-59883?f=listhub&s=ARMLSAZ&m=6684580&c=rexren", "LeadRoutingEmail":"benkoerner@gmail.com", "BrokerName":"Realty Executives", "ListingTitle":"Single Family - Detached, Ranch - Scottsdale, AZ", "ListOfficeBrokerMlsId":"dl247", "ListOfficeEmail":"dpatricklewis@gmail.com", "ListOfficeAddress1":"2133 E Warner Rd", "ListOfficeAddress2":"Suite 105", "ListOfficeCity":"Tempe", "ListOfficePostalCode":"85284", "ListOfficeStateOrProvince":"AZ", "ListOfficeCountry":"US", "BuilderPhone":null, "BuilderFax":null, "BuilderEmail":null, "UnparsedAddress":null, "UnitNumber":null, "City":null, "StateOrProvince":null, "PostalCode":null, "Country":null, "ListBrokerageName":"Realty Executives", "ListBrokeragePhone":"(602) 957-0444", "ListBrokerageEmail":"RhondaPeters@RealtyExecsAZ.com", "ListBrokerageWebsiteUrl":"http://www.RealtyExecutivesPhoenix.com", "ListBrokerageLogoUrl":"http://brokerlogos.listhub.net/ARMLSAZ/c5ababc320fc835a0120fd2b8de3004e/20100526131334966.png", "ListBrokerageUnparsedAddress":"21040 N. Pima Road", "ListBrokerageUnitNumber":null, "ListBrokerageCity":"Scottsdale", "ListBrokerageStateOrProvince":"AZ", "ListBrokeragePostalCode":"85255", "ListBrokerageCountry":"US", "RoomCount":null, "GeocodeOptions":null, "MLSModificationTimestamp":"2024-05-25T11:08:09Z", "Taxes":[{"TaxYear":"2023", "TaxAnnualAmount":1751, "TaxDescription":null}]}
Listing Changed: 6/12/2024 2:32:54 PM GMT
Source Updated Date: 6/16/2024 6:49:51 AM GMT

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

Copyright © 2024 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.