|
|
|
|
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: $195,000
MLS Number: 921100
Type: Land
|
|
|
|
Property Description:
.48 acre lot between U. S. Route One in Ogunquit and Ocean Heights Lane. Could be a house/residentia...
more>>
|
|
|
|
Status: Active
Price: $195,000
MLS Number: 968513
Type: Residential
Bedrooms: 3
Bathrooms: 1.5
|
|
|
|
Property Description:
Well maintained ranch w/ spacious 1400 SF floor plan including updated kitchen w/ double sinks & la...
more>>
|
|
|
|
Status: Active
Price: $194,900
MLS Number: 937585
Type: Residential
Bedrooms: 4
Bathrooms: 1
|
|
|
|
Property Description:
Meticulously maintained 4 bedroom Cape offering private lot, deck, patio, above ground pool, partial...
more>>
|
|
|
|
Status: Active
Price: $194,800
MLS Number: 895725
Type: Income
Bedrooms: 4
Bathrooms: 2
|
|
|
|
Property Description:
This Duplex has excellent monthly income $800 and $750. This is a larger older home with seperate ut...
more>>
|
|
|
|
Status: Active
Price: $193,000
MLS Number: 979901
Type: Single Family
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
Spacious Raised Ranch offering open living spaces, sprawling floor plan, fully finished basement, Ca...
more>>
|
|
|
|
Status: Active
Price: $192,000
MLS Number: 985047
Type: Residential
Bedrooms: 2
Bathrooms: 1.5
|
|
|
|
Property Description:
- Exposed beams
- Wide pine floors
- New pellet wood stove/electric heat
- 5 rooms
- 2 bedr...
more>>
|
|
|
|
Status: Active
Price: $190,000
MLS Number: 835142
Type: Land
|
|
|
|
Property Description:
2.90 acres with over 150' of water frontage tucked away in a serene cove of the Piscataqua River. Tr...
more>>
|
|
|
|
Status: Active
Price: $189,000
MLS Number: 900820
Type: Residential
Bedrooms: 3
Bathrooms: 1.75
|
|
|
|
Property Description:
Flexible floor plan
Studio or workshop behind garage
Large yard
Deck...
more>>
|
|
|
|
Status: Active
Price: $184,900
MLS Number: 811335
Type: Condo
Bedrooms: 2
Bathrooms: 1
|
|
|
|
Property Description:
Beach Dreams is a gated seasonal community built in 2005. Beautiful beaches nearby. This condo is th...
more>>
|
|
|
|
Status: Active
Price: $179,900
MLS Number: 945696
Type: Income
Bedrooms: 7
Bathrooms: 3
|
|
|
|
Property Description:
Call today to view this 3 family money maker or owner occupied. Close to shopping, Rte 95, and recre...
more>>
|
|
|
|
|
