|
|
|
|
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' ORDER BY ap_property.property_LocationID ASC, ap_property.property_StatusID ASC, LPAD(ap_property.property_ListPrice,12,'0') DESC
|
|
Status: Sold
Sold for: $1,941,500
Original Price: $2,100,000
MLS Number: 896848
Type: Residential
Bedrooms: 4
Bathrooms: 3
|
|
|
|
Property Description:
Architecturally designed cottage-style home sited on an acre of professionally landscaped grounds wi...
more>>
|
|
|
|
Status: Sold
Price: $1,600,000
MLS Number: 744789
Type: Residential
Bedrooms: 3
Bathrooms: 3.5
|
|
|
|
Property Description:
Island living at its best - awake to the sun rising over the cool waters of the Piscataqua River - a...
more>>
|
|
|
|
Status: Sold
Price: $1,500,000
MLS Number: 841110
Type: Commercial
|
|
|
|
Property Description:
TURNKEY Operation. Open the doors and serve in this incredibly busy, Center of Town Location. 100+ ...
more>>
|
|
|
|
Status: Sold
Price: $1,495,000
MLS Number: 775656
Type: Residential
Bedrooms: 3
Bathrooms: 3
|
|
|
|
Property Description:
Ocean view home has a walk to Marginal Way and Little Beach location. This home offers cherry hardw...
more>>
|
|
|
|
Status: Sold
Price: $1,395,000
Type: Residential
Bedrooms: 3
Bathrooms: 3.5
|
|
|
|
Property Description:
Escape from the ordinary when you walk into this fabulous home. Open concept living allows you to e...
more>>
|
|
|
|
Status: Sold
Price: $1,275,000
MLS Number: 860512
Type: Residential
Bedrooms: 4
Bathrooms: 3.5
|
|
|
|
Property Description:
4 large bedrooms, 3.5 well appointed baths, master suite,harwood floors, radiant heat, floor to ceil...
more>>
|
|
|
|
Status: Sold
Price: $1,100,000
MLS Number: 880911
Type: Residential
Bedrooms: 3
Bathrooms: 3.5
|
|
|
|
Property Description:
GREET THE MORNING from your east facing Stage Neck Condo! This unit affords more privacy than most, ...
more>>
|
|
|
|
Status: Sold
Price: $995,000
MLS Number: 870348
Type: Residential
Bedrooms: 3
Bathrooms: 2.5
|
|
|
|
Property Description:
Old time Ogunquit home professionally restored and updated. Fantastic gourmet kitchen featuring 10 f...
more>>
|
|
|
|
Status: Sold
Price: $899,000
MLS Number: 881248
Type: Residential
Bedrooms: 3
Bathrooms: 4
|
|
|
|
Property Description:
Walk to the Marginal Way, Perkins Cove and the Ogunuit Beaches from this well designed, new construc...
more>>
|
|
|
|
Status: Sold
Price: $849,000
MLS Number: 804115
Type: Residential
Bedrooms: 4
Bathrooms: 1
|
|
|
|
Property Description:
Waterfront property with bold ocean view and only steps to Short Sands Beach. Restore it to its orig...
more>>
|
|
|
|
