|
|
|
|
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,150,000
MLS Number: 975687
Type: Commercial
Bedrooms: 3
Bathrooms: 1.5
|
|
|
|
Property Description:
Located at 262 Shore Road in the famous seaside summer resort of Ogunquit, Maine, this 55 seat resta...
more>>
|
|
|
|
Status: Active
Price: $1,150,000
MLS Number: 952317
Type: Residential
Bedrooms: 4
Bathrooms: 1.5
|
|
|
|
Property Description:
Classic, Turn of the century, Wells beach home. This vintage beauty features 4 bedrooms, all with vi...
more>>
|
|
|
|
Status: Active
Price: $1,145,000
MLS Number: 967635
Type: Condo
Bedrooms: 2
Bathrooms: 3
|
|
|
|
Property Description:
Exquisitely sited on a privately owned peninsula in York, bordered by the Atlantic Ocean, York Harbo...
more>>
|
|
|
|
Status: Active
Price: $1,100,000
MLS Number: 966466
Type: Residential
Bedrooms: 3
Bathrooms: 3
|
|
|
|
Property Description:
Exceptional custom built home located just steps to Ogunquit Village! Walk to local eateries, shops ...
more>>
|
|
|
|
Status: Active
Price: $1,095,000
MLS Number: 959082
Type: Residential
Bedrooms: 6
Bathrooms: 4
|
|
|
|
Property Description:
Ocean views from this newly renovated shingle-style home located in York Harbor. A blend of turn-of-...
more>>
|
|
|
|
Status: Active
Price: $1,095,000
MLS Number: 989638
Type: Residential
Bedrooms: 4
Bathrooms: 4.5
|
|
|
|
Property Description:
Short Sale! Bank is ready to approve! Waterfront shingle-style 2007 New Construction in Briers At ...
more>>
|
|
|
|
Status: Active
Price: $1,075,000
MLS Number: 896820
Type: Residential
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
Steps to the ocean and great views. Enjoy this ranch just the way it is or redesign it to suit your...
more>>
|
|
|
|
Status: Active
Price: $999,000
MLS Number: 956015
Type: Single Family
Bedrooms: 5
Bathrooms: 3
|
|
|
|
Property Description:
This exceptional waterfront cape has been expanded & fully remodeled creating a seamless blend of 19...
more>>
|
|
|
|
Status: Active
Price: $995,000
MLS Number: 961610
Type: Condo
Bedrooms: 5
Bathrooms: 2
|
|
|
|
Property Description:
This luxury penthouse condo boasts dramatic views of Old Orchard Pier and the Atlantic Ocean. Ejoy b...
more>>
|
|
|
|
Status: Active
Price: $995,000
MLS Number: 976830
Type: Land
|
|
|
|
Property Description:
Large parcel ready for development within very healthy, well established industrial park. Water, s...
more>>
|
|
|
|
|
