{assign_variable:my_weblog="residential"} Detailed Home Information - Frisco Residential Homes {embed="realestate/header"}

Home Details

{exp:query sql="SELECT * FROM exp_property_{my_weblog} WHERE exp_property_{my_weblog}.MLSNUM = '' "}
{exp:phpstringfun function="strtoupper"}{STREETNUM} {STREETDIR} {STREETNAME} {STREETTYPE} {UNITNUM}{/exp:phpstringfun}, {CITY} {ZIPCODE}
Subdivision:{SUBDIVISION}
Price:${exp:phpstringfun function="number_format"}{LISTPRICE}{/exp:phpstringfun}Size:{exp:phpstringfun function="number_format"}{SQFTTOTAL}{/exp:phpstringfun}sf / {exp:phpstringfun function="strtolower"}{SQFTSOURCE}{/exp:phpstringfun}
Beds:{BEDS}Baths:{BATHSTOTAL}
City:{CITY}Year Built:{YEARBUILT}
HOA:{if HOA == "MAN"}Yes{/if}{if HOA == "NON"}No{/if}{if HOA == "VOL"}Voluntary{/if}Garage:{GARAGECAP}
Stories:{STORIES}Mbr Level:{ROOMMASTERBEDLEVEL}
Pool:{POOLYN}District:{exp:phpstringfun function="ucwords"}{SCHOOLDISTRICT}{/exp:phpstringfun}
Schools:{exp:phpstringfun function="ucwords"}{SCHOOLNAME1}{/exp:phpstringfun}, {exp:phpstringfun function="ucwords"}{SCHOOLNAME2}{/exp:phpstringfun}, {exp:phpstringfun function="ucwords"}{SCHOOLNAME3}{/exp:phpstringfun}{if SCHOOLNAME4}, {/if}{exp:phpstringfun function="ucwords"}{SCHOOLNAME4}{/exp:phpstringfun}
Interior Features: {exp:phpstringfun function="strtolower"}{INTERIOR}{/exp:phpstringfun}
Exterior Features: {exp:phpstringfun function="strtolower"}{EXTERIOR}{/exp:phpstringfun}
Lot Size and Features: {exp:phpstringfun function="strtolower"}{LOTSIZE}, {LOTDESC}{/exp:phpstringfun}


{if logged_in}{/if} {if logged_out}{/if}

Listing courtesy {AGENTLIST_FULLNAME} of {OFFICELIST_OFFICENAM1}
{/exp:query}

More Images - Click to Enlarge