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

2518 E EMERALD AVENUE     ) MLS#: 4143415  
NOT A SHORT SALE OR A FORCLOSURE I have never seen a property like this one. 1.1 acre irrigated lot with a 4000 sq ft work shop with 3 giant bays. Features include wood floors, large tile floors, plantation shutters, granite counters, large loft set up as a theater, recessed lighting, new cabinets, exersize room of the master, circle drive with rv gate balcony, under ground trampoline and lots of grass in the front and back yards. The giant barn could hold at well over 10 cars. It has a bathroom and an office with ac and there is a 100 gallon propane storage tank for the pool heater and truck supply. Store your collector cars or run your trucking business from home. I have never seen anything like this!!
 
  More Pictures ...
Click on any picture to see it enlarged.
PRICE
More Options
$549,000
 
ADDRESS
2518 E EMERALD AVENUE
Mesa, AZ 85204
 
HIGHLIGHTS
Style: Santa Barbara/Tuscan
Year Built: 1993
Square Feet: 3,001 - 3,500 Sq.Ft.
Bedrooms: 5
Bathrooms: 3
 
SCHOOL INFORMATION
School District: 004 - Mesa Unified District
High: Mesa
Middle: Taylor
Elementary: Robson
 
DETAILS
Subdivision : Southern Estates  
Planned Comm Name : SOUTHERN ESTATES  
Marketing Name : SOUTHERN ESTATES  
Architecture : Santa Barbara/Tuscan  
Property Description : North/South Exposure  
Master Bathroom : Double Sinks, Tubs with Jets, Separate Shwr & Tub, Full Bth Master Bdrm  
Dining Area : Eat-in Kitchen, Formal  
Kitchen Features : Disposal, Pantry, Range/Oven, Refrigerator, Microwave, Dishwasher  
Exterior Features : Balcony/Deck(s), Patio, Covered Patio(s)  
Cooling : Refrigeration  
Features : 9+ Flat Ceilings, Vaulted Ceiling(s)  
Level : Two Levels  
Lot Size : 1 - 1.9 Acres  
Ownership : Fee Simple  
Fencing : Block  
Parking : Electric Door Opener, 8+ Car Garage, Separate Strge Area, Rear Vehicle Entry, Over Height Garage, Extnded Lngth Garage  
Builder Name : CUSTOM  
Model : remodeled  
Spa : Spa - Heated, Spa - Private  
Additional Bedroom : Master Bdrm Dwnstrs, Separate Bdrm Exit, Othr Bdr Walkin Clst, Mstr Bdr Walkin Clst, Mstr Bdrm Sitting Rm, Master Bdrm Split  
Energy Features : Ceiling Fan(s), Multi-Zones, Multi-Pane Wndws  
Sewer : Sewer - Public  
Pool - Private : Fenced Pool, Pool - Private, Heated Pool  
Water : City Water, Irrigation  
Tax Year : 2008  
Taxes : 2540  
Roofing : All Tile, Concrete  
RV Parking : RV Gate, RV Parking, Other (See Remarks)  
Fireplace : 1 Fireplace, Fireplace Living Rm  
Other Rooms : Bonus/Game Room, Separate Workshop, Great Room, Family Room, Exercise/Sauna Room, Den/Office  
Utilities : SRP  
Heating : Electric Heat 
 
Back to search results

Listing Courtesy of: RE/MAX Fine Properties

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