|
|
|
|
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: $594,000
MLS Number: 985094
Type: Residential
Bedrooms: 3
Bathrooms: 3
|
|
|
|
Property Description:
This new build in Ogunquit with 3bdrm floor plan, convenient location and views can be yours! Ogunqu...
more>>
|
|
|
|
Status: Active
Price: $575,000
MLS Number: 948819
Type: Single Family
Bedrooms: 3
Bathrooms: 3.5
|
|
|
|
Property Description:
Simply a sensational home with gorgeous views of the marsh and only steps to the ocean. This home we...
more>>
|
|
|
|
Status: Active
Price: $575,000
MLS Number: 953140
Type: Land
|
|
|
|
Property Description:
This lot will be subdivided from larger parcel. Development potential for a new subdivision, farmin...
more>>
|
|
|
|
Status: Active
Price: $559,000
MLS Number: 981237
Type: Residential
Bedrooms: 3
Bathrooms: 4
|
|
|
|
Property Description:
Live on the coast without sacrificing privacy. This carefully renovated, 1909 home offers an open fl...
more>>
|
|
|
|
Status: Active
Price: $559,000
MLS Number: 981237
Type: Single Family
Bedrooms: 3
Bathrooms: 4
|
|
|
|
Property Description:
Live on the coast without sacrificing privacy. This carefully renovated, 1909 home offers an open fl...
more>>
|
|
|
|
Status: Active
Price: $550,000
MLS Number: 927542
Type: Land
|
|
|
|
Property Description:
This land is surveyed and ready for building permits. Divided into 6 wooded residential lots. Perfec...
more>>
|
|
|
|
Status: Active
Price: $550,000
MLS Number: 957045
Type: Land
|
|
|
|
Property Description:
Large parcel ready for development within very healthy, well established industrial park. Water, s...
more>>
|
|
|
|
Status: Active
Price: $549,900
MLS Number: 948728
Type: Residential
Bedrooms: 4
Bathrooms: 3
|
|
|
|
Property Description:
Bright open concept floor plan,2 seperate master suites with jacuzzi and fireplace,central air,firep...
more>>
|
|
|
|
Status: Active
Price: $549,000
MLS Number: 965372
Type: Residential
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
Walk to Short & Long Sands beaches, restaurants & shops from this stylish, finely detailed, quality ...
more>>
|
|
|
|
Status: Active
Price: $545,000
MLS Number: 975577
Type: Residential
Bedrooms: 4
Bathrooms: 2.5
|
|
|
|
Property Description:
LOCATION, CHARM & INCOME all in one! This 2-unit home is in the heart of York Harbor & just steps f...
more>>
|
|
|
|
|
