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" 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 (mabry) OR "idx_listings"."middle_school" IN (mabry) OR "idx_listings"."high_school" IN (mabry)) AND "idx_listings"."updated" > 2017-12-13 22:22:20.165992) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-8 of 51 Listings

$825,000

274 Bertha Burns Road

Inman, SC

4 BDs, 3 BAs

MLS: 1352809

 

Source: Greater Greenville Association of REALTORS®

Jan Walker - Bhhs C Dan Joyner - Greer

$750,000

1700 Foster Road

Inman, SC

5 BDs, 4 BAs

MLS: 1351707

 

Source: Greater Greenville Association of REALTORS®

Kim Stroud - Keller Williams Grv Upst

$750,000

411 Bradley Dill Road

Campobello, SC

4 BDs, 2 BAs

MLS: 1347504

 

Source: Greater Greenville Association of REALTORS®

LeAnne Carswell - The Leanne Carswell Expert Re

$460,000

479 Sunset Pointe Drive

Lyman, SC

5 BDs, 3 BAs

MLS: 1352219

Sunset Point

Source: Greater Greenville Association of REALTORS®

Richard Escher - Carol Pyfrom Realty

REDUCED

$449,900

455 Grassland Road

Campobello, SC

3 BDs, 3 BAs

MLS: 1348499

 

Source: Greater Greenville Association of REALTORS®

Kelly Vogel - Keller Williams Realty

$399,900

217 Hammett Road

Wellford, SC

4 BDs, 3 BAs

MLS: 1355884

Other

Source: Greater Greenville Association of REALTORS®

Gary Heinecke - 1 Stop Realty

CONTINGENCY CONTRACT

$379,900

935 Lansfair Drive

Inman, SC

4 BDs, 4 BAs

MLS: 1346929

Cumberland Walk

Source: Greater Greenville Association of REALTORS®

LeAnne Carswell - The Leanne Carswell Expert Re

CONTINGENCY CONTRACT

$374,900

705 Tinsberry Lane

Inman, SC

4 BDs, 4 BAs

MLS: 1354923

Cumberland Walk

Source: Greater Greenville Association of REALTORS®

Buddy Huffman - Keller Williams Grv Upst

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
281 Weatherly Road
Inman, SC 29349
10/27/17 525000 None
1120 Wilkins Road
Inman, SC 29349
11/30/17 499900 Other
412 Rockcove Road
Inman, SC 29349
9/28/17 450000 Other
251 Bertha Burns Road
Inman, SC 29349
10/23/17 429900 None
501 Ben Johnson Road
Inman, SC 29349
11/27/17 275000 None
380 Hickory Hollow Road
Inman, SC 29349
11/17/17 265000 Other
365 Lyman Lake Road
Lyman, SC 29365
11/13/17 239000 None
1320 Holly Springs Church Road
Campobello, SC 29322
9/21/17 234900 None
1710 Ballenger Road
Wellford, SC 29385
11/3/17 224900 Carriage Gate
605 E Keepsake Lane
Inman, SC 29349
11/30/17 221400 Manzanares
1301 Holly Springs Church Road
Campobello, SC 29322
10/31/17 220000 None
559 Holly Belle Drive
Lyman, SC 29365
11/17/17 219900 Holly Belle
276 Gala Lane
Inman, SC 29349
9/27/17 211400 Manzanares
930 Grand Canyon Road
Inman, SC 29349
10/23/17 210000 Other
278 Lamp Post Road
Inman, SC 29349
12/6/17 199900 Other
744 Baldwin Orchard Drive
Inman, SC 29349
11/3/17 195900 Manzanares
540 Brashears Road
Campobello, SC 29322
12/13/17 191000 Brashears Commons 014
871 W Keepsake Lane
Inman, SC 29349
12/12/17 176800 Manzanares
9 Mitchell Farm Road
Inman, SC 29349
11/2/17 175000 Mitchell Farms S
258 Gala Lane
Inman, SC 29349
11/9/17 169900 Manzanares
140 Morrow Road
Landrum, SC 29356
10/25/17 164900 None
151 Jarvis Road
Inman, SC 29349
10/31/17 109999 None
568 Franklin Asberry Lane
Inman, SC 29349
10/6/17 109900 Other
1279 Little Mountain Road
Wellford, SC 29385
12/11/17 89900 None
18 E Street
Inman, SC 29349
11/10/17 73000 None