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

View Details
Keller Williams University Cty
IDX
ADDRESS

1044 Hearth Lane

Type

Single Family

CITY

Concord

MLS#

2040748

PRICE

$396,000

STATUS

Active

View Details
Keller Williams University Cty
IDX
ADDRESS

1278 Island Creek Drive

Type

Single Family

CITY

Troy

MLS#

2045316

PRICE

$489,000

STATUS

Active

View Details
Keller Williams University Cty
IDX
ADDRESS

6715 Constitution Lane

Type

Condo/Townhouse

CITY

Charlotte

MLS#

2063075

PRICE

$165,900

STATUS

Active

View Details
Keller Williams University Cty
IDX
The MLS data was last updated on February 07, 2012.
IDXThe data relating to real estate on this Web site derive in part from the Carolina Multiple Listing Services, Inc. IDX program. Brokers make an effort to deliver accurate information, buy buyers should independently verify any information on which they will rely in a transaction. All properties are subject to prior sale, charge or withdrawal. Neither Judy Piercy nor any listing broker shall be responsible for any typographical errors, misinformation, or misprints, and they shall be held totally harmless from any damages arising from reliance upon this data. This data is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties they may be interested in purchasing. © 2012 Carolina Multiple Listing Services, Inc.