|
|
|
|
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: $399500
MLS Number: 987351
Type: Residential
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
This adorable year-round home is just 4/10 mile walk to York Beach. Wide pine and bamboo floors, wr...
more>>
|
|
|
|
Status: Active
Price: $39,900
MLS Number: 945270
Type: Land
|
|
|
|
Property Description:
Sanford's Premier Subdivision Featuring Buildable Lots for Sale. Excellent South Sanford Location Cl...
more>>
|
|
|
|
Status: Active
Price: $39,900
MLS Number: 945268
Type: Land
|
|
|
|
Property Description:
Sanford's Premier Subdivision Featuring Buildable Lots for Sale. Excellent South Sanford Location Cl...
more>>
|
|
|
|
Status: Active
Price: $378000
MLS Number: 990238
Type: Residential
Bedrooms: 4
Bathrooms: 2.5
|
|
|
|
Property Description:
NOT TO BE MISSED! Quality construction Colonial in pristine condition at
sought-after Deerfield Es...
more>>
|
|
|
|
Status: Active
Price: $374000
MLS Number: 990557
Type: Residential
Bedrooms: 3
Bathrooms: 1.75
|
|
|
|
Property Description:
This spacious 3 Bedroom Property offers 1.830 acres of land in wooded neighborhood. View property on...
more>>
|
|
|
|
Status: Active
Price: $342000
MLS Number: 964736
Type: Residential
Bedrooms: 3
Bathrooms: 2.5
|
|
|
|
Property Description:
This spacious in Town home, features three bed rooms a large kitchen with a cathedral ceiling a wood...
more>>
|
|
|
|
Status: Active
Price: $334900
MLS Number: 334900
Type: Condo
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
This lovely condominium in Ocean Meadows is immaculate and turnkey. The Ocean Meadows complex featur...
more>>
|
|
|
|
Status: Active
Price: $319000
MLS Number: 951942
Type: Single Family
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
Immaculate Cape Cod with a bright airy interior. A sunny back yard and deck with an automatic awning...
more>>
|
|
|
|
Status: Active
Price: $319000
MLS Number: 977648
Type: Residential
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
Charming cape built in 1960 and renovated with many upgrades from 2003 to 2010. Features include pub...
more>>
|
|
|
|
Status: Active
Price: $319000
MLS Number: 977648
Type: Residential
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
Features include town water and sewer, oil plus gas heat, many renovations from 2003 to 2010 in a de...
more>>
|
|
|
|
|
