| |
|
|
|
|
|
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: $689,000
ID Number: 340
Type: Condo
Bedrooms: 1
Bathrooms: 1
|
|
|
|
Property Description:
Unique opportunity to own a renovated one bedroom condo in this full service internationally known c...
more>>
|
|
|
|
Status: Active Sale
Price: $129,900
ID Number: 346
Type: Co-Op
Bathrooms: 1
|
|
|
|
Property Description:
ONLY 20 MINUTES TO GRAND CENTRAL STATION
This cleverly designed and renovated studio offers a qui...
more>>
|
|
|
|
Status: Rented
Price: $7000
ID Number: 345
Type: Condo
Bedrooms: 2
Bathrooms: 2
|
|
|
|
Property Description:
Only 4 apartments on this floor, this private residence offers a unique layout to settle into with a...
more>>
|
|
|
|
Status: Rented
Price: $3300
ID Number: 343
Type: Condo
Bedrooms: 1
Bathrooms: 1
|
|
|
|
Property Description:
High floor with balcony, this one bedroom apartment has open city views, bright, sunny daylight faci...
more>>
|
|
|
|
|
| © 2006 Agent Image, Inc. All rights reserved. | Terms | Login |
 |
Design by Agent Image - Real Estate Web Site Design |
|
|
|
