|
|
|
|
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: $275,000
MLS Number: 955430
Type: Condo
Bedrooms: 3
Bathrooms: 2.5
|
|
|
|
Property Description:
To Be Built! Upscale condo within walking distance to ebach & shopping. 3+ levels of living space of...
more>>
|
|
|
|
Status: Active
Price: $275,000
MLS Number: 961222
Type: Residential
Bedrooms: 4
Bathrooms: 2.25
|
|
|
|
Property Description:
This 3-4 bedroom classic style cape has been lovingly maintained and offers spacious rooms, sensibl...
more>>
|
|
|
|
Status: Active
Price: $275,000
MLS Number: 955434
Type: Condo
Bedrooms: 3
Bathrooms: 2.5
|
|
|
|
Property Description:
To be built! Upscale condo within walking distance to beach & shopping. 3+ levels of living space of...
more>>
|
|
|
|
Status: Active
Price: $275,000
MLS Number: 955432
Type: Condo
Bedrooms: 3
Bathrooms: 2.5
|
|
|
|
Property Description:
To be built! Upscale condo within walking distance to beach & shopping. 3+ levels of living space of...
more>>
|
|
|
|
Status: Active
Price: $275,000
MLS Number: 966972
Type: Residential
Bedrooms: 2
Bathrooms: 1
|
|
|
|
Property Description:
.1 mile walk to the beach! This sweet cottage is open and inviting! Dry off from the beach on the en...
more>>
|
|
|
|
Status: Active
Price: $275,000
MLS Number: 966972
Type: Single Family
Bedrooms: 2
Bathrooms: 1
|
|
|
|
Property Description:
This sweet cottage is open & inviting.Dry off from the beach on the enclosed 9x11 porch.Turn on the ...
more>>
|
|
|
|
Status: Active
Price: $274,900
MLS Number: 939588
Type: Residential
Bedrooms: 4
Bathrooms: 3
|
|
|
|
Property Description:
This spacious Colonial offers plenty of room for the entire family. High end finishings, quality con...
more>>
|
|
|
|
Status: Active
Price: $274,900
MLS Number: 947168
Type: Condo
Bedrooms: 3
Bathrooms: 3
|
|
|
|
Property Description:
Built Following the strictest of standards for energy efficiency and having earned the Energy Star R...
more>>
|
|
|
|
Status: Active
Price: $274,900
MLS Number: 947166
Type: Condo
Bedrooms: 3
Bathrooms: 3
|
|
|
|
Property Description:
Built Following the strictest of standards for energy efficiency and having earned the Energy Star R...
more>>
|
|
|
|
Status: Active
Price: $274,900
MLS Number: 947156
Type: Condo
Bedrooms: 3
Bathrooms: 3
|
|
|
|
Property Description:
Built Following the strictest of standards for energy efficiency and having earned the Energy Star R...
more>>
|
|
|
|
|
