|
|
|
|
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: $135,000
MLS Number: 954208
Type: Commercial
|
|
|
|
Property Description:
Garage and warehouse space that can be divided or used for one business. Check out this flexible spa...
more>>
|
|
|
|
Status: Active
Price: $130,000
MLS Number: 954213
Type: Commercial
|
|
|
|
Property Description:
Built to Energy Star Standards, this spacious office suite offers a convenient location and highly v...
more>>
|
|
|
|
Status: Active
Price: $129,900
MLS Number: 831469
Type: Land
|
|
|
|
Property Description:
more>>
|
|
|
|
Status: Active
Price: $129,000
MLS Number: 964883
Type: Land
|
|
|
|
Property Description:
Don't put off building your dream home any longer! These THREE scenic lots are ready for you to buil...
more>>
|
|
|
|
Status: Active
Price: $1285000
MLS Number: 962590
Type: Residential
Bedrooms: 3
Bathrooms: 3
|
|
|
|
Property Description:
Cathedral Grand Master Suite with a marble Fireplace added in 2007. Elegant Master bath with spa tub...
more>>
|
|
|
|
Status: Active
Price: $125,000
MLS Number: 954212
Type: Commercial
|
|
|
|
Property Description:
Enjoy this location on Route One, between York and Ogunquit! Well designed facility, designed to mee...
more>>
|
|
|
|
Status: Active
Price: $125,000
MLS Number: 977614
Type: Residential
Bedrooms: 2
Bathrooms: 1
|
|
|
|
Property Description:
Just like new this unit has never been used!3-season porch, cool A/C and 5 pools to chose from. The ...
more>>
|
|
|
|
Status: Active
Price: $124000.
MLS Number: 956498
Type: Single Family
Bedrooms: 1
Bathrooms: 1
|
|
|
|
Property Description:
Seasonal cottage in York. This is a rare find for beach location on almost half an acre. Near beache...
more>>
|
|
|
|
Status: Active
Price: $124,900
MLS Number: 968074
Type: Residential
Bedrooms: 4
Bathrooms: 2
|
|
|
|
Property Description:
Built in 1996 this 4 bedroom, 9 room DBL Wide offers open living spaces, wood burning fireplace, mas...
more>>
|
|
|
|
Status: Active
Price: $120,000
MLS Number: 954210
Type: Commercial
|
|
|
|
Property Description:
This front, second floor unit could easily divided for shared office space for those seeking a quiet...
more>>
|
|
|
|
|
