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 (cross hill) AND "idx_listings"."updated" > 2018-10-13 06:00:13.427641) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-1 of 1 Listings

REDUCED

$392,900

221 Brashears Road

Campobello, SC

4 BDs, 3 BAs

MLS: 1377108

Cross Hill

Source: Greater Greenville Association of REALTORS®

Tim Toates - Bhhs C Dan Joyner - Pelham

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
190 Sloan Road
Lyman, SC 29365
7/27/18 699900 Other
1633 Hampton Road
Inman, SC 29349
8/10/18 699900 Other
1481 Ballenger Road
Wellford, SC 29385
8/28/18 695000 None
4485 Skyland Drive
Greer, SC 29651
9/18/18 674000 None
3003 Motlow Creek Road
Campobello, SC 29322
7/20/18 524900 Motlow Creek
485 Motlow Creek Road
Campobello, SC 29322-8122
8/31/18 500000 None
151 Lake Lyman Heights
Lyman, SC 29365
8/14/18 437500 None
126 Grand Canyon Road
Inman, SC 29349
9/6/18 399990 Other
6 San Bruno Court
Greer, SC 29651
7/27/18 329900 Boulder Creek
534 Laurel Crest Drive
Inman, SC 29349
10/2/18 324900 Laurel Crest
4112 N Highway 14
Greer, SC 29651
10/1/18 285000 None
250/254 Morgan Road
Wellford, SC 29385
9/19/18 275000 None
1200 Macedonia Church Road
Campobello, SC 29322
10/5/18 269000 None
237 Lyman Lake Road
Lyman, SC 29365
8/13/18 265000 None
143 Woodland Avenue
Inman, SC 29349
10/3/18 259900 Copper Creek
823 W Keepsake Lane
Inman, SC 29349
9/18/18 254900 Manzanares
167 Edwards Store Road
Lyman, SC 29365
9/5/18 245900 Other
124 Hogan Circle
Inman, SC 29349-9569
10/4/18 240000 Mountain Valley
144 Neely Mill Road
Greer, SC 29651
8/14/18 239900 None
130 Riverwalk Drive
Lyman, SC 29365
8/31/18 239900 The Village at Riverwalk
120 Pine Tree Road
Inman, SC 29349
9/12/18 239000 None
20 Lebanon Court
Greer, SC 29651
10/9/18 238900 Flagstone Village
1611 Ballenger Road
Wellford, SC 29385
8/13/18 238000 None
224 Winding Creek Way
Lyman, SC 29365
8/21/18 229900 Winding Creek
880 Ballenger Road
Inman, SC 29349
8/3/18 229900 None

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.