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` = '2023-01-02T10:23:53.607' ,`MLSNumber` = '87691951' ,`ListAgentFullName` = 'Louis Vargas' ,`ListOfficeName` = 'Tevas Real Estate Group INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.759661' ,`Longitude` = '-95.253536' ,`PhotoCount` = '25' ,`PostalCode` = '77029' ,`RoomCount` = '3' ,`ListPrice` = '249955.00' ,`Status` = 'Active' ,`StreetName` = 'Lanewell' ,`StreetNumber` = '9923' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1626' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '28 homes on this street all starting at the same time. Pre selling now Come pick your lot. Beautiful 3 bed 2-1/2 bath home will amaze you with all the updates put in. Custom cabinetry done on site with designer gray paint in all areas, kitchen, and bathrooms. quartz counter tops with stainless steal appliances which brings the whole home together. All light fixtures are dark black giving you a gorgeous modern look. The stairs are wood and stained to match the home. Upstairs you have 3 large bedrooms laid out perfect for your family. The back yard is large enough for entertaining. Come see this home before its gone. Final trims will be based on availability of materials' ,`Acres` = '0' ,`Area` = '2' ,`BuilderName` = 'SVG' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 33 THRU 46 BLK 83 FIDELITY' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'WOODLAND ACRES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GALENA PARK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODLAND ACRES MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fidelity' ,`TaxAmount` = '' ,`TaxRate` = '2.7702' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675098829' WHERE `Matrix_Unique_ID` = '206839047' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T10:24:14.727' ,`MLSNumber` = '96728364' ,`ListAgentFullName` = 'Louis Vargas' ,`ListOfficeName` = 'Tevas Real Estate Group INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.759661' ,`Longitude` = '-95.253536' ,`PhotoCount` = '25' ,`PostalCode` = '77029' ,`RoomCount` = '3' ,`ListPrice` = '249955.00' ,`Status` = 'Active' ,`StreetName` = 'Lanewell' ,`StreetNumber` = '9927' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1626' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '28 homes on this street all starting at the same time. Pre selling now Come pick your lot. Beautiful 3 bed 2-1/2 bath home will amaze you with all the updates put in. Custom cabinetry done on site with designer gray paint in all areas, kitchen, and bathrooms. quartz counter tops with stainless steal appliances which brings the whole home together. All light fixtures are dark black giving you a gorgeous modern look. The stairs are wood and stained to match the home. Upstairs you have 3 large bedrooms laid out perfect for your family. The back yard is large enough for entertaining. Come see this home before its gone. Final trims will be based on availability of materials' ,`Acres` = '0' ,`Area` = '2' ,`BuilderName` = 'SVG' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 33 THRU 46 BLK 83 FIDELITY' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'WOODLAND ACRES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GALENA PARK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODLAND ACRES MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fidelity' ,`TaxAmount` = '' ,`TaxRate` = '2.7702' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675098829' WHERE `Matrix_Unique_ID` = '206839597' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T10:23:26.120' ,`MLSNumber` = '55524263' ,`ListAgentFullName` = 'Louis Vargas' ,`ListOfficeName` = 'Tevas Real Estate Group INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.759661' ,`Longitude` = '-95.253536' ,`PhotoCount` = '25' ,`PostalCode` = '77029' ,`RoomCount` = '3' ,`ListPrice` = '249955.00' ,`Status` = 'Active' ,`StreetName` = 'Lanewell' ,`StreetNumber` = '9935' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1626' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '28 homes on this street all starting at the same time. Pre selling now Come pick your lot. Beautiful 3 bed 2-1/2 bath home will amaze you with all the updates put in. Custom cabinetry done on site with designer gray paint in all areas, kitchen, and bathrooms. quartz counter tops with stainless steal appliances which brings the whole home together. All light fixtures are dark black giving you a gorgeous modern look. The stairs are wood and stained to match the home. Upstairs you have 3 large bedrooms laid out perfect for your family. The back yard is large enough for entertaining. Come see this home before its gone. Final trims will be based on availability of materials' ,`Acres` = '0' ,`Area` = '2' ,`BuilderName` = 'SVG' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 33 THRU 46 BLK 83 FIDELITY' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'WOODLAND ACRES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GALENA PARK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODLAND ACRES MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fidelity' ,`TaxAmount` = '' ,`TaxRate` = '2.7702' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675098829' WHERE `Matrix_Unique_ID` = '206840174' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T10:23:04.233' ,`MLSNumber` = '63814587' ,`ListAgentFullName` = 'Louis Vargas' ,`ListOfficeName` = 'Tevas Real Estate Group INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.759661' ,`Longitude` = '-95.253536' ,`PhotoCount` = '25' ,`PostalCode` = '77029' ,`RoomCount` = '3' ,`ListPrice` = '249955.00' ,`Status` = 'Active' ,`StreetName` = 'Lanewell' ,`StreetNumber` = '9941' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1626' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '28 homes on this street all starting at the same time. Pre selling now Come pick your lot. Beautiful 3 bed 2-1/2 bath home will amaze you with all the updates put in. Custom cabinetry done on site with designer gray paint in all areas, kitchen, and bathrooms. quartz counter tops with stainless steal appliances which brings the whole home together. All light fixtures are dark black giving you a gorgeous modern look. The stairs are wood and stained to match the home. Upstairs you have 3 large bedrooms laid out perfect for your family. The back yard is large enough for entertaining. Come see this home before its gone. Final trims will be based on availability of materials' ,`Acres` = '0' ,`Area` = '2' ,`BuilderName` = 'SVG' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 33 THRU 46 BLK 83 FIDELITY' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'WOODLAND ACRES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GALENA PARK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODLAND ACRES MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fidelity' ,`TaxAmount` = '' ,`TaxRate` = '2.7702' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675098830' WHERE `Matrix_Unique_ID` = '206840616' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T10:15:00.600' ,`MLSNumber` = '7446740' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.220372' ,`Longitude` = '-95.348548' ,`PhotoCount` = '14' ,`PostalCode` = '77302' ,`RoomCount` = '4' ,`ListPrice` = '319990.00' ,`Status` = 'Active' ,`StreetName` = 'Dove Hollow' ,`StreetNumber` = '15834' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1628' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Available February 2023**\r\n\r\nWelcome home to the Barrett Plan featuring 3 bedrooms and 2 bathrooms on an oversized lot. The private primary suite with an ensuite bathroom includes double sinks, soaking tub, and a walk-in shower. Wood look tile floors are found in the main and wet areas, and upgraded carpet in the bedrooms. The kitchen has a single basin sink, white cabinetry, quartz countertops and stainless steel appliances.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Pulte Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6523' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mavera' ,`TaxAmount` = '' ,`TaxRate` = '3.198' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675098830' WHERE `Matrix_Unique_ID` = '209831026' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T09:15:39.707' ,`MLSNumber` = '7127319' ,`ListAgentFullName` = 'Melanie Dinh' ,`ListOfficeName` = 'Luxely Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.186972' ,`Longitude` = '-95.554246' ,`PhotoCount` = '43' ,`PostalCode` = '77382' ,`RoomCount` = '10' ,`ListPrice` = '2450000.00' ,`Status` = 'Active' ,`StreetName` = 'Palmiera' ,`StreetNumber` = '66' ,`StreetSuffix` = 'Circle' ,`City` = 'The Woodlands' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '6467' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the prestigious Carlton Woods subdivision, The Club at Carlton Woods golf-course, this Modern Mediterranean charm offers all the bells and whistles. Tons of upgrades: SAVANT home automated system, with LUTRON switches, LED module trimmed lights (estimated around $140K). Features grand entrance, more than 23 ft height ceiling; stunning gourmet kitchen with oversized island, WOLFE oven/range, SUBZERO refrigerator, custom cabinetry, built-in microwave & ice-maker, large pantry, walk-in wine room, formal dining, breakfast room, spacious living room with fireplace. Luxurious primary suite with walk-in closet, coffee-bar with sink, his & her vanities, jetted tub, stunning tray ceiling. Separate access to Guest Casita adjacent to outdoor swimming-pool, with coffee bar & full bath. 3 secondary bedrooms are on 2nd floor, additional 2 custom built fitness rooms, with media/flex spaces, and balcony. ALL MEASUREMENTS MUST BE VERIFIED INDEPENDENTLY BY BUYERS. ASK FOR FULL UPGRADE LIST.' ,`Acres` = '0.3926' ,`Area` = '15' ,`BuilderName` = 'TIPLER' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Reports Available,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'WDLNDS VIL OF CARLTON WOODS 14, BLOCK 1, LOT 14' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '17102' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '4250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other,Tile' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'TOUGH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Lockbox Left Side,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean,Other Style,Spanish,Traditional' ,`Subdivision` = 'Wdlnds Village Of Carlton Woods 14' ,`TaxAmount` = '40892' ,`TaxRate` = '2.1816' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675098830' WHERE `Matrix_Unique_ID` = '211283305' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T09:13:52.723' ,`MLSNumber` = '21279586' ,`ListAgentFullName` = 'Suyapa Jedeh' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.745650' ,`Longitude` = '-95.301664' ,`PhotoCount` = '28' ,`PostalCode` = '77011' ,`RoomCount` = '2' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue' ,`StreetNumber` = '6821' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '642' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Investment opportunity in the East End district! Being SOLD \'AS-IS\' WHERE IS- No repairs. PLEASE NOTE: LOT SIZE AND HOUSE SF IS INCORRECT IN APPRAISAL DISTRICT. Lot SIZE 2,500 AND HOUSE 642 SF. Buyer to verify all information including room dimensions, taxes, schools etc. Lot size and square footage per HCAD. Buyer to purchase a Survey. Great potential as new construction is being built in the area. Property has not flooded, prime location with easy access to Medical Center, Southeast of downtown and the Port Of Houston. Please call with any questions.' ,`Acres` = '0.1148' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 13 & 14 BLK 133 CENTRAL PARK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FRANKLIN ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'EDISON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Central Park' ,`TaxAmount` = '2762' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098830' WHERE `Matrix_Unique_ID` = '211331275' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T10:56:16.157' ,`MLSNumber` = '20271288' ,`ListAgentFullName` = 'Sherri Linscomb-Woodard' ,`ListOfficeName` = 'Tyger Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.385066' ,`Longitude` = '-94.929253' ,`PhotoCount` = '21' ,`PostalCode` = '77590' ,`RoomCount` = '5' ,`ListPrice` = '167000.00' ,`Status` = 'Active' ,`StreetName` = '1st' ,`StreetNumber` = '2324' ,`StreetSuffix` = 'Avenue' ,`City` = 'Texas City' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1452' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1722' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 142 R LOGAN SUR PT OF LOT 23 (23-8) TEXAS CITY HEIGHTS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HEIGHTS ELEMENTARY SCHOOL (TEXAS CITY)' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Texas City Heights' ,`TaxAmount` = '3385' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098830' WHERE `Matrix_Unique_ID` = '211425517' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T09:57:35.897' ,`MLSNumber` = '58349297' ,`ListAgentFullName` = 'Richard Fenyes' ,`ListOfficeName` = 'Rocket, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.084967' ,`Longitude` = '-95.234763' ,`PhotoCount` = '25' ,`PostalCode` = '77365' ,`RoomCount` = '7' ,`ListPrice` = '309000.00' ,`Status` = 'Active' ,`StreetName` = 'Cascade Mountain' ,`StreetNumber` = '22008' ,`StreetSuffix` = 'Drive' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2690' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Super clean & spacious 4-BEDROOM (largest floor-plan) newer home with many fabulous upgrades, including many features, located in a great location, close to 99 Grand Parkway, 59/69, close to restaurants, a new shopping center (new grocery store) and so much more.The family functional floorplan is open and inviting including upgraded elevated ceilings w/recessed lighting,ceiling fans w/lighting,an expansive(great for entertaining)all-granite island kitchen including ample aesthetically pleasing wrap-around counter space,also providing a barstool seating area;extremely nice,the kitchen also opens to dining & family room areas all harmoniously working together for optimum living.Home includes a guest powder-bath and the large Primary Bedroom is down with wonderful closet space;Primary bath includes separate garden tub & shower w/dual vanities.The upstairs game-FLEX room is it\'s own separate oasis that can provide space for more!Large in-home utility and beautiful backyard w/covered patio.' ,`Acres` = '0.1008' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S269800 - BROOKLYN TRAILS 01, BLOCK 1, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4393' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'PORTER ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brooklyn Trails 01' ,`TaxAmount` = '2863' ,`TaxRate` = '3.6031' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675098831' WHERE `Matrix_Unique_ID` = '211594477' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T09:14:39.240' ,`MLSNumber` = '51680493' ,`ListAgentFullName` = 'Suyapa Jedeh' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.745652' ,`Longitude` = '-95.301491' ,`PhotoCount` = '12' ,`PostalCode` = '77011' ,`RoomCount` = '2' ,`ListPrice` = '120000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue' ,`StreetNumber` = '6825' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '642' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Investment opportunity in the East End district! Being SOLD \'AS-IS\' WHERE IS- No repairs. Drive by only for now- Please do not disturb tenants!. Buyer to verify all information including room dimensions, taxes, schools etc. Lot size and square footage per HCAD. Buyer to purchase a Survey. Great potential as new construction is being built in the area. Property has not flooded, prime location with easy access to Medical Center, Southeast of downtown and the Port Of Houston. Please call with any questions.' ,`Acres` = '0.0574' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 133 CENTRAL PARK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FRANKLIN ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'EDISON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Central Park' ,`TaxAmount` = '1536' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098831' WHERE `Matrix_Unique_ID` = '211660464' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T09:15:10.940' ,`MLSNumber` = '92718805' ,`ListAgentFullName` = 'Suyapa Jedeh' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.745615' ,`Longitude` = '-95.301419' ,`PhotoCount` = '6' ,`PostalCode` = '77011' ,`RoomCount` = '2' ,`ListPrice` = '120000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue' ,`StreetNumber` = '6827' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '642' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Investment opportunity in the East End district! Being SOLD \'AS-IS\' WHERE IS- No repairs. Drive by only for now- Please do not disturb tenants!. Buyer to verify all information including room dimensions, taxes, schools etc. Lot size and square footage per HCAD. Buyer to purchase a Survey. Great potential as new construction is being built in the area. Property has not flooded, prime location with easy access to Medical Center, Southeast of downtown and the Port of Houston. Please call with any questions.' ,`Acres` = '0.0574' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 133 CENTRAL PARK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FRANKLIN ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'EDISON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Central Park' ,`TaxAmount` = '1683' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098831' WHERE `Matrix_Unique_ID` = '211670618' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T09:14:53.983' ,`MLSNumber` = '35115334' ,`ListAgentFullName` = 'Thomas Schwenk' ,`ListOfficeName` = 'Coldwell Banker TGRE' ,`SellingAgentFullName` = 'Giannina Hadfield' ,`SellingOfficeName` = 'HomeSmart' ,`Latitude` = '29.303791' ,`Longitude` = '-94.800598' ,`PhotoCount` = '38' ,`PostalCode` = '77550' ,`RoomCount` = '0' ,`ListPrice` = '599000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Market' ,`StreetNumber` = '2828' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '0' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '3782' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Own a piece of Galveston History. The 1903 Firehouse No. 3 replaced the original one in the same location. While the architect is not yet known, the building is a good and rare example of a civic firehouse of the late 19th and early 20th century. In 1957, Star State Company No. 3 became the first firehouse in the city to integrate with African American firemen. The city continued to use the building as a fire station until it was decommissioned in the 1960s. Owned by the Galveston Historic Foundation, who saved it from demolition and has kept the original facade. While the station is still in its original location, significant exterior alterations have occurred to the building including the removal of decorative features and the application of stucco over the original brickwork. Interior is ready for buildout space for 2 floors.' ,`Acres` = '0.0859' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Harborside' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR S 87 FT OF LOT 14 (14-0) BLK 568 GAL' ,`LotDesciption` = 'Other' ,`LotSize` = '3742' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '1060' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1903' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675098831' WHERE `Matrix_Unique_ID` = '211918235' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T10:03:25.000' ,`MLSNumber` = '51897532' ,`ListAgentFullName` = 'Bo Williams' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.067206' ,`Longitude` = '-96.211073' ,`PhotoCount` = '22' ,`PostalCode` = '77871' ,`RoomCount` = '7' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Yaupon' ,`StreetNumber` = '8' ,`StreetSuffix` = 'Lane' ,`City` = 'Hilltop Lakes' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2312' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful two story home sits on almost one acre with a back yard privacy fence. You can sit in your lawn chairs and watch the 4th of July fireworks without having to leave the house. Little to no traffic because W. Yaupon Lane is a dead end street. You\'ll have all the room you\'ll need with 5 bedrooms, 3 baths and 2 door garage. The community has an 18 hole golf course, play area, community pool, horse barn & stables, tennis courts. All amenities go along with the property for the residents use.' ,`Acres` = '0.2353' ,`Area` = '63' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Normangee/Marquez Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HILLTOP LAKES SEC 5 BLK 5 LT 2-5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10019' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '110' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '131 - Normangee' ,`SchoolElementary` = 'NORMANGEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORMANGEE HIGH SCHOOL' ,`SchoolMiddle` = 'NORMANGEE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Hilltop Lakes Sec Five' ,`TaxAmount` = '3905' ,`TaxRate` = '1.8865' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098832' WHERE `Matrix_Unique_ID` = '212592219' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T10:45:38.773' ,`MLSNumber` = '72026425' ,`ListAgentFullName` = 'Santiago Acosta' ,`ListOfficeName` = 'Realty World Homes & Estates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.701909' ,`Longitude` = '-95.873661' ,`PhotoCount` = '46' ,`PostalCode` = '77441' ,`RoomCount` = '3' ,`ListPrice` = '632900.00' ,`Status` = 'Active' ,`StreetName` = 'Edgemont' ,`StreetNumber` = '6' ,`StreetSuffix` = 'Court' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2688' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SPECTACULAR Lakefront Mediterranean casita style home by Trendmaker Homes. Showcasing custom features throughout including clay tile roof stucco elevation, tray ceilings w/crown molding, hardwood flooring, plantation shutters & high-end finishes! Located in the GATED community of Lakes of Cross Creek Ranch, surrounded by miles of walking trails, sports facilities & two waterparks - the award-winning community offers resort-style amenities. You’ll be welcomed through the gated courtyard then by the stunning front door. The living room and dining room are surrounded by oversized windows. Upscale kitchen w granite island and high-end appliances including double ovens and tons of counters and cabinets! Master suite w/vaulted ceiling, windows w/shutters. massive primary bathroom, bath spa and walk-in shower. Amazing outdoor living area boasts a covered patio with wide open views of the lake! Come see this beautiful home & wake up to the amazing sunrise every morning! An absolute gem!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKES OF CROSS CREEK RANCH SEC 3, BLOCK 1, LOT 33' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '8435' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Lakes of Cross Creek' ,`TaxAmount` = '14564' ,`TaxRate` = '3.3362' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098832' WHERE `Matrix_Unique_ID` = '212991312' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T09:40:04.597' ,`MLSNumber` = '91680784' ,`ListAgentFullName` = 'Melanie Wingate' ,`ListOfficeName` = 'Bates-Brinkley Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.816459' ,`Longitude` = '-95.071553' ,`PhotoCount` = '50' ,`PostalCode` = '77562' ,`RoomCount` = '8' ,`ListPrice` = '180000.00' ,`Status` = 'Active' ,`StreetName` = 'Clear Lake' ,`StreetNumber` = '1105' ,`StreetSuffix` = 'Road' ,`City` = 'Highlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1616' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'well-maintained 3/2 on approx. 1/2 acre lot - tree-shaded yard with pecans - original wood floors in large portion of home - split floor-plan - carport & shop space in garage' ,`Acres` = '0.5051' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 1C 1D & TR 1B-1 BLK 42 HIGHLANDS TOWNSITE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '22000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'HOPPER/HIGHLANDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Highlands Townsite' ,`TaxAmount` = '3297' ,`TaxRate` = '2.575' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098832' WHERE `Matrix_Unique_ID` = '213071456' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T10:34:00.367' ,`MLSNumber` = '57148076' ,`ListAgentFullName` = 'Austin Hodges' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.837594' ,`Longitude` = '-95.343439' ,`PhotoCount` = '27' ,`PostalCode` = '77320' ,`RoomCount` = '2' ,`ListPrice` = '142000.00' ,`Status` = 'Active' ,`StreetName` = 'Brumley' ,`StreetNumber` = '75' ,`StreetSuffix` = 'Road' ,`City` = 'Huntsville' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '822' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity to own a small hunting cabin in Huntsville. House is a shell house and will need to be finished by the next owner. Situated on 5 wooded acres, it is a great spot to set some deer stands. The house is NOT IN A FLOOD ZONE. With no restrictions, the possibilities are limitless. Schedule your tour today! Listing Agent is married to the seller.' ,`Acres` = '5.003' ,`Area` = '43' ,`BuilderName` = 'N/A' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Riverside (Walker)' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'CAROLINA VILLAGE, LOT 9, ACRES 5.003' ,`LotDesciption` = 'Wooded' ,`LotSize` = '217931' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SCOTT JOHNSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Carolina Village' ,`TaxAmount` = '1828' ,`TaxRate` = '1.7134' ,`WaterSewer` = 'No Sewer,No Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098832' WHERE `Matrix_Unique_ID` = '213272169' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T09:24:54.520' ,`MLSNumber` = '37318016' ,`ListAgentFullName` = 'Karen Seale' ,`ListOfficeName` = 'Etheredge Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.533638' ,`Longitude` = '-95.022229' ,`PhotoCount` = '33' ,`PostalCode` = '77565' ,`RoomCount` = '9' ,`ListPrice` = '329900.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Briar' ,`StreetNumber` = '510' ,`StreetSuffix` = 'Drive' ,`City` = 'Kemah' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2684' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**FANTASTIC 4 Bedroom Home with Home Office in KEMAH OAKS** Home features 4 bedrooms- 3 full bathrooms- 1 half bathroom- 2 car garage! Kitchen with breakfast bar is open to the breakfast room. Formal Dining Room! Home Office/Study! Fireplace. Primary en-suite located on 1st floor with walk-in closet! ADDITIONAL PRIMARY Bedroom located on the 2nd floor!! From 2016-2022 owner\'s have replaced water heater, dishwasher, backyard fencing, air conditioner, carpeting and interior paint. Energy Savings with central heat and appliances! Gas on property to add your GENERATOR! Beautiful floor plan for your Family! Kemah Oaks provides pool, playground, basketball, soccer, pavilion, walking trails and restrooms!' ,`Acres` = '0.1423' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 18 M MULDOON SUR LOT 16 (16-2) BLK 10 KEMAH OAKS SUB' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '484' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kemah Oaks Sub 92' ,`TaxAmount` = '5039' ,`TaxRate` = '2.0134' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098833' WHERE `Matrix_Unique_ID` = '213603372' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T10:41:48.523' ,`MLSNumber` = '18576293' ,`ListAgentFullName` = 'Vincent Tramonte' ,`ListOfficeName` = 'Joe Tramonte Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.301147' ,`Longitude` = '-94.786430' ,`PhotoCount` = '50' ,`PostalCode` = '77550' ,`RoomCount` = '9' ,`ListPrice` = '749500.00' ,`Status` = 'Active' ,`StreetName` = 'Broadway' ,`StreetNumber` = '1805' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3408' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exquisitely appointed and meticulously restored, the 1893 Smith-Bailey is a Queen Anne Victorian listed on National Registry of Historic Homes. Featured on 2009 Galveston Historic Home Tours, this historic beauty is graced with original hardwoods, curly pine wainscoting in the foyer and dining room, and three finely detailed fireplaces for comfort. The kitchen with 4-burner gas stove has granite and butcher block. There are four porches, two of which are screened and wrap around. For your convenience this home has an Elevator that goes to third floor (approx. 731 sf) which could be game room/studio/master with full bath, skylights and dormers. Upgrades include tankless water heater and remote controlled blinds on second floor stairwell windows, 50 year composite roof (2006), and Magtite windows and freshly painted on the exterior. The oversized garage was built in 2013 and features lots of storage. Newly installed brick pathways and patios enhance the easy care landscaping.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 PAGE126 LOT 6 BLK 138 GALVESTON' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Victorian' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '16000' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1893' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098833' WHERE `Matrix_Unique_ID` = '213931414' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T10:13:30.607' ,`MLSNumber` = '31489157' ,`ListAgentFullName` = 'Shijimon Jacob' ,`ListOfficeName` = 'Everest Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.526435' ,`Longitude` = '-95.540607' ,`PhotoCount` = '50' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '640000.00' ,`Status` = 'Active' ,`StreetName` = 'Merlins' ,`StreetNumber` = '5327' ,`StreetSuffix` = 'Trail' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3465' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Magnificently Elegant Home with Two Primary Bedrooms ! Located on a corner lot only minutes from major conveniences, this 4BR/4.5BA, 3,465sqft property embodies rustic sophistication with a gorgeous brick and stucco exterior, meticulous landscaping, an open floorplan, high foyer ceilings, engineered hardwood floors, lovely formal dining room, office w/French doors, and a great room w/gas fireplace and overhead catwalk. Open for easy entertaining, the gourmet kitchen features stainless-steel appliances, granite counters, an island, an enormous pantry, and an adjoining spice kitchen. Each level has a primary bedroom with a deep closet and an en suite featuring dual sinks, a jetted tub, and a shower. Additionally, the main-level primary bedroom boasts tray ceilings and bay windows. Other features: 3-car tandem garage, laundry w/gas hookup, tankless water heater, sprinkler system, water softener, huge game room, guest bedrooms w/attached baths, and more! Call for a tour!' ,`Acres` = '0.2253' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'AVALON AT SIENNA PLANTATION SEC 2 FINAL PLAT OF, BLOCK 2, LO' ,`LotDesciption` = 'Corner' ,`LotSize` = '9814' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1254' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SIENNA CROSSING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Avalon At Sienna Plantation Sec 2' ,`TaxAmount` = '7971' ,`TaxRate` = '2.8129' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098833' WHERE `Matrix_Unique_ID` = '214375443' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T10:00:13.687' ,`MLSNumber` = '11211999' ,`ListAgentFullName` = 'Tiera Huang' ,`ListOfficeName` = 'Nextgen Real Estate Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.007651' ,`Longitude` = '-95.491424' ,`PhotoCount` = '23' ,`PostalCode` = '77068' ,`RoomCount` = '6' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Aspen Bend' ,`StreetNumber` = '3507' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2574' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Escape to this beautiful home that has the perfect amount Modern and Charm! Come take a look at this spacious 2-story, 4 bedroom, 2.5 bathroom with hard wood floors that offers easy flow between oversized living area, dining room, and kitchen.All 4 bedroom are conveniently located on the 2nd floor. Escape to the private primary retreat with that over looks the perfect ensuite seating area that is large enough for a nursery, office, study, gym, library, what every your heart desires! This spacious home includes a game room with a wet bar, oversize walk-in closets, oversized backyard with wooden deck, 2 car garage and much more! Come make this house your home!' ,`Acres` = '0.2014' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 11 OLDE OAKS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8775' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PAT REYNOLDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Olde Oaks Sec 01' ,`TaxAmount` = '4743' ,`TaxRate` = '2.3342' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098833' WHERE `Matrix_Unique_ID` = '214377065' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T10:10:23.693' ,`MLSNumber` = '35986084' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.220753' ,`Longitude` = '-95.348614' ,`PhotoCount` = '8' ,`PostalCode` = '77302' ,`RoomCount` = '4' ,`ListPrice` = '328010.00' ,`Status` = 'Active' ,`StreetName` = 'Dove Hollow' ,`StreetNumber` = '15822' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1823' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Available in MARCH 2023. Pulte welcomes you to the spacious Oakmont Plan featuring 3 bedrooms and 2 bathrooms walking distance from the pool and lake trails! The private owner’s suite includes separate sinks, soaking tub, and a walk-in shower. The kitchen has a single basin sink, 42\" white cabinets, quartz countertops, and stainless steel appliances.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Pulte Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '30302' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mavera' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675098834' WHERE `Matrix_Unique_ID` = '214484938' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T10:13:20.013' ,`MLSNumber` = '10197393' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.220226' ,`Longitude` = '-95.348554' ,`PhotoCount` = '9' ,`PostalCode` = '77302' ,`RoomCount` = '7' ,`ListPrice` = '419990.00' ,`Status` = 'Active' ,`StreetName` = 'Dove Hollow' ,`StreetNumber` = '15839' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2787' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Available April 2023. Pulte welcomes you to the Riverdale plan featuring 5 bedroom, 4 bathrooms and walking distance to the pool and trails on the lake! Wood look tile floors are found in the main and wet areas, and upgraded carpet upstairs and in the bedrooms. The kitchen has a single basin sink, white cabinetry, quartz countertops and stainless steel appliances. Your downstairs Owners suite includes an ensuite bathroom, Huge Glam /Spa Shower, and bay windows.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Pulte Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '03202' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mavera' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675098834' WHERE `Matrix_Unique_ID` = '214485226' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T10:30:33.750' ,`MLSNumber` = '52372597' ,`ListAgentFullName` = 'Robert Wood' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.786810' ,`Longitude` = '-95.400778' ,`PhotoCount` = '6' ,`PostalCode` = '77007' ,`RoomCount` = '0' ,`ListPrice` = '725000.00' ,`Status` = 'Active' ,`StreetName` = '9th' ,`StreetNumber` = '312' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '0' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '1600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sold for lot value... 66X100 with side alley' ,`Acres` = '0.15' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 34 35A & 36 BLK 244 HOUSTON HEIGHTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HARVARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Houston Heights' ,`TaxAmount` = '12136' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098834' WHERE `Matrix_Unique_ID` = '214835842' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215254655','1675098834','215254655','2023-01-02T10:25:09.357','57904358','Richard Gamboa','MOVE HOUSTON REAL ESTATE','','','30.307867','-95.415188','21','77301','10','270000.00','Active','Silver Fir','1202','Court','Conroe','2','1','4','1851','Single-Family','Located minutes from The Woodlands ! This is your opportunity to enjoy a new lovely home in The Ladera Trails Trails . The floor plan allows for spacious and lightened quarters . A modern kitchen contains an open room for casual seating with a dining area. Quartz countertops provide space for guests and easy cooking . Soft illumination and natural lights combine to provide exemplary lighting . The large open living room allows easy movement between the kitchen and the combination living room/dining room into the primary bedroom/primary bathroom with a walk-in closet . The 2nd floor reveals 3 spacious bedrooms , utility room and 1 full bath including a game room. Abundance of space for furniture and family . You\'ll be fond of the corner lot access for an easy entry home and departure. A delightful backyard is ready for barbecues and family get-togethers ! Call today for a tour.','0.1215','19','Lennar','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Conroe Southeast','Central Gas','1','S647000 - LADERA TRAILS 01, BLOCK 1, LOT 40','Corner,Subdivision Lot','5291','Appraisal District','','600','0','','2','','0','','','','','Composition','11 - Conroe','RUNYAN ELEMENTARY SCHOOL','CONROE HIGH SCHOOL','STOCKTON JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Builder','2','Traditional','Ladera Trails','1083','2.7863','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215985162','1675098834','215985162','2023-01-02T10:07:00.197','14416745','Edgardo Martinez','Lucky Money Real Estate','','','30.220239','-95.426599','34','77385','6','215000.00','Active','Fallen Timbers','16751','Drive','Conroe','2','0','3','1448','Single-Family','Beautiful home features 3 bedrooms, 2 full baths! The family room is open to the kitchen. Covered patio in back yard perfect for entertaining. This home provides family comfort at a great price. Large backyard with a huge covered patio perfect for entertaining and BBQ’s. Close to I-45 N with easy access to The Woodlands, Exxon campus, downtown and more. Lots of area amenities. Schools are zoned to Conroe ISD. Storage shed and Refrigerator are included. You won\'t want to miss this one!! Schedule your private showing!!','0.1515','15','','','','','Mud,Sellers Disclosure','','','','Conroe Southeast','Central Electric','0','GLENEAGLES 04, LOT 279','Subdivision Lot','6600','Appraisal District','','200','0','','1','','0','','','','','Composition','11 - Conroe','SUCHMA ELEMENTARY SCHOOL','OAK RIDGE HIGH SCHOOL','IRONS JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Left Side','Appraisal District','1','Traditional','Gleneagles','3832','2.6088','Water District','2005','Appraisal District'); --> New record created successfully