|
|
|
|
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: $105,000
MLS Number: ME#957805 NH#2810578
Type: Residential
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
This upgraded 3 bedroom 2 bathroom home in desirable Marshwood Estates features a large kitchen with...
more>>
|
|
|
|
Status: Active
Price: $105,000
MLS Number: 983273
Type: Land
|
|
|
|
Property Description:
Incredible location, price, and opportunity await you! This existing post & beam barn is sited on 2....
more>>
|
|
|
|
Status: Active
Price: $100,000
MLS Number: 946038
Type: Condo
Bedrooms: 1
Bathrooms: 1
|
|
|
|
Property Description:
End unit with lots of light. Fully furnished condo suite.
Can be lived in yr round and owner has be...
more>>
|
|
|
|
Status: Active
Price: $99,000
MLS Number: 984314
Type: Land
|
|
|
|
Property Description:
This is the lowest priced lot in Ogunquit! Build now on this beautiful property! Enjoy this incredib...
more>>
|
|
|
|
Status: Active
Price: $99,000
MLS Number: 976126
Type: Condo
Bedrooms: 1
Bathrooms: 1
|
|
|
|
Property Description:
Location great for walking the Marginal Way, beaches, Perkins Cove across the street and over the br...
more>>
|
|
|
|
Status: Active
Price: $95,000
MLS Number: 954207
Type: Commercial
|
|
|
|
Property Description:
Nice first floor showroom or retail space for sale or lease. High visibility office space for walk i...
more>>
|
|
|
|
Status: Active
Price: $89,950
MLS Number: 953206
Type: Land
|
|
|
|
Property Description:
1.060 acre residential lot in Meetinghouse Acres II, a quiet neighborhood of attractive homes built ...
more>>
|
|
|
|
Status: Active
Price: $89,900
MLS Number: 959219
Type: Land
|
|
|
|
Property Description:
Buildable lot with Marsh Views & frontage on the river, surrounded by Rachel Carson conservation la...
more>>
|
|
|
|
Status: Active
Price: $89,900
MLS Number: 953984
Type: Residential
Bedrooms: 1
Bathrooms: 1
|
|
|
|
Property Description:
Compact condominium offering low maintenance lifestyle. $165/month condo fee covers all exterior ma...
more>>
|
|
|
|
Status: Active
Price: $89,000
MLS Number: 928301
Type: Land
|
|
|
|
Property Description:
more>>
|
|
|
|
|
