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 (chasewater) AND "idx_listings"."updated" > 2018-10-17 04:08:17.621342) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-2 of 2 Listings

$897,900

116 Willowbend

Anderson, South Carolina

 

MLS: 20203089

Chasewater

Source: Anderson / Seneca MLS

Nora Hooper - Re/Max Realty Prof/Anderson

$415,000

106 Chasewater

Anderson, South Carolina

5 BDs, 3 BAs

MLS: 20205048

Chasewater

Source: Anderson / Seneca MLS

John Schroder - Keller Williams Grv Upst

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
1044 North Shore Drive
Anderson, SC 29625
9/28/18 599000 Other
128 Harper Road
Pendleton, SC 29670
9/28/18 514900 Other
102 Royal Troon Court
Anderson, SC 29621-7657
9/1/18 479900 Innisbrook
201 Oakmont Drive
Anderson, SC 29621
8/17/18 479900 Oakmont
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
540 Sanders Road
Pendleton, SC 29670
10/12/18 359000 None
105 Siena Drive
Anderson, SC 29621-4311
9/11/18 349900 Other
105 Jones Creek Circle
Anderson, SC 29621
10/10/18 344900 Covered Bridge at Jones Creek
110 Jones Creek Circle
Anderson, SC 29621
10/12/18 344800 Covered Bridge at Jones Creek
138 Turnberry Road
Anderson, SC 29621
9/21/18 339000 Brookstone Meadows
104 Ridgeway Trail
Anderson, SC 29621
10/4/18 327785 Bailey Creek
1015 Harpers Way
Anderson, SC 29621
8/23/18 319900 Other
507 Watermarke Lane
Anderson, SC 29625-5965
8/22/18 315000 Other
112 Buckland Drive
Anderson, SC 29621
8/30/18 299000 Rivendell
305 Valley Dale Drive
Anderson, SC 29625
8/31/18 284900 Other
607 Watermarke Lane
Anderson, SC 29625-5965
8/23/18 269999 Other
100 Buckland Drive
Anderson, SC 29621
10/5/18 265000 Rivendell
1202 Melbourne Drive
Anderson, SC 29621
9/18/18 265000 Other
1014 Harpers Way
Anderson, SC 29621
8/24/18 264900 Other
110 Sloan Avenue
Anderson, SC 29621
9/5/18 228110 Axman Oaks
115 Olde Towne Drive
Anderson, SC 29621
8/30/18 214900 Other
10 Rosbella Drive
Anderson, SC 29625
9/27/18 200551 Mirabella
214 Forest Hill Drive
Anderson, SC 29621
8/30/18 199900 Woodland Heights

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.
Site Maintenance
at 9 p.m. EDT
on Oct. 19th
(Click for details)