American Realty Brokers-Phoenix, Arizona Real EstateAmerican Realty Brokers-Phoenix, Arizona Real EstateAmerican Realty Brokers-Phoenix, Arizona Real Estate
American Realty Brokers-Phoenix, About UsAmerican Realty Brokers-Phoenix,  Real Estate AgentsAmerican Realty Brokers-Phoenix, Buying Arizona Real EstateAmerican Realty Brokers-Phoenix, Search Arizona Real EstateAmerican Realty Brokers-Phoenix,Selling Arizona Real EstateAmerican Realty Brokers-Phoenix, Investing in Arizona Real EstateAmerican Realty Brokers-Phoenix, Relocating to Arizona Real EstateAmerican Realty Brokers-Phoenix, Arizona Real Estate ResourcesContact American Realty Brokers-Phoenix, Arizona Real Estate
   
American Realty Brokers-Phoenix, Search for Phoenix Real Estate

Receive up-to-date information on our client-tailored services


 
 
 
American Realty Brokers-Phoenix, Arizona Real Estate
  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

731 W RED FERN ROAD     ) MLS#: 4200277  
Estate style property-2 homes-Horse set up-Workshop-main home plus complete guest house-A BEST FEATURE-HUGE double gourmet kitchen perfect for parties-See list for all the bells and whistles on this great french country style home-A BEST FEATURE complete horse set up with irrigated pasture-80 x 80 barn with wild west tack room-carport-shavings bin and room for 8 stalls-professional-easy care-landscaping-over 40 good size trees-A BEST FEATURE-1500 ft workshop has roll up doors-air system-evap-220-full bath and much more-RV Parking-2 RV hookups-Bring your toothbrush all the work is done here
 
  More Pictures ...
Click on any picture to see it enlarged.
PRICE
More Options
$1,099,000
 
ADDRESS
731 W RED FERN ROAD
Queen Creek, AZ 85240
 
HIGHLIGHTS
Style: Other (See Remarks),Santa Barbara/Tuscan
Year Built: 2004
Square Feet: 4,001 - 4,500 Sq.Ft.
Bedrooms: 5
Bathrooms: 5
 
SCHOOL INFORMATION
School District: 095 - Queen Creek Unified District
High: Queen Creek
Middle: Other
Elementary: Other
 
DETAILS
Subdivision : Sun Valley Farms Unit IV  
Architecture : Other (See Remarks), Santa Barbara/Tuscan  
Property Description : City Light View(s), Street(s) Not Paved, North/South Exposure, Mountain View(s)  
Master Bathroom : 2 Master Baths, Tubs with Jets, Separate Shwr & Tub, Other (See Remarks), Full Bth Master Bdrm, Double Sinks  
Dining Area : Breakfast Bar, Formal  
Kitchen Features : Compactor, Pantry, Other (See Remarks), Kitchen Island, Range/Oven, Dishwasher  
Exterior Features : Circular Drive, Yrd Wtring Sys Front, Yrd Wtring Sys Back, Storage Shed(s), Screened in Patio(s), Separate Guest House, Private Street(s), Patio, Other (See Remarks), Misting System, Covered Patio(s)  
Cooling : Other (See Remarks), Refrigeration  
Features : 9+ Flat Ceilings, Water Softener Owned, Soft Water Loop, Skylight(s), No Interior Steps, Drink Wtr Filter Sys  
Level : Single Level  
Horses : Arena, Tack Room, Stall, Other (See Remarks), Corral, B  
Lot Size : 2 - 4.9 Acres  
Ownership : Fee Simple  
Fencing : Chain Link, Wire (See Remarks), Wood, View/Wrought Iron, Other (See Remarks)  
Parking : Detached, 3+ Car Carport, 7 Car Garage, Side Vehicle Entry, Separate Strge Area, Slab, Rear Vehicle Entry, Other (See Remarks), Extnded Lngth Garage, Electric Door Opener  
Builder Name : Stalwart Properties  
Model : Custom  
Spa : None  
Additional Bedroom : 2 Master Bdrms, Separate Bdrm Exit, Othr Bdr Walkin Clst, Other Bdrm Split, Mstr Bdr Walkin Clst, Master Bdrm Split  
Energy Features : Ceiling Fan(s), Multi-Zones, Multi-Pane Wndws  
Sewer : Other (See Remarks), Septic in & Cnctd, Septic  
Pool - Private : No Pool  
Water : Well - Shared  
Tax Year : 2008  
Taxes : 7445  
Roofing : All Tile  
RV Parking : RV Gate, RV Parking, Other (See Remarks)  
Fireplace : No Fireplace  
Other Rooms : Family Room, Separate Workshop, Great Room  
Utilities : Other (See Remarks), SRP  
Heating : Electric Heat, Other (See Remarks) 
 
Back to search results

Listing Courtesy of: Go 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-22-2009


Powered By : Killer IDXTM
Success Web Systems, Inc. © 2009 All rights reserved.
 
 
   
       
 

PRIVACY  |  TERMS OF USE  |  SITEMAP     

ABOUT US   |   AGENTS   |   BUYING   |   HOME SEARCH   |   SELLING   |   RELOCATING   |   INVESTING   |   RESOURCES   |   CONTACT  |   HOME

Contact Us Today!    602.955.6606

Serving: Greater Phoenix, Scottsdale, Ahwatukee, Anthem, Avondale, Carefree, Cave Creek, Chandler,
Fountain Hills, Gilbert, Glendale, Goodyear, Mesa, Paradise Valley, Peoria, Rio Verde, Sun City, Sun Lakes, Surprise, Tempe

 American Realty Brokers ® 2005, All Rights Reserved, 4001 N. 32nd Street, Phoenix, AZ  85018

Agent Login