to
SELECT "idx_listings"."id", "idx_listings"."proptype", "idx_listings"."subtype", "idx_listings"."idx_id", "idx_listings"."mls_id", "idx_listings"."status", "idx_listings"."created", "idx_listings"."updated", "idx_listings"."price", "idx_listings"."price_reduced", "idx_listings"."listing_agent", "idx_listings"."listing_office", "idx_listings"."listing_agent_id", "idx_listings"."co_listing_agent", "idx_listings"."co_listing_office", "idx_listings"."co_listing_agent_id", "idx_listings"."selling_agent", "idx_listings"."selling_office", "idx_listings"."selling_agent_id", "idx_listings"."address", "idx_listings"."last_geocoded_address", "idx_listings"."lat", "idx_listings"."lon", "idx_listings"."lock_geocode", "idx_listings"."city", "idx_listings"."state", "idx_listings"."zipcode", "idx_listings"."county", "idx_listings"."subdivision", "idx_listings"."original_price", "idx_listings"."beds", "idx_listings"."baths", "idx_listings"."halfbaths", "idx_listings"."foreclosure", "idx_listings"."shortsale", "idx_listings"."sqft", "idx_listings"."lotsize", "idx_listings"."virtualtour", "idx_listings"."openhouse", "idx_listings"."geolocation", "idx_listings"."geometry", "idx_listings"."elementary_school", "idx_listings"."middle_school", "idx_listings"."high_school", "idx_listings"."acres", "idx_listings"."date_listed", "idx_listings"."date_sold", "idx_listings"."sold_price", "idx_listings"."new_construction", "idx_listings"."agent_email", "idx_listings"."year_built", "idx_listings"."area", "idx_listings"."style", "idx_listings"."owner_financing", "idx_listings"."display_address", "idx_listings"."handicap_accessible", "idx_listings"."green_home", "idx_listings"."mls_system_id", "idx_listings"."waterfront", "idx_listings"."lake" FROM "idx_listings" WHERE ("idx_listings"."idx_id" IN (SELECT DISTINCT U0."idx_id" FROM "idxs_idx" U0 INNER JOIN "idxs_idxaccount" U1 ON (U0."idx_id" = U1."idx_id") WHERE U1."user_id" = 173423) AND (UPPER("idx_listings"."proptype"::text) LIKE UPPER(r%) OR UPPER("idx_listings"."proptype"::text) LIKE UPPER(e%) OR UPPER("idx_listings"."proptype"::text) LIKE UPPER(s%) OR UPPER("idx_listings"."proptype"::text) LIKE UPPER(i%)) AND "idx_listings"."subdivision" IN (fairfield acres) AND "idx_listings"."updated" > 2018-10-13 05:52:11.242985) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-2 of 2 Listings

PENDING

$149,900

2602 Warren

Anderson, South Carolina

3 BDs, 2 BAs

MLS: 20205399

Fairfield Acres

Source: Anderson / Seneca MLS

Latonia Crowe - Delta Real Estate, Llc

PENDING

$110,000

1404 Belhaven

Anderson, South Carolina

3 BDs, 2 BAs

MLS: 20193504

Fairfield Acres

Source: Anderson / Seneca MLS

Cathy Wohlford - Re/Max Realty Prof/Anderson

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
201 Oakmont Drive
Anderson, SC 29621
8/17/18 479900 Oakmont
1201 Reed Road
Anderson, SC 29621
9/24/18 450000 None
137 Spanish Wells
Anderson, SC 29621
9/7/18 349900 Cobbs Glen
104 Ridgeway Trail
Anderson, SC 29621
10/4/18 327785 Bailey Creek
112 Buckland Drive
Anderson, SC 29621
8/30/18 299000 Rivendell
100 Buckland Drive
Anderson, SC 29621
10/5/18 265000 Rivendell
1202 Melbourne Drive
Anderson, SC 29621
9/18/18 265000 Other
110 Sloan Avenue
Anderson, SC 29621
9/5/18 228110 Axman Oaks
139 Easy Gap Road
Anderson, SC 29621
7/12/18 215000 None
115 Olde Towne Drive
Anderson, SC 29621
8/30/18 214900 Other
190 Richey Road
Belton, SC 29627
9/7/18 200000 None
146 BRIAR PATCH Road
Anderson, SC 29621-1437
8/10/18 199900 None
1001 Whirlaway Circle
Anderson, SC 29621
8/8/18 198500 Other
112 Gallant Lane
Anderson, SC 29621
8/28/18 190000 Lexington Pointe
613 Laurens Drive
Anderson, SC 29621
7/17/18 184000 Silverleaf - 052
109 Gallant Lane
Anderson, SC 29621
9/25/18 181500 Lexington Pointe
114 Mediterranean Avenue
Anderson, SC 29621
7/18/18 180000 Westwood Pointe
431 McFalls Circle
Anderson, SC 29621
9/24/18 180000 Other
1820 Marchbanks Avenue
Anderson, SC 29621
8/15/18 179900 Other
145 Abigail Lane
Anderson, SC 29621
9/28/18 179900 Cobblestone West
2508 Linmar Circle
Anderson, SC 29621
10/11/18 178000 None
106 Callow Hill Way
Anderson, SC 29621
8/27/18 177500 Other
103 Willow Court
Anderson, SC 29621
8/24/18 169900 Other
162 Elliott Circle
Anderson, SC 29621
9/20/18 165000 Village at Marchbanks
34 Hillsborough Drive
Anderson, SC 29621
9/28/18 159900 Crayton Hall

Robert Haney, REALTOR®


Luxury Collection Specialist, Marketing Specialist, High End Luxury Homes
Berkshire Hathaway HomeServices/C. Dan Joyner REALTORS®
745 N Pleasantburg Dr., Greenville, SC 29607

864-270-4192

Paige Haney, REALTOR®


Luxury Collection Specialist, SFR, Certified Relocation Specialist
Berkshire Hathaway HomeServices/C. Dan Joyner REALTORS®
705 W. Wade Hampton Blvd., Greer, SC 29650

864-414-9937

Equal Housing Oppoortunity
Information is deemed reliable but not guaranteed, and is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify perspective properties consumers may be interested in purchasing. Any use of search facilities of data on the site other than by potential buyers and sellers is prohibited. Sale data is for informational purposes only and is not an indication of a market analysis or appraisal.

All code, applications and designs © 2014-present EASy Media, LLC. All right reserved. Operating under US Patent 8234174 and other Patents Pending.