|
|
|
|
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: $425,000
MLS Number: 914401
Type: Land
|
|
|
|
Property Description:
Prime Moody Beach location to enjoy the sights and sounds of the roaring Atlantic Ocean. Situated ac...
more>>
|
|
|
|
Status: Active
Price: $425,000
MLS Number: 954777
Type: Commercial
Bedrooms: 3
Bathrooms: 1.75
|
|
|
|
Property Description:
This Colonial 3+ bedroom, 2 bath home has wonderful colors, hardwood floors through out, granite cou...
more>>
|
|
|
|
Status: Active
Price: $424,000
MLS Number: 956383
Type: Residential
Bedrooms: 3
Bathrooms: 2.5
|
|
|
|
Property Description:
Renovated & expanded cape privately set back on 1.96 level,manicured acres.Oversized windows pour su...
more>>
|
|
|
|
Status: Active
Price: $419,900
MLS Number: 087944
Type: Condo
Bedrooms: 3
Bathrooms: 3
|
|
|
|
Property Description:
Fully furnished, 3 bedroom - 2.5 bathroom, year round townhouse offering magnificent marsh/water vie...
more>>
|
|
|
|
Status: Active
Price: $419,900
MLS Number: 944583
Type: Residential
Bedrooms: 4
Bathrooms: 2.5
|
|
|
|
Property Description:
Grand 4 bedroom Colonial, open concept,flexible floor plan, plenty of natural light, modern kitchen,...
more>>
|
|
|
|
Status: Active
Price: $419,000
MLS Number: 978540
Type: Residential
Bedrooms: 3
Bathrooms: 1
|
|
|
|
Property Description:
EARN OVER $25,000 IN RENTAL INCOME!!!It's all about LOCATION....just a 5 minute stroll to the center...
more>>
|
|
|
|
Status: Active
Price: $419,000
MLS Number: 970367
Type: Residential
Bedrooms: 3
Bathrooms: 3
|
|
|
|
Property Description:
Quintessential Raeside Dame on a picturesque corner lot in one of Eliot's most desirable areas. Arch...
more>>
|
|
|
|
Status: Active
Price: $418,000
MLS Number: 975412
Type: Residential
Bedrooms: 1
Bathrooms: 1
|
|
|
|
Property Description:
Opportunity Knocks! Fantastic opportunity to own single family home AND commercial building! Home si...
more>>
|
|
|
|
Status: Active
Price: $399,000
MLS Number: 969327
Type: Residential
Bedrooms: 3
Bathrooms: 1.5
|
|
|
|
Property Description:
Plenty of light & space in this impeccably maintained and privately located cape on 6.79 acres. The ...
more>>
|
|
|
|
Status: Active
Price: $399,000
MLS Number: 965659
Type: Residential
Bedrooms: 3
Bathrooms: 3
|
|
|
|
Property Description:
After a day at the beach, retreat to your Brand NEW home with distant oceanviews bordered by conserv...
more>>
|
|
|
|
|
