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 (berea heights) AND "idx_listings"."updated" > 2018-07-15 13:30:48.169401) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-1 of 1 Listings

CONTINGENCY CONTRACT

$149,900

5 Moonshell Court

Greenville, SC

3 BDs, 2 BAs

MLS: 1369598

Berea Heights

Source: Greater Greenville Association of REALTORS®

Kennie Norris - Blackstream International Re

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
707 E McBee Park
Greenville, SC 29601
7/13/18 1249000 McBee Park
303 Crescent Avenue
Greenville, SC 29605
5/3/18 1195000 Alta Vista
201 Riverplace Way
Greenville, SC 29601
5/21/18 899000 Terrace at RiverPlace
18 Paddington Avenue
Greenville, SC 29609
6/22/18 875000 Avondale West
1306 Augusta Street
Greenville, SC 29605
6/13/18 795000 None
205 E Montclair Avenue
Greenville, SC 29609
6/28/18 735000 North Main
318 Jones Avenue
Greenville, SC 29605-2824
6/1/18 724500 Alta Vista
20 E Montclair Avenue
Greenville, SC 29609
6/26/18 675000 North Main
401 Jones Avenue
Greenville, SC 29605
7/11/18 650000 Alta Vista
100 W Court Street
Greenville, SC 29601
5/15/18 650000 Court St Condos
403 Watts Avenue
Greenville, SC 29601
6/15/18 599601 Alta Vista
716 Villaggio Drive
Greenville, SC 29609
6/28/18 579900 Montebello
214 Aberdeen Drive
Greenville, SC 29605
6/15/18 575000 Augusta Road
7 James Street
Greenville, SC 29609
5/1/18 565000 None
4 CROFT Street
Greenville, SC 29609
4/26/18 559900 North Main
112 W Broad Street
Greenville, SC 29601
5/17/18 549500 Poinsett Corners
208 Gibbs Street
Greenville, SC 29601
5/7/18 549100 Downtown
26 Grove Valley Way
Greenville, SC 29605
7/2/18 549000 Ivy Grove
101 W Avondale Drive
Greenville, SC 29609
6/28/18 547000 North Main
608 Carilion Lane
Greenville, SC 29617
6/29/18 509795 Carilion
14 Parkside Drive
Greenville, SC 29609
6/22/18 499900 North Main
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
108 Arlington Avenue
Greenville, SC 29601
6/14/18 475000 None

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.
Site Maintenance
at 8 p.m. EDT
(Click for details)