to
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" = 173423) 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"."subdivision" IN (fairmont ridge) AND "idx_listings"."updated" > 2018-08-20 02:16:18.590029) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-4 of 4 Listings

$198,888

191 Fair Orchard Way

Duncan, SC

3 BDs, 2 BAs

MLS: 1369867

Fairmont Ridge

Source: Greater Greenville Association of REALTORS®

Jessica Stone - Exp Realty Llc

NEW

$187,500

417 Pangel Lane

Duncan, SC

3 BDs, 2 BAs

MLS: 1374473

Fairmont Ridge

Source: Greater Greenville Association of REALTORS®

Robbie Haney - Bhhs C Dan Joyner - N. Pleas

REDUCED

$170,990

337 Hague Drive

Duncan, SC

3 BDs, 2 BAs

MLS: 1360751

Fairmont Ridge

Source: Greater Greenville Association of REALTORS®

Stacy Rector - Dan Ryan Builders

REDUCED

$167,990

369 Hague Drive

Duncan, SC

3 BDs, 2 BAs

MLS: 1367114

Fairmont Ridge

Source: Greater Greenville Association of REALTORS®

Stacy Rector - Dan Ryan Builders

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
190 Sloan Road
Lyman, SC 29365
7/27/18 699900 Other
1633 Hampton Road
Inman, SC 29349
8/10/18 699900 Other
120 Carshalton Drive
Lyman, SC 29365
7/10/18 444900 Carshalton By The Bay
151 Lake Lyman Heights
Lyman, SC 29365
8/14/18 437500 None
125 Teal Drive
Wellford, SC 29385-9777
8/6/18 369900 None
467 Sunset Pointe Drive
Lyman, SC 29365
6/27/18 340000 Sunset Point
522 Laurel Crest Drive
Inman, SC 29349
6/1/18 334900 Laurel Crest
3111 E Gap Creek Road
Greer, SC 29651
8/8/18 329900 None
341 Reflection Drive
Lyman, SC 29365
6/25/18 329800 Carshalton By The Bay
116 Floyd Meadow Drive
Inman, SC 29349
7/9/18 274900 Patterson Estates
365 Lyman Lake Road
Lyman, SC 29365
7/3/18 269900 None
237 Lyman Lake Road
Lyman, SC 29365
8/13/18 265000 None
351 Laura Faye Lane
Lyman, SC 29365
6/15/18 265000 Gabriel Point
225 Holly Drive
Duncan, SC 29334-9144
7/10/18 256900 Other
282 Springlake Estates Drive
Lyman, SC 29365
8/1/18 249900 Spring Lake Estates
222 Chelsea Nicole Drive
Lyman, SC 29365-9221
8/1/18 239900 Other
566 Shrine Court
Lyman, SC 29365
7/13/18 239425 Shiloh Farm
545 Shrine Court
Lyman, SC 29365
6/21/18 239020 Shiloh Farm
1611 Ballenger Road
Wellford, SC 29385
8/13/18 238000 None
147 Lyman Lake Road
Lyman, SC 29365
6/29/18 232900 Other
880 Ballenger Road
Inman, SC 29349
8/3/18 229900 None
478 Silver Thorne Drive
Wellford, SC 29385
7/24/18 228900 Blackberry Farms (015)
577 Friar Park Lane
Lyman, SC 29365
7/27/18 224990 Highland Hills
507 Bridgetowne Court
Lyman, SC 29635
7/1/18 224880 Ridge Water
469 Bollweevil Way
Wellford, SC 29385
8/10/18 220000 Other

Robert Haney, REALTOR®


Luxury Collection Specialist, Marketing Specialist, High End Luxury Homes
Berkshire Hathaway HomeServices/C. Dan Joyner REALTORS®
745 N Pleasantburg Dr., Greenville, SC 29607

864-270-4192

Paige Haney, REALTOR®


Luxury Collection Specialist, SFR, Certified Relocation Specialist
Berkshire Hathaway HomeServices/C. Dan Joyner REALTORS®
705 W. Wade Hampton Blvd., Greer, SC 29650

864-414-9937

Equal Housing Oppoortunity
Information is deemed reliable but not guaranteed, and is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify perspective properties consumers may be interested in purchasing. Any use of search facilities of data on the site other than by potential buyers and sellers is prohibited. Sale data is for informational purposes only and is not an indication of a market analysis or appraisal.

All code, applications and designs © 2014-present EASy Media, LLC. All right reserved. Operating under US Patent 8234174 and other Patents Pending.