|
|
|
|
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: $349,000
MLS Number: 979087
Type: Condo
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
Walk to village from this charming Condo! This 'Aunt Bee' unit offers 3bdrms, 2 baths, diningroom, a...
more>>
|
|
|
|
Status: Active
Price: $349,000
MLS Number: 926955
Type: Residential
Bedrooms: 2
Bathrooms: 1.5
|
|
|
|
Property Description:
Nestled in a secluded & serene area, this Kittery Point home has comfort written all over it. Metic...
more>>
|
|
|
|
Status: Active
Price: $349,000
MLS Number: 957961
Type: Condo
Bedrooms: 2
Bathrooms: 1
|
|
|
|
Property Description:
Enjoy the majestic views of the Atlantic Ocean & Boone Island in this newly remodeled open concept c...
more>>
|
|
|
|
Status: Active
Price: $349,000
MLS Number: 961432
Type: Residential
Bedrooms: 2
Bathrooms: 2
|
|
|
|
Property Description:
In the heart of York Harbor, this historic condo offers a dynamic combination of charm, location & i...
more>>
|
|
|
|
Status: Active
Price: $349,000
MLS Number: 964074
Type: Income
|
|
|
|
Property Description:
Waterfront 3 unit w/ 72' frontage on the Piscataqua and a new 10'x20' floating dock w/ fixed pier & ...
more>>
|
|
|
|
Status: Active
Price: $345,000
MLS Number: 947551
Type: Single Family
Bedrooms: 4
Bathrooms: 2.5
|
|
|
|
Property Description:
This spacious 4 bedroom cape isnestled on 3.30 private acres and features a first floor master suite...
more>>
|
|
|
|
Status: Active
Price: $340,000
MLS Number: 921050
Type: Residential
Bedrooms: 5
Bathrooms: 3
|
|
|
|
Property Description:
SHORT SALE - Versatile duplex completely renovated in 2004 offers both residential & commercial usag...
more>>
|
|
|
|
Status: Active
Price: $340,000
MLS Number: 962375
Type: Single Family
Bedrooms: 2
Bathrooms: 1
|
|
|
|
Property Description:
Waterfront!!! Lovingly maintained Pine Point beach cottage w/ water frontage to the Scarborough Wild...
more>>
|
|
|
|
Status: Active
Price: $339,900
MLS Number: 927044
Type: Residential
Bedrooms: 3
Bathrooms: 1
|
|
|
|
Property Description:
Endless commercial development possibilies await...this 3 bedroom Cape with 2 car garage and cottage...
more>>
|
|
|
|
Status: Active
Price: $339,900
MLS Number: 927049
Type: Commercial
Bedrooms: 3
Bathrooms: 1
|
|
|
|
Property Description:
Endless commercial development possibilies await...this 3 bedroom Cape with 2 car garage and cottage...
more>>
|
|
|
|
|
