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-23T08:18:37.017' ,`MLSNumber` = '14425053' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.128645' ,`Longitude` = '-95.312358' ,`PhotoCount` = '33' ,`PostalCode` = '77365' ,`RoomCount` = '10' ,`ListPrice` = '710556.00' ,`Status` = 'Active' ,`StreetName` = 'Breakwater' ,`StreetNumber` = '22045' ,`StreetSuffix` = 'Lane' ,`City` = 'Porter' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3772' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 14425053 - Built by Drees Custom Homes - Ready Now! ~ The Brookdale\'s open layout is in a word - stunning. The family room, kitchen and dining room combine clean modern lines and walls of windows for a bright and welcoming space. The family room\'s sloped ceiling and two-story opening create a voluminous feel. The kitchen island, walk-in pantry and ample cabinets are a chef\'s dream. With four bedrooms, study and gameroom, plus an outdoor living area, there is no lack of space in this gorgeous home.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Drees Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S582905 - THE HIGHLANDS 05, BLOCK 3, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8446' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1420' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'ROBERT CRIPPEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Highlands' ,`TaxAmount` = '' ,`TaxRate` = '3.42' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217924' WHERE `Matrix_Unique_ID` = '205790937' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T08:18:07.550' ,`MLSNumber` = '84922567' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.270203' ,`Longitude` = '-95.475957' ,`PhotoCount` = '14' ,`PostalCode` = '77304' ,`RoomCount` = '6' ,`ListPrice` = '639938.00' ,`Status` = 'Active' ,`StreetName` = 'Cibolo Creek' ,`StreetNumber` = '631' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2630' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 84922567 - Built by Drees Custom Homes - Ready Now! ~ The Sawyer is a multifaceted single-level layout that includes three bedrooms, a media room with wine bar, and an open living triangle. The great room and kitchen offer classic features such as a vaulted beam ceiling, fireplace, walk-in pantry and pocket office. This home has it all!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Drees Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas,Propane' ,`HOAMandatory` = '1' ,`Legal` = 'S537520 - GRAND CENTRAL PARK 20, BLOCK 4, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7906' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Central Park' ,`TaxAmount` = '' ,`TaxRate` = '3.16' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217924' WHERE `Matrix_Unique_ID` = '205793101' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T08:43:25.900' ,`MLSNumber` = '45508552' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Dequaidrian Dorough' ,`SellingOfficeName` = 'HomeSmart' ,`Latitude` = '29.701865' ,`Longitude` = '-95.706406' ,`PhotoCount` = '28' ,`PostalCode` = '77407' ,`RoomCount` = '11' ,`ListPrice` = '324990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Telford Hollow' ,`StreetNumber` = '6906' ,`StreetSuffix` = 'Trail' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The New Construction-Grant Plan by D.R.Horton is Loaded with High end, chic modern designs that will Wow you! This Dramatic open floor plan features an Walls of Windows looking out to your Patio, high ceilings, Tile Flooring throughout, Tile in all wet areas and Plush Carpeting in all bedrooms! Your Casual Dining area & Family Rm flows gracefully into the Gourmet Kitchen w/Upgraded Quartz Counters, Tile Back-splash, Large Eat-in & Working Island w/Under-mount Stainless Sink & plenty of room for extra seating if needed, Stainless Steel Appliances, Tall Cabinets & more! The Owner\'s Suite features Luxurious Bath w/Dual Sink Vanity, Huge \"Massive\" (room for 2) Shower & Walk-in Closet! HERS Energy Rated, Rinnai Tank-less Gas Water Heater, 2 USB outlets & more! Outstanding Smart Home Automation System allowing you to control your home from anywhere, Lights, Thermostat & more! Covered Patio! NO FLOODING! Amenities include: Pool, Splash Pad & more!20 minutes to The Galleria! Call us today' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeview Retreat Lot: 6/Block: 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`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` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217925' WHERE `Matrix_Unique_ID` = '206669889' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T08:19:10.413' ,`MLSNumber` = '34082619' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.128746' ,`Longitude` = '-95.312581' ,`PhotoCount` = '7' ,`PostalCode` = '77365' ,`RoomCount` = '10' ,`ListPrice` = '759543.00' ,`Status` = 'Active' ,`StreetName` = 'Breakwater Lane' ,`StreetNumber` = '22021' ,`StreetSuffix` = '' ,`City` = 'Porter' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3770' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 34082619 - Built by Drees Custom Homes - Ready Now! ~ The Brookdale\'s open layout is in a word - stunning. The family room, kitchen and dining room combine clean modern lines and walls of windows for a bright and welcoming space. The family room\'s sloped ceiling and two-story opening create a voluminous feel. The kitchen island, walk-in pantry and ample cabinets are a chef\'s dream. With five bedrooms, study and gameroom. There is no lack of space in this gorgeous home.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Drees Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5 / Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8125' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1420' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'ROBERT CRIPPEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Highlands 65' ,`TaxAmount` = '' ,`TaxRate` = '3.42' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217925' WHERE `Matrix_Unique_ID` = '207651154' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T08:27:25.857' ,`MLSNumber` = '96206139' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.162147' ,`Longitude` = '-95.589803' ,`PhotoCount` = '28' ,`PostalCode` = '77354' ,`RoomCount` = '6' ,`ListPrice` = '399990.00' ,`Status` = 'Active' ,`StreetName` = 'Flintlock' ,`StreetNumber` = '26979' ,`StreetSuffix` = 'Trail' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1944' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 96206139 - Built by Highland Homes - Ready Now! ~ Clean lines, neutral interior makes this one story home easy to personalize. Primary bath and bathroom #3 have extra large shower in lieu of a tub. All bathrooms have framed mirrors. Primary Bedroom bay window and Extended Outdoor living area sets the tone for many relaxing days to enjoy this open concept home with 11’ ceilings. Fully sod yard with front and back sprinklers and fully fenced backyard. This home is on the end of a cul-de-sac and backs to green space, no shared fence in the back! House is prewired/pre-plumb up to 24Kw for a generator. Energy saving features and Smart Home Technology makes this an efficient and comfortable home.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6639' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'NorthGrove' ,`TaxAmount` = '' ,`TaxRate` = '3.21' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217925' WHERE `Matrix_Unique_ID` = '207996873' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T07:21:33.087' ,`MLSNumber` = '72663068' ,`ListAgentFullName` = 'Marcela Martinez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.036034' ,`Longitude` = '-94.876339' ,`PhotoCount` = '46' ,`PostalCode` = '77535' ,`RoomCount` = '6' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Ella' ,`StreetNumber` = '122' ,`StreetSuffix` = 'Street' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1786' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME TO FORDLAND ESTATES!! GORGEOUS ONE STORY HOME, BUILT IN 2019. LARGE CUL DE SAC!!!4 BEDROOMS , 2 FULL BATH, 2 CAR GARAGE AND A HUGE PATIO WAITING FOR ALL YOUR FAMILY TO ENJOY IT. OPEN FLOOR PLAN, PRIMARY BEDROOM WITH WALKIN CLOSET AND VERY SPACIOUS LAUNDRY ROOM WITH EXTRA SHELVES. COVERED PATIO AND HIGH-EFFICIENCY HVAC. NEVER FLOODED!!!\r\nDONT WAIT ANY LONGER!!! MAKE YOUR APPOINTMENT TODAY! \r\nWELCOME HOME!!! Biggest lot For Sale in Ella Street! Huge fenced PATIO!!' ,`Acres` = '0.3208' ,`Area` = '52' ,`BuilderName` = 'FIRST AMERICA HOMES' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'FORDLAND ESTATES, SEC 5, LOT 10, ACRES .3208' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13974' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'KIMMIE M. BROWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fordland Estates, Sec 5' ,`TaxAmount` = '5852' ,`TaxRate` = '2.4832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675217925' WHERE `Matrix_Unique_ID` = '208554179' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T08:19:42.300' ,`MLSNumber` = '10905802' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.148794' ,`Longitude` = '-95.681577' ,`PhotoCount` = '9' ,`PostalCode` = '77362' ,`RoomCount` = '10' ,`ListPrice` = '759458.00' ,`Status` = 'Active' ,`StreetName` = 'Plantinum Stone' ,`StreetNumber` = '734' ,`StreetSuffix` = 'Lane' ,`City` = 'Pinehurst' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3663' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 10905802 - Built by Drees Custom Homes - Ready Now! ~ The Merrick is an expansive two-story home with plenty of space for a busy family. An elegant two-story foyer draws you in and leads to the open living triangle. The dining room flows seamlessly to the kitchen and voluminous family room. A quiet study with French doors creates the perfect home office. A luxurious owner\'s suite and private guest suite complete the first floor. Upstairs, your family can unwind in the versatile gameroom and cozy media room.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Drees Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 16 / Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8699' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodtrace' ,`TaxAmount` = '' ,`TaxRate` = '3.35' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217926' WHERE `Matrix_Unique_ID` = '208695979' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T08:22:35.923' ,`MLSNumber` = '62760277' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.436714' ,`Longitude` = '-95.420799' ,`PhotoCount` = '7' ,`PostalCode` = '77578' ,`RoomCount` = '8' ,`ListPrice` = '659137.00' ,`Status` = 'Active' ,`StreetName` = 'Brush Way' ,`StreetNumber` = '10102' ,`StreetSuffix` = '' ,`City` = 'Manvel' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3403' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 62760277 - Built by Drees Custom Homes - Ready Now! ~ The Brendan offers convenience and comfort! An open study and dining room lie just off the kitchen which comes with an ample serving island, custom cabinetry, and built-in home office. An inviting corner fireplace grounds and centers the family room with its vaulted ceiling and openness to the kitchen. . Two spacious bedroom suites lie on the first-floor, both with generous walk-in closets. The owner\'s suite comes with a spa-like bath including a garden tub and glass walk-in shower room. The upstairs opens into a common area leading into the media and gameroom with two comfortable bedrooms located on the other side.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Drees Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot - 8 / Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8659' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.67' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217926' WHERE `Matrix_Unique_ID` = '211433379' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T07:09:31.560' ,`MLSNumber` = '15534535' ,`ListAgentFullName` = 'Jesus Lopez' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.018606' ,`Longitude` = '-95.478548' ,`PhotoCount` = '15' ,`PostalCode` = '77068' ,`RoomCount` = '12' ,`ListPrice` = '269000.00' ,`Status` = 'Active' ,`StreetName` = 'Waycreek' ,`StreetNumber` = '16915' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3318' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Handyman/Investor Special. SOLD AS IS in Great Location, property is located near major shoppings centers. With easy access to I-45, 1960 and Beltway 8. Buyer to verify measurements of property. Perfect investment property in the rapidly growing North Houston neighborhood, only a few minutes away from downtown, Bush international airport, medical center, U of H and major shopping centers. Amazing opportunity!!!' ,`Acres` = '0.8072' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '4' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 224 BAMMEL FOREST SEC 3' ,`LotDesciption` = 'Cleared' ,`LotSize` = '35160' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PONDEROSA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bammel Forest Sec 03' ,`TaxAmount` = '7697' ,`TaxRate` = '2.0892' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217926' WHERE `Matrix_Unique_ID` = '212827336' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T07:39:12.717' ,`MLSNumber` = '88838370' ,`ListAgentFullName` = 'Christy Luong' ,`ListOfficeName` = 'Precious Realty & Mortgage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.901462' ,`Longitude` = '-95.666121' ,`PhotoCount` = '33' ,`PostalCode` = '77095' ,`RoomCount` = '9' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Innisbrook' ,`StreetNumber` = '16702' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2796' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is beautiful FORMER MODEL house located in the gated Brookside Court subdivision of Copperfield area features 4 bedrooms, 2.5 bath 2 car garage, LARGE island kitchen with upgraded granite countertop & title backsplash, large family room with corner fireplace/mantle. All bedrooms are upstairs, great master bedroom with large master bath with walk-in closet, his and her vanity tub and separate shower. There are well size secondary bedroom and along long with hug game room. This home offered soaring high ceiling, open concept, large window and tons of natural light. This home RECENTLY REMODEL in 2021. HIGH RATED Cypress Fairbanks ISD schools and conveniently located close to HWY 290. 99 Grand Parkway, Beltway 8, Dinning, Shopping, Outlet Mall and Entertaiment. Home has never flooded. A MUST SEE!!!!' ,`Acres` = '0.137' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 2 BROOKSIDE COURT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5968' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '737' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BIRKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'ARAGON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave