|
|
|
|
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: $199,900
Type: Residential
Bedrooms: 2
Bathrooms: 1.5
|
|
|
|
Property Description:
Enjoy all of York's precious beaches in all the spare time you will have when you own this open conc...
more>>
|
|
|
|
Status: Active
Price: $199,000
MLS Number: 954215
Type: Commercial
|
|
|
|
Property Description:
Busy Route One Retail/Commercial/Residential, with high traffic/visibility on corner lot. 12 room -...
more>>
|
|
|
|
Status: Active
Price: $199,000
MLS Number: 901983
Type: Land
|
|
|
|
Property Description:
Situated on an 11.483 acre wooded lot, this exceptionally private parcel is located just 5 miles fro...
more>>
|
|
|
|
Status: Active
Price: $199,000
MLS Number: 928173
Type: Condo
Bedrooms: 2
Bathrooms: 1
|
|
|
|
Property Description:
Your own personal cottage near the sea with marsh and ocean views. Attractively decorated and fully ...
more>>
|
|
|
|
Status: Active
Price: $199,000
MLS Number: 928173
Type: Condo
Bedrooms: 2
Bathrooms: 1
|
|
|
|
Property Description:
Own your very own cottage by the sea. This attractively decorated and fully furnished 2 bedroom cott...
more>>
|
|
|
|
Status: Active
Price: $199,000
MLS Number: 973643
Type: Land
|
|
|
|
Property Description:
Build immediately! Foundation poured and ready to complete this .69 acre parcel on a quiet cul-de-sa...
more>>
|
|
|
|
Status: Active
Price: $199,000
MLS Number: 973818
Type: Land
|
|
|
|
Property Description:
Build immediately on this large 3.59 acre lot among fine colonial style homes on a quiet cul-de-sac....
more>>
|
|
|
|
Status: Active
Price: $199,000
MLS Number: 981421
Type: Land
|
|
|
|
Property Description:
Less than 500 yards from the ocean, this lot is oversized for beach properties! Already cleared, su...
more>>
|
|
|
|
Status: Active
Price: $195,000
MLS Number: 975862
Type: Land
|
|
|
|
Property Description:
A wonderful opportunity to build has presented itself here, just a short walk to Ogunquit Village an...
more>>
|
|
|
|
Status: Active
Price: $195,000
MLS Number: 921100
Type: Land
|
|
|
|
Property Description:
.48 acre lot between U. S. Route One in Ogunquit and Ocean Heights Lane. Could be a house/residentia...
more>>
|
|
|
|
|
