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" = 164552) 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"."elementary_school" IN (cliffdale elementary) OR "idx_listings"."middle_school" IN (cliffdale elementary) OR "idx_listings"."high_school" IN (cliffdale elementary)) AND "idx_listings"."updated" > 2018-04-23 01:08:24.339072) ORDER BY "idx_listings"."price" DESC LIMIT 100

1-8 of 86 Listings

$194,000

5421 SUMMER DUCK RD

FAYETTEVILLE, NC

5 BDs, 4 BAs

MLS: 539705

Eden

Source: Fayetteville Regional Association of REALTORS®

PENDING

$135,000

5787 SONORA PLACE

FAYETTEVILLE, NC

3 BDs, 2 BAs

MLS: 534440

Morgan Place

Source: Fayetteville Regional Association of REALTORS®

PENDING

$127,000

809 NIGHTHAWK PL

FAYETTEVILLE, NC

3 BDs, 2 BAs

MLS: 540036

Glen Allen

Source: Fayetteville Regional Association of REALTORS®

NEW

$127,000

842 NIGHTHAWK PL

FAYETTEVILLE, NC

3 BDs, 2 BAs

MLS: 540374

Glen Allen

Source: Fayetteville Regional Association of REALTORS®

$126,500

415 OFFING DR.

FAYETTEVILLE, NC

3 BDs, 2 BAs

MLS: 538890

Waters Edge

Source: Fayetteville Regional Association of REALTORS®

$125,000

337 WHIPPLETREE LANE

FAYETTEVILLE, NC

3 BDs, 2 BAs

MLS: 539866

Waters Edge

Source: Fayetteville Regional Association of REALTORS®

PENDING

$123,900

5970 CHAMBRIAN DRIVE

FAYETTEVILLE, NC

3 BDs, 2 BAs

MLS: 534631

Wellington

Source: Fayetteville Regional Association of REALTORS®

NEW

$119,000

6028 DALTON RD

FAYETTEVILLE, NC

3 BDs, 2 BAs

MLS: 540303

Waters Edge

Source: Fayetteville Regional Association of REALTORS®

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
5724 WATERWOOD DRIVE
FAYETTEVILLE, NC 28314
3/1/18 139900 WATERS EDGE
405 WATERGAP DR
FAYETTEVILLE, NC 28314
2/27/18 132000 WATERS EDGE
424 LOBLOLLY CT
FAYETTEVILLE, NC 28314
3/29/18 124900 WATERS EDGE
808 NIGHTHAWK PL.
FAYETTEVILLE, NC 28314
3/13/18 124000 GLEN ALLEN
6940 CALLAHAN CIRCLE
FAYETTEVILLE, NC 28314
2/12/18 109000 GLENREILLY
7301 RYAN ST
FAYETTEVILLE, NC 28314
2/28/18 106900 LOCH LOMOND
520 HICKORYWOOD DR.
FAYETTEVILLE, NC 28314
2/16/18 106000 LOCH LOMOND
612 MARSHTREE LN
FAYETTEVILLE, NC 28314
3/1/18 95000 LANDFALL CONDOS
315 BITTEROOT CT
FAYETTEVILLE, NC 28314
3/16/18 94500 WATERS EDGE
6843 SHAWCROSS LN
FAYETTEVILLE, NC 28314
4/11/18 93500 GLENREILLY
728 GLEN REILLY DR
FAYETTEVILLE, NC 28314
3/6/18 90500 GLENREILLY
318 BITTEROOT COURT
FAYETTEVILLE, NC 28314
4/5/18 89900 WATERS EDGE
6854 SHAWCROSS LN
FAYETTEVILLE, NC 28314
3/9/18 79900 GLENREILLY
318 EDGEWAY LOOP
FAYETTEVILLE, NC 28314
2/26/18 74983 WATERS EDGE
303 WHIPPLE TREE LN
FAYETTEVILLE, NC 28314
2/1/18 74900 WATERS EDGE
5745 WATERWOOD DRIVE
FAYETTEVILLE, NC 28314
2/27/18 59000 WATERS EDGE
512 AUBURNDALE LANE
FAYETTEVILLE, NC 28314
4/18/18 54900 LOCH LOMOND
6541 ST LOUIS ST
FAYETTEVILLE, NC 28314
12/11/17 49800 GLENBROOK
6561 BALDOON DRIVE
FAYETTEVILLE, NC 28314
1/30/18 49800 LOCH LOMOND
536 AUBURNDALE LANE
FAYETTEVILLE, NC 28314
3/14/18 49000 LOCH LOMOND
301 DESMOND DR
FAYETTEVILLE, NC 28314
3/5/18 45900 LOCH LOMOND
667-7 BARTONS LANDING PL
FAYETTEVILLE, NC 28314
1/31/18 45000 BARTONS LND
7060 CANDLEWOOD
FAYETTEVILLE, NC 28314
4/11/18 41500 LOCH LOMOND
5813 WATERS EDGE DR
FAYETTEVILLE, NC 28314
2/20/18 40500 WATERS EDGE
532 HICKORYWOOD DR
FAYETTEVILLE, NC 28314
2/12/18 34500 VILLAS LOCH