ERA Logo My ERA.com | Find an Office | Find a Sales Associate | Find a Relocation Specialist | Español.era.com
5 miles from zip code 85242
Search Criteria Arrow Search Results Arrow Search for Other Houses in this County

Showing 1 - 5 of 136 homes
Previous | Next
Address
Beds Baths
Full  Half
Graphic Price Sq.Ft.
0 W Rhea Rd Queen Creek, AZ 85242 0 00 $4,000,000 1742400
Photo
View Details
This property features:
Photo Gallery
Description: Secluded Desert Oasis with rolling topography and un-obstructed views. Backs to San Tan Park. Final plat submitted to county for a mstr planned community of 28 custom lots at 1.25 ac. The property is surrounded by multiple custom home subdivision developments. Area is exploding w/commercial/residential growth. New San Tan High School half mile. A wide variety of restaurants, plazas, shopping and golf w/in 3 miles. Utilities are w/in 600 to 1300 ft of property line.

Compare - NoAdd to Compare
Save in \CompareApply for Mortgage
19633 E Ocotillo Rd Queen Creek, AZ 85242 4 25 $2,200,000 3579
Photo
View Details
This property features:
Virtual TourPhoto Gallery
Description: Beautiful custom home on 6 immaculately maintained acres. This home shows perfectly from the time you pull up to the front gates. A graceful drive brings you to a lovely fountain at the front of the crisp landscaping. Enter the home w/high expectations, the 12 ft ceilings give the house a sense of grandure. Once you're fully in love w/the house venture out to the lush backyard w/the perfect play pool. Next, go out to the 'kids' area complete w/an air conditioned play house, swing set, sand box & kids gazebo-WOW! Now its time to go see the guest house, its completely self contained w/everything your guest needs at there finger tips. Awesome barn. To much to tell.

Compare - NoAdd to Compare
Save in \CompareApply for Mortgage
2237 E PLUM Court Gilbert, AZ 85298 5 41 $1,360,000 4350
Photo
View Details
This property features:
Virtual TourPhoto Gallery
Description: SPECTACULAR NEW HOME W/FINE DETAILS. OPEN PLAN WITH 5 BDRM PLUS BONUS/GAME ROOM, OFFICE, COMPUTER/CRAFT ROOM, LARGE AC COOLED STORAGE ROOM & 5 BATHROOMS. TRAVERTINE STONE FLOORS & BATH ENCLOSURES, GOTHIC CATHEDRAL CEILING IN LR,BARREL ARCHES,7.1 SURROUND SOUND,PREMIUM CARPETS T/O, CANTERRA STONE FIREPLACE, BOLD & BEAUTIFUL GRANITE ON ALL SURFACES, TOP SHELF CABINETRY IN DEEP AND RICH TONES W/SELF CLOSING DRAWERS,SUPERB CHANDELIERS & LIGHT FIXTURES, CHILDREN'S MUD LOCKERS,DOUBLE DISHWASHERS IN GOURMET KITCHEN. MEDITERRANEAN POOL W/SOOTHING WATERFALL SET AGAINST THE BACKDROP OF THE SAN TAN MOUNTAINS, SIDE ENTRY GARAGE,CITRUS TREES. A SPACIOUS AND SUPERB HOME.

Compare - NoAdd to Compare
Save in \CompareApply for Mortgage
35648 N ELLSWORTH Road Queen Creek, AZ 85242 0 00 $1,300,000 145490
Photo
View Details
This property features:
Photo Gallery
Description: THIS IS A VERY VERY BUSY INTERSECTION; COMMERCIAL POTENTIAL! YOU WANT EXPOSURE...YOU HAVE IT HERE!

Compare - NoAdd to Compare
Save in \CompareApply for Mortgage
2766 E Haymore Ct Gilbert, AZ 85298 5 31 $995,000 4500
Photo
View Details
This property features:
Virtual TourPhoto Gallery
Description: Stunning custom built home in highly desireable Greenfield Acres, located near Seville Country Club w/memberships available. This home features a dream gourmet kitchen w/cherry cabinets,granite countertops,breakfast bar,high end appliances,dining area & open to family room w/fireplace; formal dining room; travertine throughout & upgraded carpet; plantation shutters; cofferred ceilings;custom lighting, split floor plan w/amazing master suite;& Jack & Jill bath for br #4 & 5. Outside is an entertainers dream w/huge covered patios, lush landscaping, heated pebble tec diving pool & spa. 3 car garage, rv gate & parking; horse privileges & so much more. A 10+ HOME-MUST SEE

Compare - NoAdd to Compare
Save in \CompareApply for Mortgage
Change Search Criteria Local Office Websites

Previous | Next

Area Map



Loading Map...
Map Legend:
Home Resort Property
Land Commercial Property
ERA Office   International Collection Property

Adjust Your Search
Price Range:
Minimum Bedrooms:
Minimum Bathrooms:


RSS Feeds
These search results are available as an RSS feed.
Subscribe | More Info

My ERA.com - Save this search
Name your search:
My ERA.com
My ERA.comLogo
Manage your home buying or selling process here!

Join My ERA now

Already a member? Login now!
User Name/email address:
Password:
 
Forgot your password?
ERA® Mortgage
Path to Homeownership

ERA Mortgage Logo

Making home loans easy in 4 simple steps.

Go

Equal Housing Opportunity ©2008 ERA Franchise Systems LLC. All Right Reserved. ERA® and Always There For You® are registered trademarks licensed to ERA Franchise Systems LLC.
An Equal Opportunity Company. Equal Housing Opportunity. Each Office is Independently Owned and Operated.
View our Privacy Policy and Terms and Conditions.