|
|
|
|
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: $324,900
MLS Number: 970109
Type: Single Family
Bedrooms: 4
Bathrooms: 2.5
|
|
|
|
Property Description:
With over 2,800 sq/ft. this spacious Colonial offers open living spaces, private back yard, farmers ...
more>>
|
|
|
|
Status: Active
Price: $324,900
MLS Number: 970109
Type: Residential
Bedrooms: 4
Bathrooms: 2.5
|
|
|
|
Property Description:
With over 2,800 sq/ft. this spacious Colonial offers open living spaces, private back yard, farmers ...
more>>
|
|
|
|
Status: Active
Price: $319,000
MLS Number: 954809
Type: Condo
Bedrooms: 3
Bathrooms: 2.5
|
|
|
|
Property Description:
To Be Built. Upscale condo within walking distance to beach. 3+ levels of living offer wood floors. ...
more>>
|
|
|
|
Status: Active
Price: $319,000
MLS Number: 969627
Type: Residential
Bedrooms: 1
Bathrooms: 1
|
|
|
|
Property Description:
This recently updated year round cottage is delightful! Upgrades include new appliances and a gas bu...
more>>
|
|
|
|
Status: Active
Price: $319,000
MLS Number: 974543
Type: Residential
Bedrooms: 4
Bathrooms: 1.5
|
|
|
|
Property Description:
Excellent In-town neighborhood with easy access to 95, schools, and York Village. Spacious 4 bedroom...
more>>
|
|
|
|
Status: Active
Price: $319,000
Type: Single Family
Bedrooms: 5
Bathrooms: 2.5
|
|
|
|
Property Description:
Golfers take note! Your dream home is now available! There is room for everyone in this recently upd...
more>>
|
|
|
|
Status: Active
Price: $318,900
MLS Number: 968921
Type: Single Family
Bedrooms: 3
Bathrooms: 1
|
|
|
|
Property Description:
MOTIVATED SELLER! Lots of privacy for this rustic ranch, renovated, new family room addition w/firep...
more>>
|
|
|
|
Status: Active
Price: $314,900
MLS Number: 969810
Type: Residential
Bedrooms: 3
Bathrooms: 2
|
|
|
|
Property Description:
This fantastic Cape has been completely remodeled in 04-05 and is that cheerful retreat that everybo...
more>>
|
|
|
|
Status: Active
Price: $311,900
MLS Number: 938473
Type: Residential
Bedrooms: 3
Bathrooms: 1.25
|
|
|
|
Property Description:
Charming 3 Bedroom Cape with three dormers just steps to York Country Club, York River & Middle scho...
more>>
|
|
|
|
Status: Active
Price: $310,000
MLS Number: 874720
Type: Residential
Bedrooms: 3
Bathrooms: 2.5
|
|
|
|
Property Description:
Built in 2004 this well crafted open concept 3 bedroom 2.5 bathroom contemporary colonial with farme...
more>>
|
|
|
|
|
