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

4252 E MARLETTE AVENUE     ) MLS#: 4168441  
***COLLECTORS ESTATE. Perfect for her, even better for him. Park eighteen cars in multiple garages. Tennis anyone? Double gates, a circle drive and a portico suitable for a royal visit. In exclusive and gated Clearview. Lovingly created on this perfect Paradise Valley site, Camelback views fill the formal living rooms French arched windows. The kitchen is ready for a Martha Stewart episode. Viking, Asko, Dacor, dual dishwashers and three sinks. Twenty foot ceiling in family room. Masonry fireplaces. Each room is a retreat. Uniquely clad in ½-inch Quartz stone, this Luxury showplace has 23 SEER A/C units for cottage size power bills. The pool beckons. Two built-in BBQ's. If leased for a twelve month period, one-half of lease payments may be applied towards purchase price.
 
  More Pictures ...
Click on any picture to see it enlarged.
PRICE
More Options
Contact: Barry Zweig
Phone: 602-989-4663
Email: barry@azhousefinder.com
$5,900
 
ADDRESS
4252 E MARLETTE AVENUE
Paradise Valley, AZ 85253
 
HIGHLIGHTS
Year Built: 1989
Square Feet: 5,001+ Sq.Ft.
Bedrooms: 4
Bathrooms: 7
 
SCHOOL INFORMATION
School District: 048 - Scottsdale Unified District
High:
Middle: Ingleside
Elementary: Hopi
 
DETAILS
Features : 9+ Flat Ceilings, Wet Bar(s), Vaulted Ceiling(s), Skylight(s), Roller Shields, Central Vacuum  
Heating : Gas Heat  
Additional Bedroom : Master Bedroom Split, Separate Bdrm Exit, Othr Bdr Walkin Clst, Mstr Bdr Walkin Clst, Mstr Bdrm Sitting Rm  
Parking : Electric Door Opener, 8+ Car Garage, Separate Strge Area, Other (See Remarks)  
Utilities : SRP, SW Gas  
Roofing : All Tile  
Kitchen Features : Refrigerator, Pantry, Kitchen Island, Range/Oven, Microwave, Dishwasher, Compactor  
Water : City Water  
Fencing : Block  
Level : Two Levels  
Fireplace : 3+ Fireplace, Fireplace Master Bdr, Fireplace Living Rm, Fireplace Family Rm  
Pool - Private : Play Pool, Pool - Private  
Property Description : Cul-De-Sac Lot, Mountain View(s), Gated Community  
Energy Features : Ceiling Fan(s), Multi-Zones, Multi-Pane Wndws  
Other Rooms : Den/Office, Separate Workshop, Loft, Guest Qtrs-Sep Entrn, Family Room, Exercise/Sauna Room  
Builder Name : Custom  
Spa - Private : Spa - Private  
Exterior Features : Balcony/Deck(s), Built-in BBQ, Yrd Wtring Sys Front, Yrd Wtring Sys Back, Tennis Court(s), Storage Shed(s), Pvt Yrd(s)/Crtyrd(s), Private Street(s), Patio, Gazebo/Ramada, Childrens Play Area, Covered Patio(s), Circular Drive  
Dining Area : Breakfast Bar, Formal, Eat-in Kitchen, Dining in LR/GR, Dining in FR, Breakfast Room  
Master Bathroom : 2 Master Baths, Tubs with Jets, Separate Shwr & Tub, Full Bth Master Bdrm, Double Sinks, Bidet  
Sewer : Sewer - Public 
 
Back to search results

Listing Courtesy of: John Hall & Associates

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-21-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