Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3422 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3422 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3422 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

3075 E Agritopia Loop N
Gilbert, AZ 85296

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,400,000
Beds: 7
Baths: 4
Status: Pending
SqFt: 4688
Agency: American Allstar Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2007
Notes: Where do you start with this incredible house?! *RenoTight Design designed and fully remodeled the entire kitchen, the stunning primary bathroom, and the huge expanded custom closet* There's a brand new private pool & outdoor entertaining space* AND it's in one of the most desirable neighborhoods in AZ* BONUS -the sellers will credit $10,000 towards an interest rate buy down!*<br /> <br /> Welcome to Agritopia, one of the most sought out communities in Gilbert due to the picturesque tree lined streets and colorful homes, the community amenities, and the walkability to incredible dining and shopping at Epicenter, and Barnone. Grab a coffee from The Coffee Shop, and enjoy your morning as you sit on the huge front porch. When you walk in you have a dining room and sitting area on either side then into the open kitchen and family room area. The kitchen is stunning! it has been reconfigured adding an island with quartz countertops, brand new cabinets, backsplash, double ovens, a drawer microwave, and flooring throughout. Off the family room is the primary bedroom with a bathroom and custom closet that was completely remodeled adding an additional 100 sqft to it! Upstairs you have 3 bedrooms, a loft, and full bathroom that has been updated. The basement has a remodeled kitchen with microwave, refrigerator, dishwasher, and sink, right off a huge open area that is amazing for entertaining. Throw the game on the projector and enjoy! There are an additional three bedrooms and a full bathroom downstairs, and a beautifully redone laundry room. Head outside where they just completed a full scale backyard remodel with a brand new pool, fireplace, and turf all throughout for easy maintenance. Enjoy doing cannonballs in the pool during the summer and the ambiance of a fire during the cooler months. Agritopia has a community pool, 5 playgrounds, 2 basketball and volleyball courts, a tennis court that is lined for 4 pickle ball courts, a fitness center, and a clubhouse you can use for parties or meetings. You are in walking distance to all of the shops at Barnone like Fire & Brimstone, The Farm Store, & Garage East, the two restaurants that have been on Food Network-The Coffee Shop and Joe's Farm Grill, then you have Epicenter with Buck & Rider, Peixoto Coffe, Spinatos, and more!!
MlsNumber: 6638895


Listing Provided By: American Allstar Realty, original listing
Name: American Allstar Realty
Phone: (480) 751-5300
Office Name: American Allstar Realty
Office Phone: (480) 751-5300
Agent Name: Cheryl Riley
Disclaimer: Copyright © 2024 Arizona Regional Multiple Listing Service, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3422 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for Cori Taber
Cori Taber
ASCIIJason Mitchell Group
Call Today!: (480) 298-4292

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App