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

5050 E RED ROCK DRIVE     ) MLS#: 4000806  
REDUCED $900,000. A TRUE VALLEY LANDMARK!! THIS AUTHENTIC MEDIEVAL MASTERPIECE HAS AREPUTATION AS ONE OF THE MOST UNIQUE HOMES IN THE WORLD. THE CASTLESITS ON ONE OF THE HIGHEST LOTS ON CAMELBACK MOUNTAIN OFFERINGUNPARALLELED CITY VIEWS. A SEPARATE PAD EXISTS IDEALLY SUITED FOR APOOL HOUSE AND NEGATIVE EDGE POOL. AN APPROXIMATE 700 SQ/FT DUNGEONWILL MAKE THE PERFECT OVERSIZED WINE ROOM/BAR OR IN HOME THEATER.SEPARATE GUEST QUARTERS AND GATED PRIVATE DRIVE. ***THE PROPERTY IS PRICED TO REFLECT THE NEED FOR SIGNIFICANT UPDATING TO BEDROOMS/BATHS, KITCHEN NEEDS TO BE ADDED; POSSIBILITY OF INCREASING THE LIVABLE SQUARE FOOTAGE
 
  More Pictures ...
Click on any picture to see it enlarged.
PRICE
More Options
$3,500,000
 
ADDRESS
5050 E RED ROCK DRIVE
Phoenix, AZ 85018
 
HIGHLIGHTS
Year Built: 1977
Square Feet: 5,001+ Sq.Ft.
Bedrooms: 5
Bathrooms: 8
 
SCHOOL INFORMATION
School District: 048 - Scottsdale Unified District
High: Arcadia
Middle: Ingleside
Elementary: Hopi
 
DETAILS
Subdivision : RED ROCK NORTH  
Marketing Name : THE CASTLE  
Property Description : Border Pres/Pub Lnd, North/South Exposure, Mountain View(s), Hillside Lot, Desert Front, Desert Back, City Light View(s)  
Master Bathroom : 3/4 Bath Master Bdrm  
Dining Area : Dining in FR, Formal  
Kitchen Features : Compactor, Pantry, Kitchen Island, Refrigerator, Dishwasher, Disposal  
Exterior Features : Balcony/Deck(s), Separate Guest House, Patio, Covered Patio(s)  
Cooling : Refrigeration  
Features : Skylight(s)  
Level : Two Levels  
Lot Size : 1 - 1.9 Acres  
Ownership : Fee Simple  
Fencing : Other (See Remarks)  
Parking : 2 Car Carport, 2 Car Garage  
Builder Name : CUSTOM  
Model : 30' STONE  
Spa : None  
Additional Bedroom : 2 Master Bdrms, Separate Bdrm Exit, Mstr Bdr Walkin Clst, Master Bdrm Upstairs, Mstr Bdrm Sitting Rm, Master Bdrm Split, Master Bdrm Dwnstrs  
Energy Features : Ceiling Fan(s), Multi-Zones  
Sewer : Septic in & Cnctd  
Pool - Private : No Pool  
Water : City Water  
Tax Year : 2007  
Taxes : 3990  
Roofing : Foam  
Fireplace : 3+ Fireplace, Fireplace Master Bdr, Fireplace Living Rm, Fireplace Family Rm  
Other Rooms : Basement, Library-Blt-in Bkcse, Great Room, Guest Qtrs-Sep Entrn, Exercise/Sauna Room, Bonus/Game Room  
Utilities : SRP  
Heating : Electric Heat 
 
Back to search results

Listing Courtesy of: RE/MAX Excalibur 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