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" = 163882) AND UPPER("idx_listings"."proptype"::text) LIKE UPPER(res%) AND "idx_listings"."created" > 1744-07-05 22:49:04.030684 AND "idx_listings"."price" >= 0 AND "idx_listings"."price" <= 10000000 AND "idx_listings"."beds" >= 0 AND "idx_listings"."baths" >= 0 AND ("idx_listings"."elementary_school" IN (OVERHILLS SENIOR HIGH) OR "idx_listings"."middle_school" IN (OVERHILLS SENIOR HIGH) OR "idx_listings"."high_school" IN (OVERHILLS SENIOR HIGH)) AND "idx_listings"."updated" > 2018-04-17 22:49:04.030648) ORDER BY "idx_listings"."price" DESC LIMIT 100

1-8 of 100 Listings

$575,000

452 FALLING WATER

SPRING LAKE, NC

7 BDs, 4 BAs

MLS: 536906

Anderson Creek Club

Source: Fayetteville Regional Association of REALTORS®

REDUCED

$575,000

231 BROADLAKE LANE

SPRING LAKE, NC

6 BDs, 6 BAs

MLS: 510145

Anderson Creek Club

Source: Fayetteville Regional Association of REALTORS®

PENDING

$549,990

119 PELICAN COURT

SANFORD, NC

6 BDs, 4 BAs

MLS: 533421

Carolina Lakes

Source: Fayetteville Regional Association of REALTORS®

$549,700

76 MICAHS WAY N

SPRING LAKE, NC

4 BDs, 3 BAs

MLS: 539425

Anderson Creek Club

Source: Fayetteville Regional Association of REALTORS®

$519,990

75 SUMMER CREEK LANE

SANFORD, NC

6 BDs, 5 BAs

MLS: 531038

Carolina Lakes

Source: Fayetteville Regional Association of REALTORS®

PENDING

$479,990

209 CLEARVIEW COURT

SANFORD, NC

5 BDs, 4 BAs

MLS: 516679

Carolina Lakes

Source: Fayetteville Regional Association of REALTORS®

$464,900

115 MICAHS WAY N

SPRING LAKE, NC

4 BDs, 3 BAs

MLS: 535968

Anderson Creek Club

Source: Fayetteville Regional Association of REALTORS®

$464,900

127 SKIPPING WATER DRIVE

SPRING LAKE, NC

4 BDs, 3 BAs

MLS: 534329

Anderson Creek Club

Source: Fayetteville Regional Association of REALTORS®

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
351 BARONS RUN WEST
SPRING LAKE, NC 28390
3/16/18 599000 ANDERSON CREEK CLUB
87 PELICAN COURT
SANFORD, NC 27332
3/16/18 499990 CAROLINA LAKES
125 SUMMER CREEK LANE
SANFORD, NC 27332
1/17/18 469990 CAROLINA LAKES
96 PELICAN COURT
SANFORD, NC 27332
3/19/18 439990 CAROLINA LAKES
342 LAKESIDE LANE
SANFORD, NC 27332
4/5/18 409000 CAROLINA LAKES
375 WHISPERING PINES DRIVE
SPRING LAKE, NC 28390
1/22/18 359900 ANDERSON CREEK CLUB
1804 MICAHS WAY NORTH
SPRING LAKE, NC 28390
1/31/18 359000 ANDERSON CREEK CLUB
15 EDGEMONT TER
SANFORD, NC 27332
3/19/18 349990 CAROLINA LAKES
32 SCHOLAR DRIVE
SPRING LAKE, NC 28390
1/22/18 327400 ANDERSON CREEK CLUB
68 GLEN BEND COURT
SPRING LAKE, NC 28390
2/16/18 319900 ANDERSON CREEK CLUB
645 ANDERSON CREEK DR
SPRING LAKE, NC 28390
3/23/18 309900 ANDERSON CREEK CLUB
611 CAROLINA WAY
SANFORD, NC 27332
3/1/18 309900 CAROLINA LAKES
15 OAK LANDING
SANFORD, NC 27332
1/19/18 309000 CAROLINA LAKES
116 MOSSBURG CT
BUNNLEVEL, NC 28323
2/28/18 299900 GATEWEST
180 CROWN PT
SANFORD, NC 27332
3/5/18 297500 CAROLINA LAKES
169 GLENWOOD COURT
SPRING LAKE, NC 28390
3/16/18 297177 ANDERSON CREEK CLUB
489 FALLING WATER ROAD
SPRING LAKE, NC 28390
4/4/18 295999 ANDERSON CREEK CLUB
106 VALLEY STREAM RD
SPRING LAKE, NC 28390
4/2/18 294900 ANDERSON CREEK CLUB
97 CLEARVIEW CT
SANFORD, NC 27332
3/16/18 293500 CAROLINA LAKES
34 WICKER CIRCLE
SPRING LAKE, NC 28390
4/5/18 292800 ANDERSON CREEK CLUB
495 WHISPERING PINES DRIVE
SPRING LAKE, NC 28390
4/2/18 289900 ANDERSON CREEK CLUB
95 GRAYSON PLACE
SANFORD, NC 27332
4/9/18 289900 CAROLINA LAKES
35 QUAIL HOLLOW
SANFORD, NC 27332
4/11/18 285000 CAROLINA LAKES
600 SEA MIST DRIVE
SANFORD, NC 27332
1/24/18 274990 CAROLINA LAKES
319 PITTFIELD RUN
CAMERON, NC 28326
3/27/18 266671 THE MANORS AT LEXINGTON PLAN