|
|
|
|
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,350,000
MLS Number: 906437
Type: Residential
Bedrooms: 5
Bathrooms: 2.5
|
|
|
|
Property Description:
This classic 1905 Maine shingle home has been fully restored for 21st century living. Capturing oce...
more>>
|
|
|
|
Status: Active
Price: $2,950,000
MLS Number: 896843
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,495,000
MLS Number: 874702
Type: Condo
Bedrooms: 5
Bathrooms: 3.5
|
|
|
|
Property Description:
This magnificent home, originally the "Ye Village Studio" gallery and theatre, according to local lo...
more>>
|
|
|
|
Status: Active
Price: $2,195,000
MLS Number: 921532
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
MLS Number: 885717
Type: Residential
Bedrooms: 4
Bathrooms: 3.5
|
|
|
|
Property Description:
JUST IMAGINE.... coming home to this stunning custom built home capturing wide & ever-changing views...
more>>
|
|
|
|
Status: Active
Price: $1,995,000
MLS Number: 865121
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>>
|
|
|
|
Status: Active
Price: $1,925,000
MLS Number: 852067
Type: Residential
Bedrooms: 4
Bathrooms: 4.5
|
|
|
|
Property Description:
The asking price for this fabulous waterfront property has been drastically reduced to accomodate to...
more>>
|
|
|
|
Status: Active
Price: $1,875,000
MLS Number: 905213
Type: Single Family
Bedrooms: 3
Bathrooms: 2.5
|
|
|
|
Property Description:
This 3000SF saltbox reproduction is tucked several hundred yards from Route 91 down a meandering tre...
more>>
|
|
|
|
Status: Active
Price: $1,800,000
MLS Number: 889508
Type: Residential
Bedrooms: 4
Bathrooms: 3.5
|
|
|
|
Property Description:
You'll enjoy meandering through mature woods on a winding drive to your custom built manor. This 2.6...
more>>
|
|
|
|
Status: Active
Price: $1,700,000
MLS Number: 897369
Type: Residential
Bedrooms: 5
Bathrooms: 1.5
|
|
|
|
Property Description:
This is vintage Maine oceanfront living. Built by a sea captain in 1880, this 5-bedroom home has be...
more>>
|
|
|
|
|
