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 (fairforest) OR "idx_listings"."middle_school" IN (fairforest) OR "idx_listings"."high_school" IN (fairforest)) AND "idx_listings"."updated" > 2018-08-17 00:17:19.003948) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-8 of 24 Listings

REDUCED

$369,900

1231 Mount Zion Road

Spartanburg, SC

5 BDs, 3 BAs

MLS: 1356608

 

Source: Greater Greenville Association of REALTORS®

Dianne Wofford - Better Homes & Gardens Young &

REDUCED

$283,947

606 Big Oak Court

Inman, SC

5 BDs, 3 BAs

MLS: 1364899

Cool Waters

Source: Greater Greenville Association of REALTORS®

Andrea Looper - New Home Star Sc, Llc

REDUCED

$280,996

420 Majestic View Court

Inman, SC

4 BDs, 3 BAs

MLS: 1364894

Cool Waters

Source: Greater Greenville Association of REALTORS®

Andrea Looper - New Home Star Sc, Llc

CONTINGENCY CONTRACT

$246,900

991 Shoresbrook Road

Spartanburg, SC

4 BDs, 2 BAs

MLS: 1374105

Planters Walk

Source: Greater Greenville Association of REALTORS®

Jeanie Nethery - Keller Williams Realty

$242,900

371 Hickory Hollow Road

Inman, SC

4 BDs, 2 BAs

MLS: 1373997

Other

Source: Greater Greenville Association of REALTORS®

Donna Morrow - Coldwell Banker Caine Real Est

CONTINGENCY CONTRACT

$239,500

7 Lismore Court

Inman, SC

4 BDs, 2 BAs

MLS: 1372693

Waterford

Source: Greater Greenville Association of REALTORS®

Trish Hollon - Coldwell Banker Caine Real Est

REDUCED

$227,214

360 Swift Water Lane

Inman, SC

3 BDs, 2 BAs

MLS: 1363291

Cool Waters

Source: Greater Greenville Association of REALTORS®

Andrea Looper - New Home Star Sc, Llc

$225,777

718 W Dateria Way

Inman, SC

3 BDs, 2 BAs

MLS: 1373905

Bush Fork

Source: Greater Greenville Association of REALTORS®

Lisa Ebersole - Dempsey Properties, Llc

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
208 Woodlake Drive
Spartanburg, SC 29301
7/26/18 599900 Woodlake
825 Southern Magnolia Court
Spartanburg, SC 29301
7/27/18 549900 Magnolia Park Estates
412 Danbury Court
Spartanburg, SC 29301
7/10/18 500000 Woodridge
118 Woodridge Drive
Spartanburg, SC 29301
7/26/18 450000 Woodridge
457 S Oakley Lane
Spartanburg, SC 29301
7/26/18 424900 Hawkcreek
311 Burro Court
Boiling Springs, SC 29316
7/31/18 419900 Other
822 Oakcrest Road
Spartanburg, SC 29301
6/13/18 415000 Woodridge
760 Glenridge Road
Spartanburg, SC 29301
7/20/18 415000 Woodridge
115 Dunwoody Way
Spartanburg, SC 29301
6/29/18 400000 Woodridge
105 MonReve Drive
Boiling Springs, SC 29316
6/14/18 399900 MonReve Village
317 ashwick Court
Spartanburg, SC 29301-5609
7/17/18 389900 Shadowlakes
332 Kennesaw Court
Spartanburg, SC 29301
8/8/18 385000 Woodridge
125 Teal Drive
Wellford, SC 29385-9777
8/6/18 369900 None
226 Longleaf Road
Spartanburg, SC 29301
7/27/18 348500 Woodridge
453 S Oakley Lane
Spartanburg, SC 29301
6/29/18 347500 Hawkcreek
630 Ship Wreck Place
Inman, SC 29349
8/17/18 345900 Lake Emory
172 W Woodglen Road
Spartanburg, SC 29301
7/27/18 304900 Woodridge
233 N Radcliff Way
Spartanburg, SC 29301
7/13/18 299900 The Pointe at Rock Springs
414 E Woodbury Lane
Spartanburg, SC 29301
7/12/18 289900 Woodridge
504 Planters Rest Lane
Inman, SC 29349
8/9/18 284900 Sugar Ridge
223 Slate Drive
Boiling Springs, SC 29316
7/13/18 237579 Hanging Rock
478 Silver Thorne Drive
Wellford, SC 29385
7/24/18 228900 Blackberry Farms (015)
469 Bollweevil Way
Wellford, SC 29385
8/10/18 220000 Other
329 Slate Drive
Boiling Springs, SC 29316
8/1/18 219900 Hanging Rock
21 Glen Eagle Place
Spartanburg, SC 29301
7/31/18 218900 Shoresbrook