|
|
|
|
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: $489,000
MLS Number: 982463
Type: Residential
Bedrooms: 4
Bathrooms: 2.5
|
|
|
|
Property Description:
Renovated & expanded ranch privately located on corner lot abuttting Rachel Carson preserve with vie...
more>>
|
|
|
|
Status: Active
Price: $479,900
MLS Number: 924873
Type: Residential
Bedrooms: 4
Bathrooms: 4
|
|
|
|
Property Description:
Open concept first floor w/eat-in kitchen and family room. Home has a great flow and lots of natural...
more>>
|
|
|
|
Status: Active
Price: $479,000
MLS Number: 972185
Type: Single Family
Bedrooms: 4
Bathrooms: 3
|
|
|
|
Property Description:
Fantastic opportunity to own two homes in the heart of Ogunquit. The main house is a beautifully ap...
more>>
|
|
|
|
Status: Active
Price: $475,000
MLS Number: 915654
Type: Commercial
|
|
|
|
Property Description:
The Faircrest Motel is a charming 9 unit motel located on Route One in York close to beaches and loc...
more>>
|
|
|
|
Status: Active
Price: $475,000
MLS Number: 914083
Type: Residential
Bedrooms: 4
Bathrooms: 3
|
|
|
|
Property Description:
Built circa 1820 and IMPECCABLY restored in 2002, this gentleman's farm on 3.86 acres is a welcoming...
more>>
|
|
|
|
Status: Active
Price: $469,000
MLS Number: 953223
Type: Residential
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
Walk to town and beach from this recently updated, year-round home. Wonderful floor plan with an inc...
more>>
|
|
|
|
Status: Active
Price: $469,000
MLS Number: 970957
Type: Condo
Bedrooms: 2
Bathrooms: 2
|
|
|
|
Property Description:
Make this beautiful ocean view condo your new getaway! This 2 bedroom, 2 bath home has beautiful vie...
more>>
|
|
|
|
Status: Active
Price: $469,000
MLS Number: 971795
Type: Residential
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
LOCATION is everything and this one is walk to Ogunquit Center and Beach. Wonderful, bright, sunny,...
more>>
|
|
|
|
Status: Active
Price: $459,000
MLS Number: 898295
Type: Single Family
Bedrooms: 2
Bathrooms: 1.75
|
|
|
|
Property Description:
Adorable 2 bedroom year-round home with three season views of marsh. Fireplace, wood floors, tranqui...
more>>
|
|
|
|
Status: Active
Price: $459,000
MLS Number: 973303
Type: Residential
Bedrooms: 3
Bathrooms: 1
|
|
|
|
Property Description:
Location, location, location! Steps to Ogunquit Village, this 3 bedroom home offers the best of all ...
more>>
|
|
|
|
|
