|
|
|
|
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: $995,000
MLS Number: 982010
Type: Residential
Bedrooms: 4
Bathrooms: 2.5
|
|
|
|
Property Description:
MILLION DOLLAR VIEW! Spectacular ocean view from your master bedroom, fireplaced living room, or wra...
more>>
|
|
|
|
Status: Active
Price: $945,000
MLS Number: 906562
Type: Single Family
Bedrooms: 3
Bathrooms: 2.5
|
|
|
|
Property Description:
Fabulous Ocean and Bay views from this 4 bedroom shingle style residence in the heart of Camp Ellis,...
more>>
|
|
|
|
Status: Active
Price: $899,900
MLS Number: 928718
Type: Condo
Bedrooms: 3
Bathrooms: 2.75
|
|
|
|
Property Description:
more>>
|
|
|
|
Status: Active
Price: $899,000
MLS Number: 971940
Type: Single Family
Bedrooms: 4
Bathrooms: 3.5
|
|
|
|
Property Description:
New Construction on the Ogunquit River overlooking the River and Ocean. This 3,700 square foot home...
more>>
|
|
|
|
Status: Active
Price: $899,000
MLS Number: 975104
Type: Residential
Bedrooms: 4
Bathrooms: 3.5
|
|
|
|
Property Description:
Supreme custom-built shingle style executive home on private, estate-like 7.5 acres. Expansive livi...
more>>
|
|
|
|
Status: Active
Price: $895,000
MLS Number: 914984
Type: Residential
Bedrooms: 3
Bathrooms: 3.5
|
|
|
|
Property Description:
If it is luxury that you seek - your search is over! This Townhome epitomizes luxury and ease of liv...
more>>
|
|
|
|
Status: Active
Price: $879,000
MLS Number: 929916
Type: Commercial
Bedrooms: 6
Bathrooms: 7
|
|
|
|
Property Description:
more>>
|
|
|
|
Status: Active
Price: $879,000
MLS Number: 929915
Type: Residential
Bedrooms: 6
Bathrooms: 7
|
|
|
|
Property Description:
more>>
|
|
|
|
Status: Active
Price: $875,000
MLS Number: 980620
Type: Condo
Bedrooms: 6
Bathrooms: 4.5
|
|
|
|
Property Description:
Location! Location! Location! Stately, custom-built, colonial, located in a tranquil neighborhood in...
more>>
|
|
|
|
Status: Active
Price: $850,000
MLS Number: 949453
Type: Commercial
Bedrooms: 3
Bathrooms: 3
|
|
|
|
Property Description:
Exceptional location in Wells! Located on highly visible Post road, this property offers over an acr...
more>>
|
|
|
|
|
