|
|
|
|
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: $1,995,000
MLS Number: 963902
Type: Residential
Bedrooms: 5
Bathrooms: 5
|
|
|
|
Property Description:
Magnificent oceanfront Victorian perched high on the Nubble with breathtaking panoramic views of Lon...
more>>
|
|
|
|
Status: Active
Price: $1,995,000
MLS Number: 972034
Type: Residential
Bedrooms: 3
Bathrooms: 4
|
|
|
|
Property Description:
BOLD Atlantic Ocean Views! This gorgeous 3-4 bedroom home offers first class living in Braeburn Par...
more>>
|
|
|
|
Status: Active
Price: $1,975,000
MLS Number: 990520
Type: Residential
Bedrooms: 4
Bathrooms: 4.5
|
|
|
|
Property Description:
Distinctive architectural design and solid construction characterize this exceptional waterfront hom...
more>>
|
|
|
|
Status: Active
Price: $1,550,000
MLS Number: 953385
Type: Residential
Bedrooms: 4
Bathrooms: 4
|
|
|
|
Property Description:
Biddeford Pool Beachfront Living. Perched amid the dunes and sea grass in the quiet coastal communit...
more>>
|
|
|
|
Status: Active
Price: $1,500,000
MLS Number: 986772
Type: Residential
Bedrooms: 3
Bathrooms: 3
|
|
|
|
Property Description:
One of Ogunquit's most stunning homes. This magnificent setting offers a short stroll to Ogunquit Vi...
more>>
|
|
|
|
Status: Active
Price: $1,395,000
MLS Number: 957982
Type: Commercial
Bathrooms: 2
|
|
|
|
Property Description:
This is a beautifully designed restaurant with an excellent Route One location in Wells' bustling bu...
more>>
|
|
|
|
Status: Active
Price: $1,300,000
MLS Number: 873837
Type: Commercial
Bedrooms: 6
Bathrooms: 7.5
|
|
|
|
Property Description:
Built in 2001, this English manor house is located on lovely private 6 acres within walking distance...
more>>
|
|
|
|
Status: Active
Price: $1,295,000
MLS Number: 972006
Type: Residential
Bedrooms: 3
Bathrooms: 3
|
|
|
|
Property Description:
Enjoy stunning BOLD oceanviews from one of Cape Neddick's finest neighborhoods! Stunning views from ...
more>>
|
|
|
|
Status: Active
Price: $1,250,000
MLS Number: 953220
Type: Residential
Bedrooms: 4
Bathrooms: 5
|
|
|
|
Property Description:
Adirondack Shingle Style 4 Br., 5,700 sq/ft home, fashioned after a turn of the century SEA CAPTAINS...
more>>
|
|
|
|
Status: Active
Price: $1,200,000
MLS Number: 945103
Type: Land
|
|
|
|
Property Description:
Beautiful area of Wells, rural yet minutes to the beach and shopping. Easy access to highway, north ...
more>>
|
|
|
|
|
