Featured Homes


String: SELECT * FROM cds.single WHERE `Listing Agent ID` = '96004' AND `Listing Status` != 'Sold' UNION SELECT * FROM cds.multifamily WHERE `Listing Agent ID` = '96004' AND `Listing Status` != 'Sold' UNION SELECT * FROM cds.commercial WHERE `Listing Agent ID` = '96004' AND `Listing Status` != 'Sold' UNION SELECT * FROM cds.rentals WHERE `Listing Agent ID` = '96004' AND `Listing Status` != 'Sold' UNION SELECT * FROM cds.lots WHERE `Listing Agent ID` = '96004' AND `Listing Status` != 'Sold' UNION SELECT * FROM cds.condos WHERE `Listing Agent ID` = '96004' AND `Listing Status` != 'Sold' ORDER BY PropertyType DESC, `Listing Price` ASC
Total: 4
SortBy: ORDER BY PropertyType DESC, `Listing Price`
Contact Judy Piercy: judypiercy@carolina.rr.com
ADDRESS

11608 Tucker Field Road

Type

Single Family

CITY

Midland

MLS#

2044987

PRICE

$169,900

STATUS

Active

Keller Williams University Cty
IDX
ADDRESS

1044 Hearth Lane

Type

Single Family

CITY

Concord

MLS#

2040748

PRICE

$396,000

STATUS

Active

Keller Williams University Cty
IDX
ADDRESS

1278 Island Creek Drive

Type

Single Family

CITY

Troy

MLS#

2045316

PRICE

$489,000

STATUS

Active

Keller Williams University Cty
IDX
ADDRESS

6715 Constitution Lane

Type

Condo/Townhouse

CITY

Charlotte

MLS#

2063075

PRICE

$165,900

STATUS

Active

Keller Williams University Cty
IDX