|
|
|
|
FROM ap_property, ap_property_status, ap_property_type WHERE ap_property.property_StatusID = ap_property_status.status_ID AND ap_property_type.type_ID = ap_property.property_TypeID AND ap_property.property_StatusID <> 4 AND ap_property.property_StatusID <> 6 AND ap_property.property_StatusID <> 5 AND ap_property.property_StatusID <> 7 ORDER BY ap_property.property_LocationID ASC, ap_property.property_StatusID ASC, LPAD(ap_property.property_ListPrice,12,'0') DESC
|
|
Status: Active
Price: $295,000
MLS Number: 957446
Type: Residential
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
This home makes great use of interior space. The foyer opens to a large family room with fireplace a...
more>>
|
|
|
|
Status: Active
Price: $289,000
MLS Number: 973305
Type: Condo
Bedrooms: 2
Bathrooms: 2
|
|
|
|
Property Description:
Exceptional Value and locaation! Priced below assessed value and located on trolley line. Fantastic...
more>>
|
|
|
|
Status: Active
Price: $289,000
MLS Number: 921045
Type: Residential
Bedrooms: 3
Bathrooms: 1
|
|
|
|
Property Description:
Needs restoration. Match your dreams to this 1890 Vintage 3BR Farmhouse with Barn and outbuildings (...
more>>
|
|
|
|
Status: Active
Price: $289,000
MLS Number: 977721
Type: Residential
Bedrooms: 3
Bathrooms: 1
|
|
|
|
Property Description:
more>>
|
|
|
|
Status: Active
Price: $289,000
MLS Number: 973478
Type: Condo
Bedrooms: 2
Bathrooms: 2
|
|
|
|
Property Description:
Enjoy Views from this year round 2 bedroom, 2 full bath condo unit at Sunrise Terrace! Savor the vie...
more>>
|
|
|
|
Status: Active
Price: $285,900
MLS Number: 979396
Type: Residential
Bedrooms: 4
Bathrooms: 2
|
|
|
|
Property Description:
Welcome to your worry-free dream home! This sensational 4 bedroom home is perched on a pretty littl...
more>>
|
|
|
|
Status: Active
Price: $279,999
MLS Number: 957694
Type: Residential
Bedrooms: 2
Bathrooms: 2
|
|
|
|
Property Description:
One of just 32 Independent Living Units in this preeminent Retirement Community! This sun drenched u...
more>>
|
|
|
|
Status: Active
Price: $279,000
MLS Number: 943462
Type: Residential
Bedrooms: 4
Bathrooms: 2
|
|
|
|
Property Description:
1800's Cape style farmhouse - Move In condition - Property features original center chimney, remolde...
more>>
|
|
|
|
Status: Active
Price: $279,000
MLS Number: 960012
Type: Residential
Bedrooms: 4
Bathrooms: 2.5
|
|
|
|
Property Description:
A picturesque setting showcases this 4 bedroom 2 1/2 bath country gambrel. Tucked back from the stre...
more>>
|
|
|
|
Status: Active
Price: $275,000
MLS Number: 936748
Type: Land
|
|
|
|
Property Description:
Windward is a neighborhood where no expense has been spared. Beautifully landscaped grounds, unique...
more>>
|
|
|
|
|
