|
|
|
|
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: $309,900
MLS Number: 978984
Type: Residential
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
This 7 year young home is rich in detail, amenities and location. 1 floor living at it's best with ...
more>>
|
|
|
|
Status: Active
Price: $299,900
MLS Number: 913822
Type: Residential
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
Spacious open concept Ranch in Cape Neddick offering great privacy and plenty of natural light. Open...
more>>
|
|
|
|
Status: Active
Price: $299,900
MLS Number: 968532
Type: Single Family
Bedrooms: 3
Bathrooms: 2.5
|
|
|
|
Property Description:
3bdrm 2.5 bath home w/large 2 car garage & additional detached garage/workshop. Set back from the ro...
more>>
|
|
|
|
Status: Active
Price: $299,500
MLS Number: 965291
Type: Residential
Bedrooms: 3
Bathrooms: 2.5
|
|
|
|
Property Description:
Built in 2006 at the end of a cul-de-sac of a planned small division of homes, this large, quality L...
more>>
|
|
|
|
Status: Active
Price: $299,000
MLS Number: 903904
Type: Land
|
|
|
|
Property Description:
CAPE NEDDICK-Build your dream home or Create your own family compound on this wonderful 140 acres o...
more>>
|
|
|
|
Status: Active
Price: $299,000
MLS Number: 881667
Type: Residential
Bedrooms: 3
Bathrooms: 2.5
|
|
|
|
Property Description:
2005 Colonial in a picturesque setting. 3 bedrooms and 2.5 baths. Open concept with 2 story foyer,...
more>>
|
|
|
|
Status: Active
Price: $299,000
MLS Number: 969143
Type: Residential
Bedrooms: 2
Bathrooms: 1
|
|
|
|
Property Description:
The "Postage Stamp" cottage is a charming 1 1/2 story bungalow located within steps of the Footbridg...
more>>
|
|
|
|
Status: Active
Price: $295,500
MLS Number: 973342
Type: Residential
Bedrooms: 2
Bathrooms: 1
|
|
|
|
Property Description:
4 room, 2 bedroom cottage with a 20' x 16' sleeping loft and 16' x 16.5' porch. Enjoy being only a f...
more>>
|
|
|
|
Status: Active
Price: $295,000
MLS Number: 971937
Type: Land
|
|
|
|
Property Description:
Rare Opportunity to build your dream home in Ogunquit. Waterviews and large, flat lot and no wait f...
more>>
|
|
|
|
Status: Active
Price: $295,000
MLS Number: 938766
Type: Residential
Bedrooms: 3
Bathrooms: 3
|
|
|
|
Property Description:
Spacious and flexible this 3 bedroom home built in 2002 is a wonderful value! Just 7 years young, th...
more>>
|
|
|
|
|
