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" = 163673) 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"."elementary_school" IN (campobello-gramling) OR "idx_listings"."middle_school" IN (campobello-gramling) OR "idx_listings"."high_school" IN (campobello-gramling)) AND "idx_listings"."updated" > 2018-10-14 09:51:44.831985) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-8 of 17 Listings

$2,700,000

1300 Patterson Road

Campobello, SC

5 BDs, 4 BAs

MLS: 1378178

 

Source: Greater Greenville Association of REALTORS®

John Fravel - Century 21 Blackwell & Co

$1,050,000

1125 DICKSON Road

Campobello, SC

4 BDs, 3 BAs

MLS: 1365805

 

Source: Greater Greenville Association of REALTORS®

Haro Setian - Keller Williams Historic Dist.

REDUCED

$799,000

2410 Redland Road

Campobello, SC

4 BDs, 4 BAs

MLS: 1364792

Other

Source: Greater Greenville Association of REALTORS®

Roberta Heinrich - Walker, Wallace & Emerson Rlty

$699,900

2471 Holly Springs Road

Inman, SC

4 BDs, 3 BAs

MLS: 1378055

 

Source: Greater Greenville Association of REALTORS®

Teresa Holbrooks - Exp Realty Llc

$630,000

845 Smith Chapel Road

Campobello, SC

4 BDs, 4 BAs

MLS: 1345814

 

Source: Greater Greenville Association of REALTORS®

George Gramling - Gramling Real Estate

REDUCED

$549,900

2471 Holly Springs Road

Inman, SC

4 BDs, 3 BAs

MLS: 1370473

 

Source: Greater Greenville Association of REALTORS®

Teresa Holbrooks - Exp Realty Llc

REDUCED

$475,000

370 Farmer Road

Campobello, SC

4 BDs, 2 BAs

MLS: 1371870

 

Source: Greater Greenville Association of REALTORS®

LeAnne Carswell - Expert Real Estate Team

REDUCED

$469,000

475 Cole Road

Campobello, SC

3 BDs, 2 BAs

MLS: 1371464

 

Source: Greater Greenville Association of REALTORS®

Connie Budurka - Keller Williams Realty

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
1481 Ballenger Road
Wellford, SC 29385
8/28/18 695000 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
126 Grand Canyon Road
Inman, SC 29349
9/6/18 399990 Other
10654 Highway 11
Campobello, SC 29322
10/1/18 369950 None
382 Hillside Drive
Inman, SC 29349
7/30/18 344900 None
534 Laurel Crest Drive
Inman, SC 29349
10/2/18 324900 Laurel Crest
385 Lake Road
Inman, SC 29349
8/17/18 319500 None
1027 Rock Hill Church Road
Inman, SC 29349
8/15/18 275000 None
1200 Macedonia Church Road
Campobello, SC 29322
10/5/18 269000 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
222 Natures Court
Campobello, SC 29322
9/14/18 245000 Other
124 Hogan Circle
Inman, SC 29349-9569
10/4/18 240000 Mountain Valley
334 Meadow Road
Inman, SC 29349
10/1/18 239500 Other
1611 Ballenger Road
Wellford, SC 29385
8/13/18 238000 None
880 Ballenger Road
Inman, SC 29349
8/3/18 229900 None
824 W Keepsake Lane
Inman, SC 29349
8/20/18 225900 Manzanares
111 Millstone Drive
Campobello, SC 29322
9/4/18 224900 Old Mill Estate
1581 Ballenger Road
Wellford, SC 29385
8/31/18 222000 None
13718 Highway 11
Campobello, SC 29322-8700
9/26/18 220000 Other
819 W Keepsake Lane
Inman, SC 29349
8/1/18 219900 Manzanares
105 Millstone Drive
Campobello, SC 29322
8/30/18 218900 Old Mill Estate
2281 Old Mill Road
Campobello, SC 29322
10/1/18 216900 None
828 W Keepsake Lane
Inman, SC 29349
8/31/18 215400 Manzanares