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

1-8 of 51 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

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

$334,900

522 Laurel Crest Drive

Inman, SC

3 BDs, 2 BAs

MLS: 1360178

Laurel Crest

Source: Greater Greenville Association of REALTORS®

Sandy Clayton - Keller Williams Grv Upst

$325,000

450 Meadow Road

Inman, SC

5 BDs, 3 BAs

MLS: 1359769

 

Source: Greater Greenville Association of REALTORS®

Kim Stroud - Keller Williams Grv Upst

CONTINGENCY CONTRACT

$293,500

431 Sunset Pointe Drive

Lyman, SC

3 BDs, 3 BAs

MLS: 1355161

Other

Source: Greater Greenville Association of REALTORS®

JANICE PARKKONEN - Greer Real Estate Company

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
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
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
244 Cooley Circle
Campobello, SC 29303
2/9/18 171500 None
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
296 Brown Arrow Circle
Inman, SC 29349
2/1/18 142900 Green Acres
342 Bishop Hicks Court
Inman, SC 29349
1/30/18 135000 Other
616 Ezra Court
Inman, SC 29349
2/22/18 123900 Other
2904 Mount Lebanon Road
Campobello, SC 29322
1/5/18 115000 None
1279 Little Mountain Road
Wellford, SC 29385
12/11/17 89900 None