1442 17th St
CorpusChristi, TX 78404

Off The Market

Details

MLS# 333913
Style House
Sub-Type Resale
Status Deleted
Year 1955
Days On Site 369

Features

Bed(s) 2
Bath(s) 1 Full
SQ Feet 836
Story(s) 1
WITH stats AS ( SELECT MAX(CAST(saleprice AS bigint)) AS max_saleprice, MIN(CAST(saleprice AS bigint)) AS min_saleprice, AVG(CAST(saleprice AS bigint)) AS avg_saleprice, SUM(CAST(saleprice AS bigint)) AS sum_saleprice, ROUND(MIN(CASE WHEN sq_foot > 0 THEN CAST(saleprice AS float) / CAST(sq_foot AS float) ELSE NULL END), 2) AS min_ppsqft, ROUND(MAX(CASE WHEN sq_foot > 0 THEN CAST(saleprice AS float) / CAST(sq_foot AS float) ELSE NULL END), 2) AS max_ppsqft, ROUND(AVG(CASE WHEN sq_foot > 0 THEN CAST(saleprice AS float) / CAST(sq_foot AS float) ELSE NULL END), 2) AS avg_ppsqft, AVG(DATEDIFF ( "D" , DATEFROMPARTS(left(AddDateTime,4), substring(AddDateTime,5, 2), substring(AddDateTime,7, 2)) , getdate() )) AS avg_dom, LEFT(adddatetime, 6) AS adddatetime, COUNT(ml_number) AS count_sales FROM listings WITH (NOLOCK) WHERE mlsid = :SQL_PARAM_1 AND (saleprice != :SQL_PARAM_2) AND (adddatetime between :SQL_PARAM_3 AND