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 (belmont) AND "idx_listings"."updated" > 2018-10-13 05:59:43.670972) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-1 of 1 Listings

NEW

$187,900

874 Affirmed Drive

Boiling Springs, SC

3 BDs, 2 BAs

MLS: 1378297

Belmont

Source: Greater Greenville Association of REALTORS®

Cindy Collins - The Ponce Realty Group, Llc

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
114 Club Pointe Drive
Spartanburg, SC 29302
8/31/18 695000 Other
207 Muirfield Drive
Spartanburg, SC 29306
8/17/18 599000 Carolina Country Club
807 Inverness Circle
Spartanburg, SC 29306
9/4/18 489000 Carolina Country Club
211 Indian Wells Drive
Spartanburg, SC 29306
8/6/18 479900 Carolina Country Club
118 Woodridge Drive
Spartanburg, SC 29301
7/26/18 450000 Woodridge
492 Mockingbird Lane
Spartanburg, SC 29307
7/31/18 349999 Lake Forest Hill
226 Longleaf Road
Spartanburg, SC 29301
7/27/18 348500 Woodridge
3071 Carolina Country Club Road
Spartanburg, SC 29306
8/17/18 287900 None
736 Maple Street
Spartanburg, SC 29302
8/3/18 254900 Converse Heights
205 Beechwood Drive
Spartanburg, SC 29307
7/27/18 249900 Fernwood
438 Maplecroft Street
Spartanburg, SC 29303
7/30/18 215000 North River Hills
253 Medoc Lane
Moore, SC 29369
8/14/18 213500 Bordeaux
249 Medoc Lane
Moore, SC 29369
9/27/18 209900 Bordeaux
110 Roswell Terrace
Spartanburg, SC 29307
8/22/18 200000 Heatherwood
415 Ransdell Drive
Spartanburg, SC 29307
9/7/18 200000 Hillbrook Forest
147 Bradford Drive
Moore, SC 29369
9/11/18 193500 Other
307 Londonberry Drive
Spartanburg, SC 29301
8/14/18 189900 Shannon Forest
293 Zimmerman Lake Road
Spartanburg, SC 29306
8/31/18 184777 None
412 Perrysburg Lane
Moore, SC 29369
9/12/18 180000 None
442 Listrac Drive
Moore, SC 29369
8/23/18 175000 Bordeaux
433 Melbourne Lane
Spartanburg, SC 29301
7/30/18 174967 Westgate Plantation
67 Casey Lane
Spartanburg, SC 29301
8/17/18 174900 None
112 Redwood Circle
Spartanburg, SC 29301
9/13/18 174500 Camelot
214 Heather Drive
Spartanburg, SC 29301
9/19/18 172500 Camelot
122 Saint James Drive
Spartanburg, SC 29301
7/31/18 169923 Woodland Heights

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.