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 (centerville terrace) AND "idx_listings"."updated" > 2018-10-13 05:54:20.822463) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-4 of 4 Listings

PENDING

$114,900

632 A & B 119 Whitehall Road

Anderson, South Carolina

1 BDs, 1 BAs

MLS: 20205870

Centerville Terrace

Source: Anderson / Seneca MLS

Patti White - All Star Company

$89,900

500 Chestnut

Anderson, South Carolina

3 BDs, 1 BAs

MLS: 20208649

Centerville Terrace

Source: Anderson / Seneca MLS

SHIRLEY WINCHESTER - Allen Tate Company - Easley

$89,900

500 Chestnut Boulevard

Anderson, SC

3 BDs, 1 BAs

MLS: 1377552

Centerville Terrace

Source: Greater Greenville Association of REALTORS®

Shirley Winchester - Allen Tate Company - Easley

PENDING

$62,500

105 Poplar

Anderson, South Carolina

3 BDs, 2 BAs

MLS: 20204160

Centerville Terrace

Source: Anderson / Seneca MLS

Ted Morlok - Commonwealth Realty

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
113 Tall Ship Drive
Anderson, SC 29625
9/7/18 659000 Other
1044 North Shore Drive
Anderson, SC 29625
9/28/18 599000 Other
1115 Rooks Drive
Anderson, SC 29625
8/6/18 459900 None
1201 Reed Road
Anderson, SC 29621
9/24/18 450000 None
4406 Denver Cove Road
Anderson, SC 29625
8/29/18 419900 Other
724 Sunny Shore Lane
Anderson, SC 29621
7/20/18 390000 Other
100 Briar Creek Lane
Anderson, SC 29621
7/11/18 389900 Other
507 Watermarke Lane
Anderson, SC 29625-5965
8/22/18 315000 Other
208 Peninsula Drive
Anderson, SC 29625
8/15/18 297500 Other
305 Valley Dale Drive
Anderson, SC 29625
8/31/18 284900 Other
607 Watermarke Lane
Anderson, SC 29625-5965
8/23/18 269999 Other
1202 Melbourne Drive
Anderson, SC 29621
9/18/18 265000 Other
107 Toliver Lane
Anderson, SC 29625
7/30/18 209900 None
229 Streams Way
Anderson, SC 29625
7/26/18 205000 Winding Stream
10 Rosbella Drive
Anderson, SC 29625
9/27/18 200551 Mirabella
214 Forest Hill Drive
Anderson, SC 29621
8/30/18 199900 Woodland Heights
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
1011 Windmill Trail
Anderson, SC 29626
9/14/18 190000 Other
101 Ashby Court
Anderson, SC 29625
8/12/18 189900 Other
109 Gallant Lane
Anderson, SC 29621
9/25/18 181500 Lexington Pointe
600 Parkwood Drive
Anderson, SC 29625
8/31/18 169900 None
210 Shore Drive
Anderson, SC 29625
8/6/18 165900 None
103 Dove Hollow Road
Anderson, SC 29626
9/25/18 159900 Dove Hollow

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.