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" = 171305) 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 (chapman) OR "idx_listings"."middle_school" IN (chapman) OR "idx_listings"."high_school" IN (chapman)) AND "idx_listings"."updated" > 2018-02-23 21:08:49.159361) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-8 of 64 Listings

$1,200,000

161 Deyoung Road

Lyman, SC

7 BDs, 6 BAs

MLS: 1359910

 

Source: Greater Greenville Association of REALTORS®

JANICE PARKKONEN - Greer Real Estate Company

$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

$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

$489,000

2075 Mt. Lebanon Road

Campobello, SC

3 BDs, 3 BAs

MLS: 1360845

 

Source: Greater Greenville Association of REALTORS®

Shaun Phillips - Shaun & Shari Realty

CONTINGENCY CONTRACT

$389,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

$350,000

616 W Star Drive

Lyman, SC

4 BDs, 2 BAs

MLS: 1353519

Sunset Point

Source: Greater Greenville Association of REALTORS®

Mary Babcock - Re/Max Moves Greer

$349,900

124 Carbandy Drive

Inman, SC

3 BDs, 3 BAs

MLS: 1361201

Gramling Hill

Source: Greater Greenville Association of REALTORS®

Flo Watson - The Ponce Realty Group, Llc

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
6371 New Cut Road
Inman, SC 29349
2/8/18 899000 None
1120 Wilkins Road
Inman, SC 29349
11/30/17 499900 Other
935 Lansfair Drive
Inman, SC 29349
12/29/17 379900 Cumberland Walk
705 Tinsberry Lane
Inman, SC 29349
1/31/18 374900 Cumberland Walk
100 Panorama Lane
Inman, SC 29349
1/22/18 319000 None
216 Carbandy Drive
Inman, SC 29349
1/19/18 304900 Other
366 Baywood Drive
Campobello, SC 29322
2/2/18 262200 Other
807 W Keepsake Lane
Inman, SC 29349
1/2/18 240000 Manzanares
275 Gala Lane
Inman, SC 29349
2/16/18 239000 Manzanares
605 E Keepsake Lane
Inman, SC 29349
11/30/17 221400 Manzanares
125 Apple Grove Drive
Inman, SC 29349
12/14/17 218900 Manzanares
255 Gala Lane
Inman, SC 29349
2/15/18 218400 Manzanares
1661 Ballenger Road
Inman, SC 29349
1/31/18 210000 Other
415 Bradburn Fields Court
Inman, SC 29349
1/31/18 208900 Manzanares
1620 Ballenger Road
Wellford, SC 29385
2/12/18 194800 Other
540 Brashears Road
Campobello, SC 29322
12/13/17 191000 Brashears Commons 014
330 Caxton Farms Court
Inman, SC 29349
12/14/17 189900 Mitchell Farms S
871 W Keepsake Lane
Inman, SC 29349
12/12/17 176800 Manzanares
322 HALLIE OLIVIA Drive
Inman, SC 29349
2/5/18 172900 Copper Leaf
244 Cooley Circle
Campobello, SC 29303
2/9/18 171500 None
708 Holtfield Terrace
Spartanburg, SC 29303
1/31/18 164500 Other
2515 Motlow Creek Road
Campobello, SC 29322
1/12/18 162000 None
300 Brown Arrow Circle
Inman, SC 29349
1/31/18 160900 Green Acres
529 Nature Walk Way
Inman, SC 29349
1/8/18 155000 Woods Creek Crossing
292 Brown Arrow Circle
Inman, SC 29349
2/1/18 144900 Green Acres