|
|
|
|
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: $179,000
MLS Number: 911575
Type: Single Family
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
Close to the New Hampshire border this three bedroom, two bath New Englander enjoys a sunny bright i...
more>>
|
|
|
|
Status: Active
Price: $179,000
MLS Number: 975410
Type: Residential
Bedrooms: 1
Bathrooms: 1
|
|
|
|
Property Description:
Easy access to I-95 or to Route One and Beaches! This one bedroom is located on nearly a half acre w...
more>>
|
|
|
|
Status: Active
Price: $176,000
MLS Number: 874191
Type: Land
|
|
|
|
Property Description:
Building Permit in Hand. Walk to Ogunquit Beaches. Lovely wooded two acreas overlooking Josias Norto...
more>>
|
|
|
|
Status: Active
Price: $170,000
MLS Number: 978804
Type: Residential
Bedrooms: 3
Bathrooms: 1.5
|
|
|
|
Property Description:
Investment opportunity with a great location - within walking distance to Dock Square & Beach! Needs...
more>>
|
|
|
|
Status: Active
Price: $169,000
MLS Number: 978853
Type: Land
|
|
|
|
Property Description:
Location AND Price! This nearly 2 1/2 acre secluded lot is located near Cape Neddick Country Club, m...
more>>
|
|
|
|
Status: Active
Price: $165,000
MLS Number: 874378
Type: Land
|
|
|
|
Property Description:
Perk tested
Building permit filed
Kittery public water services this area
Wooded with scenic view...
more>>
|
|
|
|
Status: Active
Price: $165,000
MLS Number: 958732
Type: Residential
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
$8,000 TAX Credit! If you have not owned a home in the 3 years or are a first-time buyer. This singl...
more>>
|
|
|
|
Status: Active
Price: $163,900
MLS Number: 892993
Type: Residential
Bedrooms: 1
Bathrooms: 1
|
|
|
|
Property Description:
Start your memories! Fun, summer seasonal, private cottage ready for family and friends. Convenient...
more>>
|
|
|
|
Status: Active
Price: $159,900
MLS Number: 968410
Type: Land
|
|
|
|
Property Description:
Excellent location for your dream home in Ogunquit. Gorgeous lot on quiet side street centrally loc...
more>>
|
|
|
|
Status: Active
Price: $159,900
MLS Number: 968412
Type: Land
|
|
|
|
Property Description:
Gorgeous lot on quiet side street centrally located just a short drive from Ogunquit Village, beach,...
more>>
|
|
|
|
|
