|
|
|
|
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: $372,800
MLS Number: 901419
Type: Residential
Bedrooms: 1
Bathrooms: 1.5
|
|
|
|
Property Description:
Nestled among the pines overlooking Rachael Carson Wildlife Refuge and Ogunquit River. Very desirabl...
more>>
|
|
|
|
Status: Active
Price: $370,800
MLS Number: 973225
Type: Residential
Bedrooms: 3
Bathrooms: 1
|
|
|
|
Property Description:
6 room/3 bedroom cottage with public sewer and public water located in a prime "vacationland" settin...
more>>
|
|
|
|
Status: Active
Price: $369,900
MLS Number: 940051
Type: Commercial
Bedrooms: 4
Bathrooms: 3
|
|
|
|
Property Description:
If you're looking for a beautiful home AND an incredible deal, you've found it. Nestled off the roa...
more>>
|
|
|
|
Status: Active
Price: $369,900
MLS Number: 940051
Type: Residential
Bedrooms: 4
Bathrooms: 3
|
|
|
|
Property Description:
If you're looking for good value, this is it. This 4-bedroom home on nearly 4 acres of privacy has ...
more>>
|
|
|
|
Status: Active
Price: $365,000
MLS Number: 964892
Type: Residential
Bedrooms: 2
Bathrooms: 2
|
|
|
|
Property Description:
If you're looking for a home near the beach, with charm, comfort & space, look no more! This renova...
more>>
|
|
|
|
Status: Active
Price: $365,000
MLS Number: 957076
Type: Income
|
|
|
|
Property Description:
Well maintained 7 unit apartment building in historic district with excellent occupancy history, gen...
more>>
|
|
|
|
Status: Active
Price: $365,000
MLS Number: 984097
Type: Residential
Bedrooms: 3
Bathrooms: 1
|
|
|
|
Property Description:
Peekaboo ocean views from this circa 1900 seasonal 3BR cottage. On the market for first time in 65 y...
more>>
|
|
|
|
Status: Active
Price: $359,000
MLS Number: 938306
Type: Land
|
|
|
|
Property Description:
Oceanviews from this lot on a new cul-de-sac just a 2 minute walk to ocean's edge! Underground utili...
more>>
|
|
|
|
Status: Active
Price: $359,000
MLS Number: 982783
Type: Residential
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
Convenient to Rt. 236 and I95, this inviting cape offers an open floor plan, double sided fireplace ...
more>>
|
|
|
|
Status: Active
Price: $359,000
MLS Number: 969304
Type: Residential
Bedrooms: 4
Bathrooms: 2.5
|
|
|
|
Property Description:
Located near the golf course, with great open space and course views, this inviting home offers many...
more>>
|
|
|
|
|
