|
|
|
|
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: $699000.
MLS Number: 984588
Type: Residential
Bedrooms: 4
Bathrooms: 2
|
|
|
|
Property Description:
Built in 1989 this spacious and light 4 bedroom, 2 bath, contemporary home with lovely gardens is re...
more>>
|
|
|
|
Status: Active
Price: $699,000
MLS Number: 973849
Type: Residential
Bedrooms: 3
Bathrooms: 3
|
|
|
|
Property Description:
YORK HARBOR - Enjoy picturesque ocean views from this brilliant 3BR/3BA multi-level Contemporary Ra...
more>>
|
|
|
|
Status: Active
Price: $699,000
MLS Number: 952784
Type: Residential
Bedrooms: 5
Bathrooms: 4.5
|
|
|
|
Property Description:
Absolute must-see custom colonial on a private cul-de-sac featuring a spacious and comfortable open ...
more>>
|
|
|
|
Status: Active
Price: $689,000
MLS Number: 874341
Type: Residential
Bedrooms: 3
Bathrooms: 2.5
|
|
|
|
Property Description:
Energy efficient "green home" being built y a local builder/craftsman. Master suite on the first fl...
more>>
|
|
|
|
Status: Active
Price: $675,000
MLS Number: 892087
Type: Residential
Bedrooms: 4
Bathrooms: 3
|
|
|
|
Property Description:
Own a piece of history with this unique property offering enormous potential including development. ...
more>>
|
|
|
|
Status: Active
Price: $675,000
Type: Residential
Bedrooms: 3
Bathrooms: 2.5
|
|
|
|
Property Description:
more>>
|
|
|
|
Status: Active
Price: $669,000
MLS Number: 947319
Type: Residential
Bedrooms: 3
Bathrooms: 1.5
|
|
|
|
Property Description:
Year round contemporary home located 'between the beaches' on the Nubble and offrering views of Cape...
more>>
|
|
|
|
Status: Active
Price: $649,900
MLS Number: 963649
Type: Condo
Bedrooms: 4
Bathrooms: 3
|
|
|
|
Property Description:
From the stunning custom wood working, marble, hardwood and tile floorings to the professional light...
more>>
|
|
|
|
Status: Active
Price: $649,000
MLS Number: 904856
Type: Residential
Bedrooms: 5
Bathrooms: 2.5
|
|
|
|
Property Description:
Contemporary Cape with 5 bedrooms and a first floor bedroom suite. Enjoy the beach with plenty of r...
more>>
|
|
|
|
Status: Active
Price: $649,000
MLS Number: 981549
Type: Single Family
Bedrooms: 3
Bathrooms: 1
|
|
|
|
Property Description:
Plucked from a painting......this 1930 vintage cape will win your heart! Set in coveted York Harbor...
more>>
|
|
|
|
|
