|
|
|
|
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: $450,000
MLS Number: 930889
Type: Land
|
|
|
|
Property Description:
This wonderful WELLS BEACH lot is located directly on the Webhannet River and offers unsurpassed vie...
more>>
|
|
|
|
Status: Active
Price: $449,900
MLS Number: 986045
Type: Single Family
Bedrooms: 4
Bathrooms: 2.5
|
|
|
|
Property Description:
: Beautifully restored, the Ivory Paul House boasts period architectural detail, original hardware a...
more>>
|
|
|
|
Status: Active
Price: $449,900
MLS Number: 940580
Type: Residential
Bedrooms: 4
Bathrooms: 2
|
|
|
|
Property Description:
Home and Location can't be beat! Beautiful Cape along Main Street complete with 4 bedrooms, gorgeous...
more>>
|
|
|
|
Status: Active
Price: $449,900
MLS Number: 899166
Type: Residential
Bedrooms: 4
Bathrooms: 2
|
|
|
|
Property Description:
Built in 1973, this Lindal Cedar designed contemporary home boasts an open concept floor plan with s...
more>>
|
|
|
|
Status: Active
Price: $449,900
MLS Number: 986045
Type: Single Family
Bedrooms: 4
Bathrooms: 2.5
|
|
|
|
Property Description:
: Beautifully restored, the Ivory Paul House boasts period architectural detail, original hardware a...
more>>
|
|
|
|
Status: Active
Price: $449,000
MLS Number: 989100
Type: Single Family
Bedrooms: 2
Bathrooms: 2
|
|
|
|
Property Description:
Enjoy one level living in Ogunquit! This versatile, 3 bedroom, 2 bath home will be built in desirab...
more>>
|
|
|
|
Status: Active
Price: $449,000
MLS Number: 967195
Type: Residential
Bedrooms: 4
Bathrooms: 4
|
|
|
|
Property Description:
Superb attention to detail is the hallmark of this distinctive Cape that sits comfortably nestled am...
more>>
|
|
|
|
Status: Active
Price: $449,000
MLS Number: 972798
Type: Residential
Bedrooms: 3
Bathrooms: 2.5
|
|
|
|
Property Description:
This nearly 1/2 acre lot offers quiet sounds of nature, total privacy, and the perfect location near...
more>>
|
|
|
|
Status: Active
Price: $449,000
MLS Number: 942205
Type: Residential
Bedrooms: 4
Bathrooms: 2.5
|
|
|
|
Property Description:
Steps to The Ledges Golf Course this custom built colonial with an expansive farmers porch is nestle...
more>>
|
|
|
|
Status: Active
Price: $449,000
MLS Number: 979753
Type: Residential
Bedrooms: 4
Bathrooms: 2.5
|
|
|
|
Property Description:
This fabulous Raeside-Dame, Early American Reproduction home with its recent enhancements is designe...
more>>
|
|
|
|
|
