|
|
|
|
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: $159,900
MLS Number: 921578
Type: Land
|
|
|
|
Property Description:
more>>
|
|
|
|
Status: Active
Price: $159,000
MLS Number: 988757
Type: Residential
Bedrooms: 2
Bathrooms: 2
|
|
|
|
Property Description:
Bright open spaces offered in this well maintined home. Convenient in-town location, hardwood floor ...
more>>
|
|
|
|
Status: Active
Price: $155,000
MLS Number: 982347
Type: Condo
Bedrooms: 2
Bathrooms: 1
|
|
|
|
Property Description:
Great value in a convenient location!! This pet friendly condo is located within walking distance to...
more>>
|
|
|
|
Status: Active
Price: $154,000
MLS Number: 960273
Type: Residential
Bedrooms: 2
Bathrooms: 1
|
|
|
|
Property Description:
Great 1st Time Home Buyer opportunity with $8000Tax Credit. Immaculate 2BR condo within walking dist...
more>>
|
|
|
|
Status: Active
Price: $150,000
MLS Number: 882402
Type: Land
|
|
|
|
Property Description:
Lot is being sold out of subdivision recorded back in 1978.
Map 87 Lot 62...
more>>
|
|
|
|
Status: Active
Price: $139,900
MLS Number: 934838
Type: Land
|
|
|
|
Property Description:
Wonderfully situated building lot located in the area's premier subdivision..."The Forest"...offerin...
more>>
|
|
|
|
Status: Active
Price: $139,500
MLS Number: 947891
Type: Residential
Bedrooms: 2
Bathrooms: 2
|
|
|
|
Property Description:
55+ Community w/a friendly atmosphere, Outdoor activities, Library, Club house & Exersise room. Hand...
more>>
|
|
|
|
Status: Active
Price: $136,900
MLS Number: 942886
Type: Land
|
|
|
|
Property Description:
Convenient yet Private location off Branch Road in Wells. Underground utilities, private road maint...
more>>
|
|
|
|
Status: Active
Price: $135,000
MLS Number: 964887
Type: Land
|
|
|
|
Property Description:
Don't put off building your dream home any longer! These THREE scenic lots are ready for you to buil...
more>>
|
|
|
|
Status: Active
Price: $135,000
MLS Number: 964888
Type: Land
|
|
|
|
Property Description:
Don't put off building your dream home any longer! These THREE scenic lots are ready for you to buil...
more>>
|
|
|
|
|
