|
|
|
|
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: $224,900
MLS Number: 906533
Type: Residential
Bedrooms: 2
Bathrooms: 1.5
|
|
|
|
Property Description:
Appealing 2BR end unit townhouse condominium on the south end of Yorke Woods has been nicely updated...
more>>
|
|
|
|
Status: Active
Price: $224,000
MLS Number: 956245
Type: Land
|
|
|
|
Property Description:
Bring your dreams and builder to this beautiful 2 acre lot located in the highly desirable Raynes Ne...
more>>
|
|
|
|
Status: Active
Price: $223,500
MLS Number: 949490
Type: Residential
Bedrooms: 2
Bathrooms: 1
|
|
|
|
Property Description:
Country road ranch nestled on .33 acre of wooded land with outcroppings in Cape Neddick, wood burnin...
more>>
|
|
|
|
Status: Active
Price: $219,900
Type: Condo
Bedrooms: 1
Bathrooms: 2
|
|
|
|
Property Description:
2 units combined to create spacious 1 bedroom, year round condo...or use or rent separately. Indoor ...
more>>
|
|
|
|
Status: Active
Price: $219,000
MLS Number: 947397
Type: Condo
Bedrooms: 2
Bathrooms: 1.5
|
|
|
|
Property Description:
Greatly reduced! 'The Cottage' at Bittersweet is a whimsical York Harbor getaway w/in 1 mile to Long...
more>>
|
|
|
|
Status: Active
Price: $219,000
MLS Number: 934291
Type: Residential
Bedrooms: 3
Bathrooms: 1.75
|
|
|
|
Property Description:
This 8 room Ranch offers a sprawling floor plan, brand new heating system, 2 updated bathrooms,home ...
more>>
|
|
|
|
Status: Active
Price: $219,000
MLS Number: 908534
Type: Land
|
|
|
|
Property Description:
Build Immediately!! Generous one acre lot with building permit in hand. Privately yet conveniently t...
more>>
|
|
|
|
Status: Active
Price: $219,000
MLS Number: 974999
Type: Condo
Bedrooms: 2
Bathrooms: 1.5
|
|
|
|
Property Description:
Walk 200 yards to direct access at Ocean Park beach from this well located fully renovated 2 bedroom...
more>>
|
|
|
|
Status: Active
Price: $219,000
MLS Number: 975411
Type: Commercial
Bathrooms: 1
|
|
|
|
Property Description:
Visibility AND Location! If that's what you're looking for, and at a GREAT price, look no further! O...
more>>
|
|
|
|
Status: Active
Price: $215,000
MLS Number: 966832
Type: Condo
Bedrooms: 2
Bathrooms: 1.5
|
|
|
|
Property Description:
This spacious, appealing 2BR end unit townhouse condominium on the south end of Yorke Woods has been...
more>>
|
|
|
|
|
