Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T20:25:05.853' ,`MLSNumber` = '71356718' ,`ListAgentFullName` = 'Charle Thomas' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.427336' ,`Longitude` = '-95.439722' ,`PhotoCount` = '40' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '381499.00' ,`Status` = 'Active' ,`StreetName` = 'Mendel Terrace' ,`StreetNumber` = '10822' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1931' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 1-story, 3 bedroom and 2 bathroom single-family new house floor plan offers an abundance of inviting design features. Some of these include a study, a formal dining room, a spacious family room, a master bedroom with a large walk-in closet in the owners retreat, an oversized kitchen with stainless steel appliances that opens to the breakfast area, a walk-in utility room, rear covered patio and fully sodded backyard.' ,`Acres` = '0.1469' ,`Area` = '5' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA SEC 4B (A0288 HT&BRR) BLK 1 LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6399' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '936' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista Sec 4b' ,`TaxAmount` = '1440' ,`TaxRate` = '3.6007' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704941' WHERE `Matrix_Unique_ID` = '208959559' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T21:06:54.337' ,`MLSNumber` = '21688115' ,`ListAgentFullName` = 'Evy Elston' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.956251' ,`Longitude` = '-96.275213' ,`PhotoCount` = '34' ,`PostalCode` = '77418' ,`RoomCount` = '10' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Machemehl' ,`StreetNumber` = '101' ,`StreetSuffix` = 'Drive' ,`City` = 'Bellville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2227' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This wonderful 4 bedroom 2 bath home is located in a great neighborhood in beautiful Bellville! Situated on a double sized lot, this 4 bedroom/2 bathroom home has been nicely maintained & updated by the current owners. Renovated kitchen with granite counter tops, large center island and custom painted cabinets. The garage was converted into a spacious flex area that is currently being used as a game room, but has endless possibilities. Includes a spacious backyard completely fenced with a storage building for lawn equipment and tools. Large covered porch, covered carport too. Very close to cute shops and great restaurants. Simple access to I10 for your travels to Houston, Katy or Austin. Small town living with easy access to anywhere you need to be. Roof is less than 5 years old, no HOA and low tax rate. Make this gem your new home!' ,`Acres` = '0.5362' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'MEADOWS SUB SECT I BLOCK 1 LOT 1, 2 (ALL OF 1 & NORTH 1/2 OF' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '23357' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '136 - Bellville' ,`SchoolElementary` = 'WEST END ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'BELLVILLE JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadows Sub' ,`TaxAmount` = '4651' ,`TaxRate` = '2.1116' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704941' WHERE `Matrix_Unique_ID` = '210021334' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T20:27:02.087' ,`MLSNumber` = '89977629' ,`ListAgentFullName` = 'Mary Cox' ,`ListOfficeName` = 'Vip Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.448350' ,`Longitude` = '-95.565674' ,`PhotoCount` = '21' ,`PostalCode` = '77318' ,`RoomCount` = '5' ,`ListPrice` = '114900.00' ,`Status` = 'Active' ,`StreetName` = 'Lee Shore' ,`StreetNumber` = '14423' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come live in the quiet Shadow Bay lake side community where you can enjoy the amenities of using the private boat ramp as well as a children\'s play area. This 3 br/2 bath property has a nice covered front porch area to relax and unwind. Property has a fenced yard.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW BAY 01, BLOCK 4, LOT 15, SERIAL # 12534707, TITLE # 0' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '264' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'C.C. HARDY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Shadow Bay 01' ,`TaxAmount` = '242' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663704941' WHERE `Matrix_Unique_ID` = '210231641' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T21:49:54.763' ,`MLSNumber` = '65483154' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.854374' ,`Longitude` = '-95.190525' ,`PhotoCount` = '50' ,`PostalCode` = '77044' ,`RoomCount` = '7' ,`ListPrice` = '291330.00' ,`Status` = 'Active' ,`StreetName` = 'Vuitton' ,`StreetNumber` = '13214' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1816' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COMPLETION JANUARY/FEBRUARY 2023 To be built Colina Home 1816 Plan. View Homesite. TIDWELL LAKES BRAND NEW one story 4/3/2 energy efficient home. The interior selections to include 42\" Legacy Pewter Gray upgrade cabinets, huge kitchen island with New Caledonia granite 3x6 Desert Gray subway tile backsplash. Luxury vinyl planking in all we areas, entry and living room, stainless steel appliances to include our premium 5 burner range, 9\" farm sink, 2\" blinds, garden tub plus separate showing, Pex Plumbing, Lennox 16 seer A/C. Taexx Pest Control and an oversized covered back patio this is 22X8. All this included for you. The 1816 one story floor plan is unique because it has three full bathrooms including an en-suite. Don\'t miss out. 365 day rate lock or $0 down no PMI. PHOTOS ARE REPRESENTATIVE.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9 Block 5 Section 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON LAKEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tidwell Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704941' WHERE `Matrix_Unique_ID` = '210276054' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T20:48:42.993' ,`MLSNumber` = '44727417' ,`ListAgentFullName` = 'Samantha Le' ,`ListOfficeName` = 'United Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.891311' ,`Longitude` = '-95.540938' ,`PhotoCount` = '15' ,`PostalCode` = '77040' ,`RoomCount` = '0' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Spring Wind' ,`StreetNumber` = '8211' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2046' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful and well-maintained free-standing home in Mauna Loa subdivision. 3 bedrooms 2.5 bathrooms with a nice size gameroom. First floor living area is spacious and open with formal dining, kitchen/breakfast combo. Second floor holds a generous size primary bedroom with two closets. A plentiful space gameroom & utility room for convenience. Two nice size secondary bedrooms. Home is clean and ready-to move in.' ,`Acres` = '0.0725' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 MAUNA LOA GARDENS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3157' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '345' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'GLEASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'COOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mauna Loa Gardens Sec 2' ,`TaxAmount` = '4654' ,`TaxRate` = '2.541' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704941' WHERE `Matrix_Unique_ID` = '210333689' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T21:21:05.167' ,`MLSNumber` = '70936310' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.877804' ,`Longitude` = '-95.785662' ,`PhotoCount` = '27' ,`PostalCode` = '77493' ,`RoomCount` = '11' ,`ListPrice` = '794773.00' ,`Status` = 'Active' ,`StreetName` = 'Longspur Hollow' ,`StreetNumber` = '7314' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3818' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS#70936310 REPRESENTATIVE PHOTOS ADDED! Built by Taylor Morrison, December Completion - The 5811! This exquisite two-story home features a grand foyer with soaring ceilings and a lovely guest suite ideally located at the front of the home with a full bathroom. Down the foyer, stop by the media room before entering the impressive family room. The kitchen and dining area are alongside the family room where the covered patio can be easily accessed for more relaxation and fun! The owner\'s suite at the back of the home provides a peaceful haven. Upstairs has a great game room with three bedrooms, three full bathrooms, and a charming half-bath. This home is next to a beautiful lake and is walking distance to the new recreation center and pool. Structural options added to 7314 Longspur Hollow include: bay window at owner\'s suite, 5 bed/5 bath and half-bath, extended outdoor living, pendant lights in kitchen, granite in kitchen, and wood flooring.' ,`Acres` = '0.21' ,`Area` = '25' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 21, Block 2, of Elyson Section 37' ,`LotDesciption` = 'Other,Subdivision Lot,Water View' ,`LotSize` = '9175' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2575' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Elyson 60\'s' ,`TaxAmount` = '' ,`TaxRate` = '3.49' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704941' WHERE `Matrix_Unique_ID` = '210417370' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T20:50:21.707' ,`MLSNumber` = '7712959' ,`ListAgentFullName` = 'Praful Shah' ,`ListOfficeName` = 'Praful Shah' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.595565' ,`Longitude` = '-95.655963' ,`PhotoCount` = '28' ,`PostalCode` = '77479' ,`RoomCount` = '9' ,`ListPrice` = '619900.00' ,`Status` = 'Active' ,`StreetName` = 'Spindle Pine' ,`StreetNumber` = '6930' ,`StreetSuffix` = 'Way' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3333' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Excellent Schools - Zone to Clements High School, one of the best schools in Texas. Telfair located in the heart of Sugar Land. Spacious 4 bedrooms, 3.5 Baths, 3 Car Tandem Garage, Cul-de-sac, Stone elevation, white mortar, covered patio, Kitchen with SS appliances, granite countertops, undermount sink, tile backsplash, hardwood flooring, new carpet and paint - April 2022, Dryer and Refrigerator included - As Is. Upgraded shower in upstairs bathroom. New AC Unit -2018, New AC Coil- 2017, New LG Microwave - 2018.\r\nTrendmaker home with lots of Upgrades, Plan F521-G - 3149 sq. ft. plus extra room added in the attic - 184 sq. ft. = 3,333 sq. ft. per Builder' ,`Acres` = '0.4071' ,`Area` = '29' ,`BuilderName` = 'Trendmaker' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TELFAIR SEC 13, BLOCK 1, LOT 8' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '17732' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'CORNERSTONE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'SARTARTIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Telfair Sec 13' ,`TaxAmount` = '13787' ,`TaxRate` = '2.9144' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663704942' WHERE `Matrix_Unique_ID` = '210548859' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T21:12:30.787' ,`MLSNumber` = '37273046' ,`ListAgentFullName` = 'Jo Ann Hughes' ,`ListOfficeName` = 'RE/MAX On The Water - Bolivar' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.132848' ,`Longitude` = '-94.387211' ,`PhotoCount` = '36' ,`PostalCode` = '77659' ,`RoomCount` = '5' ,`ListPrice` = '170000.00' ,`Status` = 'Active' ,`StreetName` = 'Ryan' ,`StreetNumber` = '900' ,`StreetSuffix` = 'Road' ,`City` = 'Sour Lake' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1230' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute home sits on 1/2 an acre in Hardin Jefferson ISD. 2/1 with bonus room. Bonus room could be office, hobby room or 3rd bedroom.Covered deck in backyard is great for entertaining. Large back yard is fenced in for pets! The covered front porch with extended deck isgreat for sitting outside with your favorite beverage.' ,`Acres` = '0.52' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'AB 49 H STEPHENSON P# 49-48 I# 2013-37690 05/17/2013' ,`LotDesciption` = 'Cleared' ,`LotSize` = '22651' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '163 - Hardin-Jefferson' ,`SchoolElementary` = 'SOUR LAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN-JEFFERSON HIGH SCHOOL' ,`SchoolMiddle` = 'HENDERSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'H Stephenson' ,`TaxAmount` = '1648' ,`TaxRate` = '2.2858' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704942' WHERE `Matrix_Unique_ID` = '210956541' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T20:51:17.927' ,`MLSNumber` = '77275407' ,`ListAgentFullName` = 'Grant Threatt' ,`ListOfficeName` = 'Beebe Real Estate, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.692320' ,`Longitude` = '-95.292185' ,`PhotoCount` = '28' ,`PostalCode` = '77087' ,`RoomCount` = '3' ,`ListPrice` = '179999.00' ,`Status` = 'Active' ,`StreetName` = 'Thurow' ,`StreetNumber` = '7535' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1444' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Original owner home offered for sale in established, Greenway subdivision. Close to city districts, airports, hospitals, shopping, and more. Situated just outside the 610 Loop, this home is minutes from the Gulfgate Center and the Astrodome. The property has tremendous potential for a new owner and includes a 12x20 workshop with power, water, and sewer. Property boasts a beautiful lawn, thoughtful paths, deck, and landscaping. It is ready for your touches to make this gem uniquely yours. All dimensions should be verified.' ,`Acres` = '0.1599' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Probate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Wall Heater' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 14 GREENWAY SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6966' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GOLFCREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HARTMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,No Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Greenway' ,`TaxAmount` = '2371' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704942' WHERE `Matrix_Unique_ID` = '211379686' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T21:46:07.743' ,`MLSNumber` = '3796737' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.860202' ,`Longitude` = '-95.192541' ,`PhotoCount` = '50' ,`PostalCode` = '77044' ,`RoomCount` = '6' ,`ListPrice` = '313265.00' ,`Status` = 'Active' ,`StreetName` = 'Lanrin Park' ,`StreetNumber` = '13211' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2121' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COMPLETION JANUARY/FEBRUARY 2023 Amazing 1 story 4-bedroom 3 bath 2 car garage. Colina Home features incredible open design with an oversized kitchen island-Gorgeous Kitchen w/ stunning 42\" Pewter Cabinets, Stormy Night Kitchen Granite and Upgraded Kitchen Backsplash, stainless steel range, microwave, and dishwasher, 9’ ceilings, 2” blinds throughout, large garden tub with separate shower, marble vanity, large walk-in closet, covered back patio, carpet only in bedrooms, luxury vinyl wood plank throughout. Raised panel doors, rounded sheetrock corners and archways. Texas Size BBQ with a large covered back patio. 365 day rate lock or $0 down no PMI. PHOTOS ARE REPRESENTATIVE' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Block 5 Sec 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6350' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON LAKEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tidwell Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.713438' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704942' WHERE `Matrix_Unique_ID` = '211941991' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T21:30:39.947' ,`MLSNumber` = '68187432' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.218954' ,`Longitude` = '-95.163831' ,`PhotoCount` = '19' ,`PostalCode` = '77372' ,`RoomCount` = '13' ,`ListPrice` = '297290.00' ,`Status` = 'Active' ,`StreetName` = 'Willie Mays' ,`StreetNumber` = '15340' ,`StreetSuffix` = 'Court' ,`City` = 'Splendora' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '1978' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand new beautiful 2 story 5 bedroom 3 1/2 bath and 2 car garage. Colina Home features 42\'\' cabients, quartz/granite kitchen countertops, kitchen includes recess lighting, high ceilings, laminated vinyl (wood look) flooring throughout the home, 2\" blinds throughout the home, Stainless Steel Appliances including 5 burner gas range, Large single bowl under-mount kitchen sink. Ceramic tile backsplash in kitchen & bathrooms. Masterbath features a large garden tub with separate shower, dual marble vanities, large walk-in closet. 10-year warranty on frame and foundation, 25-year warranty on roof, and 30-year warranty on Hardi Plank, and extreme energy efficiencies to reduce cost. This Home is Move in ready Nov 2022. Call to schedule a showing now' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 30 BLK 1 Sec 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9194' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PEACH CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Splendora Fields' ,`TaxAmount` = '' ,`TaxRate` = '2.62' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704942' WHERE `Matrix_Unique_ID` = '211964421' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T21:31:42.920' ,`MLSNumber` = '91756662' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.220247' ,`Longitude` = '-95.164152' ,`PhotoCount` = '19' ,`PostalCode` = '77372' ,`RoomCount` = '12' ,`ListPrice` = '310266.00' ,`Status` = 'Active' ,`StreetName` = 'Willie Mays' ,`StreetNumber` = '15307' ,`StreetSuffix` = 'Court' ,`City` = 'Splendora' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1978' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand new beautiful 2 story 5 bedroom 3 1/2 bath and 2 car garage. Colina Home features 42\'\' cabients, quartz/granite kitchen countertops, kitchen includes recess lighting, high ceilings, laminated vinyl (wood look) flooring throughout the home, 2\" blinds throughout the home, Stainless Steel Appliances including 5 burner gas range, Large single bowl under-mount kitchen sink. Ceramic tile backsplash in kitchen & bathrooms. Masterbath features a large garden tub with separate shower, dual marble vanities, large walk-in closet. 10-year warranty on frame and foundation, 25-year warranty on roof, and 30-year warranty on Hardi Plank, and extreme energy efficiencies to reduce cost. This Home is Move in ready Nov 2022. Call to schedule a showing now' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 33 BLK 3 Sec 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15316' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PEACH CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Splendora Fields' ,`TaxAmount` = '' ,`TaxRate` = '2.62' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704942' WHERE `Matrix_Unique_ID` = '211964598' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T20:52:59.247' ,`MLSNumber` = '56280750' ,`ListAgentFullName` = 'Roland Rasos' ,`ListOfficeName` = 'Keller Williams HoustonCentral' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.825561' ,`Longitude` = '-95.400043' ,`PhotoCount` = '23' ,`PostalCode` = '77018' ,`RoomCount` = '5' ,`ListPrice` = '215000.00' ,`Status` = 'Active' ,`StreetName` = 'Hyta' ,`StreetNumber` = '209' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '886' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investor\'s or DIY dream! SQUARE FOOTAGE DOES NOT INCLUDE THE FRONT BONUS ROOM ADDITION. While it does need a bit of TLC, 209 is a true diamond-in-the-rough that needs only minimal or no work to get it to livable status. With 2 bedrooms, 1 full bath, & bonus room that can be used as a study or even third bed, this cozy home can fit a number of different housing needs. This home is also in the ideal 77018 zip code with multiple properties being flipped as high as the $300k+ range. The property has a number of exit strategies and can serve as your next Short-term Airbnb, BRRRR, flip, tear down for development, or even DIY home of your dreams.' ,`Acres` = '0.1653' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'TR 11A BLK B AVANZINI SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KENNEDY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Avanzini Sec 01' ,`TaxAmount` = '3290' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704943' WHERE `Matrix_Unique_ID` = '211996317' --> Updated record success