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-07-14 20:07:59.031860) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-8 of 17 Listings

$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

REDUCED

$695,000

1481 Ballenger Road

Wellford, SC

5 BDs, 4 BAs

MLS: 1367525

 

Source: Greater Greenville Association of REALTORS®

John Fravel - Century 21 Blackwell & Co

$650,000

2471 Holly Springs Road

Inman, SC

4 BDs, 3 BAs

MLS: 1370473

 

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

CONTINGENCY CONTRACT

$524,900

3003 Motlow Creek Road

Campobello, SC

4 BDs, 3 BAs

MLS: 1364127

Motlow Creek

Source: Greater Greenville Association of REALTORS®

Tawana Porter - Hometown Real Estate

REDUCED

$500,000

485 Motlow Creek Road

Campobello, SC

3 BDs, 3 BAs

MLS: 1336568

 

Source: Greater Greenville Association of REALTORS®

Kathleen Toomey - New View Realty Llc

NEW

$490,000

370 Farmer Road

Campobello, SC

4 BDs, 2 BAs

MLS: 1371870

 

Source: Greater Greenville Association of REALTORS®

LeAnne Carswell - The Leanne Carswell Expert Re

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
124 Carbandy Drive
Inman, SC 29349
5/11/18 349900 Gramling Hill
522 Laurel Crest Drive
Inman, SC 29349
6/1/18 334900 Laurel Crest
450 Meadow Road
Inman, SC 29349
6/8/18 315000 None
611 Holden Road
Inman, SC 29349
4/30/18 279000 None
725 Holston Creek Church Road
Inman, SC 29349
5/4/18 269900 Gramling Hill
364 Roy Hall Way
Campobello, SC 29322
6/28/18 265000 Canecreek
126 McIntosh Lane
Inman, SC 29349
6/22/18 238000 Other
615 Farms Bridge Road
Inman, SC 29349
4/23/18 232500 None
1540 Ballenger Road
Wellford, SC 29385
5/21/18 229000 Carriage Gate
251 Gala Lane
Inman, SC 29349
5/17/18 225900 Manzanares
167 Cothran Road
Inman, SC 29349
6/5/18 219900 None
336 Edwards Road
Inman, SC 29349
5/25/18 219900 None
342 Baywood Drive
Campobello, SC 29322
4/20/18 209000 Orchard Grove
254 Gala Lane
Inman, SC 29349
4/27/18 201400 Manzanares
5469 New Cut Road
Inman, SC 29349
5/7/18 189900 None
611 E Keepsake Lane
Inman, SC 29349
5/9/18 186900 Manzanares
365 Granny Doris Boulevard
Inman, SC 29349
6/25/18 184900 Johnson Fields - 015
11 Littlefield Street
Inman, SC 20349
4/30/18 179900 None
100 Turner Barton Road
Landrum, SC 29356
5/16/18 164900 Other
175 Inn View Drive
Inman, SC 29349
6/29/18 160000 Other
27 S Main Street
Inman, SC 29349
7/6/18 155000 None
6636 357 Highway
Campobello, SC 29322
6/20/18 139900 None
123 Holly Tree Lane
Inman, SC 29349
5/30/18 134900 Other
125 Harrison Pond Road
Campobello, SC 29322
5/14/18 119900 Other
743 E Fleming Farm Drive
Inman, SC 29349
5/29/18 117900 Other