|
|
|
|
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: $89,000
MLS Number: 928301
Type: Land
|
|
|
|
Property Description:
more>>
|
|
|
|
Status: Active
Price: $85,000
MLS Number: 954197
Type: Commercial
|
|
|
|
Property Description:
For Sale or lease, this first floor unit is equipt as a kitchen and would be an ideal Cafe or Deli. ...
more>>
|
|
|
|
Status: Active
Price: $849000
MLS Number: 961191
Type: Condo
Bedrooms: 2
Bathrooms: 2.5
|
|
|
|
Property Description:
This Location is unmatched! Watch the Harbor activity from your Dining room, living room or bed room...
more>>
|
|
|
|
Status: Active
Price: $82,500
MLS Number: 973385
Type: Residential
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
Spacious 3 bedroom, 2 bath new double wide features bright open concept design, large fully applianc...
more>>
|
|
|
|
Status: Active
Price: $82,000
MLS Number: 984675
Type: Land
|
|
|
|
Property Description:
Residential lot in a quiet, small neighborhood of recently built attractive homes surrounded by cons...
more>>
|
|
|
|
Status: Active
Price: $79,500
MLS Number: 948651
Type: Residential
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
$8,000 TAX Credit! If you have not owned a home in the 3 years or are a first-time buyer. Opportunit...
more>>
|
|
|
|
Status: Active
Price: $79,500
MLS Number: 948652
Type: Land
|
|
|
|
Property Description:
3 BR septic, well in place. Opportunity and convenience with a single wide in live-in condition that...
more>>
|
|
|
|
Status: Active
Price: $699000
MLS Number: 946973
Type: Residential
Bedrooms: 4
Bathrooms: 3.5
|
|
|
|
Property Description:
Classic victorian exterior with hardwood floors, fireplaces, high tin ceilings and many other classi...
more>>
|
|
|
|
Status: Active
Price: $69,950
MLS Number: 953204
Type: Land
|
|
|
|
Property Description:
0.540 acre residential lot in Meetinghouse Acres II, a quiet neighborhood of attractive homes built ...
more>>
|
|
|
|
Status: Active
Price: $69,000
MLS Number: 915197
Type: Residential
Bedrooms: 2
Bathrooms: 1.5
|
|
|
|
Property Description:
Sun N Sea Village home. 2 bedrooms, open floor plan with 3 season room and foyer. Upgrades include...
more>>
|
|
|
|
|
