|
|
|
|
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,795,000
MLS Number: 950154
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: 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,595,000
MLS Number: 950154
Type: Residential
Bedrooms: 4
Bathrooms: 4
|
|
|
|
Property Description:
Just imagine...coming home to this stunning custom home, capturing wide and ever changing views of t...
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: 860176
Type: Residential
Bedrooms: 5
Bathrooms: 4.5
|
|
|
|
Property Description:
This skillfully crafted shingle-style contemporary home comes with deeded waterfront, common dock ri...
more>>
|
|
|
|
