siteInfoProfileImage
 
CEDRIC THE REALTOR . COM
Cedric  "Joe" Kolstad  ABR, GRI
phone: 480-678-0123

fax: 480-816-5831
cedric.kolstad@pruaz.com  
 
E-mail:


Need an account?
Enter your search criteria with your
information at the bottom of this
form box to create a new account.

Search the MLS

Select a County:
Then select city or cities:
Property type:
Name:*

Email:*

Phone:*

Receive new listing e-mail
alerts on this search?
Want more options?
Try an Advanced Search
 
         
37163 N 102nd Street, Scottsdale, AZ 85262  
MLS ID: 4005591
Listed for $899,000


This home is exquisite in every possible way, from the pavered drive and entry via expansive courtyard with separate casita, Koi pond and water feature to the walls of windows showcasing views of Pinnacle Peak, desert vistas and city lights. Travertine, slab granite counters, cherry wood cabinetry, Chef's dream kitchen w/every desired appointment. This home is ideal for elegant entertaining as well as for the active Executive family lifestyle. On nearly one acre, this premium lot affords the most privacy, space and views...plus a negative edge pool, spa, built-in BBQ, fireplace and more! Original owners, pride of owner throughout.
 
Home Details
Bedrooms: 5 Type: Single Family Home
Square Feet: 4,001 - 4,500 Year Built: 2002
County: Maricopa
 
Property Details
Lot Size: 1.00 acres Pool: Yes
 
School Details
Elementary: Black Mountain Middle: Desert Arroyo
High: Cactus Shadows
 



Additional Features Include:
Kitchen Features: disposal, pantry, kitchen island, range/oven, refrigerator, microwave, dishwasher Exterior Features: covered patio(s), yrd wtring sys front, yrd wtring sys back, separate guest house, pvt yrd(s)/crtyrd(s), private street(s), patio
Master Bedroom Width: 15 Cooling: refrigeration
Horses: n Dining Room Width: 12
Association & Fees: Cap Imprv/impact Fee: 0.00 Association & Fees: Land Lease Fee: 0.0
New Financing: cash, conventional Bedroom 4 Width: 12
Tax Municipality: scottsdale Source Of Sqft: county assessor
Family Room Width: 20 Level: single level
Association & Fees: Pad Fee: 0.0 Laundry: dryer included, washer included, inside laundry
Fencing: block, view/wrought iron Architecture: santa barbara/tuscan
Subdivision: cresta norte Builder Name: toll
Marketing Name: cresta norte Spa: spa - heated, spa - private
Energy Features: ceiling fan(s), multi-zones, multi-pane wndws Den/other Room Length: 22
Bedroom 3 Length: 16 Bedroom 2 Width: 16
Other Rooms: bonus/game room, guest qtrs-sep entrn, family room Utilities: aps, sw gas, city electric
Property Description: adjacent to wash, north/south exposure, mountain view(s), gated community, desert front, desert back, city light view(s) Unbranded Virtual Tour: http://rtvpix.com/rst/re-5685-8eoxqd-01
Bedroom 2 Length: 16 Den/other Room Width: 13
Special Listing Cond: short sale aprvl req Complex Feature: gated community, tennis court(s)
Bedroom 3 Width: 12 Dining Room Length: 21
Year Built: 2002 Features: central vacuum, water softener owned, wet bar(s), soft water loop, no interior steps, intercom, fire sprinklers, drink wtr filter sys
Kitchen Width: 17 Bedroom 5 Length: 16
Family Room Length: 21 Bedroom 5 Width: 13
Bedroom 4 Length: 12 Legal Info: Lot Number: 79
Parking: 3 car garage Master Bathroom: double sinks, separate shwr & tub, full bth master bdrm
Dining Area: breakfast bar, eat-in kitchen, dining in fr, breakfast room Additional Bedroom: master bdrm split, separate bdrm exit, other bdrm split, mstr bdr walkin clst, mstr bdrm sitting rm
Map Code/grid: f38 Living Room Width: 15
Sewer: sewer - public Jr. High School: desert arroyo
Kitchen Length: 21 Pool - Private: heated pool, pool - private, lap pool
Elementary School: black mountain Water: city water
Living Room Length: 16 Listing Id: 4005591
Planned Comm Name: cresta Roofing: all tile
High School: cactus shadows Fireplace: 2 fireplace, gas fireplace, fireplace living rm, exterior fireplace
Heating: gas heat Master Bedroom Length: 19
Zip4: 3125 Model: cadiz
County Code: maricopa

©Copyright 2009 Arizona Regional Multiple Listing Service, Inc. All rights reserved. Information Deemed Reliable but Not Guaranteed. This information is being provided by ARMLS (Arizona Regional Multiple Listing Service, Inc.)(Broker of Record for this listing is Prudential Arizona Properties). The listings presented here may or may not be listed by this web site's agent. This information is intended for the personal use of consumers. Data last updated on 2009-01-07 05:10:53

 
  ©An independently owned and operated member of the Prudential Real Estate Affiliates, Inc. Prudential is a service mark of the Prudential Insurance Company of America. Equal Housing Opportunity.

Privacy Policy  |  Contact Us  |  Realtor® Login