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 (fairway view) AND "idx_listings"."updated" > 2018-07-13 20:58:25.218894) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-2 of 2 Listings

CONTINGENCY CONTRACT

$349,000

108 Golf View Lane

Greenville, SC

4 BDs, 2 BAs

MLS: 1369173

Fairway View

Source: Greater Greenville Association of REALTORS®

Sara Younginer - Coldwell Banker Caine/Williams

CONTINGENCY CONTRACT

$269,900

8 Spyglass Court

Greenville, SC

4 BDs, 2 BAs

MLS: 1368170

Fairway View

Source: Greater Greenville Association of REALTORS®

Jim Fritzsche - Bhhs C Dan Joyner - Pelham

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
18 Paddington Avenue
Greenville, SC 29609
6/22/18 875000 Avondale West
14 Mossy Brook Trail
Travelers Rest, SC 29690
5/14/18 739900 Paris Mt Area
205 E Montclair Avenue
Greenville, SC 29609
6/28/18 735000 North Main
207 Chelsea Lane
Greer, SC 29650-3262
6/8/18 709000 Chelsea Woods
20 E Montclair Avenue
Greenville, SC 29609
6/26/18 675000 North Main
7 Prestige Court
Greenville, SC 29615
5/29/18 650000 Other
31 HIGHFIELD Court
Greer, SC 29650
5/25/18 624900 Hammett Creek
216 Sweetbriar Road
Greenville, SC 29615
6/15/18 619900 Lake Forest Heights
217 Terra Woods Drive
Greenville, SC 29615
6/15/18 610000 Terra Woods
6 Morgan Pond Drive
Greer, SC 29650
7/12/18 609500 Greywood at Hammett
716 Villaggio Drive
Greenville, SC 29609
6/28/18 579900 Montebello
20 Lowther Hall Lane
Greenville, SC 29615
4/30/18 575000 Plantation on Pelham
5 Terra Lane
Greenville, SC 29615
5/31/18 565000 Terra Oaks
6 Terrapin Trail
Taylors, SC 29687
6/15/18 565000 Pebble Creek
4 CROFT Street
Greenville, SC 29609
4/26/18 559900 North Main
101 W Avondale Drive
Greenville, SC 29609
6/28/18 547000 North Main
106 Raes Creek Drive
Greenville, SC 29609
6/22/18 514900 Linkside III
323 Raes Creek Drive
Greenville, SC 29609
5/10/18 510000 Linkside III
14 Parkside Drive
Greenville, SC 29609
6/22/18 499900 North Main
1045 Owens Road
Greer, SC 29651
4/27/18 495000 None
19 Arezzo Drive
Greenville, SC 29609
6/29/18 494900 Montebello
701 Montebello Drive
Greenville, SC 29609
5/4/18 487500 Montebello
100 Merritt View Terrace
Greenville, SC 29606-413
6/29/18 479900 None
12 Caliston Court
Greenville, SC 29615
6/29/18 459000 TINSLEY PLACE
723 Bennett Street
Greenville, SC 29609
6/6/18 449900 North Main

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.