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-03T09:31:56.417' ,`MLSNumber` = '66760805' ,`ListAgentFullName` = 'Mark Maniha' ,`ListOfficeName` = 'Mark Maniha Real Estate' ,`SellingAgentFullName` = 'Mark Maniha' ,`SellingOfficeName` = 'Mark Maniha Real Estate Experts' ,`Latitude` = '29.823073' ,`Longitude` = '-95.415758' ,`PhotoCount` = '28' ,`PostalCode` = '77018' ,`RoomCount` = '7' ,`ListPrice` = '625000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Fisher' ,`StreetNumber` = '818' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2535' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Modern Farmhouse, walking distance to Garden Oaks Elementary, with custom trim work, Stainless appliances, hardwoods and custom finishes selected by Christine Heartsill Design, New Oak Homes has created a breath-taking and Elegant 3 story home with the feel of a true custom. Private Driveway, Private Back Yard, and Full size 2 car Garage. Our homes include a MASSIVE Primary Suite, His and Her closets, large soaking tub and separate shower. First floor full guest suite. Oversized secondary bedrooms with walk-in closets and private baths. A beautiful open floor plan perfect for hosting family and friends, solid hardwood floors. Upgraded features include, Foam Insulation, Radiant Barrier, Tankless hotwater heaters, 6\" exterior walls (more insulation and strength), Solid Wood Cabinetry, Chef Kitchen with custom island, Fridge included, designer plumbing fixtures, lovely Balcony. Mudroom entry! Laundry room up. Alarm system and wired for security cameras. Smart Home Ready!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'NEW OAK HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'BRINKMAN ESTATES LOT 2 BLK 1' ,`LotDesciption` = 'Patio Lot,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARDEN OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Craftsman,Traditional' ,`Subdivision` = 'GARDEN OAKS' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101014' WHERE `Matrix_Unique_ID` = '207349969' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T10:52:01.097' ,`MLSNumber` = '6687299' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Mariana Ioneva' ,`SellingOfficeName` = 'Texas United Realty' ,`Latitude` = '29.852738' ,`Longitude` = '-95.742516' ,`PhotoCount` = '7' ,`PostalCode` = '77449' ,`RoomCount` = '3' ,`ListPrice` = '273140.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Bay Meadows Lane' ,`StreetNumber` = '5210' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1415' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FANTASTIC NEW D. R. HORTON BUILT 1 STORY! Desirable Open Concept Interior Layout! Split Plan Design Affords Maximum Privacy! Impressive Foyer Leads to Gourmet Island Kitchen with Corner Pantry, Granite Counters, & Stainless Appliances PLUS Spacious Breakfast Niche & Large Living Area! Great Primary Suite - Adjoining Bath with Huge Walk-In Closet + Oversized Shower! Large Secondary Bedrooms - Both with Walk-In Closets! Indoor Utility Room with Direct Access from Garage! Covered Patio Enhances Backyard Setting! MUST SEE!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 1 JASMINE HEIGHTS SEC 24' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5999' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GOLBOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jasmine Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101014' WHERE `Matrix_Unique_ID` = '208910839' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T10:27:31.773' ,`MLSNumber` = '61541464' ,`ListAgentFullName` = 'Ricardo Gonzalez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.128079' ,`Longitude` = '-95.286710' ,`PhotoCount` = '26' ,`PostalCode` = '77365' ,`RoomCount` = '4' ,`ListPrice` = '892000.00' ,`Status` = 'Active' ,`StreetName` = 'Sonora' ,`StreetNumber` = '22713' ,`StreetSuffix` = 'Drive' ,`City` = 'Porter' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4248' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Mi casa, su casa! Imagine being greeted, every day, by this tastefully appointed yet opulent porte cochere. This polished and sophisticated home is truly made for both entertaining and everyday living, with plenty of space and custom design elements. Enjoy an open floor plan, high tray ceilings and a chef grade kitchen with stainless steel appliances, plenty of cabinets and a roomy pantry. A secret second floor movie room is perfect for those “Netflix & Chill” nights. The heart of this home, the kitchen- with adjoining dining and family rooms- makes it ideal for gatherings. Walk outside to your backyard oasis paradise with stretched patio and captivation relaxation ambiance. This property Is immaculate, well-cared for, and ready for new owner. Welcome Home!' ,`Acres` = '1' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S834905 - RIVERWALK 05, BLOCK 2, LOT 9, A0438 ROBINSON THOMA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '43500' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'SORTERS MILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverwalk 05' ,`TaxAmount` = '12268' ,`TaxRate` = '2.1331' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101014' WHERE `Matrix_Unique_ID` = '209090170' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T09:18:53.273' ,`MLSNumber` = '10821503' ,`ListAgentFullName` = 'Joe Forkner' ,`ListOfficeName` = 'Anne Willis Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.524334' ,`Longitude` = '-94.486203' ,`PhotoCount` = '14' ,`PostalCode` = '77617' ,`RoomCount` = '3' ,`ListPrice` = '489900.00' ,`Status` = 'Active' ,`StreetName` = 'Faggard Slip Road' ,`StreetNumber` = '1279' ,`StreetSuffix` = '' ,`City` = 'Gilchrist' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.3099' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Gilchrist' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 64 E FRANKS SUR LOTS 73 THRU 78 BLK 1 FAGGARD SLIP UNRE' ,`LotDesciption` = 'Cleared,Water View,Waterfront' ,`LotSize` = '13500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '25 - High Island' ,`SchoolElementary` = 'HIGH ISLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HIGH ISLAND HIGH SCHOOL' ,`SchoolMiddle` = 'HIGH ISLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Faggard Slip Ext' ,`TaxAmount` = '2097' ,`TaxRate` = '1.5543' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101014' WHERE `Matrix_Unique_ID` = '210056294' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T09:09:14.450' ,`MLSNumber` = '7292009' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = 'Thinh Dao' ,`SellingOfficeName` = 'Consortium Brokerage LLCSte. 100-217' ,`Latitude` = '29.828761' ,`Longitude` = '-95.554677' ,`PhotoCount` = '19' ,`PostalCode` = '77043' ,`RoomCount` = '11' ,`ListPrice` = '474995.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Centre Forest' ,`StreetNumber` = '10629' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '2257' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Venice II plan features 2 bedrooms, 3 full baths & half bath. Flexible downstairs activity room with French doors, walk-in closet and shower only bath is perfect for an office space or guest room. The cozy valet located on first floor is great for organization. The gourmet kitchen has maple cabinets with under cabinet lighting, quartz countertops, gas cooktop & stainless steel appliances that opens into the dining and great room with linear fireplace. Balcony is accessible from the great room. Soaker tub & separate shower, dual vanity sinks and walk-in closet in owner\'s luxury bath. The 3rd floor also has 1 secondary bedroom with en-suite bath and a loft space that can be used as you wish. Community walking trail make it easy to stay active. Great location, near Beltway 8 & I-10 and within minutes of CITYCENTRE, Memorial City Mall, Energy Corridor, parks & restaurants. Must see; schedule a tour today! Offered by: K. Hovnanian Houston III, L.L.C.' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '23/1/1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2234' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'TERRACE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING OAKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Centrepark Terrace' ,`TaxAmount` = '' ,`TaxRate` = '2.473' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101014' WHERE `Matrix_Unique_ID` = '210912848' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T10:16:24.753' ,`MLSNumber` = '72923127' ,`ListAgentFullName` = 'Clarissa Woodward' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.373208' ,`Longitude` = '-95.030143' ,`PhotoCount` = '24' ,`PostalCode` = '77568' ,`RoomCount` = '9' ,`ListPrice` = '268000.00' ,`Status` = 'Active' ,`StreetName` = 'Driftwood' ,`StreetNumber` = '834' ,`StreetSuffix` = 'Lane' ,`City` = 'La Marque' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2156' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious 4 Bedroom 2.5 Bathroom home located in Saltgrass Crossing with a huge back yard and no back neighbors! The first floor offers a great open concept living area, the primary bedroom has a bay window for a spacious seating area, the en-suite has a spacious double sink vanity, soaking tub and separate shower, and all secondary bedrooms are upstairs. There\'s no shortage of storage, everyone loves the 9ft deep walk-in pantry, huge primary walk-in closet, and 2 of the 3 secondary bedrooms also feature walk-in closets. Includes 1 hardwired Security Camera in the front and 1 in the back! \r\nSaltgrass Crossing is conveniently located within minutes of I45, Hwy 6, and Galveston Island.' ,`Acres` = '0.206' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SALTGRASS CROSSING SEC 1 (2007) ABST 2, BLOCK 1, LOT 34, ACR' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8985' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Saltgrass Crossing' ,`TaxAmount` = '6604' ,`TaxRate` = '3.2275' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101015' WHERE `Matrix_Unique_ID` = '212066175' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T10:48:48.550' ,`MLSNumber` = '2542325' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Tram Ton' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.852738' ,`Longitude` = '-95.742516' ,`PhotoCount` = '7' ,`PostalCode` = '77449' ,`RoomCount` = '3' ,`ListPrice` = '277490.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Bay Meadows Drive' ,`StreetNumber` = '5207' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1501' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AMAZING NEW DR Horton One Story Property!! Fantastic kitchen featuring beautiful cabinetry and modern finishes! Also open to the breakfast and family rooms! Spacious primary bedroom suite with a great closet and oversized shower!! Hard surface flooring in all living areas. Easy access from the garage to a generous sized utility room. GREAT LOCATION! Hurry and call today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12 - Block 2 - Section 24' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5979' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GOLBOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jasmine Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101015' WHERE `Matrix_Unique_ID` = '212070150' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T10:50:01.570' ,`MLSNumber` = '51686166' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Erick Mariscal' ,`SellingOfficeName` = 'City Insight Houston' ,`Latitude` = '29.852738' ,`Longitude` = '-95.742516' ,`PhotoCount` = '7' ,`PostalCode` = '77449' ,`RoomCount` = '3' ,`ListPrice` = '282490.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Bonita Vista Drive' ,`StreetNumber` = '21515' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1575' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CHARMING NEW DR Horton One Story Property!! Fantastic kitchen featuring beautiful cabinetry and modern finishes! Also open to the breakfast and family rooms! Spacious primary bedroom suite with a great closet and oversized shower!! Hard surface flooring in all living areas. Easy access from the garage to a generous sized utility room. GREAT LOCATION! Hurry and call today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 18 Block 1 Section 25' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GOLBOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jasmine Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101015' WHERE `Matrix_Unique_ID` = '212098687' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T10:19:05.490' ,`MLSNumber` = '5794264' ,`ListAgentFullName` = 'Paulina Elizalde' ,`ListOfficeName` = 'RE/MAX Real Estate Assoc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.785254' ,`Longitude` = '-95.161950' ,`PhotoCount` = '44' ,`PostalCode` = '77015' ,`RoomCount` = '6' ,`ListPrice` = '228000.00' ,`Status` = 'Active' ,`StreetName` = 'Texarkana' ,`StreetNumber` = '14630' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1768' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Location close to Channelview!! . Beautiful home with lots of room for storage, additional home studio, recent driveway built, electric fence all around the home. Quiet neighborhood close to Schools and shopping.\r\nThis house has never been flooded. Schedule your appointment now.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '2017 CMH 26X68 HUD# NTA1787960 SERIAL# BL2002299TXA LEASE LA' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'SAM HOUSTON ELEMENTARY SCHOOL (GALENA PARK)' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH SHORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Lockbox Right Side' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Houston Manor' ,`TaxAmount` = '1655' ,`TaxRate` = '2.5853' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675101015' WHERE `Matrix_Unique_ID` = '212392313' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T10:47:44.437' ,`MLSNumber` = '56112185' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Veronica Mendoza' ,`SellingOfficeName` = 'Veronica Mendoza Realty, LLC.' ,`Latitude` = '29.830982' ,`Longitude` = '-95.731048' ,`PhotoCount` = '7' ,`PostalCode` = '77449' ,`RoomCount` = '4' ,`ListPrice` = '282490.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Bay Meadows' ,`StreetNumber` = '5142' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1575' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INCREDIBLE NEW D. R. HORTON BUILT 1 STORY! Great Island Kitchen with Lots of Cabinetry & Corner Walk-In Pantry - Open to Breakfast Area & Family Room! Large Primary Bedroom with Spacious Walk-In Closet & Fantastic Bath with Large Shower! Desirable Split Plan Layout! Convenient Indoor Utility Room! Hard Surface Flooring in Living Area! Covered Patio Overlooks Backyard! MUST SEE! Estimated Completion - October 2022.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 1 JASMINE HEIGHTS SEC 25' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6310' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'FRANZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jasmine Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewe