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-08-20 03:48:23.864849) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-3 of 3 Listings

NEW

$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

PENDING

$74,000

1101 Bolt

Anderson, South Carolina

3 BDs, 1 BAs

MLS: 20204845

Fairfield Acres

Source: Anderson / Seneca MLS

CONNIE FINLEY - Felix Finley Real Estate

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
109 Foxcroft Way
Anderson, SC 29621
6/29/18 629700 Other
110 Harlond Drive
Anderson, SC 29621
7/31/18 529000 Rivendell
129 Rivendell
Anderson, South Carolina 29621
6/13/18 498500 Rivendell
201 Oakmont Drive
Anderson, SC 29621
8/17/18 479900 Oakmont
1028 Omega Farms Lane
Williamston, SC 29697
6/14/18 474900 Omega Farms
123 Ridgeway Trail
Anderson, SC 29621
7/6/18 399000 Other
108 Wild Meadows Drive
Anderson, SC 29621
7/2/18 339100 Wild Meadows
106 McPhail Farms Circle
Anderson, SC 29621
6/21/18 319900 Other
8 Chardonnay Drive
Anderson, SC 29621
7/31/18 316900 Mystic Vineyards
2905 Cobbs Way
Anderson, SC 29621
7/20/18 290000 Cobbs Glen
205 Pebble Brook Lane
Belton, SC 29627
7/30/18 289900 Rock Springs
2029 Moultrie Square
Anderson, SC 29621
6/4/18 279000 None
100 Rossmoor Court
Anderson, SC 29621
6/26/18 260712 Pennington Farms
127 Bradley Park
Anderson, SC 29621
7/10/18 229900 Other
139 Easy Gap Road
Anderson, SC 29621
7/12/18 215000 None
129 Running Fox Lane
Belton, SC 29627
6/26/18 215000 Wild Deer Crossing
146 BRIAR PATCH Road
Anderson, SC 29621-1437
8/10/18 199900 None
1001 Whirlaway Circle
Anderson, SC 29621
8/8/18 198500 Other
613 Laurens Drive
Anderson, SC 29621
7/17/18 184000 Silverleaf - 052
114 Mediterranean Avenue
Anderson, SC 29621
7/18/18 180000 Westwood Pointe
1820 Marchbanks Avenue
Anderson, SC 29621
8/15/18 179900 Other
1406 Whiten Road
Belton, SC 29627
6/13/18 145000 None
918 Highway 252
Belton, SC 29627
6/28/18 124900 None
115 Comet Street
Anderson, SC 29621
6/28/18 110000 None
155 STRAWBERRY Place
Anderson, SC 29624
6/29/18 110000 Strawberry Ridge

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.