|
|
|
|
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: $549000
MLS Number: 972381
Type: Single Family
Bedrooms: 2
Bathrooms: 2
|
|
|
|
Property Description:
Artist, master gardener, and avante-garde buyers will appreciate the tasteful creativity and expert ...
more>>
|
|
|
|
Status: Active
Price: $508000
MLS Number: 956017
Type: Commercial
Bedrooms: 3
Bathrooms: 2.5
|
|
|
|
Property Description:
If 20 units scares you this could also be a smaller project! For conventional housing the land requi...
more>>
|
|
|
|
Status: Active
Price: $499900
MLS Number: 962409
Type: Residential
Bedrooms: 4
Bathrooms: 1.5
|
|
|
|
Property Description:
- 4-bedroom, 1 1/2 bath New Englander
- Built in 1880, this home was used as summer residence for...
more>>
|
|
|
|
Status: Active
Price: $479000
MLS Number: 972189
Type: Income
Bedrooms: 4
Bathrooms: 2
|
|
|
|
Property Description:
Main house is 3 bdrm w/curved staircase, private patio and much more. Charming stand alone cottage i...
more>>
|
|
|
|
Status: Active
Price: $469900
MLS Number: 905207
Type: Condo
Bedrooms: 4
Bathrooms: 4
|
|
|
|
Property Description:
Location, location, just steps to Short Sands Beach & fun for all. This 2375 sq. ft. Townhouse is pe...
more>>
|
|
|
|
Status: Active
Price: $468000
MLS Number: 934314
Type: Condo
Bedrooms: 3
Bathrooms: 2.5
|
|
|
|
Property Description:
Exceptional waterview townhouse 2690 sq.ft. overlooking the Piscatqua River. Great Portsmouth experi...
more>>
|
|
|
|
Status: Active
Price: $449900
MLS Number: 954914
Type: Residential
Bedrooms: 3
Bathrooms: 2.5
|
|
|
|
Property Description:
Nubble, excellent private location at the end of a private Rd. Spacious 1972 Sq/ft well maintained 3...
more>>
|
|
|
|
Status: Active
Price: $44,900
MLS Number: 978964
Type: Residential
Bedrooms: 1
Bathrooms: 1
|
|
|
|
Property Description:
Built in 2004, this Breckenridge mobile home has an attached 30' x 10' screened-in porch for your su...
more>>
|
|
|
|
Status: Active
Price: $435000
MLS Number: 987324
Type: Condo
Bedrooms: 2
Bathrooms: 1.75
|
|
|
|
Property Description:
This charming cottage style condominium has virtually everything one could wish for in a retirement ...
more>>
|
|
|
|
Status: Active
Price: $42,500
MLS Number: 982407
Type: Residential
Bedrooms: 1
Bathrooms: 1
|
|
|
|
Property Description:
- 2005 Breckenridge 844 SB-3
- 1 bedroom with plenty of built-in storage space
- bathroom with ...
more>>
|
|
|
|
|
