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 (blumefield est) AND "idx_listings"."updated" > 2018-08-19 18:12:43.708557) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-1 of 1 Listings

$153,500

311 Bridgeview

Anderson, South Carolina

3 BDs, 2 BAs

MLS: 20205259

Blumefield Est

Source: Anderson / Seneca MLS

Berenice Ramage - Western Upstate Kw

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
528 Pioneer Lane
Anderson, SC 29625
7/11/18 699000 None
205 Richland Point Road
Anderson, SC 29626
8/13/18 667900 Other
110 Harrison Harbor Way
Anderson, SC 29621
6/27/18 665000 Other
1115 Rooks Drive
Anderson, SC 29625
8/6/18 459900 None
905 Snug Harbor
Anderson, SC 29625
7/23/18 459900 None
209 Stelling Road
Townville, SC 29689
5/31/18 429900 Other
409 Watermarke Lane
Anderson, SC 29625
6/11/18 330000 Other
208 Peninsula Drive
Anderson, SC 29625
8/15/18 297500 Other
100 Woods Way
Anderson, SC 29625
7/19/18 250000 Welborn Acres
138 Norfolk Circle
Anderson, SC 29625
7/31/18 216700 Sullivan Hills
107 Toliver Lane
Anderson, SC 29625
7/30/18 209900 None
229 Streams Way
Anderson, SC 29625
7/26/18 205000 Winding Stream
250 Streams Way
Anderson, SC 29625-5148
7/16/18 199900 Winding Stream
7 Rosbella Drive
Anderson, SC 29625
8/15/18 199900 Mirabella
212 Harrington Drive
Anderson, SC 29625
5/30/18 199900 Other
101 Ashby Court
Anderson, SC 29625
8/12/18 189900 Other
97 Cann Road
Anderson, SC 29625
6/4/18 180418 None
405 Regency Circle
Anderson, SC 29625
6/6/18 178500 Regency Park
122 Yellow Pine Drive
Anderson, SC 29626
6/29/18 167900 Other
210 Shore Drive
Anderson, SC 29625
8/6/18 165900 None
402 ASHWOOD Lane
Anderson, SC 29625-2048
7/9/18 160000 None
102 Cloverdale Drive
Anderson, SC 29626
7/17/18 145000 Other
209 Rio Way
Anderson, SC 29625
7/10/18 142000 Other
311 Kingston Way
Anderson, SC 29625
6/29/18 139900 Stonehaven
203 Stone Drive
Anderson, SC 29625
7/30/18 119000 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.