|
|
|
|
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: $359,000
MLS Number: 982555
Type: Residential
Bedrooms: 2
Bathrooms: 2
|
|
|
|
Property Description:
Scintilating views of the Harbor can be yours from this immaculate, third floor condo. The open, sun...
more>>
|
|
|
|
Status: Active
Price: $359,000
MLS Number: 980798
Type: Condo
Bedrooms: 2
Bathrooms: 2
|
|
|
|
Property Description:
Exceptional townhouse offers turnkey low maintenance solution in one of So Maine's most popular reso...
more>>
|
|
|
|
Status: Active
Price: $355,000
MLS Number: 984686
Type: Residential
Bedrooms: 3
Bathrooms: 2.5
|
|
|
|
Property Description:
This expanded Cape is tucked neatly on the end of the street with the Ogunquit River as the backyard...
more>>
|
|
|
|
Status: Active
Price: $350,000
MLS Number: 914138
Type: Residential
Bedrooms: 2
Bathrooms: 2
|
|
|
|
Property Description:
A slice of heaven! Stonewalls line the border of this 15 acre property. Home built in 2002 offers 2 ...
more>>
|
|
|
|
Status: Active
Price: $350,000
MLS Number: 984750
Type: Residential
Bedrooms: 4
Bathrooms: 3
|
|
|
|
Property Description:
This wonderful home has been lovingly renovated to perfection. This home does not give up its privac...
more>>
|
|
|
|
Status: Active
Price: $349,900
MLS Number: 926557
Type: Single Family
Bedrooms: 4
Bathrooms: 2
|
|
|
|
Property Description:
Immaculately maintained Cape on a gorgeous corner lot in walkable neighborhood. Minutes to beach, t...
more>>
|
|
|
|
Status: Active
Price: $349,900
MLS Number: 966670
Type: Residential
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
This beautiful home has been immaculately cared for and features wide-plank pine floors, huge living...
more>>
|
|
|
|
Status: Active
Price: $349,900
MLS Number: 987638
Type: Residential
Bedrooms: 2
Bathrooms: 1
|
|
|
|
Property Description:
Enjoy the ocean views from this meticulous 2 bedroom year round home. Come relax on the expansive de...
more>>
|
|
|
|
Status: Active
Price: $349,000
MLS Number: 971087
Type: Land
|
|
|
|
Property Description:
A truly spectacular, one of a kind property. This 2.17 acre property backs to the Ogunquit River and...
more>>
|
|
|
|
Status: Active
Price: $349,000
MLS Number: 988316
Type: Residential
Bedrooms: 3
Bathrooms: 3
|
|
|
|
Property Description:
Offered below Assessed Value! Minutes to Beaches and Ogunquit Village! Built in 2008, this spacious ...
more>>
|
|
|
|
|
