|
|
|
|
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: $3,150,000
MLS Number: 967729
Type: Single Family
Bedrooms: 4
Bathrooms: 3.75
|
|
|
|
Property Description:
Enjoy all the luxuries of the 21st century while basking in the history & glory of this classic & qu...
more>>
|
|
|
|
Status: Active
Price: $2,950,000
MLS Number: 958474
Type: Single Family
Bedrooms: 2
Bathrooms: 1
|
|
|
|
Property Description:
Gooseberry Island is a privately deeded island oasis located in the heart of Portsmouth Harbor just ...
more>>
|
|
|
|
Status: Active
Price: $2,650,000
MLS Number: 952022
Type: Residential
Bedrooms: 4
Bathrooms: 7
|
|
|
|
Property Description:
Nestled among pastures & wooded areas and with ocean breezes & sounds, this 18-acre estate is perfec...
more>>
|
|
|
|
Status: Active
Price: $2,500,000
MLS Number: 954939
Type: Residential
Bedrooms: 5
Bathrooms: 4
|
|
|
|
Property Description:
Experience breathtaking Oceanfront views from this rare Moody Beach offering. Sited on a wide lot, y...
more>>
|
|
|
|
Status: Active
Price: $2,495,000
MLS Number: 941372
Type: Residential
Bedrooms: 5
Bathrooms: 4.5
|
|
|
|
Property Description:
Reigning over the bold Atlantic with unobstructed views of Cape Neddick Lighthouse and the Nubble, t...
more>>
|
|
|
|
Status: Active
Price: $2,475,000
MLS Number: 984204
Type: Residential
Bedrooms: 3
Bathrooms: 3.5
|
|
|
|
Property Description:
Unique opportunity to live green alongside the blue.
Expert combination of style, grace, elegance, ...
more>>
|
|
|
|
Status: Active
Price: $2,295,000
MLS Number: 952285
Type: Residential
Bedrooms: 5
Bathrooms: 5.25
|
|
|
|
Property Description:
The bold Atlantic crashes at the rocky shore below while views of Nubble Light, Boone Island and the...
more>>
|
|
|
|
Status: Active
Price: $2,195,000
MLS Number: 963664
Type: Commercial
Bedrooms: 1
Bathrooms: 5
|
|
|
|
Property Description:
Incredible space to make a dream come true. This building offers unbelievable square footage for en...
more>>
|
|
|
|
Status: Active
Price: $2,150,000
Type: Residential
Bedrooms: 3
Bathrooms: 2.5
|
|
|
|
Property Description:
Exceptional Bold oceanviews can be experienced from every room of this home nestled near Perkins Cov...
more>>
|
|
|
|
Status: Active
Price: $1,995,000
MLS Number: 948751
Type: Residential
Bedrooms: 3
Bathrooms: 2.5
|
|
|
|
Property Description:
Relax and gaze at the Atlantic Ocean from "South Cliff". This 3 bedroom, 2.5 bath ocean front home ...
more>>
|
|
|
|
|
