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 (innisbrook) AND "idx_listings"."updated" > 2018-06-16 11:24:20.015633) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-2 of 2 Listings

NEW

$307,000

105 Prestwick

Anderson, South Carolina

3 BDs, 2 BAs

MLS: 20203977

Innisbrook

Source: Anderson / Seneca MLS

Pete Jenkinson - Coldwell Banker Durham & Assoc

PENDING

$294,900

103 Royal Birkdale

Anderson, South Carolina

3 BDs, 2 BAs

MLS: 20193756

Innisbrook

Source: Anderson / Seneca MLS

Jackie Haffner - D.R. Horton

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
108 Chickasaw Run
Williamston, SC 29697
6/14/18 569900 Other
110 Cordova Court
Belton, SC 29627
5/17/18 549000 None
129 Rivendell
Anderson, South Carolina 29621
6/13/18 498500 Rivendell
1040 Omega Farms Lane
Williamston, SC 29697
4/11/18 479000 Omega Farms
1028 Omega Farms Lane
Williamston, SC 29697
6/14/18 474900 Omega Farms
1 Sparrow Drive
Williamston, SC 29697
6/1/18 430000 Ridgewood Plantation
7 Ione Circle
Williamston, SC 29697
3/23/18 414900 Ridgewood Plantation
112 Tully Drive
Anderson, SC 29621
5/31/18 395000 Brookstone Meadows
113 Caversham Lane
Anderson, SC 29621
5/4/18 379900 Kings Grant
1212 CRESTVIEW Road
Anderson, SC 29621
4/12/18 378900 None
108 Tully Drive
Anderson, SC 29621
3/31/18 374500 Brookstone Meadows
115 Hunting Meadow Drive
Williamston, SC 29697
5/31/18 360000 Other
120 Croxton Road
Williamston, SC 29697
5/24/18 329900 None
1042 Tuscany Drive
Anderson, SC 29621
5/30/18 309900 Other
107 Cathey Road
Anderson, SC 29621
5/24/18 300000 None
122 Carnoustie Circle
Anderson, SC 29621
5/30/18 299900 Innisbrook
138 Tully Drive
Anderson, SC 29621
5/15/18 299095 Brookstone Meadows
5410 Midway Road
Williamston, SC 29697
5/31/18 279000 None
1201 Whippoorwill Road
Pelzer, SC 29669
5/29/18 260000 None
1018 Tuscany Drive
Anderson, SC 29621
5/18/18 259900 Other
120 Siena Drive
Anderson, SC 29621
4/2/18 259900 Other
176 Buckland Drive
Anderson, SC 29621
4/27/18 249900 Rivendell
122 Stone Cottage Drive
Anderson, SC 29621
4/1/18 239900 Brookstone Meadows
114 Stone Cottage Drive
Anderson, SC 29621
5/17/18 239900 Brookstone Meadows
144 Rock Moss Drive
Williamston, SC 29697
4/30/18 178000 Other

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.