|
|
|
|
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: $1,199,000
MLS Number: 963931
Type: Residential
Bedrooms: 7
Bathrooms: 2
|
|
|
|
Property Description:
Breathtaking views and incredible sunsets from this "Turn of the Century" oceanfront Victorian home....
more>>
|
|
|
|
Status: Active
Price: $1,199,000
MLS Number: 963931
Type: Residential
Bedrooms: 7
Bathrooms: 1.75
|
|
|
|
Property Description:
Step back in time in this charming architechural treasure. Original details, "Candy Kiss" turret, s...
more>>
|
|
|
|
Status: Active
Price: $1,195,000
MLS Number: 962945
Type: Residential
Bedrooms: 3
Bathrooms: 2.5
|
|
|
|
Property Description:
Bold Oceanfront Views! This stunning home is in that dream location right on the ocean with views of...
more>>
|
|
|
|
Status: Active
Price: $1,195,000
MLS Number: 932008
Type: Commercial
Bedrooms: 6
Bathrooms: 2
|
|
|
|
Property Description:
This fantastic property is located in the Center of Ogunquit Village! Currently operated as an offic...
more>>
|
|
|
|
Status: Active
Price: $1,195,000
MLS Number: 932008
Type: Commercial
Bedrooms: 6
Bathrooms: 2
|
|
|
|
Property Description:
This fantastic property is located in the Center of Ogunquit Village! Currently operated as an offic...
more>>
|
|
|
|
Status: Active
Price: $1,195,000
MLS Number: 970945
Type: Residential
Bedrooms: 5
Bathrooms: 1.5
|
|
|
|
Property Description:
This is vintage Maine oceanfront living. Built by a sea captain in 1880, this 5-bedroom home has be...
more>>
|
|
|
|
Status: Active
Price: $1,190,000
MLS Number: 937347
Type: Condo
Bedrooms: 3
Bathrooms: 3.5
|
|
|
|
Property Description:
Breathtaking penthouse home offers unobstructed and panoramic views of Portsmouth Harbor and citysca...
more>>
|
|
|
|
Status: Active
Price: $1,190,000
MLS Number: 921124
Type: Commercial
Bedrooms: 2
|
|
|
|
Property Description:
Prime Route One Location in Ogunquit - Large Commercial kitchen-generous seating capacity-2 BR apart...
more>>
|
|
|
|
Status: Active
Price: $1,190,000
MLS Number: 921124
Type: Commercial
Bedrooms: 2
|
|
|
|
Property Description:
Prime Route One Ogunquit Restaurant Location. Large commercial kitchen, generous seating capacity, a...
more>>
|
|
|
|
Status: Active
Price: $1,185,000
MLS Number: 962590
Type: Residential
Bedrooms: 3
Bathrooms: 3
|
|
|
|
Property Description:
The drama starts the instant you step inside and experience the free-flowing design without the obst...
more>>
|
|
|
|
|
