Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T14:59:32.477' ,`MLSNumber` = '16111009' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Shamim Momin' ,`SellingOfficeName` = 'Walzel Properties' ,`Latitude` = '29.569940' ,`Longitude` = '-95.738894' ,`PhotoCount` = '35' ,`PostalCode` = '77469' ,`RoomCount` = '17' ,`ListPrice` = '599871.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Colonel Fields' ,`StreetNumber` = '2111' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3509' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Preston V, Elevation P) CURRENTLY BEING BUILT. Two Story cul-de-sac lot. 5 bedrooms, 4.5 baths. Private Primary Suite with large walk-in closet. Spacious kitchen open to Family Room. Dining Room and Study. Game Room, 4 bedrooms, and 3 bathrooms upstairs. Covered patio and 2 car attached garage. Spanning nearly 600 acres of beautiful homes, lush landscaping, trails, and exciting amenities, Veranda embodies the legacy of historic Richmond with all the comforts of a luxurious master-planned community. Minutes to the newly expanded I-69 and the Grand Parkway, you are near exceptional shopping, dining and recreation. Stop by the Westin Homes model home today to find out more about Veranda!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 31 BLK 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8470' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'PHELAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Veranda' ,`TaxAmount` = '' ,`TaxRate` = '3.22' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091021' WHERE `Matrix_Unique_ID` = '210778011'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T14:58:13.963' ,`MLSNumber` = '69033816' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS                       ' ,`Latitude` = '29.713052' ,`Longitude` = '-95.916081' ,`PhotoCount` = '6' ,`PostalCode` = '77441' ,`RoomCount` = '13' ,`ListPrice` = '464627.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Egret Gable' ,`StreetNumber` = '5203' ,`StreetSuffix` = 'Court' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2599' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Park Avenue, Elevation A) CURRENTLY BEING BUILT. Two story. 5 bedrooms. 3 baths. Spacious island kitchen open to Informal Dining and Family Room. Primary suite with large walk-in closet. Three additional bedrooms and game room upstairs. Covered patio with 2-car garage. Located in Fulshear, one of the fastest growing cities in Texas, Cross Creek West is located minutes from major roadways including Interstate 10. As a sister community to Cross Creek Ranch, homeowners will have access to the fabulous amenities available! Stop by the Westin Homes sales model to learn more about Cross Creek West!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 28 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6632' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek West' ,`TaxAmount` = '' ,`TaxRate` = '3.29' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091021' WHERE `Matrix_Unique_ID` = '212522574'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T13:48:22.300' ,`MLSNumber` = '86998442' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = 'Nicholas Meador' ,`SellingOfficeName` = 'Coldwell Banker RealtyThe Willis Office' ,`Latitude` = '30.220372' ,`Longitude` = '-95.749698' ,`PhotoCount` = '11' ,`PostalCode` = '77354' ,`RoomCount` = '15' ,`ListPrice` = '644903.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Black Bronco' ,`StreetNumber` = '510' ,`StreetSuffix` = 'Road' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3605' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Be amazed by this fantastic Beazer Home on a spacious lot in Timber Hollow, featuring sloped ceilings, tile flooring, a 3-car sideload garage, cast stone fireplace, study with French doors, game room, media room, open great room, and an extended covered patio on over half an acre lot. Impress guests in the kitchen, equipped with granite countertops, tile backsplash, a 36” cooktop, double Whirlpool® wall oven, Jasper undermount kitchen sink, stainless steel appliances, 42” upper cabinets, pendant lighting, and under-counter lighting. The serene primary suite boasts a walk-in closet, dual vanities, and a mud-set shower. Residents of the 68-acre Timber Hollow community enjoy many amenities, including a 9-acre lake, rolling hills, and walking trails. Commuters can easily access central Magnolia via Highway 249 and the Grand Parkway. Zoned to Magnolia ISD. You don’t want to miss this home – call today!' ,`Acres` = '0.6' ,`Area` = '15' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 24 Block 1' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Hollow' ,`TaxAmount` = '' ,`TaxRate` = '3.36' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091021' WHERE `Matrix_Unique_ID` = '213337603'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T14:56:10.180' ,`MLSNumber` = '33366685' ,`ListAgentFullName` = 'Megan Behan' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.239328' ,`Longitude` = '-95.490450' ,`PhotoCount` = '50' ,`PostalCode` = '77384' ,`RoomCount` = '7' ,`ListPrice` = '422500.00' ,`Status` = 'Active' ,`StreetName` = 'Forest Haven' ,`StreetNumber` = '1074' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2560' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely darling cul de sac home located in the highly desirable community of Jacobs Reserve! This home has 4 bedrooms, 3 full bath, & the upstairs has its own game room, bedroom, & full bath. This would be great for an older teen or college student. Lots of storage thru out the house, including in the kitchen. The backyard has a covered porch ideal for entertaining. The lots side yard is large enough that you could easily fit an in-ground pool. Big truck lovers will appreciate that this home has an oversized garage – deep enough for those extended cabs. The flooring in one of the bedrooms & microwave was recently replaced. Miles of sidewalks in this community will put mom at ease when out with the kids. This home is walking distance to the playground, pool, dog park, fishing pond, park. Zoned to Conroe ISD, Woodlands schools, & top rated Galatas Elementary. This home is super close to 45 making for an easy commute with access to everything The Woodlands and Conroe have to offer.' ,`Acres` = '0.1556' ,`Area` = '15' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S802800 - PINES AT JACOBS RESERVE 01, BLOCK 1, LOT 19' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6778' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '665' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GALATAS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Pines At Jacobs Reserve 01' ,`TaxAmount` = '10132' ,`TaxRate` = '2.7488' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091021' WHERE `Matrix_Unique_ID` = '214385822'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T13:38:02.720' ,`MLSNumber` = '76756939' ,`ListAgentFullName` = 'Tracie Conyers' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.131256' ,`Longitude` = '-94.201245' ,`PhotoCount` = '23' ,`PostalCode` = '77713' ,`RoomCount` = '3' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Emily' ,`StreetNumber` = '5755' ,`StreetSuffix` = 'Lane' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1897' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You must see this beautiful home with vaulted ceilings, great color scheme and awesome floor plan. Has a living room and den/gameroom. Master bath has jetted tub, double sinks and separate shower. This jewel will not last long.' ,`Acres` = '0.1515' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 4 BLK 2 PINE GLEN 3RD PHASE 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'GUESS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'VINCENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Glen Sec III Ph 1' ,`TaxAmount` = '5533' ,`TaxRate` = '2.6134' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091022' WHERE `Matrix_Unique_ID` = '214941911'  --> Updated record success<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215460368','1675091022','215460368','2022-12-14T13:44:12.647','73649784','Lance Loken','Beazer Homes','Julia Liao','Coldwell Banker Apex, REALTORS LLC','29.846902','-95.816818','8','77493','9','414754.00','Pending Continue to Show','Yellow Rays','5006','Trail','Katy','2','0','4','1700','Single-Family','**Home is under construction**','','25','Beazer Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','','','Katy - Old Towne','Central Gas','1','Lot 30 Block 3','Subdivision Lot','','','','500','1','Never Lived In','2','Single Oven','0','','','Freestanding Range,Gas Range','','Composition','30 - Katy','MCELWAIN ELEMENTARY SCHOOL','PAETOW HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Marisol','','3.59','Public Sewer,Public Water,Water District','2021','Builder');  --> New record created successfully<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215594068','1675091022','215594068','2022-12-14T13:16:04.400','14170249','Blake Vincent','DUX Realty, LLC','','','29.776179','-95.423704','44','77007','11','669900.00','Active','HAMMAN','6112','Street','Houston','2','1','3','2490','Single-Family','Mazzarino Construction & Development unveils their new “Classic Series” Home. This residence will feature all of the high end finishes you’ve come to expect from MCD, packaged into a smaller home to achieve an unrivaled balance of luxury and price. These new luxury homes feature first floor living each with private driveways and modest backyards. Finishes include granite/quartz countertops, Fisher Paykel appliances, 2 luxurious built-in primary closets, energy efficient water heater, intricate trim carpentry, engineered wood floors, and so much more. Retail, restaurants, gym, groceries, you name it, it\'s walking distance away. Major freeways, downtown, recently renovated Memorial park, Height hike & bike trail, theater, art & museum districts are all w/in minutes. Contact us today for a private viewing of this unique offering. ASK ABOUT CUSTOMIZATION OPTIONS DURING CONSTRUCTION ONLY * MODEL HOME PHOTOS MAY SHOW A SIMILAR FLOOR PLAN AND/OR UPGRADED/ALTERNATIVE FINISHES -Use as a guide *','','16','Mazzarino Cons & Dev','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','Rice Military/Washington Corridor','Central Gas,Zoned','0','LT 2 BLK 1 HAMMAN GREEN','Subdivision Lot','2600','Other','','','1','To Be Built/Under Construction','2','Convection Oven,Freestanding Oven,Gas Oven,Single Oven','0','','','Freestanding Range,Gas Range','','Aluminum,Composition','27 - Houston','MEMORIAL ELEMENTARY SCHOOL (HOUSTON)','LAMAR HIGH SCHOOL (HOUSTON)','HOGG MIDDLE SCHOOL (HOUSTON)','Appointment Required','Builder','2','Contemporary/Modern,Traditional','HAMMAN GREEN','','','Public Sewer,Public Water','2023','Builder');  --> New record created successfully<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215598920','1675091022','215598920','2022-12-14T13:11:26.900','3993189','Melvin Thomas','Excel Realty Co','','','29.727628','-95.475889','0','77056','6','479000.00','Active','Judalon','5545','Lane','Houston','2','0','3','1452','Single-Family','Wonderful lot opportunity in the enchanting Larchmont! Built your dream home inside 610 Loop. House has been empty for the past 2 years. \r\nImmediate access to shopping and dining offerings of the Galleria, uptown park, and the Highland Village along with the quaint small-town feel.','0.1776','22','','','','','No Disclosures','','','','Galleria','Central Gas','0','LT 12 BLK 9 LARCHMONT SEC 1','Corner','7735','Appraisal District','','75','0','','','','0','','','','','Wood Shingle','27 - Houston','SCHOOL AT ST GEORGE PLACE','WISDOM HIGH SCHOOL','TANGLEWOOD MIDDLE SCHOOL','No Appointment Required,Vacant/Unoccupied','Appraisal District','1','Victorian','Larchmont Sec 01','8238','2.3307','Water District','1950','Appraisal District');  --> New record created successfully<br />