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 (hammond hall) AND "idx_listings"."updated" > 2018-06-21 21:32:33.846560) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-3 of 3 Listings

$429,900

108 Vining Crossing

Belton, South Carolina

4 BDs, 3 BAs

MLS: 20203934

Hammond Hall

Source: Anderson / Seneca MLS

Dave Chamblee - Anderson Area Properties

REDUCED

$425,000

106 Hawks Nest

Belton, South Carolina

4 BDs, 4 BAs

MLS: 20194617

Hammond Hall

Source: Anderson / Seneca MLS

Suzette Christopher - Re/Max Realty Prof/Anderson

REDUCED

$367,900

211 Vinings

Belton, South Carolina

4 BDs, 3 BAs

MLS: 20203579

Hammond Hall

Source: Anderson / Seneca MLS

Dee Dee Shead - Gloria Robinson Real Estate

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
110 Cordova Court
Belton, SC 29627
5/17/18 549000 None
129 Rivendell
Anderson, South Carolina 29621
6/13/18 498500 Rivendell
900 Windy Hill Drive
Anderson, SC 29621
5/15/18 489000 None
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
112 Tully Drive
Anderson, SC 29621
5/31/18 395000 Brookstone Meadows
104 Natural Springs
Belton, SC 29627
4/23/18 389900 Hammond Hall
1212 CRESTVIEW Road
Anderson, SC 29621
4/12/18 378900 None
108 Tully Drive
Anderson, SC 29621
3/31/18 374500 Brookstone Meadows
104 Wild Meadows Drive
Anderson, SC 29621
5/17/18 360900 Wild Meadows
106 McPhail Farms Circle
Anderson, SC 29621
6/21/18 319900 Other
1042 Tuscany Drive
Anderson, SC 29621
5/30/18 309900 Other
107 Cathey Road
Anderson, SC 29621
5/24/18 300000 None
138 Tully Drive
Anderson, SC 29621
5/15/18 299095 Brookstone Meadows
2029 Moultrie Square
Anderson, SC 29621
6/4/18 279000 None
5410 Midway Road
Williamston, SC 29697
5/31/18 279000 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
100 Golden Eagle Lane
Anderson, SC 29621
5/29/18 236037 Arbors at Cobbs Glen
3003 Midway Road
Anderson, SC 29621
6/22/18 227500 None
121 Coosa Lane
Anderson, SC 29621
5/8/18 203000 Willow Haven at Cobbs Glen
1018 Edenbrooke Circle
Anderson, SC 29621
3/30/18 175900 Other
5018 King Drive
Anderson, SC 29621
4/2/18 175000 Other
101 Foghorn Court
Williamston, SC 29697
5/11/18 169000 Hidden Anchor

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 8 p.m. EDT
(Click for details)