|
|
|
|
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: $499,000
MLS Number: 918441
Type: Single Family
Bedrooms: 5
Bathrooms: 3
|
|
|
|
Property Description:
This custom constructed cape epitomizes all that is New England. Privately sited on over 2 wooded ac...
more>>
|
|
|
|
Status: Active
Price: $499,000
MLS Number: 924034
Type: Residential
Bedrooms: 4
Bathrooms: 3
|
|
|
|
Property Description:
Great 2 family option in Cape Neddick. 3 Bedroom Contemporary home with a 1 bedroom apartment. 2 c...
more>>
|
|
|
|
Status: Active
Price: $499,000
MLS Number: 939596
Type: Residential
Bedrooms: 3
Bathrooms: 2.5
|
|
|
|
Property Description:
Local GREEN builder offering this incrediable package. Home features, 1st floor master suite with Sp...
more>>
|
|
|
|
Status: Active
Price: $499,000
MLS Number: 952719
Type: Residential
Bedrooms: 4
Bathrooms: 2
|
|
|
|
Property Description:
Expanded cape with vintage maine charm located near the Ogunquit town line. Private location with pr...
more>>
|
|
|
|
Status: Active
Price: $499,000
MLS Number: 963019
Type: Residential
Bedrooms: 4
Bathrooms: 3
|
|
|
|
Property Description:
This newly built 2450 square foot custom, contemporary home is just minutes to beaches, Kittery outl...
more>>
|
|
|
|
Status: Active
Price: $498,000
MLS Number: 965901
Type: Residential
Bedrooms: 2
Bathrooms: 2
|
|
|
|
Property Description:
Just steps from Marginal Way, Perkins Cove and Ogunquit eateries, this is an incredible place to cal...
more>>
|
|
|
|
Status: Active
Price: $495,000
MLS Number: 860098
Type: Land
|
|
|
|
Property Description:
Waterfront! One of two lots on Spruce Creek. Deep water access close to Portsmouth, shopping & all a...
more>>
|
|
|
|
Status: Active
Price: $495,000
MLS Number: 957513
Type: Land
|
|
|
|
Property Description:
Waterfront! One of two lots on Spruce Creek. Deep water access close to Portsmouth, shopping & all a...
more>>
|
|
|
|
Status: Active
Price: $495,000
MLS Number: 967389
Type: Residential
Bedrooms: 3
Bathrooms: 3
|
|
|
|
Property Description:
Lovely colonial on quiet street just minutes from downtown Ogunquit and Main Beach. Large bright kit...
more>>
|
|
|
|
Status: Active
Price: $490,000
MLS Number: 975635
Type: Residential
Bedrooms: 3
Bathrooms: 3
|
|
|
|
Property Description:
Charming & authentic 1938 vintage family compound nestled into the rolling, sloping landscape of Bar...
more>>
|
|
|
|
|
