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 (hampshire hills) AND "idx_listings"."updated" > 2018-07-13 20:37:20.431420) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-1 of 1 Listings

REDUCED

$215,000

100 Keene Drive

Travelers Rest, SC

3 BDs, 2 BAs

MLS: 1370324

Hampshire Hills

Source: Greater Greenville Association of REALTORS®

Brad Tamrack - Only Way Realty Greenville

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
14 Mossy Brook Trail
Travelers Rest, SC 29690
5/14/18 739900 Paris Mt Area
124 Grassy Meadow Drive
Travelers Rest, SC 29690
5/4/18 579900 The Reserve @ Green Valley
716 Villaggio Drive
Greenville, SC 29609
6/28/18 579900 Montebello
608 Carilion Lane
Greenville, SC 29617
6/29/18 509795 Carilion
112 Grassy Meadow Drive
Travelers Rest, SC 29690
4/27/18 499900 The Reserve @ Green Valley
19 Arezzo Drive
Greenville, SC 29609
6/29/18 494900 Montebello
701 Montebello Drive
Greenville, SC 29609
5/4/18 487500 Montebello
100 Merritt View Terrace
Greenville, SC 29606-413
6/29/18 479900 None
4 Mallard Court
Greenville, SC 29617
7/2/18 459900 Valley Oaks
62 DEVONHALL Way
Taylors, SC 29687
7/13/18 449900 Berkshire Park
3410 State Park Road
Greenville, SC 29609
5/31/18 439750 None
408 Palladio Drive
Greenville, SC 29617
7/2/18 436900 Carilion
110 Lake Point Drive
Taylors, SC 29687
6/8/18 399500 Lake Boling Est
10 Ridenour Avenue
Greenville, SC 29617
5/7/18 398000 Carilion
204 N Kensington Road
Greenville, SC 29617
5/31/18 397000 Carilion
10 Winding Walk Way
Taylors, SC 29687
5/4/18 389900 Silver Meadows
1306 N Parker Road
Greenville, SC 29609
6/6/18 379900 None
206 Berrow Way
Taylors, SC 29687
5/4/18 375000 Berkshire Park
304 Beckworth Drive
Taylors, SC 29687
4/25/18 374000 Berkshire Park
236 Castlemaine Drive
Greenville, SC 29617
5/16/18 369900 Carilion
615 Tugaloo Road
Travelers Rest, SC 29690
5/25/18 369700 None
335 Club Drive
Travelers Rest, SC 29690
6/28/18 364900 Grandview Hgts
33 Jones Kelley Road
Travelers Rest, SC 29690
4/25/18 360000 Kelley Farms
15 Belle Terre Court
Greenville, SC 29609
5/7/18 359500 Summersett Manor
4 Overlook Court
Greenville, SC 29609
5/22/18 354900 Oak Hollow

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.