|
|
|
|
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: $120,000
MLS Number: 954210
Type: Commercial
|
|
|
|
Property Description:
This front, second floor unit could easily divided for shared office space for those seeking a quiet...
more>>
|
|
|
|
Status: Active
Price: $120,000
MLS Number: 980154
Type: Land
|
|
|
|
Property Description:
more>>
|
|
|
|
Status: Active
Price: $119,900
MLS Number: 968405
Type: Land
|
|
|
|
Property Description:
Excellent location for your dream home in Ogunquit. Autumn River Lane is a sought after neighborhoo...
more>>
|
|
|
|
Status: Active
Price: $119,000
MLS Number: 989104
Type: Land
|
|
|
|
Property Description:
Bring your dream of building to this beautiful North Village Estates location! Just minutes to Ogunq...
more>>
|
|
|
|
Status: Active
Price: $116,900
MLS Number: 882630
Type: Condo
Bathrooms: 1
|
|
|
|
Property Description:
Studio style condo unit featuring full kitchen, 3/4 bathroom, and off street parking for two. Enjoy ...
more>>
|
|
|
|
Status: Active
Price: $115,000
MLS Number: 963381
Type: Land
|
|
|
|
Property Description:
Level building lot with town water and town sewer....
more>>
|
|
|
|
Status: Active
Price: $114,900
MLS Number: 967276
Type: Condo
Bedrooms: 2
Bathrooms: 1
|
|
|
|
Property Description:
Fully furnished 2 bedroom townhouse style condo offering first floor laundry, ample storage, private...
more>>
|
|
|
|
Status: Active
Price: $110,000
MLS Number: 954479
Type: Single Family
Bedrooms: 1
Bathrooms: 1
|
|
|
|
Property Description:
This is a very quaint property that has lots of history for the town of South Berwick as it used to ...
more>>
|
|
|
|
Status: Active
Price: $110,000
MLS Number: 954211
Type: Commercial
|
|
|
|
Property Description:
This spacious unit can be divided into two office. Convenient locaiton between York and Ogunquit to ...
more>>
|
|
|
|
Status: Active
Price: $109,500
MLS Number: 969027
Type: Residential
Bedrooms: 2
Bathrooms: 1
|
|
|
|
Property Description:
Affordable, well-maintained 2BR condo designed for someone on the go & carefree living in mind! Key...
more>>
|
|
|
|
|
