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 (benjamin martin elementary) OR "idx_listings"."middle_school" IN (benjamin martin elementary) OR "idx_listings"."high_school" IN (benjamin martin elementary)) AND "idx_listings"."updated" > 2017-11-20 17:00:59.216169) ORDER BY "idx_listings"."price" DESC LIMIT 100

1-8 of 80 Listings

REDUCED

$139,000

6497 PITTSFIELD

FAYETTEVILLE, NC

3 BDs, 2 BAs

MLS: 524502

Four Season

Source: Fayetteville Regional Association of REALTORS®

Eva Mattice - Exit Realty Preferred

$135,000

901 RUTON CT

FAYETTEVILLE, NC

4 BDs, 2 BAs

MLS: 529284

Summerhill

Source: Fayetteville Regional Association of REALTORS®

Welcome Home Team - Keller Williams Realty (Fayetteville)

REDUCED

$130,900

7247 GODFREY DR

FAYETTEVILLE, nc

3 BDs, 2 BAs

MLS: 470889

Lagrange

Source: Fayetteville Regional Association of REALTORS®

The Signature Group - Keller Williams Realty (Fayetteville)

REDUCED

$129,900

7127 FILLYAW RD

FAYETTEVILLE, NC

3 BDs, 2 BAs

MLS: 524112

Summerhill

Source: Fayetteville Regional Association of REALTORS®

Gene Cooper - Gene Cooper Realty

$122,500

6527 KEMPER CT

FAYETTEVILLE, NC

3 BDs, 2 BAs

MLS: 529674

Morganton Place

Source: Fayetteville Regional Association of REALTORS®

Cynthia Grimsley - Re/Max Choice

$115,000

286 DECATUR DR

FAYETTEVILLE, NC

3 BDs, 1 BAs

MLS: 531144

Lagrange

Source: Fayetteville Regional Association of REALTORS®

Cynthia Gill - X-Cel Real Estate & Prop Mgt Corp.

$115,000

6450 FREEPORT ROAD

FAYETTEVILLE, NC

4 BDs, 2 BAs

MLS: 530351

Summerhill

Source: Fayetteville Regional Association of REALTORS®

Aisling Bonner - The Key Group

REDUCED

$114,500

237 DECATUR DR

FAYETTEVILLE, NC

3 BDs, 1 BAs

MLS: 521711

Lagrange

Source: Fayetteville Regional Association of REALTORS®

Uta Belletete - Re/Max Infinity

SOLD INFORMATION

Maximum 25 Listings
Closings Date $ Sold Area
324 ROUNDTREE DR
FAYETTEVILLE, NC 28303
8/31/17 147500 ROUNDTREE
211 INGLESIDE DR
FAYETTEVILLE, NC 28303
9/27/17 143000 LAGRANGE
7063 DARNELL ST
FAYETTEVILLE, NC 28314
9/1/17 129900 DEVONWOOD
7125 BARNWELL PL
FAYETTEVILLE, NC 28303
9/8/17 127500 SUMMERHILL
1013 GLEN REILLY
FAYETTEVILLE, NC 28314
7/3/17 99900 GLENREILLY
141 S INGLESIDE
FAYETTEVILLE, NC 28314
10/2/17 99450 LAGRANGE
7252 GODFREY DR
FAYETTEVILLE, NC 28303
10/27/17 99000 LAGRANGE
1264 BROMLEY DR
FAYETTEVILLE, NC 28303
10/25/17 98500 SUMMERHILL
6509 CISSNA DR.
FAYETTEVILLE, NC 28303
9/11/17 90000 MORGANTON PLACE
7303 GODFREY DR
FAYETTEVILLE, NC 28303
10/20/17 72700 LAGRANGE
6354 HAWFIELD DR
FAYETTEVILLE, NC 28303
10/23/17 69900 SUMMERHILL
236 RAMONA DRIVE
FAYETTEVILLE, NC 28303
9/28/17 68000 LAGRANGE
646 WAKEFIELD DR
FAYETTEVILLE, NC 28303
10/19/17 65900 COOL SPRINGS ESTATE
872 DANISH DR
FAYETTEVILLE, NC 28303
8/29/17 62000 FOUR SEASON
7522 KISCO DR
FAYETTEVILLE, NC 28303
11/7/17 57000 LAGRANGE
110 INGLESIDE DR
FAYETTEVILLE, NC 28303
10/24/17 52000 LAGRANGE
7254 RYAN ST
FAYETTEVILLE, NC 28314
10/11/17 45000 LOCH LOMOND
6516 KEMPER CT
FAYETTEVILLE, NC 28303
9/1/17 44900 MORGANTON PLACE
6448 KELMSCOT CT
FAYETTEVILLE, NC 28303
9/15/17 39900 FOUR SEASON
1001-3 BROOKHOLLOW DRIVE
FAYETTEVILLE, NC 28314
9/1/17 39900 STEWARTS CK
847 DANISH DRIVE
FAYETTEVILLE, NC 28303
9/22/17 38250 FOUR SEASON
942 STEWARTS CREEK DR
FAYETTEVILLE, NC 28314
9/1/17 37000 STEWARTS CK
1021 WOOD CREEK DRIVE
FAYETTEVILLE, NC 28314
11/1/17 35500 STEWARTS CK
6788 WILLOWBROOK DR.
FAYETTEVILLE, NC 28314
5/30/17 35000 STEWARTS CK
962-7 STEWARTS CREEK
FAYETTEVILLE, NC 28314
11/16/17 30000 STEWARTS CK