|
|
|
|
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: $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>>
|
|
|
|
Status: Active
Price: $214,900
MLS Number: 982551
Type: Residential
Bedrooms: 2
Bathrooms: 1.75
|
|
|
|
Property Description:
One floor living in this 2-3 BR ranch w/ easy hwy access close to Naval Shipyard, Kittery Outlets & ...
more>>
|
|
|
|
Status: Active
Price: $214,000
MLS Number: 931275
Type: Condo
Bedrooms: 2
Bathrooms: 2
|
|
|
|
Property Description:
On the east of Route 1, located on a sidewalk to town, this Condo is also on the Trolley line. This...
more>>
|
|
|
|
Status: Active
Price: $212,500
MLS Number: 955295
Type: Residential
Bedrooms: 1
Bathrooms: 1
|
|
|
|
Property Description:
Much sought-after 2nd floor condo at Ocean Towers overlooking swimming pool. Freshly-painted with n...
more>>
|
|
|
|
Status: Active
Price: $210,000
MLS Number: 987373
Type: Residential
Bedrooms: 2
Bathrooms: 1
|
|
|
|
Property Description:
- Town water and town sewer
- Wood floors
- Finished room in basement
- Detached 1-car garag...
more>>
|
|
|
|
Status: Active
Price: $209,900
MLS Number: 974792
Type: Condo
Bedrooms: 2
Bathrooms: 1
|
|
|
|
Property Description:
Wonderful resort located minutes to Moody,Wells and Ogunquit Beach! The Cottages at Summer Village o...
more>>
|
|
|
|
Status: Active
Price: $207,000
MLS Number: 937585
Type: Residential
Bedrooms: 4
Bathrooms: 1
|
|
|
|
Property Description:
Meticulously maintained 4 bedroom Cape offering private lot, deck, patio, above ground pool, partial...
more>>
|
|
|
|
Status: Active
Price: $205,000
MLS Number: 959778
Type: Residential
Bedrooms: 3
Bathrooms: 1.5
|
|
|
|
Property Description:
Location is key! This welcoming home is situated in Old Mill, a desirable, well established neighbo...
more>>
|
|
|
|
Status: Active
Price: $199,995
MLS Number: 932775
Type: Residential
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
Village farmhouse with all the charm of yesteryear.This sunsplahed offering presents high ceilings, ...
more>>
|
|
|
|
Status: Active
Price: $199,900
MLS Number: 911087
Type: Land
|
|
|
|
Property Description:
This pretty wooded lot will benefit from a R.O.W. to the old RRbed where you can enjoy bucolic views...
more>>
|
|
|
|
|
