|
|
|
|
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: $449,000
MLS Number: 949800
Type: Residential
Bedrooms: 3
Bathrooms: 2.5
|
|
|
|
Property Description:
Gracious, custom built home situated on 19.98 wooded acres near the North Berwick town line. Chef's ...
more>>
|
|
|
|
Status: Active
Price: $449,000
MLS Number: 958196
Type: Residential
Bedrooms: 3
Bathrooms: 2.5
|
|
|
|
Property Description:
This custom 3 bedroom colonial with farmers' porch exudes character and style in a key location. Fea...
more>>
|
|
|
|
Status: Active
Price: $449,000
MLS Number: 978101
Type: Residential
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
Sun filled and spacious this stand alone condo feels like Home! Farmers porch, 3bdrms, hardwood floo...
more>>
|
|
|
|
Status: Active
Price: $447,900
MLS Number: 985252
Type: Residential
Bedrooms: 6
Bathrooms: 2
|
|
|
|
Property Description:
Build your wealth with this smart investment in York Village! This home is currently a duplex and i...
more>>
|
|
|
|
Status: Active
Price: $429,900
MLS Number: 956613
Type: Residential
Bedrooms: 4
Bathrooms: 2.5
|
|
|
|
Property Description:
4 bedroom Colonial designed w/open concept for easy life & entertaining,Cathedral great room w/Wood ...
more>>
|
|
|
|
Status: Active
Price: $429,900
MLS Number: 956613
Type: Residential
Bedrooms: 4
Bathrooms: 2.5
|
|
|
|
Property Description:
4 bedroom Grand Colonial designed w/open concept for easy life & entertaining,Cathedral great room w...
more>>
|
|
|
|
Status: Active
Price: $429,000
MLS Number: 931131
Type: Residential
Bedrooms: 3
Bathrooms: 1.75
|
|
|
|
Property Description:
Immaculate builder owned Cape with 3-4 bedrooms, 2 baths, updated granite kitchen, wood floors throu...
more>>
|
|
|
|
Status: Active
Price: $429,000
MLS Number: 944345
Type: Residential
Bedrooms: 4
Bathrooms: 2
|
|
|
|
Property Description:
Seller's loss is your gain!! Ogunquit building lot included with this property with the home alone p...
more>>
|
|
|
|
Status: Active
Price: $429,000
MLS Number: 965159
Type: Condo
Bedrooms: 4
Bathrooms: 4
|
|
|
|
Property Description:
What an opportunity to own a brand new home just a short walk to Long Sands Beach in York! Only 1 ot...
more>>
|
|
|
|
Status: Active
Price: $425,900
MLS Number: 968419
Type: Land
|
|
|
|
Property Description:
Beautiful, large, wooded parcel on a quiet side street just a 5 minute drive to Ogunquit Village and...
more>>
|
|
|
|
|
