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

2725 N 88TH STREET     ) MLS#: 4245773  
Distinctive with Details. 5056 Sq.ft. This BASEMENT and former MODEL HOME by Schuler is on 1/2+ acre lot in the prestigious NE Mesa gated community of Madrid. VIEWS: breathtaking Mountain and City Lights. The interior is sophisticated with a thoughtfully designed kitchen, lots of storage and work space. A gourmets delight. LUXURIOUS MASTER SUITE comes with a jetted tub, snail shower accented with natural stone, a large walkin closet. Separate MBR entry to back patio and pool.FINISHED basement offers: multimedia area; kitchenette w/wet-bar; office-library w/ built-in cabinets; game room area; bedroom and full bath. Private pool with a cascading boulder waterfall. Entry has a private gated courtyard w/water feature. This fabulous home has it all. Great schools and neighborhood.
 
  More Pictures ...
Click on any picture to see it enlarged.
PRICE
More Options
$930,000
 
ADDRESS
2725 N 88TH STREET
Mesa, AZ 85207
 
HIGHLIGHTS
Style: Santa Barbara/Tuscan
Year Built: 2001
Square Feet: 5,001+ Sq.Ft.
Bedrooms: 5
Bathrooms: 4
 
SCHOOL INFORMATION
School District: 004 - Mesa Unified District
High: Red Mountain
Middle: Fremont
Elementary: Zaharis
 
DETAILS
Subdivision : Madrid Community  
Planned Comm Name : Madrid Community  
Marketing Name : Madrid  
Architecture : Santa Barbara/Tuscan  
Property Description : Cul-De-Sac Lot, Mountain View(s), Gated Community, Desert Front, City Light View(s)  
Master Bathroom : Double Sinks, Tubs with Jets, Separate Shwr & Tub, Full Bth Master Bdrm  
Dining Area : Breakfast Bar, Formal, Eat-in Kitchen, Breakfast Room  
Kitchen Features : Disposal, Pantry, Kitchen Island, Range/Oven, Refrigerator, Microwave, Dishwasher  
Exterior Features : Covered Patio(s), Built-in BBQ, Yrd Wtring Sys Front, Yrd Wtring Sys Back, Pvt Yrd(s)/Crtyrd(s), Private Street(s), Patio, Childrens Play Area  
Complex Features : Gated Community, Children's Playgrnd  
Cooling : Refrigeration  
Features : 9+ Flat Ceilings, Water Softener Owned, Wet Bar(s), Drink Wtr Filter Sys, Central Vacuum  
Level : Two Levels  
Lot Size : 24, 001 - 35, 000  
Ownership : Fee Simple  
Fencing : Block, View/Wrought Iron  
Parking : 3 Car Garage, Extnded Lngth Garage, Electric Door Opener, Attch'd Gar Cabinets  
Builder Name : Schuler  
Model : Cantabria w/basement  
Spa : None  
Additional Bedroom : Master Bdrm Split, Separate Bdrm Exit, Othr Bdr Walkin Clst, Other Bdrm Dwnstrs, Mstr Bdr Walkin Clst  
Energy Features : Ceiling Fan(s), Sunscreen(s), Multi-Zones, Multi-Pane Wndws  
Sewer : Sewer - Public  
Pool - Private : Fenced Pool, Pool - Private  
Water : City Water  
Tax Year : 2008  
Taxes : 3546  
Roofing : All Tile  
Fireplace : 1 Fireplace, Gas Fireplace, Fireplace Family Rm  
Other Rooms : Basement, Media Room, Library-Blt-in Bkcse, Great Room, Family Room, Den/Office, Bonus/Game Room  
Utilities : Oth Gas (See Rmrks), SRP  
Heating : Electric Heat 
 
Back to search results

Listing Courtesy of: DPR Realty, LLC

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