|
|
|
|
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: $249,000
MLS Number: 980774
Type: Condo
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
Offered at nearly $28K below Assessed Value! Live in the heart of Short Sands and enjoy all that "Va...
more>>
|
|
|
|
Status: Active
Price: $249,000
MLS Number: 942435
Type: Land
|
|
|
|
Property Description:
Partially cleared in front and lush, wooded with a pond in rear. Beautiful area with potential. You ...
more>>
|
|
|
|
Status: Active
Price: $245,900
MLS Number: 977957
Type: Single Family
Bedrooms: 3
Bathrooms: 1
|
|
|
|
Property Description:
Great location just a 0.4 mile walk to the beach. Home needs a lot of attention but with a pretty ha...
more>>
|
|
|
|
Status: Active
Price: $243,900
MLS Number: 988934
Type: Residential
Bedrooms: 4
Bathrooms: 2
|
|
|
|
Property Description:
Income possibilities here in this lovely duplex located on Ogunquit River! You'll appreciate walking...
more>>
|
|
|
|
Status: Active
Price: $239,900
MLS Number: 970393
Type: Single Family
Bedrooms: 4
Bathrooms: 2.5
|
|
|
|
Property Description:
Unrivaled in its price range, this 4 BR Colonial is designed with attention to detail & efficiency f...
more>>
|
|
|
|
Status: Active
Price: $239,000
MLS Number: 980886
Type: Condo
Bedrooms: 1
Bathrooms: 1
|
|
|
|
Property Description:
Perfect location!!!East of Route One and a very easy walk to beach! This recently renovated condo ha...
more>>
|
|
|
|
Status: Active
Price: $239,000
MLS Number: 972796
Type: Residential
Bedrooms: 1
Bathrooms: 1
|
|
|
|
Property Description:
This special cottage in the woods is located on a private, serene lot and is just waiting for your T...
more>>
|
|
|
|
Status: Active
Price: $239,000
MLS Number: 911092
Type: Land
|
|
|
|
Property Description:
Reward yourself with privacy & natural surroundings, accessed by a R.O.W. Enjoy walks to the old RR...
more>>
|
|
|
|
Status: Active
Price: $239,000
MLS Number: 976937
Type: Residential
Bedrooms: 5
Bathrooms: 2
|
|
|
|
Property Description:
PRICED TO SELL! Privacy galore! This split entry home boasts 4 bedrooms, front porch, 2 car attached...
more>>
|
|
|
|
Status: Active
Price: $239,000
MLS Number: 981958
Type: Condo
Bedrooms: 1
Bathrooms: 1
|
|
|
|
Property Description:
Views of marsh and beyond! Savor ocean breezes and views from your private deck. Immaculate and char...
more>>
|
|
|
|
|
