|
|
|
|
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: $68,000
MLS Number: 963514
Type: Land
|
|
|
|
Property Description:
Located in a smaller, established neighborhood of homes on a wooded cul-de-sac this building lot fea...
more>>
|
|
|
|
Status: Active
Price: $675000
MLS Number: 919873
Type: Single Family
Bedrooms: 4
Bathrooms: 2
|
|
|
|
Property Description:
Panoramic views of the Atlantic Ocean and three light houses, Nubble Light House, Isle of Shoals and...
more>>
|
|
|
|
Status: Active
Price: $67,000
MLS Number: 918858
Type: Land
|
|
|
|
Property Description:
Build your dream home in this desirable neighborhood, perfect for commuters. CLose to I-95, Route On...
more>>
|
|
|
|
Status: Active
Price: $649900
MLS Number: 984463
Type: Residential
Bedrooms: 4
Bathrooms: 2
|
|
|
|
Property Description:
Sweet Cape- Hardwood flooring, trim, & doors, fireplace, newer roof, heating system, & generator. Fa...
more>>
|
|
|
|
Status: Active
Price: $599900
MLS Number: 942437
Type: Land
|
|
|
|
Property Description:
Julian Huxley Subdivision is 55plus absolutely beautiful acres, lush with mature trees, all surveyin...
more>>
|
|
|
|
Status: Active
Price: $59,900
MLS Number: 930002
Type: Condo
Bedrooms: 1
Bathrooms: 1
|
|
|
|
Property Description:
3 rooms including 3-season porch of approx. 120 sq. ft. Small association of 10 other units. Low f...
more>>
|
|
|
|
Status: Active
Price: $59,000
MLS Number: 926285
Type: Land
|
|
|
|
Property Description:
This wonderful lot is located in the very desirable "Merriland River Resort"...offering many onsite ...
more>>
|
|
|
|
Status: Active
Price: $589000
MLS Number: 989245
Type: Residential
Bedrooms: 6
Bathrooms: 2.5
|
|
|
|
Property Description:
VICTORIAN FEATURES on this 1910 RENOVATED BEACH HOME located 2/10 mile to YORK BEACH on a dead end s...
more>>
|
|
|
|
Status: Active
Price: $575000
MLS Number: 946981
Type: Residential
Bedrooms: 4
Bathrooms: 2.75
|
|
|
|
Property Description:
Gas fireplace in the livingroom, vaulted ceilings, formal diningroom, Library or den for a quiet ret...
more>>
|
|
|
|
Status: Active
Price: $56,900
MLS Number: 976625
Type: Residential
Bedrooms: 1
Bathrooms: 1
|
|
|
|
Property Description:
- Ogunquit Farms Park with swimming pool
- 2004 Chariot Eagle model with a 34'x8' sunroom attach...
more>>
|
|
|
|
|
