|
|
|
|
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: $649,000
MLS Number: 970430
Type: Residential
Bedrooms: 4
Bathrooms: 4
|
|
|
|
Property Description:
Perfectly located, this spacious 4 bedroom, 3.5 bath home is like brand new offering walk to beach l...
more>>
|
|
|
|
Status: Active
Price: $649,000
MLS Number: 972176
Type: Residential
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
Very short stroll to Perkins Cove, the Drawbridge and Marginal Way from this renovated 1920's rambli...
more>>
|
|
|
|
Status: Active
Price: $649,000
MLS Number: 950128
Type: Residential
Bedrooms: 6
Bathrooms: 2
|
|
|
|
Property Description:
Vintage Summer home just steps to Perkins Cove! Walk to Ogunquit Village, local eateries, shops, & t...
more>>
|
|
|
|
Status: Active
Price: $649,000
MLS Number: 952254
Type: Commercial
Bedrooms: 3
Bathrooms: 1
|
|
|
|
Property Description:
Post & Beam Gambrel style home on over 46 acres. Property features a 9 hole executive golf course, a...
more>>
|
|
|
|
Status: Active
Price: $649,000
MLS Number: 966269
Type: Residential
Bedrooms: 4
Bathrooms: 4
|
|
|
|
Property Description:
This quality constructed custom built contemporary home is situated on an exceptional lot in one of ...
more>>
|
|
|
|
Status: Active
Price: $639,000
MLS Number: 987999
Type: Residential
Bedrooms: 3
Bathrooms: 3
|
|
|
|
Property Description:
Steps to Marginal Way and Perkins Cove, this incredible cottage is a perfect backdrop for all your s...
more>>
|
|
|
|
Status: Active
Price: $625,000
MLS Number: 979767
Type: Residential
Bedrooms: 4
Bathrooms: 3
|
|
|
|
Property Description:
Built in 2003 - but you would think no one has lived in it - this home is in impeccable condition. ...
more>>
|
|
|
|
Status: Active
Price: $625,000
MLS Number: 965699
Type: Residential
Bedrooms: 3
Bathrooms: 3
|
|
|
|
Property Description:
In a quiet residential neighborhood, with ocean views across the street, "Sea Lily" is a haven with ...
more>>
|
|
|
|
Status: Active
Price: $599,900
MLS Number: 919173
Type: Residential
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
Wonderfully maintained two level home situated across the street from Wells beach. Featuring ocean ...
more>>
|
|
|
|
Status: Active
Price: $599,900
MLS Number: 981312
Type: Single Family
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
LOOK NO FURTHER if you are a discerning buyer looking for a private retreat that speaks exceptional ...
more>>
|
|
|
|
|
