Search the MLS Search for a Rental Leasing your property Selling your real estate

MLS Rental Search Form

Tell Us Your Rental Needs

Rental Application

Local Resources

Turn on Utilities

Helpful Real Estate Links

Ready to Find a Tenant

About Our Services

Contact Us | Email Us

FAQ

Welcome to 
Scottsdale, AZ

Click for Scottsdale, Arizona Forecast

Meet Barry Zweig

Testimonials

Email:

Metro Phoenix Map - PDF

Home mortgage center Mortgage Center
A variety of payment calculators to help Calculate Mortgage

Your home's value Your Home's Value
A comparative market analysis to find out
Your Home's Value

MLS Rental Search Form

 

  Save Your Searches & Properties!   Sign Me Up  |  Existing Member Login
New User Registration: Become a member today! Save your searches and properties to view later. It's a FREE service!
* Name: 
* eMail: 
* Choose Password: 
Existing Members: Login to access and edit your saved searches and properties!
* eMail: 
* Password: 
[Forgot Your Password?
New Search > Modify Search > Search Results > Property Details

15308 E HIDDEN SPRINGS TRAIL     ) MLS#: 3023885  
PALAZZINO...'A SPLENDID RESIDENCE' IS THE PERFECT DESCRIPTION FOR THIS MASTER-CRAFTED TUSCAN 5 BEDROOM, 5.5 BATH+DEN,FIREROCK COUNTRY CLUB ESTATE.GO TO PHOTO'S SELECT VIRTUAL TOUR FOR WEBSITE. THIS LAKE FRONT MASTERPIECE WAS DESIGNED FOR QUIET INTERIOR & EXTERIOR LIVING, OVERLOOKING FROM THE NEGATIVE EDGE POOL/SPA IS THE 7TH TEE,LAKE, MOUNTAIN & CITY LIGHT VIEWS. BUILT FOR THE FUTURE ENERGY ''SMART HOME TECHNOLOGY BUYER' 5-ZONED HVAC, NUVO,CENTRALITE, ASKO, SUB ZERO, WOLF & PLUMBED MIELE COFFEE STATION. 120''THEATER SCREEN,SURROUND SOUND & STATE-OF-THE-ART SECURITY. Prime lot NO Shea view or traffic noise.Sports membership w/apvd offer @ coe. Utilize the technology sheet for comparison.
 
  More Pictures ...
Click on any picture to see it enlarged.
PRICE
More Options
$2,900,000
 
ADDRESS
15308 E HIDDEN SPRINGS TRAIL
Fountain Hills, AZ 85268
 
HIGHLIGHTS
Style: Santa Barbara/Tuscan
Year Built: 2007
Square Feet: 5,001+ Sq.Ft.
Bedrooms: 5
Bathrooms: 6
 
SCHOOL INFORMATION
School District: 098 - Fountain Hills Unified District
High: Fountain Hills
Middle: Fountain Hills
Elementary: Fountain Hills
 
DETAILS
Subdivision : FIREROCK  
Planned Comm Name : FIREROCK COUNTRY CLUB  
Marketing Name : FIREROCK  
Architecture : Santa Barbara/Tuscan  
Property Description : Cul-De-Sac Lot, Waterfront Lot, North/South Exposure, Guarded Entry, Golf Course Subd, Gated Community, Desert Front  
Master Bathroom : Double Sinks, Tubs with Jets, Separate Shwr & Tub, Other (See Remarks), Full Bth Master Bdrm  
Dining Area : Breakfast Bar, Formal, Breakfast Room  
Kitchen Features : Disposal, Pantry, Other (See Remarks), Kitchen Island, Range/Oven, Refrigerator, Microwave, Dishwasher  
Exterior Features : Balcony/Deck(s), Yrd Wtring Sys Front, Yrd Wtring Sys Back, Pvt Yrd(s)/Crtyrd(s), Private Street(s), Covered Patio(s)  
Complex Features : Gated Community, On-Site Guard  
Cooling : Refrigeration  
Features : 9+ Flat Ceilings, Water Softener Owned, Wet Bar(s), Fire Sprinklers, Elevator, Drink Wtr Filter Sys, Central Vacuum  
Level : Two Levels  
Lot Size : 1 - 1.9 Acres  
Ownership : Fee Simple  
Fencing : View/Wrought Iron  
Parking : 4 Car Garage, Tandem Garage, Other (See Remarks), Over Height Garage, Extnded Lngth Garage, Electric Door Opener  
Builder Name : UNKNOWN  
Model : CUSTOM  
Spa : Spa - Heated, Spa - Private  
Additional Bedroom : Master Bdrm Dwnstrs, Separate Bdrm Exit, Othr Bdr Walkin Clst, Other Bdrm Split, Other Bdrm Dwnstrs, Mstr Bdr Walkin Clst, Master Bdrm Upstairs, Mstr Bdrm Sitting Rm, Master Bdrm Split  
Energy Features : Ceiling Fan(s), Multi-Zones, Multi-Pane Wndws  
Sewer : Sewer - Public, Sewer in & Cnctd  
Pool - Private : Heated Pool, Pool - Private, Play Pool  
Water : Pvt Water Company  
Tax Year : 2007  
Taxes : 2359  
Roofing : Foam, Partial Tile  
Fireplace : 3+ Fireplace, Two Way Fireplace, Gas Fireplace, Fireplace Master Bdr, Fireplace Living Rm, Fireplace Family Rm, Firepit  
Other Rooms : Bonus/Game Room, Media Room, Great Room, Guest Qtrs-Sep Entrn, Den/Office  
Utilities : SRP, SW Gas  
Heating : Electric Heat 
 
Back to search results

Listing Courtesy of: MCO Realty

Information Deemed Reliable But Not Guaranteed.

The Fair Housing Act prohibits discrimination in housing based on color, race, religion, national origin, sex, familial status, or disability.

Copyright © 2009 (ARMLS) Arizona Regional Multiple Listing Service, Inc.

Listing Information Current As Of 11-24-2009


Powered By : Killer IDXTM
Success Web Systems, Inc. © 2009 All rights reserved.
 

Phoenix Real Estate Broker
Home | Featured Listings | Buy | Rent | Sell | Lease | FAQs | Our Services | Contacts
Local Resources | Rental Request Form | Rental Application | Sample Listings
© 2006-2008 Barry Zweig AZHouseFinder.com 
emailEmail Us     Call Barry (602) 989-4663 or Susan (480) 204-2599