$500,000

503 N Alamo

Rockwall TX, 75087

Description

Amazing opportunity to build your dream home or multiple homes on approximately 2 acres within easy walking distance to Downtown Rockwall's dining and entertainment venues! Lake views at approximately 30', mature pecan and oak trees throughout the property! Existing home on property can be demolished or salvaged! Multiple parcels included in this listing: 401 N. Alamo .14 acres PID 000000014003, 405 N. Alamo PID .3 acres 000000014020, 503 N. Alamo 1.648 acres PID 000000014002. Seller wants to sell all properties together.

Details

MLS# 14266149
Listing Type For Sale
Sub-Type Resale
Status Active
Days On Site 464

Features

Zoning Residential
Acreage 2.09
Water Front No
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 :SQL_PARAM_4) AND (propertytype IN (:SQL_PARAM_5)) AND (statuscode = :SQL_PARAM_6) AND (zip_code = :SQL_PARAM_7) GROUP BY left(adddatetime, 6) ) SELECT * FROM stats INNER JOIN ( SELECT adddatetime as median_adddatetime, AVG(saleprice) AS median_saleprice FROM ( SELECT left(adddatetime, 6) AS adddatetime, saleprice, ROW_NUMBER() OVER ( PARTITION BY left(adddatetime, 6) ORDER BY saleprice ASC ) AS RowNum, COUNT(left(adddatetime, 6)) OVER (PARTITION BY left(adddatetime, 6)) AS RowCnt FROM listings WITH (NOLOCK) WHERE mlsid = :SQL_PARAM_8 AND (saleprice <> :SQL_PARAM_9) AND (adddatetime between :SQL_PARAM_10 AND