|
|
|
|
SELECT
ap_property.property_ID,
ap_property.property_StreetNum,
ap_property.property_StreetName,
ap_property.property_City,
ap_property.property_State,
ap_property.property_ListPrice,
ap_property.property_HideListPrice,
ap_property.property_HideStreet,
ap_property.property_VirtualTour,
ap_property.property_Title,
ap_property.property_LeasePrice,
ap_property_status.status_ID,
ap_property_status.status_Title,
ap_property.property_Zip,
ap_property.property_Bedrooms,
ap_property.property_Bathrooms,
ap_property.property_Details,
LENGTH(ap_property.property_OpenHouse) AS openhouse,
ap_property.property_SoldPrice,
ap_property.property_MLS,
ap_property_type.type_Title,
ap_property.property_PDF
FROM ap_property
INNER JOIN ap_property_status
ON ap_property.property_StatusID = ap_property_status.status_ID
INNER JOIN ap_property_type
ON ap_property_type.type_ID = ap_property.property_TypeID WHERE 1 AND ap_property.property_StatusID NOT IN (4,5,6,7) AND ap_property.property_TypeID NOT IN (5,9) ORDER BY ap_property.property_LocationID ASC, ap_property.property_StatusID ASC, LPAD(ap_property.property_ListPrice,12,'0') DESC LIMIT 0, 10
|
|
Status: Active Sale
Price: $679,000
ID Number: 332
Type: Co-Op
Bedrooms: 1
Bathrooms: 1
|
|
|
|
Property Description:
Custom details throughout this well-designed one bedroom, 1 bath home include a Juparana Columbo gra...
more>>
|
|
|
|
Status: Active Sale
Price: $569,000
Type: Single Family
Bedrooms: 3
Bathrooms: 3.5
|
|
|
|
Property Description:
A GEM OF A COMMUNITY WITH A 4 STAR RESTAURANT ON PREMISES, TENNIS COURTS AND MARINA, THE CALOOSA YAC...
more>>
|
|
|
|
Status: Active Sale
Price: $459,000
ID Number: 333
Type: Single Family
Bedrooms: 4
Bathrooms: 3.5
|
|
|
|
Property Description:
Nestled in the trees, brick pavers, beautifully landscaped and decorated. Private fenced back yard ...
more>>
|
|
|
|
