|
|
|
|
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: $539,000
MLS Number: 968712
Type: Residential
Bedrooms: 3
Bathrooms: 3
|
|
|
|
Property Description:
Wonderfully updated York River Farms home with 3 bedrooms, 2 1/2 baths for todays family! Perfect fo...
more>>
|
|
|
|
Status: Active
Price: $529,000
MLS Number: 963622
Type: Land
|
|
|
|
Property Description:
Elevated waterviews of Spruce Creek in serene Kittery Pt location.Large parcel with opportunity to c...
more>>
|
|
|
|
Status: Active
Price: $528,400
MLS Number: 974581
Type: Condo
Bedrooms: 1
Bathrooms: 1.5
|
|
|
|
Property Description:
Brilliant ocean views & invigorating seabreezes from this upscale 1 BR condo perched atop Marginal W...
more>>
|
|
|
|
Status: Active
Price: $525,000
MLS Number: 861121
Type: Residential
Bedrooms: 1
Bathrooms: 1
|
|
|
|
Property Description:
Boat, fish, swim or kayak from the serene banks of this private cove on the Piscataqua River in undi...
more>>
|
|
|
|
Status: Active
Price: $525,000
MLS Number: 962835
Type: Residential
Bedrooms: 5
Bathrooms: 2
|
|
|
|
Property Description:
Fantastic Opportunity to own 2 cottages steps to sandy Crescent Beach in Wells...Situated on almost ...
more>>
|
|
|
|
Status: Active
Price: $519,000
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: $499,900
MLS Number: 966427
Type: Residential
Bedrooms: 3
Bathrooms: 3.5
|
|
|
|
Property Description:
Sited among attractive woodlands and rugged topography, this stylish contemporary Cape with Farmer's...
more>>
|
|
|
|
Status: Active
Price: $499,800
MLS Number: 950006
Type: Residential
Bedrooms: 4
Bathrooms: 4
|
|
|
|
Property Description:
This home has you from hello! The serene pastoral setting is perfect for this dignified home. Nest...
more>>
|
|
|
|
Status: Active
Price: $499,500
MLS Number: 957282
Type: Commercial
|
|
|
|
Property Description:
The superior design of the two floors instills confidence by blending tasteful decor, functionality,...
more>>
|
|
|
|
Status: Active
Price: $499,000
MLS Number: 929879
Type: Condo
Bedrooms: 2
Bathrooms: 2
|
|
|
|
Property Description:
Bright and sunny, first floor, end unit overlooking Short Sands Beach. Open concept living and dinin...
more>>
|
|
|
|
|
