|
|
|
|
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: $599,000
MLS Number: 988083
Type: Single Family
Bedrooms: 4
Bathrooms: 3.5
|
|
|
|
Property Description:
Too many upgrades to list with this spacious custom built Colonial. Located only minutes to beaches,...
more>>
|
|
|
|
Status: Active
Price: $599,000
MLS Number: 912741
Type: Commercial
Bedrooms: 5
Bathrooms: 5
|
|
|
|
Property Description:
more>>
|
|
|
|
Status: Active
Price: $599,000
MLS Number: 838803
Type: Residential
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
more>>
|
|
|
|
Status: Active
Price: $599,000
MLS Number: 929879
Type: Residential
Bedrooms: 2
Bathrooms: 2
|
|
|
|
Property Description:
Bright and sunny 1st floor, 2 bedroom, 2 Bath, end unit. Open concept living and dining area opening...
more>>
|
|
|
|
Status: Active
Price: $598,000
Type: Land
|
|
|
|
Property Description:
This 70 acre parcel holds many posibilities ...
more>>
|
|
|
|
Status: Active
Price: $597,000
MLS Number: 985803
Type: Residential
Bedrooms: 5
Bathrooms: 3
|
|
|
|
Property Description:
GREAT LOCATION! Walk to beach, Village and Marginal Way from this secluded location! This sun-filled...
more>>
|
|
|
|
Status: Active
Price: $595,000
MLS Number: 987724
Type: Residential
Bedrooms: 7
Bathrooms: 4
|
|
|
|
Property Description:
PRICED TO SELL QUICKLY!!!! Incredible opportunity AND location, walk to Wells Beach! Two properties ...
more>>
|
|
|
|
Status: Active
Price: $595,000
MLS Number: 974143
Type: Commercial
|
|
|
|
Property Description:
Affordable Commercial Space for your very own business. Currently operating as a Convenience Store a...
more>>
|
|
|
|
Status: Active
Price: $595,000
MLS Number: 974721
Type: Residential
Bedrooms: 7
Bathrooms: 4
|
|
|
|
Property Description:
Unique offering of 3 separate Cottages located within walking distance to Ogunquit Village, Beaches,...
more>>
|
|
|
|
Status: Active
Price: $595,000
MLS Number: 973965
Type: Residential
Bedrooms: 4
Bathrooms: 2
|
|
|
|
Property Description:
Walk to Ogunquit Village, restaurants, and beaches from this immaculate open concept home. Imagine y...
more>>
|
|
|
|
|
