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-09-19 07:03:46.742289) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-3 of 3 Listings

$409,900

106 Hawks Nest

Belton, South Carolina

4 BDs, 4 BAs

MLS: 20207995

Hammond Hall

Source: Anderson / Seneca MLS

Suzette Christopher - Re/Max Realty Prof/Anderson

REDUCED

$405,000

109 Vining

Belton, South Carolina

5 BDs, 4 BAs

MLS: 20205253

Hammond Hall

Source: Anderson / Seneca MLS

Jeremy Bouknight - Bhhs C Dan Joyner - Pelham

REDUCED

$405,000

109 Vining Crossing

Belton, SC

5 BDs, 4 BAs

MLS: 1372727

Hammond Hall

Source: Greater Greenville Association of REALTORS®

Jeremy Bouknight - Bhhs C Dan Joyner - Pelham

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
110 Harlond Drive
Anderson, SC 29621
7/31/18 529000 Rivendell
201 Oakmont Drive
Anderson, SC 29621
8/17/18 479900 Oakmont
102 Royal Troon Court
Anderson, SC 29621-7657
9/1/18 479900 Innisbrook
724 Sunny Shore Lane
Anderson, SC 29621
7/20/18 390000 Other
100 Briar Creek Lane
Anderson, SC 29621
7/11/18 389900 Other
137 Spanish Wells
Anderson, SC 29621
9/7/18 349900 Cobbs Glen
105 Siena Drive
Anderson, SC 29621-4311
9/11/18 349900 Other
128 Baybrooke Lane
Anderson, SC 29621
8/2/18 344900 Other
102 Sunrise Harbor Drive
Anderson, SC 29621
7/6/18 339900 Other
132 Baybrooke Lane
Anderson, SC 29621
7/27/18 324900 Kensington Plantation
1015 Harpers Way
Anderson, SC 29621
8/23/18 319900 Other
111 Grove Park Drive
Anderson, SC 29621
6/28/18 299900 Brookstone Meadows
112 Buckland Drive
Anderson, SC 29621
8/30/18 299000 Rivendell
135 Hammett Acres Road
Anderson, SC 29621
7/6/18 299000 Other
414 Ashley Downs
Anderson, SC 29621-2410
6/27/18 295000 None
2905 Cobbs Way
Anderson, SC 29621
7/20/18 290000 Cobbs Glen
205 Pebble Brook Lane
Belton, SC 29627
7/30/18 289900 Rock Springs
1202 Melbourne Drive
Anderson, SC 29621
9/18/18 265000 Other
1014 Harpers Way
Anderson, SC 29621
8/24/18 264900 Other
127 Bradley Park
Anderson, SC 29621
7/10/18 229900 Other
110 Sloan Avenue
Anderson, SC 29621
9/5/18 228110 Axman Oaks
110 Stone Cottage Drive
Anderson, SC 29621
7/16/18 219900 Brookstone Meadows
139 Easy Gap Road
Anderson, SC 29621
7/12/18 215000 None
129 Running Fox Lane
Belton, SC 29627
6/26/18 215000 Wild Deer Crossing
115 Olde Towne Drive
Anderson, SC 29621
8/30/18 214900 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.