x
Showing 1 of 0
X
Save

28216 N 148th Street
Scottsdale AZ 85262 US

$930,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

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

Active Listing ID 6786512
Save

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.

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: 930000
  • 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-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":"2024-11-21T00:46:45Z", "Neighborhoods":[], "PostalCode":null, "RoomCount":null, "StateOrProvince":null, "Taxes":[{"TaxAnnualAmount":1751, "TaxDescription":null, "TaxYear":"2023"}], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 11/21/2024 5:10:10 PM GMT
Source Updated Date: 12/26/2024 6:52:58 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.