|
|
|
|
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: $382,500
MLS Number: 967566
Type: Residential
Bedrooms: 3
Bathrooms: 2.5
|
|
|
|
Property Description:
Delightful 3BR colonial tucked privately away from the street on 2+ well-landscaped acres. A spaciou...
more>>
|
|
|
|
Status: Active
Price: $380,000
MLS Number: 973823
Type: Residential
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
Exceptional location AND price! This beautiful home offers 3 bedrooms, 1.5 baths, open concept livin...
more>>
|
|
|
|
Status: Active
Price: $379,900
MLS Number: 963917
Type: Residential
Bedrooms: 4
Bathrooms: 1.75
|
|
|
|
Property Description:
A remarkable makeover! Located in a desirable, well-established York neighborhood this Colonial sta...
more>>
|
|
|
|
Status: Active
Price: $379,900
MLS Number: 963917
Type: Residential
Bedrooms: 4
Bathrooms: 1.75
|
|
|
|
Property Description:
Located in a desirable, well-established York neighborhood this Colonial stands apart with its drama...
more>>
|
|
|
|
Status: Active
Price: $379,000
MLS Number: 935732
Type: Residential
Bedrooms: 2
Bathrooms: 2.5
|
|
|
|
Property Description:
Great Location! Easy walk to Long Sands Beach from this very well maintained multi level home. 2+ ...
more>>
|
|
|
|
Status: Active
Price: $379,000
MLS Number: 959990
Type: Residential
Bedrooms: 5
Bathrooms: 3.5
|
|
|
|
Property Description:
South Berwick in-town colonial with hardwood floors, high ceilings, wainscoting, mouldings, 2 Firepl...
more>>
|
|
|
|
Status: Active
Price: $375,000
MLS Number: 984311
Type: Residential
Bedrooms: 2
Bathrooms: 1
|
|
|
|
Property Description:
Fantastic location East of Rt 1 in Ogunquit! Full of charm and comfortable living space including a ...
more>>
|
|
|
|
Status: Active
Price: $375,000
MLS Number: 970433
Type: Condo
Bedrooms: 2
Bathrooms: 2
|
|
|
|
Property Description:
Located in desirable Ocean Meadows, on trolley stop, this 2 bdrm condo offers spacious floorplan, hu...
more>>
|
|
|
|
Status: Active
Price: $374,900
MLS Number: 884349
Type: Condo
Bedrooms: 2
Bathrooms: 2
|
|
|
|
Property Description:
Completely renovated buildings. Multi level townhome with vaulted ceilings, gas fireplace, attached...
more>>
|
|
|
|
Status: Active
Price: $372,800
MLS Number: 901419
Type: Residential
Bedrooms: 1
Bathrooms: 1.5
|
|
|
|
Property Description:
Nestled among the pines overlooking Rachael Carson Wildlife Refuge and Ogunquit River. Very desirabl...
more>>
|
|
|
|
|
