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-15T11:03:30.473' ,`MLSNumber` = '7185023' ,`ListAgentFullName` = 'Lyle Jackson' ,`ListOfficeName` = 'LJ Group Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.303546' ,`Longitude` = '-96.063819' ,`PhotoCount` = '28' ,`PostalCode` = '77488' ,`RoomCount` = '3' ,`ListPrice` = '219999.00' ,`Status` = 'Active' ,`StreetName` = 'Cline' ,`StreetNumber` = '3614' ,`StreetSuffix` = 'Drive' ,`City` = 'Wharton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.254' ,`Area` = '55' ,`BuilderName` = 'Censeo Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 7 of Baker Subdivision No.1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '11064' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '180 - Wharton' ,`SchoolElementary` = 'CG SIVELLS/WHARTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHARTON HIGH SCHOOL' ,`SchoolMiddle` = 'WHARTON JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Club Estates' ,`TaxAmount` = '' ,`TaxRate` = '2.43' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663698942' WHERE `Matrix_Unique_ID` = '203827289' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T11:01:43.800' ,`MLSNumber` = '45908056' ,`ListAgentFullName` = 'Lyle Jackson' ,`ListOfficeName` = 'LJ Group Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.303561' ,`Longitude` = '-96.063838' ,`PhotoCount` = '25' ,`PostalCode` = '77488' ,`RoomCount` = '3' ,`ListPrice` = '219999.00' ,`Status` = 'Active' ,`StreetName` = 'Cline' ,`StreetNumber` = '3610' ,`StreetSuffix` = 'Drive' ,`City` = 'Wharton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.254' ,`Area` = '55' ,`BuilderName` = 'Censeo Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 6 of Baker Subdivision No.1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '11064' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '180 - Wharton' ,`SchoolElementary` = 'CG SIVELLS/WHARTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHARTON HIGH SCHOOL' ,`SchoolMiddle` = 'WHARTON JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Club Estates' ,`TaxAmount` = '' ,`TaxRate` = '2.43' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663698942' WHERE `Matrix_Unique_ID` = '203827486' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T10:42:42.783' ,`MLSNumber` = '44092443' ,`ListAgentFullName` = 'Jeffrey Ginn' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.654772' ,`Longitude` = '-95.536517' ,`PhotoCount` = '44' ,`PostalCode` = '77340' ,`RoomCount` = '5' ,`ListPrice` = '510000.00' ,`Status` = 'Active' ,`StreetName` = 'Lake' ,`StreetNumber` = '2007' ,`StreetSuffix` = 'Drive' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2892' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom WATERFRONT home located in Elkins Lake!! This 2 story 3/4BR/2.5BA home is situated on 2 lots giving you almost .75 acres to enjoy. The open floor plan make this home perfect for entertaining family and guests. This home also features an Office/Study on the 2nd level, with a built-in desk, that could also be used for a 4th bedroom! Granite countertops in kitchen with custom 3/4\" Ash plywood cabinets. Master BR is on the first level and features a large walk-in closet. 2nd and 3rd BR\'s are on the lower level as well. Oversized 2 car garage features built-in cabinets and workshop. A 2nd detached garage offers much needed extra storage space. Also included with this home is a 22kw whole home generator!! Amenities include clubhouse, 3 golf courses, 3 lakes, 2 pools, 4 tennis/pickleball courts, 2 walking trails, playgrounds, ball fields, basketball area, several parks and even a dog park!!' ,`Acres` = '0.7428' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ELKINS LAKE - SEC 3, BLOCK 27, LOT 10 & 11' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Waterfront' ,`LotSize` = '32358' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '198' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'ESTELLA STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Elkins Lake - Sec 3' ,`TaxAmount` = '6782' ,`TaxRate` = '1.9609' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698942' WHERE `Matrix_Unique_ID` = '206208292' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T11:37:14.923' ,`MLSNumber` = '77689177' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = 'April Aberle' ,`SellingOfficeName` = 'Mills Family Realty' ,`Latitude` = '29.201247' ,`Longitude` = '-95.407219' ,`PhotoCount` = '17' ,`PostalCode` = '77515' ,`RoomCount` = '14' ,`ListPrice` = '415888.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Brushy Meadow' ,`StreetNumber` = '3423' ,`StreetSuffix` = 'Drive' ,`City` = 'Angleton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2721' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Elmore home design features 4 bedrooms, 3 baths and 2 car garage on a cul-de-sac lot. Home office tucked off hall 2. Beautiful maple cabinets, granite countertops with low bartop and walk-in pantry in kitchen. Two bedrooms, including owner\'s suite, located downstairs. Double sinks, huge walk-in closet, separate tub and shower in owner\'s luxury bath. Upstairs, you\'ll find a loft space, media room and 2 secondary bedrooms. No linen closet and shower only in hall bath in order to accommodate a larger door. Double sinks in hall bath 2. Covered patio in backyard. This home is a must see, so schedule your appointment today to find out if this home is the best option for you and your family. \r\nWindrose Green in Angleton offers easy access to Hwy 288 and Hwy 35. Students will have access to a trail which will lead them to Angleton High School. Planned amenities include a neighborhood park with playground and splashpad plus walking trails. Offered by: K. Hovnanian of Houston II, L.L.C.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'K.Hovnanian' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '51/2/1' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8610' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'RANCHO ISABELLA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Windrose Green' ,`TaxAmount` = '' ,`TaxRate` = '3.527' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698942' WHERE `Matrix_Unique_ID` = '207428012' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T11:37:00.557' ,`MLSNumber` = '10331181' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.205594' ,`Longitude` = '-95.734833' ,`PhotoCount` = '10' ,`PostalCode` = '77354' ,`RoomCount` = '5' ,`ListPrice` = '264985.00' ,`Status` = 'Active' ,`StreetName` = 'Bellewood Manor' ,`StreetNumber` = '215' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1689' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Camden floor plan is a finely designed 2 story plan that incorporates the master on second floor with extra living devoted to the downstairs open family room and dining areas. The large granite kitchen island allows for the unrestricted view of the gathering areas. This home also includes a large patio slab off the back door. Adding to the appeal is the upstairs game room with the taller ceilings on the main floor and in the master bedroom. This plan has to be considered in your quest for the best design and livability you can find.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Rausch Coleman Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '32/1/14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5400' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Magnolia Ridge' ,`TaxAmount` = '' ,`TaxRate` = '3.3' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698942' WHERE `Matrix_Unique_ID` = '207766089' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T10:42:26.653' ,`MLSNumber` = '58795988' ,`ListAgentFullName` = 'Misti Bruton' ,`ListOfficeName` = 'AVO Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.286016' ,`Longitude` = '-97.354519' ,`PhotoCount` = '20' ,`PostalCode` = '78629' ,`RoomCount` = '6' ,`ListPrice` = '347000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 766' ,`StreetNumber` = '13496' ,`StreetSuffix` = '' ,`City` = 'Gonzales' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1248' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute house on over 24 acres of Unrestricted land in Gonzales! Lots of room to grow, property has 2 wells, 2 septics and 2 electric meters. Ag Exempt. Schedule your Showing today!' ,`Acres` = '24.79' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '12 DAN DAVIS' ,`LotDesciption` = 'Wooded' ,`LotSize` = '1079852' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '456 - Cuero' ,`SchoolElementary` = 'CISD DRAW' ,`SchoolHigh` = 'CUERO HIGH SCHOOL' ,`SchoolMiddle` = 'CUERO JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Unknown' ,`TaxAmount` = '1600' ,`TaxRate` = '2.4' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663698942' WHERE `Matrix_Unique_ID` = '208699447' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T10:47:40.233' ,`MLSNumber` = '15100217' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.826021' ,`Longitude` = '-94.986039' ,`PhotoCount` = '22' ,`PostalCode` = '77521' ,`RoomCount` = '7' ,`ListPrice` = '295990.00' ,`Status` = 'Active' ,`StreetName` = 'Morning Dove' ,`StreetNumber` = '8822' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The attractive Pedernales plan holds four large bedrooms, two full bathrooms & an oversized pantry!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 42, Block 1, Section 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6453' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Goose Creek Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.77' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698942' WHERE `Matrix_Unique_ID` = '208740929' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T10:46:44.950' ,`MLSNumber` = '31000823' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.826360' ,`Longitude` = '-94.988955' ,`PhotoCount` = '17' ,`PostalCode` = '77521' ,`RoomCount` = '6' ,`ListPrice` = '320990.00' ,`Status` = 'Active' ,`StreetName` = 'Ruddy Duck' ,`StreetNumber` = '8822' ,`StreetSuffix` = 'Court' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1801' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The attractive Greeley plan presents three bedrooms with large walk-in closets & two full bathrooms!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 19, Block 1, Section 5' ,`LotDesciption` = 'Corner' ,`LotSize` = '11117' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Goose Creek Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.77' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698943' WHERE `Matrix_Unique_ID` = '208743572' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T10:26:28.827' ,`MLSNumber` = '37282410' ,`ListAgentFullName` = 'Chanel Rodgers' ,`ListOfficeName` = 'Texas Diamond Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.068653' ,`Longitude` = '-94.900803' ,`PhotoCount` = '11' ,`PostalCode` = '77535' ,`RoomCount` = '3' ,`ListPrice` = '89500.00' ,`Status` = 'Active' ,`StreetName` = 'Winfree' ,`StreetNumber` = '3406' ,`StreetSuffix` = 'Street' ,`City` = 'Dayton' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely small home with great curb appeal . Nestled by the woods in a picturesque lot with variant foliage, roses and many birds. It is in a quiet neighborhood within walking distance to the High School . It features large bedrooms and a refurbished kitchen sink and counter. This property is sold AS IS.\n' ,`Acres` = '0.1182' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'KINDT-3, BLOCK 38, LOT 62, ACRES .1182' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5149' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'RICHTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Kindt-3' ,`TaxAmount` = '1247' ,`TaxRate` = '2.4832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698943' WHERE `Matrix_Unique_ID` = '208889273' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T10:27:27.213' ,`MLSNumber` = '3923807' ,`ListAgentFullName` = 'Andy Rolf' ,`ListOfficeName` = 'Rolf Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.665145' ,`Longitude` = '-95.007180' ,`PhotoCount` = '18' ,`PostalCode` = '77571' ,`RoomCount` = '7' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Carroll' ,`StreetNumber` = '508' ,`StreetSuffix` = 'Street' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1812' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION IN LA PORTE NOT FAR FROM GALVESTON BAY AND THE SYLVAN BEACH PARK COMPLEX\r\nOPEN CONCEPT LIVING/BREAKFAST/KITCHEN AREAS - LARGE PRIMARY BEDROOM AND BATHROOM SUITE - SPLIT\r\nBEDROOMS - TRAYED CEILINGS - UPGRADED KITCHEN AND BATHROOM CABINETRY - UPGRADED TILE - CARPET\r\nIN THE BEDROOMS - FENCED BACK YARD - UTILITY ROOM IN HOUSE - ENERGY EFFICIENT HOME - LOCATED IN\r\nA QUIET, ESTABLISHED NEIGHBORHOOD - STONE COUNTERTOPS THROUGHOUT THE HOME - EASY LIVING AND JUST WAITING FOR YOU TO MOVE INTO.' ,`Acres` = '0.1435' ,`Area` = '7' ,`BuilderName` = 'BP COASTAL BUILDERS' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOTS 21 & 22, BLOCK 36' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LA PORTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'BAYFRONT ADDITION TO LA PORTE' ,`TaxAmount` = '544' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698943' WHERE `Matrix_Unique_ID` = '209534481' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T10:07:31.433' ,`MLSNumber` = '49477665' ,`ListAgentFullName` = 'Kelly Kelley' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.145273' ,`Longitude` = '-95.036515' ,`PhotoCount` = '47' ,`PostalCode` = '77554' ,`RoomCount` = '7' ,`ListPrice` = '1150000.00' ,`Status` = 'Active' ,`StreetName` = 'Scissor Tail' ,`StreetNumber` = '21222' ,`StreetSuffix` = 'Lane' ,`City` = 'Galveston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2732' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Coastal meets modern in this premier new construction home with Gulf AND Bay views. There is so much to love about this home from the floorplan to the finishes to the Summer sunset bay views. Inverted floorplan maximizes the views from the living areas. 3 bedrooms with en-suite baths, the utility room, & 2nd living area occupy the main level of the home. Primary retreat, & open concept living space are on 2nd level. Finishes in this home include Carrera Marble tile, shiplap walls, 10ft ceilings on both living floors, 250 Gallon buried Propane Tank, 15 ft vaulted ceiling (kitchen/living/dining), A/V pre-wired (family, living, upstairs porch, TV all bedrooms), Twin 55 Gallon – Wifi Electric Rheem water heaters, Isokern vent free fireplace, & outdoor stainless fireplace. Enclosed garage allows plenty of room for storage. Sunset Cove is a gated community with a pool, tennis court, boat ramp & golf cart ride to beach access. AT&T Fiber access. Furniture is for staging purposes only.' ,`Acres` = '0.3444' ,`Area` = '33' ,`BuilderName` = 'owner' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Gas,Propane' ,`HOAMandatory` = '1' ,`Legal` = 'ESTATES OF SUNSET COVE PH 2 (2016) ABST 121, BLOCK 3, LOT 6,' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '15000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Sunset Cove' ,`TaxAmount` = '' ,`TaxRate` = '2.2124' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698943' WHERE `Matrix_Unique_ID` = '209698243' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T11:34:04.810' ,`MLSNumber` = '15311662' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = 'Kelli Dilling' ,`SellingOfficeName` = 'K. Dilling Real Estate LLC.' ,`Latitude` = '29.441453' ,`Longitude` = '-95.249125' ,`PhotoCount` = '11' ,`PostalCode` = '77511' ,`RoomCount` = '14' ,`ListPrice` = '423231.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Kenley' ,`StreetNumber` = '1852' ,`StreetSuffix` = 'Way' ,`City` = 'Alvin' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2501' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming Sawyer II home features 4 bedrooms, 3.5 baths and 2 car garage. Convenient home office tucked of foyer. Maple cabinets and granite countertops in kitchen. Huge walk-in closet, double sinks, separate tub and shower in owner\'s luxury bath. Upstairs, you\'ll find a cozy loft space and all secondary bedrooms. Covered patio in backyard, perfect for entertaining. Offered by: K. Hovnanian Houston Midtown Park I, LLC.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'K. Hovnanian' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '10/4/3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'HASSE ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'G W HARBY J H' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Midtown Park' ,`TaxAmount` = '' ,`TaxRate` = '2.885' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698943' WHERE `Matrix_Unique_ID` = '210118500' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T11:34:34.543' ,`MLSNumber` = '76319636' ,`ListAgentFullName` = 'Justin Guyer' ,`ListOfficeName` = 'RE/MAX Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.731629' ,`Longitude` = '-96.421941' ,`PhotoCount` = '47' ,`PostalCode` = '77465' ,`RoomCount` = '3' ,`ListPrice` = '279000.00' ,`Status` = 'Active' ,`StreetName` = 'Starling' ,`StreetNumber` = '258' ,`StreetSuffix` = 'Drive' ,`City` = 'Palacios' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1152' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well maintained and updated home in the gated and coastal Cape Carancahua Community. Whether you are looking for a part time vacation home for weekend fun and fishing trips or full time residence, this property is well equipped and conveniently located just minutes from shopping, dining and public schools. The interior has been updated to include quartz counters, custom soft close cabinets and drawers, SMARTCORE Ultra 100% waterproof vinyl plank floors and matching kitchen appliances. Downstairs you\'ll find the third bedroom and utility room with full bathroom. Outside, you\'ll find weather resistant vinyl siding, metal roof, awning additions and mature trees for abundant shade on three lots. There is plenty of storage under the home and in the extra storage shed. Community amenities include: Lighted fishing piers, boat ramp, security gate entrance, covered pavilion, public bathrooms, tennis courts, parks, community center and relaxed atmosphere.' ,`Acres` = '0.47' ,`Area` = '67' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CAPE CARANCAHUA #4, LOT 1515-1517, ACRES 0.47' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '20474' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '156 - Palacios' ,`SchoolElementary` = 'CENTRAL ELEMENTARY SCHOOL (PALACIOS)' ,`SchoolHigh` = 'PALACIOS HIGH SCHOOL' ,`SchoolMiddle` = 'PALACIOS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cape Carancahua 04' ,`TaxAmount` = '2643' ,`TaxRate` = '1.8978' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698943' WHERE `Matrix_Unique_ID` = '210123517' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T11:00:13.510' ,`MLSNumber` = '80813235' ,`ListAgentFullName` = 'Valentina Marquez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.796920' ,`Longitude` = '-95.306348' ,`PhotoCount` = '19' ,`PostalCode` = '77026' ,`RoomCount` = '5' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Crane' ,`StreetNumber` = '6302' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1288' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1 story home, recently remodel kitchen offers granite countertops and new cabinets. Home has new laminate floors, and water proof vinyl floors in the kitchen and bathroom. detach garage with door opener. Short commute to downtown, hospital and parks nearby.' ,`Acres` = '0.124' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 188 BLK 10 LIBERTY GARDENS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ISAACS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'FLEMING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Liberty Gardens Sec 01' ,`TaxAmount` = '1836' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698943' WHERE `Matrix_Unique_ID` = '210189554' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T10:27:39.523' ,`MLSNumber` = '8240927' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = 'Debo Sangosanya' ,`SellingOfficeName` = 'Lone Star Realty' ,`Latitude` = '29.537012' ,`Longitude` = '-95.490826' ,`PhotoCount` = '15' ,`PostalCode` = '77545' ,`RoomCount` = '15' ,`ListPrice` = '422125.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Sunlit Meadow' ,`StreetNumber` = '2606' ,`StreetSuffix` = 'Trail' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*This home is under construction.* Find total comfort in this charming Lake Ridge Builders home in Winfield Lakes. Situated on a spacious lot, this 3-sided brick home boasts a premium elevation, no back neighbors, tile flooring, full gutters, a sprinkler system, wrought iron spindles, and a covered patio. Spend time in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, and undercabinet light. Complete with dual vanities, a 42” tub, and a separate shower, the primary suite is ideal for unwinding. Conveniently located near Hwy 6 and the Fort Bend Toll Road, residents enjoy quick access to Downtown Houston and an assortment of nearby restaurants and shopping centers. Students attend schools zoned to Fort Bend ISD. Don’t wait any longer - call now to learn more!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '515' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PARKS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Winfield Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.02' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698943' WHERE `Matrix_Unique_ID` = '210350794' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T10:33:37.063' ,`MLSNumber` = '39512138' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.838029' ,`Longitude` = '-95.693304' ,`PhotoCount` = '13' ,`PostalCode` = '77084' ,`RoomCount` = '14' ,`ListPrice` = '480000.00' ,`Status` = 'Active' ,`StreetName` = 'Gardens End' ,`StreetNumber` = '18119' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2785' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Escape the city to this charming Lake Ridge Builders home in Grand Oaks. Nestled on a spacious lot, this 3-sided brick home boasts a premium elevation, no back neighbors, open ceilings, tile flooring, full gutters, sprinkler system, wrought iron spindles, faux wood blinds, cast stone fireplace, study with French doors, and a covered patio. Try a new recipe in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, and 42” upper cabinets. The serene primary suite features dual vanities, a 42” tub, and a separate shower. Community amenities include an Olympic-size swimming pool with water slides, walking trails, and a playground. Situated near I-10, Hwy 6, and the Grand Parkway, residents enjoy easy access to the Energy Corridor and plenty of dining and shopping options. Nearby schools are zoned to the highly-acclaimed Cypress-Fairbanks ISD. Call today to book your private showing!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 23 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '710' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WILSON ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'WATKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Oaks' ,`TaxAmount` = '' ,`TaxRate` = '2.81' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698944' WHERE `Matrix_Unique_ID` = '210690216' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T11:04:00.610' ,`MLSNumber` = '48048475' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.864700' ,`Longitude` = '-95.282900' ,`PhotoCount` = '6' ,`PostalCode` = '77016' ,`RoomCount` = '4' ,`ListPrice` = '299990.00' ,`Status` = 'Active' ,`StreetName` = 'Meadow Saffron' ,`StreetNumber` = '10538' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Manchester floorplan features 4 bedrooms, 2.5 baths with an over sized home site and first floor primary bedroom!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Rausch Coleman Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '10-1-11' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHADYDALE ELEMENTARY' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wayside Village' ,`TaxAmount` = '' ,`TaxRate` = '3.13' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698944' WHERE `Matrix_Unique_ID` = '211315370' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T11:40:24.207' ,`MLSNumber` = '93230829' ,`ListAgentFullName` = 'Valeria Sanchez' ,`ListOfficeName` = 'CJM Realty Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.123700' ,`Longitude` = '-94.131167' ,`PhotoCount` = '25' ,`PostalCode` = '77703' ,`RoomCount` = '3' ,`ListPrice` = '120000.00' ,`Status` = 'Active' ,`StreetName` = 'Abilene' ,`StreetNumber` = '4695' ,`StreetSuffix` = 'Street' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1130' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute home waiting for you to come add your sweet touches! This home offers 3 spacious bedrooms. Original bathroom was renovated, en-suite was added in the second room with beautiful tile in the shower. Tile flooring in the garage that can be converted into a man cave, or extra-large laundry room. Large fenced in yard for your fury friends to run around or enjoy a Barbeque in the fenced in covered patio. Home is located in a quiet and established neighborhood, close proximity to the paddling trail, shopping and much more!' ,`Acres` = '0.1928' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'GLENWOOD N35FT L41 S1/2 L 42 B 212' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'MARTIN ELEMENTARY SCHOOL (BEAUMONT)' ,`SchoolHigh` = 'BEAUMONT UNITED HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Glenwood' ,`TaxAmount` = '932' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698944' WHERE `Matrix_Unique_ID` = '211338706' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T11:43:55.550' ,`MLSNumber` = '21868213' ,`ListAgentFullName` = 'Martha Sanford' ,`ListOfficeName` = 'Sticks & Bricks Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.938126' ,`Longitude` = '-95.330328' ,`PhotoCount` = '11' ,`PostalCode` = '75862' ,`RoomCount` = '5' ,`ListPrice` = '187900.00' ,`Status` = 'Active' ,`StreetName` = 'Coral Gables' ,`StreetNumber` = '73' ,`StreetSuffix` = '' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Darling new construction home in gated golf course community of Westwood Shores. From the welcoming front porch to the back deck this home has many amenities found in custom homes. Custom kitchen and bathroom cabinets boast soft close drawers, beautiful finish, deep drawers, island for additional workspace. Living area is open to the kitchen with ceiling fan and windows to view the pond behind the home. 13-foot ceilings in kitchen & family room. Primary bedroom is generous in size with ceiling fan. Primary bath has double sinks & tub with shower. Utility room is in the house. Enjoy vacation living year-round with golf, tennis, community pool, country club with restaurant. Neighborhood hosts several community events throughout the year.' ,`Acres` = '0.1949' ,`Area` = '42' ,`BuilderName` = 'Mark Olson' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD SHORES SECTION 01, BLOCK 07A LOT 04' ,`LotDesciption` = 'In Golf Course Community,Patio Lot,Water View' ,`LotSize` = '8492' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2244' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood Shores' ,`TaxAmount` = '64' ,`TaxRate` = '2.5863' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698944' WHERE `Matrix_Unique_ID` = '211391597' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T10:41:29.900' ,`MLSNumber` = '69359375' ,`ListAgentFullName` = 'Aaron Jistel' ,`ListOfficeName` = 'Listing Spark' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.823249' ,`Longitude` = '-95.511210' ,`PhotoCount` = '25' ,`PostalCode` = '77080' ,`RoomCount` = '9' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Mona Lee' ,`StreetNumber` = '3122' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3894' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Huge house, big trees in safe, quiet neighborhood in the Spring Branch school district. Lots of storage, pantry, office, sun room, back yard covered deck, tool storage area, cute playhouse under staircase and large game room/extra bedroom upstairs. New gas stove in kitchen and refrigerator convey. Family ready.' ,`Acres` = '0.23' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 185 BLK 14 BINGLEWOOD SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '10018' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'EDGEWOOD ELEMENTARY SCHOOL (SPRING BRANCH)' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'NORTHBROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Binglewood Sec 02' ,`TaxAmount` = '9292' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698944' WHERE `Matrix_Unique_ID` = '211413369' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T10:03:49.217' ,`MLSNumber` = '23344420' ,`ListAgentFullName` = 'Dayna Simmons' ,`ListOfficeName` = 'Dayna Simmons Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.931308' ,`Longitude` = '-94.210858' ,`PhotoCount` = '27' ,`PostalCode` = '77705' ,`RoomCount` = '11' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Sheila' ,`StreetNumber` = '10930' ,`StreetSuffix` = 'Court' ,`City` = 'Beaumont' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4094' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This marvelous mansion awaits you with amenities galore! Come down the long driveway and take a step into this beauty where you are greeted by warm tones throughout, complete with brick accent. Entertain your guests in the beautiful living space while whipping up your favorite recipe in the kitchen, complete with custom cabinets, a large pantry, and wine rack. Retreat to the owners suite for rest and relaxation, where you will find your very own soaker tub & separate shower. Take a step outside onto the patio and you are greeted by your very own in-ground pool complete with a waterfall - perfect for those hot summer afternoons! You won\'t want to miss this one. Call us today!' ,`Acres` = '1.95' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'THE ESTATES AT FANNETT LOT 7-A REPLAT BLK 4 1.953 THE ESTATE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '84942' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '110 - Hamshire-Fannett' ,`SchoolElementary` = 'HAMSHIRE-FANNETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HAMSHIRE-FANNETT HIGH SCHOOL' ,`SchoolMiddle` = 'HAMSHIRE-FANNETT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates At Fannett The' ,`TaxAmount` = '11879' ,`TaxRate` = '2.0652' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698944' WHERE `Matrix_Unique_ID` = '211424649' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T11:42:10.987' ,`MLSNumber` = '14056882' ,`ListAgentFullName` = 'Glena Smith' ,`ListOfficeName` = 'NextHome Realty Center' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.868340' ,`Longitude` = '-95.726638' ,`PhotoCount` = '21' ,`PostalCode` = '77449' ,`RoomCount` = '4' ,`ListPrice` = '270000.00' ,`Status` = 'Active' ,`StreetName` = 'Settlers Lake' ,`StreetNumber` = '6247' ,`StreetSuffix` = 'Circle' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2140' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investor only, Tenant occupied till September 30, 2023, Charming 4 bedroom, 2.1 baths. Upstairs is large gameroom, 3 bedrooms, one full bath and utility room. Downstairs is Primary bedroom with bath, powder room, family room, formal dining room, island in Kitchen. backyard fenced with detached garage.' ,`Acres` = '0.0914' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 33 BLK 4 LAKEVILLE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3980' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '569' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HEMMENWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeville Sec 01' ,`TaxAmount` = '5639' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663698944' WHERE `Matrix_Unique_ID` = '211428174' --> Updated record success