|
|
|
|
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: $339,000
MLS Number: 937020
Type: Land
|
|
|
|
Property Description:
Incredible location now available in Wells! This lot is tucked away on a quiet road offering the pri...
more>>
|
|
|
|
Status: Active
Price: $339,000
MLS Number: 988960
Type: Condo
Bedrooms: 4
Bathrooms: 3
|
|
|
|
Property Description:
Moody Beach is just a short walk away!!! In an incredibly convenient location, this low maintainance...
more>>
|
|
|
|
Status: Active
Price: $339,000
MLS Number: 985071
Type: Residential
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
Delightful & creative, this home is quite spacious with extra rooms for many options! Two living ro...
more>>
|
|
|
|
Status: Active
Price: $334,900
MLS Number: 966740
Type: Condo
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
The privacy of owning your own home with attached garage combined with the ease of condominium owner...
more>>
|
|
|
|
Status: Active
Price: $332,900
MLS Number: 960436
Type: Residential
Bedrooms: 4
Bathrooms: 2.5
|
|
|
|
Property Description:
The 3/4 acre lot is bordered by mature trees and abuts conservation land. Built as a traditional Col...
more>>
|
|
|
|
Status: Active
Price: $331,700
MLS Number: 988115
Type: Residential
Bedrooms: 4
Bathrooms: 2
|
|
|
|
Property Description:
Bank Owned-Foreclosure. Remodeled two family, with attention to design and energy efficiency sited o...
more>>
|
|
|
|
Status: Active
Price: $329,900
MLS Number: 976849
Type: Residential
Bedrooms: 4
Bathrooms: 2
|
|
|
|
Property Description:
- 8 rooms, 3 or 4 bedrooms, 2 full bathrooms
- Large 20 x 16 family with elec. stove fireplace in...
more>>
|
|
|
|
Status: Active
Price: $329,900
MLS Number: 968401
Type: Residential
Bedrooms: 3
Bathrooms: 1.75
|
|
|
|
Property Description:
- 3 bedroom, 2 bathrooms
- living room with fireplace
- eat-in kitchen with pantry
- 4-season...
more>>
|
|
|
|
Status: Active
Price: $329,000
MLS Number: 865516
Type: Residential
Bedrooms: 2
Bathrooms: 1
|
|
|
|
Property Description:
Neat & clean condo within walking distance to Long Sands beach. 2 bedrooms and 1.5 baths. Open con...
more>>
|
|
|
|
Status: Active
Price: $325,000
MLS Number: 971803
Type: Residential
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
Tastefully decorated Cape in private location yet centrally located to downtown Ogunquit, restaurant...
more>>
|
|
|
|
|
