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

4040 E MCLELLAN ROAD Unit 16     ) MLS#: 4277904  
Beautiful brick estate situated in Los Estados. Graceful arches,stately columns & coffered ceilings can be found throughout. Formal living and dining rooms,gorgeous hardwood flooring gracefully carries you into the family room. Gourmet kitchen with stainless appliances, granite countertops, center-island, breakfast bar,and eating area flows into the family room with a floor to ceiling brick fireplace and an incredible wall of windows with views of the rear grounds. Handsome office with built-in cabinetry and showcase. Elegant master suite w/sitting area, separate exit & luxurious bath w/soaking tub, separate shower, and dual sinks. Basement w/bedroom & bonus room/game room. Fenced Pebble tec pool & spa, flagstone patio & walkways. 2-car attached garage + 2 car detached garage w/shop.
 
  More Pictures ...
Click on any picture to see it enlarged.
PRICE
More Options
$600,000
 
ADDRESS
4040 E MCLELLAN ROAD
Unit 16
Mesa, AZ 85205
 
HIGHLIGHTS
Year Built: 1999
Square Feet: 4,001 - 4,500 Sq.Ft.
Bedrooms: 4
Bathrooms: 4
 
SCHOOL INFORMATION
School District: 004 - Mesa Unified District
High: Mountain View
Middle: Stapley
Elementary: Bush
 
DETAILS
Subdivision : LOS ESTADOS  
Property Description : Gated Community  
Master Bathroom : Bidet, Tubs with Jets, Separate Shwr & Tub, Full Bth Master Bdrm, Double Sinks  
Dining Area : Breakfast Bar, Formal, Eat-in Kitchen, Breakfast Room  
Kitchen Features : Compactor, Pantry, Kitchen Island, Range/Oven, Refrigerator, Microwave, Dishwasher, Disposal  
Exterior Features : Covered Patio(s), Yrd Wtring Sys Front, Yrd Wtring Sys Back, Tennis Court(s), Sport Court(s), Private Street(s)  
Cooling : Refrigeration  
Features : Central Vacuum, Water Softener Owned, Intercom, Drink Wtr Filter Sys  
Level : Two Levels  
Lot Size : 24, 001 - 35, 000  
Ownership : Fee Simple  
Fencing : Block  
Parking : 4 Car Garage, Side Vehicle Entry, Electric Door Opener  
Builder Name : CUSTOM  
Spa : Spa - Private  
Additional Bedroom : Master Bdrm Split, Separate Bdrm Exit, Othr Bdr Walkin Clst, Other Bdrm Split, Mstr Bdr Walkin Clst  
Energy Features : Multi-Pane Wndws, Sunscreen(s), Multi-Zones  
Sewer : Sewer - Public  
Pool - Private : Fenced Pool, Pool - Private  
Water : City Water  
Tax Year : 2008  
Taxes : 4653  
Roofing : All Tile  
RV Parking : RV Parking  
Fireplace : 1 Fireplace, Gas Fireplace, Fireplace Family Rm  
Other Rooms : Basement, Family Room, Bonus/Game Room  
Utilities : SRP  
Heating : Gas Heat 
 
Back to search results

Listing Courtesy of: Russ Lyon Sotheby's International 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-23-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