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" 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 (melvin honeycutt elementary) OR "idx_listings"."middle_school" IN (melvin honeycutt elementary) OR "idx_listings"."high_school" IN (melvin honeycutt elementary)) AND "idx_listings"."updated" > 2017-11-20 17:16:14.551840) ORDER BY "idx_listings"."price" DESC LIMIT 100

1-8 of 100 Listings

$391,900

2822 SELHURST DRIVE

FAYETTEVILLE, NC

5 BDs, 3 BAs

MLS: 525414

Gates Four

Source: Fayetteville Regional Association of REALTORS®

Judy Russell - Russell Real Estate

PENDING

$328,250

3013 MCCANDLESS COURT (LOT 89)

FAYETTEVILLE, NC

4 BDs, 3 BAs

MLS: 531486

George Town Estates

Source: Fayetteville Regional Association of REALTORS®

John `Jay` Dowdy - Bhhs All American Homes #2

$310,900

4779 MCKINNON FARM ROAD(LOT 4)

FAYETTEVILLE, NC

4 BDs, 3 BAs

MLS: 522635

George Town Estates

Source: Fayetteville Regional Association of REALTORS®

John `Jay` Dowdy - Bhhs All American Homes #2

$296,500

4783 MCKINNON FARM RD (LOT 5)

FAYETTEVILLE, NC

4 BDs, 4 BAs

MLS: 515688

George Town Estates

Source: Fayetteville Regional Association of REALTORS®

John `Jay` Dowdy - Bhhs All American Homes #2

$295,900

3010 MCCANDLESS COURT (LOT 83)

FAYETTEVILLE, NC

4 BDs, 4 BAs

MLS: 526113

George Town Estates

Source: Fayetteville Regional Association of REALTORS®

John `Jay` Dowdy - Bhhs All American Homes #2

REDUCED

$294,900

3025 STODDERT LANE (LOT 44)

FAYETTEVILLE, NC

5 BDs, 3 BAs

MLS: 467470

George Town Estates

Source: Fayetteville Regional Association of REALTORS®

John `Jay` Dowdy - Bhhs All American Homes #2

$292,900

2824 MOSQUERA DRIVE

FAYETTEVILLE, NC

4 BDs, 4 BAs

MLS: 525286

Palms At Summer Grove

Source: Fayetteville Regional Association of REALTORS®

Cyndi Lee Mckinney - Peachtree Properties Of Fayetteville

$291,900

3009 McCandless Court (Lot 88)

FAYETTEVILLE, NC

4 BDs, 3 BAs

MLS: 526115

George Town Estates

Source: Fayetteville Regional Association of REALTORS®

John `Jay` Dowdy - Bhhs All American Homes #2

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
2905 SANGRIA PLACE
FAYETTEVILLE, NC 28306
11/3/17 314500 THE WOODS BRCH CK
3018 MCCANDLESS COURT (LOT 81)
FAYETTEVILLE, NC 28304
8/31/17 313470 GEORGE TOWN ESTATES
3002 MCCANDLESS COURT (LOT 85)
FAYETTEVILLE, NC 28304
11/17/17 261900 GEORGE TOWN ESTATES
3313 MICHLER LANE (LOT 58)
FAYETTEVILLE, NC 28304
10/12/17 257500 GEORGE TOWN ESTATES
2736 MOSQUERA
FAYETTEVILLE, NC 28306
8/25/17 252000 PALMS AT SUMMER GROVE
2617 DANZANTE PLACE
FAYETTEVILLE, NC 28306
9/19/17 250000 THE WOODS BRCH CK
2905 WINDJAMMER CIR
FAYETTEVILLE, NC 28306
10/27/17 232000 HIGHLAND POINTE AT SUMMER GRV
2716 BARDOLINO DR
FAYETTEVILLE, NC 28306
8/29/17 229900 THE WOODS BRCH CK
2908 MARCUS JAMES DRIVE
FAYETTEVILLE, NC 28306
9/6/17 210000 BIRCH CRK
3216 POINT CROSSING PLACE
FAYETTEVILLE, NC 28306
9/27/17 208700 ARRANS COVE
3213 POINT CROSSING PLACE
FAYETTEVILLE, NC 28306
10/18/17 208700 ARRANS COVE
3205 POINT CROSSING
FAYETTEVILLE, NC 28306
9/26/17 200000 ARRANS COVE
6404 JACOBS CREEK CIR
FAYETTEVILLE, NC 28306
9/29/17 199999 BIRCH CRK
2825 BLOCKADE RUNNER DR
FAYETTEVILLE, NC 28306
10/30/17 199950 SUMMER GROVE
2916 BLACKWATER DRIVE
FAYETTEVILLE, NC 28306
10/24/17 199900 SUMMER GROVE
2271 LAKEWELL CIRCLE
FAYETTEVILLE, NC 28306
8/31/17 194700 ARRANS COVE
2963 BROOKCROSSING DRIVE
FAYETTEVILLE, NC 28306
10/19/17 169900 VLG AT LAKEWOOD
2261 DOCKVALE DR
FAYETTEVILLE, NC 28306
9/27/17 169900 ARRAN LAKES WES
6224 LAKE TRAIL DR
FAYETTEVILLE, NC 28304
9/21/17 164999 ARRAN LAKES WES
2624 LULL WATER DRIVE
FAYETTEVILLE, NC 28306
10/6/17 164900 BIRCH CRK
5900 GOSFIELD PL
FAYETTEVILLE, NC 28304
10/23/17 164000 ARRAN LAKES WES
2915 SEAWATER COURT
FAYETTEVILLE, NC 28306
10/20/17 163450 SUMMER GROVE
2213 FOSTER GWIN LANE
FAYETTEVILLE, NC 28304
11/17/17 159900 BEACON HILL
6221 LAKEHAVEN DR
FAYETTEVILLE, NC 28304
10/12/17 155000 ARRAN LAKES WES
7319 HYANNIS DR
FAYETTEVILLE, NC 28304
9/15/17 152900 EMERALD GDN