Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
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)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T16:44:37.717' ,`MLSNumber` = '62102773' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.411535' ,`Longitude` = '-95.058497' ,`PhotoCount` = '6' ,`PostalCode` = '77568' ,`RoomCount` = '9' ,`ListPrice` = '410000.00' ,`Status` = 'Active' ,`StreetName` = 'Aqua Wave' ,`StreetNumber` = '3113' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2611' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 story with primary suite down, Glacier Bay with a White Mortar exterior, No Back Neighbors! Gated Section next to the Lagoon! Game Room as well as a Media Room Upstairs.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 28 BLK 1 LAGO MAR SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5009' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700657' WHERE `Matrix_Unique_ID` = '198515977' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T16:43:05.710' ,`MLSNumber` = '2714934' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.410479' ,`Longitude` = '-95.057737' ,`PhotoCount` = '39' ,`PostalCode` = '77568' ,`RoomCount` = '7' ,`ListPrice` = '359000.00' ,`Status` = 'Active' ,`StreetName` = 'Sapphire Lake' ,`StreetNumber` = '13016' ,`StreetSuffix` = 'Lane' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1983' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Glenwood is a 3 bedroom, 2.5 bathroom 1.5 story with an amazing bonus room upstairs. The open-concept floor plan makes the home feel much larger and features plenty of natural light and storage space. With a large granite kitchen island, GE slate series appliances, and expertly crafted kitchen cabinets, the kitchen is the heart of this home and definitely the perfect place to gather and entertain with friends and family. A large bonus room upstairs can be used as an additional flex space for a game room and media room. A large Covered Patio and Easy access to the Lagoon makes this one a popular choice among buyers!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 50' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.69' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700657' WHERE `Matrix_Unique_ID` = '199905876' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T16:43:59.857' ,`MLSNumber` = '31095383' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.410497' ,`Longitude` = '-95.057501' ,`PhotoCount` = '6' ,`PostalCode` = '77568' ,`RoomCount` = '6' ,`ListPrice` = '336000.00' ,`Status` = 'Active' ,`StreetName` = 'Cobalt Cove' ,`StreetNumber` = '13012' ,`StreetSuffix` = 'Court' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1540' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Discover the advantages of single-story living at the Creemore, which features a streamlined floor plan that makes the most out of everyday living areas. The open-concept kitchen, dining room and great room keep sightlines open and allow for ease of movement throughout the home, while the owner’s retreat at the back of the Creemore ensures privacy and beautiful backyard views. Those who love to dine or entertain al fresco will love the home’s outdoor options, with a covered porch and easy access to the lagoon and greenbelt!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 45, Block 1, Section 3' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.69' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700657' WHERE `Matrix_Unique_ID` = '199907771' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T16:44:18.093' ,`MLSNumber` = '6951782' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.411395' ,`Longitude` = '-95.057351' ,`PhotoCount` = '6' ,`PostalCode` = '77568' ,`RoomCount` = '6' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Sapphire Lake' ,`StreetNumber` = '13009' ,`StreetSuffix` = 'Lane' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2028' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Those who appreciate flexible floor plans are sure to love the Loretto covered in Silvercreek brick and white mortar, as well as Stucco! Located on a Large Corner lot. Features include open living spaces, a main floor planning niche & an outdoor extended covered patio. Whip up culinary delights in the streamlined kitchen, which features plenty of storage and prep space, including a pantry; and relax and recharge in the spacious owner’s retreat, which includes a huge walk-in closet and spa-like ensuite.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 43, Block 1, Section 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.69' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700657' WHERE `Matrix_Unique_ID` = '199910716' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T16:43:24.430' ,`MLSNumber` = '33368549' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.411844' ,`Longitude` = '-95.056912' ,`PhotoCount` = '6' ,`PostalCode` = '77568' ,`RoomCount` = '9' ,`ListPrice` = '390000.00' ,`Status` = 'Active' ,`StreetName` = 'Blue Flora' ,`StreetNumber` = '13106' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2611' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you love to entertain, then look no further than the 4 bedroom, 2.5 bathroom, Hafford floor plan, which lets you make the most of everyday with a large dining area, spacious family room and large eat-in kitchen with an attention to detail that includes a built-in pantry, ample counter and storage space and a large island for gatherings along with a covered patio and a lot that backs up to a greenbelt you have the ultimate home! The upper-level game room is an extension of the main floor entertaining area, while a media/sitting room on the same floor can be used as an office or reading space for downtime.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 13, Block 10, Section 6' ,`LotDesciption` = 'Cleared,Greenbelt,Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.68' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700657' WHERE `Matrix_Unique_ID` = '200386821' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T16:46:30.673' ,`MLSNumber` = '52651550' ,`ListAgentFullName` = 'Shelley Stoneburner' ,`ListOfficeName` = 'Stoneburner & Associates ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.974509' ,`Longitude` = '-95.584145' ,`PhotoCount` = '34' ,`PostalCode` = '77070' ,`RoomCount` = '8' ,`ListPrice` = '425900.00' ,`Status` = 'Active' ,`StreetName` = 'Fawnview' ,`StreetNumber` = '10903' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3545' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Back on market after seller doing the following updates: built out stand up shower off pool bath, replaced wooden stair spindles with wrought iron, new wooden steps and new primary bath vanity.\r\nBeautifully updated home on corner lot in Norchester! New appliances, HUGE island with tons of space for entertaining! You will love all of the floor to ceiling windows in the den area looking out over the pool with Texas sized covered patio! Primary bedroom with sitting room/office and giant walk-in shower! New windows, foam insulation throughout, 3rd bathroom is perfect for pool time with door that opens to backyard patio! Many custom touches throughout home including, wetbar, barn doors, half bath converted to full bath with shower, ductless a/c & heat in garage, new pex piping throughout, new electrical downstairs and new breaker box.' ,`Acres` = '0.2439' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 12 NORCHESTER SEC 2 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10625' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MATZKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Norchester 2 & Rp' ,`TaxAmount` = '6356' ,`TaxRate` = '2.5258' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700657' WHERE `Matrix_Unique_ID` = '201930802' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T17:19:18.117' ,`MLSNumber` = '3823631' ,`ListAgentFullName` = 'Sterling Bond' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.039167' ,`Longitude` = '-95.572815' ,`PhotoCount` = '41' ,`PostalCode` = '77422' ,`RoomCount` = '13' ,`ListPrice` = '389999.00' ,`Status` = 'Active' ,`StreetName` = 'Indiana' ,`StreetNumber` = '805' ,`StreetSuffix` = 'Street' ,`City` = 'Brazoria' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3138' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERFECTION!!! That is the word that comes to mind to describe 805 S Indiana St. Brazoria. This property stands out in a Grand Way when you enter. A well Maintained landscape with gorgeous trees surrounding this property. This Home offers 3/4 bedrooms, 3 AC Units equipped with NEW HVAC, Living Room & Kitchen W/ 4 TON Air Handler & the Sun Rooms are also air conditioned as well if you have pets in the home. Water softener, Touch plate system, BRAND NEW ALL DOUBLE PANE windows. Privacy fence wrapping the entire perimeters of property. The electric bills not over 200 hundred per month. Water heater 3 Years Old. GAS LINES ready for installation to what your needs may be. This home additionally offers OPEN PORCH, UTILITY ROOM. Media Room & a Covered Hot Tub. Schedule your viewing today!' ,`Acres` = '0.5608' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'OUTLOTS & TOWNSITE (BRAZORIA) BLK 199 LOT 2 (REPLAT \'18) & L' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '24428' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Outlots & Townsite Brazoria' ,`TaxAmount` = '5561' ,`TaxRate` = '2.3372' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700658' WHERE `Matrix_Unique_ID` = '205384898' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T16:46:06.667' ,`MLSNumber` = '41633276' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.406524' ,`Longitude` = '-95.050765' ,`PhotoCount` = '6' ,`PostalCode` = '77568' ,`RoomCount` = '7' ,`ListPrice` = '513000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayrose' ,`StreetNumber` = '2610' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2578' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Cameron floor plan is designed to impress. With its open concept family room on the main level, which flows seamlessly onto a covered patio, the opportunities for design are endless. A spacious owner’s suite is located towards the back of the home, fitted with a walk-in closet, luxurious ensuite and large walk-in closet. As you make your way up to the second floor, you’ll notice the central games room, perfect for families with children or for those who love to entertain. The 12-acre Lago Mar crystal clear lagoon is the largest in Texas and a unique staycation destination. Bay Area breezes will caress you while you lounge on white-sand beaches, swim in azure waters or dine lagoonside on our beach boardwalk. Only 20 minutes from Galveston. So much to see and do, right in your backway.' ,`Acres` = '0.1475' ,`Area` = '33' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 4 BLK 2 LAGO MAR POD 6 SEC 2 (2020) ABST 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6423' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.55' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700658' WHERE `Matrix_Unique_ID` = '206614683' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T16:46:37.397' ,`MLSNumber` = '57828438' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.405942' ,`Longitude` = '-95.051474' ,`PhotoCount` = '6' ,`PostalCode` = '77568' ,`RoomCount` = '9' ,`ListPrice` = '509000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayrose' ,`StreetNumber` = '2518' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2956' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the Collingwood Plan, Plenty of room to roam in this\r\nplan. You’re welcomed by a spacious study space before\r\nmoving through to the kitchen, which includes a dedicated\r\npantry space and an oversized island with breakfast area. Also\r\nhas a 4th bedroom with its own bathroom for guest/in-law\'s.\r\nCome and sit in your very own sitting area and cozy up with a\r\nbook or laptop for some quiet time. For more living space you\r\ncan enjoy your outdoor over sized covered patio.' ,`Acres` = '0.1474' ,`Area` = '33' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 10 BLK 2 LAGO MAR POD 6 SEC 2 (2020) ABST 11' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6421' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.55' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700658' WHERE `Matrix_Unique_ID` = '206618684' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T17:23:32.047' ,`MLSNumber` = '44146777' ,`ListAgentFullName` = 'Todd LeBlanc' ,`ListOfficeName` = 'LeBlanc Custom Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.790217' ,`Longitude` = '-95.541652' ,`PhotoCount` = '32' ,`PostalCode` = '77055' ,`RoomCount` = '9' ,`ListPrice` = '485000.00' ,`Status` = 'Active' ,`StreetName` = 'Cedardale' ,`StreetNumber` = '10022' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2262' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Step into a serene home designed as a retreat getaway that is quiet but also has easy access to I10, grocery store, and shopping. Furnished, open and bright three bedroom house with both large den and living room. Shows like new. Galley kitchen. French doors to outside patio and oasis, perfect for outdoor relaxation and grilling. Ideal for both big and small dogs, fenced yard, no carpet. Slate, tile and porcelain hardwood. Marble and granite countertop in kitchen and bathrooms. New wiring, new water pipes. Won Yard of the month.' ,`Acres` = '0.1928' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 20 BLK 17 SPRING BRANCH WOODS SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SHADOW OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING OAKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Branch Woods Sec 03' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700658' WHERE `Matrix_Unique_ID` = '206695270' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T16:45:18.073' ,`MLSNumber` = '58888987' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.406964' ,`Longitude` = '-95.051000' ,`PhotoCount` = '38' ,`PostalCode` = '77568' ,`RoomCount` = '7' ,`ListPrice` = '376000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayrose' ,`StreetNumber` = '2611' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Those who appreciate flexible floor plans are sure to love the Stratford featuring an extended covered porch. Whip up culinary delights in the Stratford\'s spacious kitchen complete with a pantry, oversized island, and breakfast bar overlooking your living space covered in luxury vinyl plank. Catch up on work in the open study area and relax and recharge in the spacious owner’s retreat, which includes a large walk-in closet and spa-like ensuite. Resort style living here in Lago Mar with it\'s 12-acre blue lagoon and tons of fun outdoor activities.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6, Block 1, Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6472' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.55' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700658' WHERE `Matrix_Unique_ID` = '206728323' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T16:45:47.150' ,`MLSNumber` = '13407071' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.405942' ,`Longitude` = '-95.051474' ,`PhotoCount` = '7' ,`PostalCode` = '77568' ,`RoomCount` = '9' ,`ListPrice` = '489000.00' ,`Status` = 'Active' ,`StreetName` = 'Ocean Key' ,`StreetNumber` = '2514' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2975' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ideal for families who love to make the most of time spent at home. The 2,975 sq.ft. Baker floor plan is loaded with features that make home the ultimate destination. From an upper-level game room to a dedicated dining area and covered patio outdoors. The kitchen is the heart of the Baker floor plan featuring a functional layout that maximizes storage space with a large island and walk-in pantry space. Homeowners can relax and recharge in the spacious owner’s retreat, which includes a huge walk-in closet and spa-like ensuite. This floor plan also comes with a private study located on the first floor.' ,`Acres` = '0.1474' ,`Area` = '33' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'lot 19 Block 1 Section 2' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.55' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700658' WHERE `Matrix_Unique_ID` = '206933371' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T17:32:51.803' ,`MLSNumber` = '44473729' ,`ListAgentFullName` = 'Guadalupe Flores' ,`ListOfficeName` = 'RE/MAX Prestige' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.353919' ,`Longitude` = '-95.186989' ,`PhotoCount` = '15' ,`PostalCode` = '77328' ,`RoomCount` = '6' ,`ListPrice` = '170000.00' ,`Status` = 'Active' ,`StreetName` = 'HICKS' ,`StreetNumber` = '81' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1250' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Agents! This is a must see the property is newly remodeled and newly installed a/c! The listing is for the home only doesn\'t include the extra 1 acre lot.' ,`Acres` = '1.052' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Coldspring/South San Jacinto County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Trails End #2, Block 16, Lot 15, Acres 1.052' ,`LotDesciption` = 'Wooded' ,`LotSize` = '45820' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Trails End #2' ,`TaxAmount` = '1575' ,`TaxRate` = '2.0237' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700658' WHERE `Matrix_Unique_ID` = '207029007' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T16:12:41.890' ,`MLSNumber` = '55060779' ,`ListAgentFullName` = 'Mariam Hejazi' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.640759' ,`Longitude` = '-95.193960' ,`PhotoCount` = '42' ,`PostalCode` = '77504' ,`RoomCount` = '7' ,`ListPrice` = '529000.00' ,`Status` = 'Active' ,`StreetName` = 'Young' ,`StreetNumber` = '4617' ,`StreetSuffix` = 'Street' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1903' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This little home has held a lot of love over the years and is now in need of some additional TLC. House has great bones, two barns, an oversized two car garage, and a pool. Tons and tons of potential: perfect for the buyer needing a wood or mechanical shop, or with additional vehicles, a boat, ATVs, FFA projects, or couple of horses. Per survey, lot dimensions are 85.5ft wide x 660ft long. Room dimensions approximate, buyer to independently verify.' ,`Acres` = '1.25' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 114A N 1/2 OF S 1/2 OF LT 114 HIGHLAND ACRES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '54450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'YOUNG ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'SOUTH HOUSTON HIGH SCHOOL' ,`SchoolMiddle` = 'MILLER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Acres' ,`TaxAmount` = '6375' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700658' WHERE `Matrix_Unique_ID` = '207432455' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T16:52:55.543' ,`MLSNumber` = '49118189' ,`ListAgentFullName` = 'Zora Spevak' ,`ListOfficeName` = 'Executive Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.770237' ,`Longitude` = '-95.531708' ,`PhotoCount` = '40' ,`PostalCode` = '77024' ,`RoomCount` = '16' ,`ListPrice` = '4250000.00' ,`Status` = 'Active' ,`StreetName` = 'Williamsburg' ,`StreetNumber` = '55' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '6' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '9124' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unique 6 Bedroom, 6 full+2 half baths home on one of the most charming streets in Bunker Hill Village. Light filled and open floorplan; 2 story family room with cathedral and beamed ceiling, woodburning fireplace and walls of windows; living room with 14\' ceiling, custom beams and fireplace; spacious dining room, elegant library with custom built-ins and paneling, large kitchen with a 9\'x6\' island, 11\' ceiling and Subzero/Wolf appliances. Large home office overlooking the meticulously maintained grounds. 1st floor primary suite with exquisite primary bath, a large and generous primary closet and extra storage. Second floor with 5 bedrooms, 5 full baths, a game room and a separate theatre. Loggia with summer kitchen, woodburning fireplace, music speakers and custom beams; spacious 3 car garage with extra storage and epoxy flooring, full house generator, central vacuum system, music speakers, stone and hardwood floors, fully landscaped yard, large pool, cedar closet, and so much more.' ,`Acres` = '0.5275' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 DOERING PLACE' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '23795' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '80' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'BUNKER HILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Doering Place' ,`TaxAmount` = '67219' ,`TaxRate` = '2.1656' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663700659' WHERE `Matrix_Unique_ID` = '207733182' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T17:36:37.793' ,`MLSNumber` = '84201691' ,`ListAgentFullName` = 'Socorro Rendon' ,`ListOfficeName` = 'My City Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.675974' ,`Longitude` = '-95.200032' ,`PhotoCount` = '3' ,`PostalCode` = '77502' ,`RoomCount` = '4' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Juliet' ,`StreetNumber` = '2405' ,`StreetSuffix` = '' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1925' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction Private Builder ESTIMATED COMPLETION SEPTEMBER 2022! This house is 1925 sq feet, and features 4 bedroom 2.5 bathrooms and 2 car garage. Kitchen over seeing the family room and dining room has a Huge island that can be used as a breakfast island. Study room right at the entrance or can be used as a workout room.' ,`Acres` = '' ,`Area` = '6' ,`BuilderName` = 'Builder' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 3 Block 1 Juliet Gardens' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'BAILEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM RAYBURN HIGH SCHOOL' ,`SchoolMiddle` = 'PARKVIEW INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Temporarily No Showings' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Juliet Gardens' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700659' WHERE `Matrix_Unique_ID` = '208130966' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T16:17:27.520' ,`MLSNumber` = '25912613' ,`ListAgentFullName` = 'Cyndi De Palermo' ,`ListOfficeName` = 'Red Diamond Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.394215' ,`Longitude` = '-95.134792' ,`PhotoCount` = '25' ,`PostalCode` = '77517' ,`RoomCount` = '5' ,`ListPrice` = '279900.00' ,`Status` = 'Active' ,`StreetName` = 'Shady' ,`StreetNumber` = '3806' ,`StreetSuffix` = 'Lane' ,`City` = 'Santa Fe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1391' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable and Affordable!!Roof replaced JUNE 2022. Seller is in the process of replacing the septic system. This move-in-ready home is located in Santa Fe on a 1/2 acre lot. Immaculately presented, this home offers a buyer a tranquil setting and an open floor plan. Step inside where you are greeted with wood floors and neutral colors. The open floorplan provides for ease of living. This functional home offers 3 bedrooms and 2 full baths as well as a 2 car garage. A lovely covered patio ensures a quiet place to relax. Towering trees offer an abundance of shade in the backyard. Amenities include; One owner home, all brick, never flooded, breaker box update in 2019, water heater 2019, kitchen and bath remodel in 2019, storm blinds, kitchen appliances updated 2019, and a 400 ft. well with chlorinator unit. This charming house awaits someone to call it home. Call today for a private tour!' ,`Acres` = '0.5707' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 613 PAGE 6 LOT 15 SHADY CORNERS UNRECORDED SUB' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '24860' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'ROY J. WOLLAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shady Corners Unrec' ,`TaxAmount` = '3332' ,`TaxRate` = '2.3536' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700659' WHERE `Matrix_Unique_ID` = '208236591' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T17:20:04.947' ,`MLSNumber` = '76767315' ,`ListAgentFullName` = 'Tammie Bell' ,`ListOfficeName` = 'TBT Real Estate' ,`SellingAgentFullName` = 'Madison Mutina' ,`SellingOfficeName` = 'Paula Mutina Properties' ,`Latitude` = '29.140713' ,`Longitude` = '-95.484023' ,`PhotoCount` = '18' ,`PostalCode` = '77515' ,`RoomCount` = '7' ,`ListPrice` = '400000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Jamison' ,`StreetNumber` = '318' ,`StreetSuffix` = 'Drive' ,`City` = 'Angleton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2336' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEVER FLOODED!! Welcome to this beautiful creek lot outside of Angleton city limits on just over an acre! You won\'t want to pass this stunning 2 story home up. The primary bedroom is downstairs and very spacious. The kitchen has plenty of counter space with an electric cooktop and double ovens. The living room has a high ceiling and very open. The backyard is peaceful out on the creek. Enjoy the open backyard, with plenty of space for entertaining. Don\'t wait, this home won\'t last long. Call today for your private showing.' ,`Acres` = '1.16' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'OAKWOOD CREEK ESTATES SEC 4, LOT 36, ACRES 1.160, A0096 A MI' ,`LotDesciption` = 'Cleared,Water View' ,`LotSize` = '50530' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'WESTSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oakwood Creek Estates' ,`TaxAmount` = '2959' ,`TaxRate` = '1.886' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700659' WHERE `Matrix_Unique_ID` = '209065122' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T16:54:45.630' ,`MLSNumber` = '74548777' ,`ListAgentFullName` = 'Justin Phillips' ,`ListOfficeName` = 'Hardee & Company Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.467097' ,`Longitude` = '-94.611336' ,`PhotoCount` = '17' ,`PostalCode` = '77650' ,`RoomCount` = '8' ,`ListPrice` = '505000.00' ,`Status` = 'Active' ,`StreetName` = 'Palm' ,`StreetNumber` = '2567' ,`StreetSuffix` = 'Drive' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1333' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opertunity for an investment property. This 3 bedroom 2 bath is located in a well sought after neighborhood with beach access. Walk into a modern home offering an open concept great for entertaining. Spacious family area is open to the dining and kitchen area. Features a kitchen bar, custom cabinets with, double kitchen sinks with kitchen window above, stainless appliances, tiled backsplash, and all the amenities of a modern kitchen, even a pantry! The primary suite offers coffered trey ceilings with lighting, crown molding. Plenty of closet space in all bedrooms and a coastal vibe through-out. This property will convey all furnishings for an additional 10k with some exclusions. Downstairs is an entertainers dream, a golf cart garage, sand shower, partially fenced, built in bar, a swing sitting conversational area, and double drive way. Schedule a showing today, this one wont last long!' ,`Acres` = '0.1199' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 B FRANKS SUR LOT A-7 (7-1) HOLIDAY BEACH' ,`LotDesciption` = 'Cleared,Water View' ,`LotSize` = '5225' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Holiday Beach' ,`TaxAmount` = '4893' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700659' WHERE `Matrix_Unique_ID` = '209603772' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T16:59:17.670' ,`MLSNumber` = '4976955' ,`ListAgentFullName` = 'Christina Flores' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.162321' ,`Longitude` = '-95.092287' ,`PhotoCount` = '31' ,`PostalCode` = '77327' ,`RoomCount` = '5' ,`ListPrice` = '315990.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5102' ,`StreetNumber` = '1434' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2238' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to The Entertainer Floor Plan a Casas-Houston new construction home. This 4 bedroom 3 bath home features 9\' ceilings with open concept kitchen, family and dinning area. The kitchen cabinets boast crown molding and granite counter tops with under cabinet lighting. The Entertainer comes loaded with energy features such as a 16-SHEER HVAC system, Low-E windows, blown insulation and much more. Double wide driveway plus a two car garage makes it easy to store your weekend toys, bikes, motorcycles, wave runners and so much more. Take advantage of the low tax rate at 1.99 and low POA with brand new schools and a Splash Pad. Appliance package includes Refrigerator, dishwasher, microwave and stove black on stainless steel. Schedule your tour today!' ,`Acres` = '0.36' ,`Area` = '52' ,`BuilderName` = 'Casas-Houston' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 3, BLOCK 49, LOT 4830, ACRES .36' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '15681' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe III' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700659' WHERE `Matrix_Unique_ID` = '209845761' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T17:19:33.607' ,`MLSNumber` = '59134515' ,`ListAgentFullName` = 'Becky Nigrelle' ,`ListOfficeName` = 'Gulf Coast, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.420857' ,`Longitude` = '-94.919886' ,`PhotoCount` = '36' ,`PostalCode` = '77590' ,`RoomCount` = '4' ,`ListPrice` = '950000.00' ,`Status` = 'Active' ,`StreetName` = '17th' ,`StreetNumber` = '4202' ,`StreetSuffix` = 'Street' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2818' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1769' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 204 PAGE 2 LOT 1 LAKESHORES ADDN NO 2' ,`LotDesciption` = 'Cleared,Corner,Waterfront' ,`LotSize` = '7705' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Freestanding Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Fiberglass,Heated' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'GUAJARDO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeshore 2' ,`TaxAmount` = '8654' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700659' WHERE `Matrix_Unique_ID` = '210340506' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T17:27:43.120' ,`MLSNumber` = '80289944' ,`ListAgentFullName` = 'Susan Annoura' ,`ListOfficeName` = 'Annoura Realty Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.749074' ,`Longitude` = '-95.506816' ,`PhotoCount` = '50' ,`PostalCode` = '77024' ,`RoomCount` = '12' ,`ListPrice` = '2200000.00' ,`Status` = 'Active' ,`StreetName` = 'Farnham Park' ,`StreetNumber` = '17' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '6' ,`BathsHalf` = '3' ,`BedsTotal` = '6' ,`SqFtTotal` = '7609' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Restore this building to its original grandeur! Home has been the personal residence of various diplomats over the years. Flooded in Harvey, gutted, and has been vacant ever since. Several impressive features including capability of a commercial kitchen, 3M blast proof film on all exterior windows, sewer lift station, 2 tankless water heaters, 8 HVACs. Located on a huge 1.38 acre lot, right on Buffalo Bayou inside the guard protected subdivision of prestigious Farnham Park. Shoreline protected with erosion control barrier in 1996. 3 car garage, in ground pool, circular driveway. Architect William Van Reed Furbush, Builder James L. Goette. Contemporary and one of a kind. First time in decades to be available for sale. Accompanied showings only.' ,`Acres` = '1.3784' ,`Area` = '23' ,`BuilderName` = 'James L. Goette' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 FARNHAM PARK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '60043' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '6500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'MEMORIAL DRIVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Farnham Park' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700660' WHERE `Matrix_Unique_ID` = '210752091' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T17:26:34.077' ,`MLSNumber` = '18607304' ,`ListAgentFullName` = 'John McDonald' ,`ListOfficeName` = 'Houston Home Store LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.867219' ,`Longitude` = '-95.440511' ,`PhotoCount` = '7' ,`PostalCode` = '77088' ,`RoomCount` = '10' ,`ListPrice` = '600000.00' ,`Status` = 'Active' ,`StreetName` = 'Dolly Wright' ,`StreetNumber` = '1936' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '8' ,`SqFtTotal` = '6204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COMMERCIAL / RESIDENTIAL 1.2 ACRE UNRESTRICTED PROPERTY. Property was previously a school but can be used as a home for a great grand office with endless parking. There are carports and stables in the back part of the property. New roof has been installed and some painting done. The land is impressive! all fenced and gated and cleared to do whatever you dream about. Third story is a private 1 bedroom loft with kitchen and living room.' ,`Acres` = '1.2099' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 46 OF LT 46 BLK 3 HIGHLAND ACRE HOMES' ,`LotDesciption` = 'Cleared' ,`LotSize` = '52705' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Acre Homes' ,`TaxAmount` = '13378' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663700660' WHERE `Matrix_Unique_ID` = '210784718' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T17:07:39.273' ,`MLSNumber` = '15578855' ,`ListAgentFullName` = 'Bonnie Assad' ,`ListOfficeName` = 'Jim Assad & Assoc., Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.889353' ,`Longitude` = '-95.671181' ,`PhotoCount` = '40' ,`PostalCode` = '77095' ,`RoomCount` = '8' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Basswood Forest' ,`StreetNumber` = '7555' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2007' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'High Ceilings!! Wood floor in formal dining room. Tile Entry, Kitchen, Breakfast, Family Room, and Baths. Master down. Elegant master bath features two sinks, whirlpool tub, separate shower, and his and her closets. Two bedrooms and game room up!! New dishwasher (less than 1 year!!) Spacious back yard with Sprinkler System!! Neutral colors throughout!! TENANT OCCUPIED THROUGH DEC 31, 2023.' ,`Acres` = '0.1532' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 56 BLK 3 COPPERFIELD WESTCREEK VILLAGE SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '6673' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HOLMSLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'ARAGON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Copperfield Westcreek Village Sec' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700660' WHERE `Matrix_Unique_ID` = '211022553' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T16:19:54.637' ,`MLSNumber` = '20087438' ,`ListAgentFullName` = 'Isac George' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.779760' ,`Longitude` = '-95.304420' ,`PhotoCount` = '32' ,`PostalCode` = '77020' ,`RoomCount` = '6' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Gazin' ,`StreetNumber` = '508' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand new construction near downtown Houston. House is currently under construction. Area is being revitalized with many new constructions/rehab. House offers 3 bedrooms, 2.5 bathrooms, with 2 car attached garage. Features are custom wood cabinets, quartz counter tops, primary bathroom with free standing tub and separate shower, along with double sink vanity. Primary bedroom also offers walk in closet. Utility room upstairs near all bedrooms. Complete house is wired video cameras and termite/pest control system. Please note pictures are for sample only. Final colors and finishes may vary.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Alta Vista Homes,LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 44 BLK 76 Denver' ,`LotDesciption` = 'Cleared' ,`LotSize` = '3125' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ELIOT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Split Level,Traditional' ,`Subdivision` = 'Denver' ,`TaxAmount` = '783' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700660' WHERE `Matrix_Unique_ID` = '211266221' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T17:17:36.487' ,`MLSNumber` = '68019006' ,`ListAgentFullName` = 'Eneida Adrianza' ,`ListOfficeName` = 'RE/MAX Grand' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.696447' ,`Longitude` = '-95.782886' ,`PhotoCount` = '32' ,`PostalCode` = '77406' ,`RoomCount` = '8' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Santini' ,`StreetNumber` = '23414' ,`StreetSuffix` = 'Street' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2931' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Immaculate 2 story house in the desirable community of Lakes of Bella Terra in Richmond!! Beautiful stone an brick elevation with a nice and relaxing front porch. It feautures 4 bedrooms, 2 downstairs with 2 full baths, and 2 upstairs with a Jack and Jill bath and spacious game room. Wood looking tile throughout first floor, except for carpet in the bedrooms. Formal dining and family room with lots of windows allowing the morning sun to bright the house and sorround sound. Gourmet kitchen open to family with big island with beautiful granite counter, lots of cabinets with under lights lots of storage and walk-in Pantry. Good size master bedroom with walk in closet and master bath with separate shower and tub, and his and her vanity with grantite counter top. Coveres patio with relaxing heated pool. Sprinklers. Great Lamar School District. Excellent location, close and easy access to Westpark Toll, 99 Grand Parkway. Close to shopping, restautants and more.' ,`Acres` = '0.1865' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKES OF BELLA TERRA SEC 32, BLOCK 1, LOT 28' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUBENAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes Of Bella Terra Sec 32' ,`TaxAmount` = '11379' ,`TaxRate` = '3.0848' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700660' WHERE `Matrix_Unique_ID` = '211334977' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T16:27:51.297' ,`MLSNumber` = '25945322' ,`ListAgentFullName` = 'Isac George' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.740873' ,`Longitude` = '-95.292368' ,`PhotoCount` = '32' ,`PostalCode` = '77011' ,`RoomCount` = '6' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue L' ,`StreetNumber` = '7316' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand new construction near downtown Houston. House is currently under construction. Area is being revitalized with many new constructions/rehab. House offers 3 bedrooms, 2.5 bathrooms, with 2 car attached garage. Features are custom wood cabinets, quartz counter tops, primary bathroom with free standing tub and separate shower, along with double sink vanity. Primary bedroom also offers walk in closet. Utility room upstairs near all bedrooms. Complete house is wired video cameras and termite/pest control system. Please note that pictures are for sample only. Colors and finishes may vary.' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'Alta Vista Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 37 BLK 98 Magnolia Park' ,`LotDesciption` = 'Cleared' ,`LotSize` = '2500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DE ZAVALA ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'EDISON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Split Level,Traditional' ,`Subdivision` = 'Magnolia Park' ,`TaxAmount` = '783' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700660' WHERE `Matrix_Unique_ID` = '211490146' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T16:35:15.073' ,`MLSNumber` = '29058715' ,`ListAgentFullName` = 'Isac George' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.740873' ,`Longitude` = '-95.292368' ,`PhotoCount` = '32' ,`PostalCode` = '77011' ,`RoomCount` = '6' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue L' ,`StreetNumber` = '7318' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand new construction near downtown Houston. House is currently under construction. Area is being revitalized with many new constructions/rehab. House offers 3 bedrooms, 2.5 bathrooms, with 2 car attached garage. Features are custom wood cabinets, quartz counter tops, primary bathroom with free standing tub and separate shower, along with double sink vanity. Primary bedroom also offers walk in closet. Utility room upstairs near all bedrooms. Complete house is wired video cameras and termite/pest control system. Please note that pictures are for sample only. Colors and finishes may vary.' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'Alta Vista Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 38 BLK 98 Magnolia Park' ,`LotDesciption` = 'Cleared' ,`LotSize` = '2500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DE ZAVALA ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'EDISON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Split Level,Traditional' ,`Subdivision` = 'Magnolia Park' ,`TaxAmount` = '783' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700660' WHERE `Matrix_Unique_ID` = '211490255' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T16:36:28.047' ,`MLSNumber` = '93817128' ,`ListAgentFullName` = 'Joanie Barnett' ,`ListOfficeName` = 'Coldwell Banker PropertiesUnlimited' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.282331' ,`Longitude` = '-96.571457' ,`PhotoCount` = '14' ,`PostalCode` = '77835' ,`RoomCount` = '3' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Longpoint' ,`StreetNumber` = '9993' ,`StreetSuffix` = 'Road' ,`City` = 'Burton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1802' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This property is located just outside of town and would be great for someone that can give it their own special touch.' ,`Acres` = '0.528' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'A0036 A0036 - COX, JAMES, TRACT 29, ACRES 0.528' ,`LotDesciption` = 'Cleared' ,`LotSize` = '23000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '128 - Burton' ,`SchoolElementary` = 'BURTON ELEMENTARY SCHOOL (BURTON)' ,`SchoolHigh` = 'BURTON HIGH SCHOOL' ,`SchoolMiddle` = 'BURTON HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'James Cox Surv Abs #36' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700661' WHERE `Matrix_Unique_ID` = '211541150' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T17:26:26.387' ,`MLSNumber` = '95325659' ,`ListAgentFullName` = 'Jody Luckie' ,`ListOfficeName` = 'Treehouse Real Estate B/CS LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.715818' ,`Longitude` = '-96.387087' ,`PhotoCount` = '23' ,`PostalCode` = '77803' ,`RoomCount` = '6' ,`ListPrice` = '200000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodville' ,`StreetNumber` = '3120' ,`StreetSuffix` = 'Road' ,`City` = 'Bryan' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2103' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The square footage this house has to offer delivers endless possibilities. Boasting 2100 sf, this single family home has 3 bedrooms, 2.5 bathrooms, a bonus/office area and a second living area, great for entertainment. With convenient access to highway 6 and just minutes away from entertainment, restaurants, Historical Downtown Bryan, Blinn College and Texas A&M, adventures will never feel like a commute. Come see the abundant potential this floor plan has to offer.' ,`Acres` = '0.1791' ,`Area` = '61' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'NORTHWOOD PH 1, BLOCK 1, LOT 4' ,`LotDesciption` = 'Other' ,`LotSize` = '7802' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '148 - Bryan' ,`SchoolElementary` = 'NAVARRO ELEMENTARY SCHOOL (BRYAN)' ,`SchoolHigh` = 'JAMES EARL RUDDER HIGH SCHOOL' ,`SchoolMiddle` = 'ARTHUR L. DAVILA MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Northwood Ph 01' ,`TaxAmount` = '3991' ,`TaxRate` = '2.3493' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700661' WHERE `Matrix_Unique_ID` = '211614203' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T16:32:53.833' ,`MLSNumber` = '98473041' ,`ListAgentFullName` = 'Gabrielle Allen' ,`ListOfficeName` = 'Southern Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.963797' ,`Longitude` = '-95.488270' ,`PhotoCount` = '22' ,`PostalCode` = '77066' ,`RoomCount` = '3' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'Hidden Trace' ,`StreetNumber` = '4446' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1321' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 4446 Hidden Trace Ct. a split level home with a primary bedroom down stairs. This property has no back neighbors and is on a cul de sac street. Schedule your tour today.' ,`Acres` = '0.1265' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 4 TRACES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5511' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '398' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KLENK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'WUNDERLICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style,Split Level' ,`Subdivision` = 'Traces Sec 02' ,`TaxAmount` = '2632' ,`TaxRate` = '2.9105' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700661' WHERE `Matrix_Unique_ID` = '211627055' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T16:16:56.710' ,`MLSNumber` = '68922590' ,`ListAgentFullName` = 'Tracie Conyers' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.106640' ,`Longitude` = '-94.021966' ,`PhotoCount` = '10' ,`PostalCode` = '77662' ,`RoomCount` = '3' ,`ListPrice` = '115000.00' ,`Status` = 'Active' ,`StreetName` = 'Dewitt' ,`StreetNumber` = '915' ,`StreetSuffix` = 'Road' ,`City` = 'Vidor' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1283' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice updated home that sits on 4.869 acres- Investment or First Time Buyer' ,`Acres` = '4.869' ,`Area` = '50' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = '95 ABST. 95 JOHN W. GENTRY, TRACT 037 & 037A1, ACRES 4.869' ,`LotDesciption` = 'Other' ,`LotSize` = '212094' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1005 - Vidor' ,`SchoolElementary` = 'VIDOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'VIDOR HIGH SCHOOL' ,`SchoolMiddle` = 'VIDOR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'John W Gentry' ,`TaxAmount` = '2780' ,`TaxRate` = '2.9308' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700661' WHERE `Matrix_Unique_ID` = '211630197' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T17:05:44.697' ,`MLSNumber` = '15552370' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.233254' ,`Longitude` = '-95.242177' ,`PhotoCount` = '15' ,`PostalCode` = '77357' ,`RoomCount` = '3' ,`ListPrice` = '253990.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Hollow' ,`StreetNumber` = '14878' ,`StreetSuffix` = '' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1489' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FANTASTIC NEW D. R. HORTON BUILT 1 STORY! Sought-After Open Concept Interior Layout! Gourmet Island Kitchen with Corner Walk-In Pantry - Opens to Spacious Dining Area & Living Room! Privately Located Primary Suite Features Great Bath with Oversized Shower & Big Walk-In Closet! Convenient Indoor Utility Room! Covered Back Patio! Wonderful Community with Pool, Splash Pad, Recreation Center, & Walking Trails - PLUS On-Site Elementary School! Easy Access to Hwy 59, the Grand Parkway, & 242! WOW!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Express Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 13 Block 2 Section 5B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'TIMBER LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harrington Trails' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700661' WHERE `Matrix_Unique_ID` = '211631971' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T17:42:36.927' ,`MLSNumber` = '21817789' ,`ListAgentFullName` = 'Lucy Keeper' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.723926' ,`Longitude` = '-95.436991' ,`PhotoCount` = '25' ,`PostalCode` = '77005' ,`RoomCount` = '7' ,`ListPrice` = '1200000.00' ,`Status` = 'Active' ,`StreetName` = 'Syracuse' ,`StreetNumber` = '3779' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Totally updated home leased till 8-2024 no sign on the property.\r\nExtra large lot in a wonderful neighborhood.' ,`Acres` = '0.293' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 & TR 4 BLK 8 SUNSET TERRACE SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12765' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunset Terrace Add Sec 10' ,`TaxAmount` = '18542' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700661' WHERE `Matrix_Unique_ID` = '211635519' --> Updated record success