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 (brookstone meadows) AND "idx_listings"."updated" > 2018-08-20 02:13:19.703015) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-12 of 19 Listings

$478,500

119 Garden Park

Anderson, South Carolina

4 BDs, 4 BAs

MLS: 20204506

Brookstone Meadows

Source: Anderson / Seneca MLS

Suzette Christopher - Re/Max Realty Prof/Anderson

$469,000

159 Tully

Anderson, South Carolina

5 BDs, 3 BAs

MLS: 20204158

Brookstone Meadows

Source: Anderson / Seneca MLS

Gia Townsley - Bhhs C Dan Joyner - Anderson

REDUCED

$459,900

119 Turnberry

Anderson, South Carolina

5 BDs, 3 BAs

MLS: 20204069

Brookstone Meadows

Source: Anderson / Seneca MLS

The CleverPeople - Bhhs C Dan Joyner - Anderson

$420,000

144 Parkside

Anderson, South Carolina

5 BDs, 4 BAs

MLS: 20203043

Brookstone Meadows

Source: Anderson / Seneca MLS

Deana Kilcommons - Western Upstate Kw

$420,000

144 Parkside Drive

Anderson, SC

5 BDs, 4 BAs

MLS: 1369126

Brookstone Meadows

Source: Greater Greenville Association of REALTORS®

Deana Kilcommons - Keller Williams Western Upstat

REDUCED

$419,000

134 Tully

Anderson, South Carolina

5 BDs, 3 BAs

MLS: 20201527

Brookstone Meadows

Source: Anderson / Seneca MLS

Gia Townsley - Bhhs C Dan Joyner - Anderson

REDUCED

$394,000

100 Turnberry Road

Anderson, SC

3 BDs, 2 BAs

MLS: 1353701

Brookstone Meadows

Source: Greater Greenville Association of REALTORS®

Lauren Gillespie - The Agent Owned Realty

$394,000

100 Turnberry

Anderson, South Carolina

3 BDs, 2 BAs

MLS: 20204524

Brookstone Meadows

Source: Anderson / Seneca MLS

Lauren Gillespie - The Agentowned Realty

$375,000

118 Parkside

Anderson, South Carolina

4 BDs, 3 BAs

MLS: 20204847

Brookstone Meadows

Source: Anderson / Seneca MLS

Chappelear and Associates - Western Upstate Kw

REDUCED

$340,000

111 Courtyard Drive

Anderson, SC

3 BDs, 3 BAs

MLS: 1368081

Brookstone Meadows

Source: Greater Greenville Association of REALTORS®

Glen Childress - Keller Williams Western Upstat

REDUCED

$340,000

122 Parkside

Anderson, South Carolina

3 BDs, 3 BAs

MLS: 20201746

Brookstone Meadows

Source: Anderson / Seneca MLS

Wanda Stewart - Coldwell Banker Caine/Williams

REDUCED

$340,000

122 Parkside Drive

Anderson, SC

3 BDs, 3 BAs

MLS: 1357756

Brookstone Meadows

Source: Greater Greenville Association of REALTORS®

Wanda Stewart - Coldwell Banker Caine/Williams

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.