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 (chateau woods) AND "idx_listings"."updated" > 2018-06-17 04:25:14.284190) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-1 of 1 Listings

$228,000

705 Fountainbleu

Anderson, South Carolina

3 BDs, 2 BAs

MLS: 20203049

Chateau Woods

Source: Anderson / Seneca MLS

Frank Alexander - The Agentowned Realty

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
114 Harrison Harbor Way
Anderson, SC 29625
5/2/18 659000 Other
409 Watermarke Lane
Anderson, SC 29625
6/11/18 330000 Other
303 Valley Dale Drive
Anderson, SC 29625
4/23/18 289900 Other
2029 Moultrie Square
Anderson, SC 29621
6/4/18 279000 None
115 Saddle Brook Circle
Anderson, SC 29625
4/17/18 250000 Other
503 Timber Lane
Anderson, SC 29621
4/25/18 219000 Other
216 Streams Way
Anderson, SC 29625
3/30/18 205000 Winding Stream
212 Harrington Drive
Anderson, SC 29625
5/30/18 199900 Other
146 Norfolk Circle
Anderson, SC 29625
4/30/18 194100 Sullivan Hills
21 Anchor Point
Anderson, SC 29625-6004
3/29/18 189000 Other
405 Regency Circle
Anderson, SC 29625
6/6/18 178500 Regency Park
117 Sugar Creek Lane
Anderson, SC 29625
3/21/18 177000 Other
1018 Edenbrooke Circle
Anderson, SC 29621
3/30/18 175900 Other
402 Hunters Lane
Anderson, SC 29625
6/4/18 157000 Hunters Glen
2112 Portside Way
Anderson, SC 29625
4/17/18 149000 Other
904 Pine Top Circle
Anderson, SC 29626
5/2/18 144000 Other
4405 & 4407 Lexington Way
Anderson, SC 29621
4/23/18 139900 Other
129 Midway Drive
Anderson, SC 29625
4/9/18 129900 None
2505 Millgate Road
Anderson, SC 29621
4/19/18 119999 Bellview Estates
1936 DOBBINS Avenue
Anderson, SC 29625
3/29/18 119900 None
310 Moultrie Square
Anderson, SC 29621
5/2/18 105000 None
104 Bertharee Court
Anderson, SC 29625
5/23/18 102500 None
313 Lookover Drive
Anderson, SC 29625
5/18/18 99750 Other
3003 Sunset Forest Road
Anderson, SC 29626-1045
5/9/18 84000 None
117-B Summerwalk Court
Anderson, SC 29625
6/8/18 78200 None

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.