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 (casa del rio) AND "idx_listings"."updated" > 2018-08-19 22:09:35.977484) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-3 of 3 Listings

NEW

$150,000

331 Monti

Anderson, South Carolina

3 BDs, 2 BAs

MLS: 20206218

Casa Del Rio

Source: Anderson / Seneca MLS

Berenice Ramage - Western Upstate Kw

$145,000

226 Rio

Anderson, South Carolina

3 BDs, 2 BAs

MLS: 20204922

Casa Del Rio

Source: Anderson / Seneca MLS

Curtis Wiles - Carolina Properties

$141,000

361 Monti

Anderson, South Carolina

3 BDs, 2 BAs

MLS: 20204940

Casa Del Rio

Source: Anderson / Seneca MLS

Andrew Dorski - The Agentowned Realty

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
528 Pioneer Lane
Anderson, SC 29625
7/11/18 699000 None
110 Harrison Harbor Way
Anderson, SC 29621
6/27/18 665000 Other
109 Foxcroft Way
Anderson, SC 29621
6/29/18 629700 Other
1115 Rooks Drive
Anderson, SC 29625
8/6/18 459900 None
123 Ridgeway Trail
Anderson, SC 29621
7/6/18 399000 Other
724 Sunny Shore Lane
Anderson, SC 29621
7/20/18 390000 Other
100 Briar Creek Lane
Anderson, SC 29621
7/11/18 389900 Other
326 Stephen King Drive
Anderson, SC 29621
6/25/18 354900 Other
102 Sunrise Harbor Drive
Anderson, SC 29621
7/6/18 339900 Other
108 Wild Meadows Drive
Anderson, SC 29621
7/2/18 339100 Wild Meadows
409 Watermarke Lane
Anderson, SC 29625
6/11/18 330000 Other
106 McPhail Farms Circle
Anderson, SC 29621
6/21/18 319900 Other
8 Chardonnay Drive
Anderson, SC 29621
7/31/18 316900 Mystic Vineyards
135 Hammett Acres Road
Anderson, SC 29621
7/6/18 299000 Other
414 Ashley Downs
Anderson, SC 29621-2410
6/27/18 295000 None
2029 Moultrie Square
Anderson, SC 29621
6/4/18 279000 None
401 Sherwood Drive
Anderson, SC 29621
7/19/18 246000 Other
127 Bradley Park
Anderson, SC 29621
7/10/18 229900 Other
131 Old North Church Road
Anderson, SC 29621
6/25/18 225000 Lexington Place
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
7 Rosbella Drive
Anderson, SC 29625
8/15/18 199900 Mirabella
212 Harrington Drive
Anderson, SC 29625
5/30/18 199900 Other
250 Streams Way
Anderson, SC 29625-5148
7/16/18 199900 Winding Stream

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.