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 (gaston heights) AND "idx_listings"."updated" > 2018-06-16 11:11:31.203508) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-1 of 1 Listings

$250,000

203 Tubbs Mountain Road

Travelers Rest, SC

3 BDs, 2 BAs

MLS: 1365164

Gaston Heights

Source: Greater Greenville Association of REALTORS®

Katherine Bliss - Keller Williams Drive

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
120 E Round Hill Road
Greenville, SC 29617
5/18/18 1460000 Green Valley
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
112 Grassy Meadow Drive
Travelers Rest, SC 29690
4/27/18 499900 The Reserve @ Green Valley
1 Thornbriar Court
Travelers Rest, SC 29690
6/12/18 449900 Briarwood Meadows
3410 State Park Road
Greenville, SC 29609
5/31/18 439750 None
10 Ridenour Avenue
Greenville, SC 29617
5/7/18 398000 Carilion
204 N Kensington Road
Greenville, SC 29617
5/31/18 397000 Carilion
1306 N Parker Road
Greenville, SC 29609
6/6/18 379900 None
206 Berrow Way
Taylors, SC 29687
5/4/18 375000 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
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
1108 Roe Ford Road
Greenville, SC 29617-6142
4/30/18 349000 Stratford Forest
26 Park Vista Way
Greenville, SC 29617
3/21/18 339900 Hunters Ridge
26 Setting Sun Lane
Travelers Rest, SC 29690
4/6/18 326500 The Ridge at Sunset
115 Jones Kelley Road
Travelers Rest, SC 29690
4/19/18 324900 Kelley Farms
887 N Highway 25 Bypass
Greenville, SC 29617
4/10/18 320000 None
15 Lodge Way
Travelers Rest, SC 29690
4/30/18 319900 Other
109 Windy Bluff Drive
Greenville, SC 29617
3/26/18 314900 Northcliff
5 Keystone Drive
Travelers Rest, SC 29690
4/26/18 299900 Points North
601 Mojave Court
Travelers Rest, SC 29690
4/17/18 299900 The Gardens at Rose Reserve
125 Jones Kelley Road
Travelers Rest, SC 29690
3/22/18 299406 Kelley Farms

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.