|
|
|
|
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: $272,000
MLS Number: 894845
Type: Residential
Bedrooms: 3
Bathrooms: 2.75
|
|
|
|
Property Description:
WELLS - Priced to sell! This newer 3BR Cape in a great neighborhood features a 1st floor BR with 3/4...
more>>
|
|
|
|
Status: Active
Price: $269,900
MLS Number: 962952
Type: Residential
Bedrooms: 3
Bathrooms: 1.5
|
|
|
|
Property Description:
GREAT VALUE in building your dream home in this sought-after neighborhood conveniently located near ...
more>>
|
|
|
|
Status: Active
Price: $269,900
MLS Number: 971646
Type: Condo
Bedrooms: 3
Bathrooms: 3
|
|
|
|
Property Description:
New 3 bedroom,2.5 bath ocean view townhouse is a short walk to Wells Harbor and the beach. Amenitie...
more>>
|
|
|
|
Status: Active
Price: $269,500
MLS Number: 985776
Type: Residential
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
Strategically upgraded & attractively updated with new hardwood flooring, kitchen countertops, light...
more>>
|
|
|
|
Status: Active
Price: $269,000
MLS Number: 943314
Type: Residential
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
This 2001,like-new home is located in a very nice neighborhood. It is near the cul-de-sac at the end...
more>>
|
|
|
|
Status: Active
Price: $269,000
MLS Number: 973670
Type: Residential
Bedrooms: 2
Bathrooms: 2
|
|
|
|
Property Description:
You can live on 1 floor: large bedroom, full bath, laundry, kit & living room w/ gorgeous oak floors...
more>>
|
|
|
|
Status: Active
Price: $267,000
MLS Number: 947775
Type: Condo
Bedrooms: 4
Bathrooms: 1
|
|
|
|
Property Description:
Looking for carefree living that puts you in the heart of it all. You can walk to it all that Ogunqu...
more>>
|
|
|
|
Status: Active
Price: $265,000
MLS Number: 961419
Type: Residential
Bedrooms: 1
Bathrooms: 1.5
|
|
|
|
Property Description:
If you want charm in a New England seaside village, this is it. In the heart of York Harbor, this h...
more>>
|
|
|
|
Status: Active
Price: $264,000
MLS Number: 978555
Type: Single Family
Bedrooms: 3
Bathrooms: 1.75
|
|
|
|
Property Description:
Enjoy walking to Ogunquit's beaches, shops & restaurants from this adorable, completely furnished bu...
more>>
|
|
|
|
Status: Active
Price: $260,000
MLS Number: 920052
Type: Residential
Bedrooms: 3
Bathrooms: 1
|
|
|
|
Property Description:
Great open living 2-3 bedroom cottage located only one mile to two sandy beaches. LARGE airy three-...
more>>
|
|
|
|
|
