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 (andrews farm) AND "idx_listings"."updated" > 2018-08-19 22:14:44.088771) ORDER BY "idx_listings"."price" DESC LIMIT 500

1-3 of 3 Listings

REDUCED

$850,000

1031 Andrews Farm Road

Spartanburg, SC

4 BDs, 3 BAs

MLS: 1349541

Andrews Farm

Source: Greater Greenville Association of REALTORS®

Lewis White - The W Lewis White Co Inc

REDUCED

$675,000

1415 THORNWOOD Drive

Spartanburg, SC

4 BDs, 5 BAs

MLS: 1329673

Andrews Farm

Source: Greater Greenville Association of REALTORS®

Lewis White - The W Lewis White Co Inc

REDUCED

$649,000

1340 Pinecrest Road

Spartanburg, SC

5 BDs, 3 BAs

MLS: 1365222

Andrews Farm

Source: Greater Greenville Association of REALTORS®

Peggy Wilson - Legacy Real Estate, Inc.

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
337 Hidden Creek Circle
Spartanburg, SC 29306
6/6/18 975000 Carolina Country Club
571 E Main Street
Spartanburg, SC 29302
6/29/18 840000 Converse Heights
1 Twin Oaks Court
Spartanburg, SC 29306
6/29/18 825000 Carolina Country Club
340 Hidden Creek Circle
Spartanburg, SC 29306
6/21/18 499900 Carolina Country Club
211 Indian Wells Drive
Spartanburg, SC 29306
8/6/18 479900 Carolina Country Club
656 Maple Street
Spartanburg, SC 29302
6/4/18 359000 Converse Heights
492 Mockingbird Lane
Spartanburg, SC 29307
7/31/18 349999 Lake Forest Hill
606 Perrin Drive
Spartanburg, SC 29307
7/12/18 314900 Hillbrook Forest
619 Poplar Street
Spartanburg, SC 29302
5/29/18 312000 Converse Heights
736 Maple Street
Spartanburg, SC 29302
8/3/18 254900 Converse Heights
205 Beechwood Drive
Spartanburg, SC 29307
7/27/18 249900 Fernwood
516 Dragonfly Court
Roebuck, SC 29376
7/12/18 231600 Four Seasons
170 Winfield Drive
Spartanburg, SC 29307
6/25/18 199900 Hillbrook
107 Eastwood Circle
Spartanburg, SC 29302
5/31/18 178500 Converse Heights
4630 S Pine Street
Spartanburg, SC 29302
7/9/18 175000 None
122 Saint James Drive
Spartanburg, SC 29301
7/31/18 169923 Woodland Heights
424 South Meadow Drive
Spartanburg, SC 29306
8/10/18 166500 Other
214 Aberdeen Lane
Spartanburg, SC 29307
7/27/18 144900 Other
133 Floy Street
Spartanburg, SC 29301
6/27/18 140000 Woodland Heights
106 Butternut Road
Spartanburg, SC 29306
5/29/18 139777 Meadowind Farms
215 Tucker Road
Spartanburg, SC 29306
7/30/18 134900 Other
1391 Highway 56
Spartanburg, SC 29302
7/10/18 125000 None
150 Evvalane Drive
Spartanburg, SC 29302
8/10/18 123490 Vista Hills
903 Lucerne Drive
Spartanburg, SC 29302
6/11/18 120000 Other
141 Cardinal Street
Spartanburg, SC 29302
8/10/18 119777 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.