|
|
|
|
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: $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>>
|
|
|
|
Status: Active
Price: $850,000
MLS Number: 949455
Type: Residential
Bedrooms: 3
Bathrooms: 3
|
|
|
|
Property Description:
Incredible property offering over 6500sq feet of space. Currently used as Retail space, however coul...
more>>
|
|
|
|
Status: Active
Price: $849,000
MLS Number: 968094
Type: Residential
Bedrooms: 4
Bathrooms: 1.75
|
|
|
|
Property Description:
Priced over $110K UNDER Assessed Value! Enjoy breathtaking, bold ocean views from this custom home o...
more>>
|
|
|
|
Status: Active
Price: $825,000
MLS Number: 988609
Type: Commercial
Bedrooms: 3
|
|
|
|
Property Description:
Retail, professional office, lodging, restaurant investment opportunity steps to Perkins Cove at bus...
more>>
|
|
|
|
Status: Active
Price: $799,000
MLS Number: 978034
Type: Residential
Bedrooms: 3
Bathrooms: 3
|
|
|
|
Property Description:
Bold ocean views, sounds & breezes from this Cape Neddick home on Bald Head Cliff. Charm & comfort ...
more>>
|
|
|
|
Status: Active
Price: $799,000
MLS Number: 923190
Type: Single Family
Bedrooms: 5
Bathrooms: 3
|
|
|
|
Property Description:
Beautiful colonial with direct water frontage on Spruce Creek in much sought after Kittery Point. Th...
more>>
|
|
|
|
Status: Active
Price: $799,000
MLS Number: 944588
Type: Single Family
Bedrooms: 4
Bathrooms: 3.5
|
|
|
|
Property Description:
Custom designed and built home for perfect for the discriminating buyer. This shingle style home, pe...
more>>
|
|
|
|
Status: Active
Price: $750,000
MLS Number: 877972
Type: Commercial
Bedrooms: 4
Bathrooms: 2.5
|
|
|
|
Property Description:
DRAMATIC Price Reduction! Incredible Main Steet location and Ogunquit Business Opportunity. Omelet...
more>>
|
|
|
|
Status: Active
Price: $750,000
MLS Number: 972330
Type: Residential
Bedrooms: 3
Bathrooms: 4
|
|
|
|
Property Description:
Architecturally designed 3 bedroom, 4 bath vintage 1929 home with original period features including...
more>>
|
|
|
|
Status: Active
Price: $750,000
MLS Number: 972330
Type: Residential
Bedrooms: 3
Bathrooms: 4
|
|
|
|
Property Description:
Completed in 1929, this architecturally designed 3 bedroom, 4 bath home was reportedly designed for ...
more>>
|
|
|
|
|
