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-07T14:28:25.953' ,`MLSNumber` = '11420969' ,`ListAgentFullName` = 'Samantha Medve' ,`ListOfficeName` = 'Schultz Texas Properties' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '30.128472' ,`Longitude` = '-96.577847' ,`PhotoCount` = '38' ,`PostalCode` = '77835' ,`RoomCount` = '8' ,`ListPrice` = '765000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Fm 2502' ,`StreetNumber` = '3388' ,`StreetSuffix` = 'Road' ,`City` = 'Burton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3314' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful farmhouse, built in 2017, has a wraparound porch with views from every side of it! The kitchen is what a chef\'s dreams are made of. It has double ovens, gas range, a large island with storage in it, solid wood cabinets, herringbone tiled backsplash and is open to the other living areas. There is a walk-in pantry, as well! The home has a split floor plan with two bedrooms and a full bathroom on one side while the primary bedroom and primary bath has it\'s own wing. The sitting room towards the front of the house could be converted into an office area, 4th bedroom, or have the perfect spot for a piano. This home is not lacking storage room! The attic could be built out to be game room because there is a full set of stairs going to it, as opposed to pull down stairs in a hallway. All the little details have been thought about in this home.' ,`Acres` = '4.579' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S7640 - GREENVINE ACRES S/D, LOT 4, ACRES 4.579, (PLAT 664B' ,`LotDesciption` = 'Other' ,`LotSize` = '199461' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '128 - Burton' ,`SchoolElementary` = 'BURTON ELEMENTARY SCHOOL (BURTON)' ,`SchoolHigh` = 'BURTON HIGH SCHOOL' ,`SchoolMiddle` = 'BURTON HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Greenvine Acres Sub' ,`TaxAmount` = '8644' ,`TaxRate` = '1.5327' ,`WaterSewer` = 'Well' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695570' WHERE `Matrix_Unique_ID` = '208712305' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-07T14:20:32.010' ,`MLSNumber` = '74256274' ,`ListAgentFullName` = 'Imeldia Adams' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.571544' ,`Longitude` = '-95.270951' ,`PhotoCount` = '28' ,`PostalCode` = '77581' ,`RoomCount` = '7' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Cactus Heights' ,`StreetNumber` = '3214' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2185' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful and Well Cared For Single Story, 4 Bedroom, 2185 square foot home in Pearland. Great Location for Commuting to Downtown Houston, Medical Center and UTMB Galveston. Plentiful Shopping. Easy access to Pearland Parkway, Beltway 8 and Broadway (518). Split floorplan with 2 Living Areas, Breakfast Room and Formal Dining. Large Kitchen has an Island, Gorgeous Granite, Travertine Backsplashes, 42\" Tall Cabinetry, Recessed Lighting, Stainless Steel Appliances and Extended Breakfast Bar. 10 Foot Ceilings make this home open and comfortable. Storage Shed in Backyard. Neighborhood Parks, Lakes, Pool and Walking Path.' ,`Acres` = '0.1708' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'THE LAKES AT HIGHLAND GLEN SEC 13 (A0076)(PEARLAND) BLK 1 LO' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7440' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '725' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'BARBARA COCKRELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH WEST' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Lakes At Highland Glen Sec' ,`TaxAmount` = '7885' ,`TaxRate` = '2.9952' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663695570' WHERE `Matrix_Unique_ID` = '210684089' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-07T14:00:31.237' ,`MLSNumber` = '68796978' ,`ListAgentFullName` = 'Rachel Parsons' ,`ListOfficeName` = 'Keller Williams Realty Austin' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.082755' ,`Longitude` = '-97.287889' ,`PhotoCount` = '14' ,`PostalCode` = '77954' ,`RoomCount` = '3' ,`ListPrice` = '149000.00' ,`Status` = 'Active' ,`StreetName` = 'First C' ,`StreetNumber` = '602' ,`StreetSuffix` = '' ,`City` = 'Cuero' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1312' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3/2 on a corner lot. Looking for some inspiration and creativity. The home was previously used and rental property. Sellers are very motivated. If interested, please bring a cash offer for a quick sale' ,`Acres` = '0.1722' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PT 15 NORTH FIELDS S100OF W75OF BLK 15 CUERO' ,`LotDesciption` = 'Corner' ,`LotSize` = '7501' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '456 - Cuero' ,`SchoolElementary` = 'CISD DRAW' ,`SchoolHigh` = 'CUERO HIGH SCHOOL' ,`SchoolMiddle` = 'CUERO JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'None' ,`TaxAmount` = '2015' ,`TaxRate` = '2.8683' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695570' WHERE `Matrix_Unique_ID` = '210871142' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-07T14:33:58.270' ,`MLSNumber` = '59446665' ,`ListAgentFullName` = 'Thaya St. Julien' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.565028' ,`Longitude` = '-95.359931' ,`PhotoCount` = '18' ,`PostalCode` = '77584' ,`RoomCount` = '10' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Sunlight' ,`StreetNumber` = '9005' ,`StreetSuffix` = 'Court' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2094' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful four bedroom home in Sunrise Lakes. Kitchen opens to breakfast area and large family room. Spacious master bedroom has private bathroom with whirlpool tub, separate shower and double sinks. Very well maintained home with versatile floorplan. Easy commute to Downtown, Medical Center, Galveston & NASA...close to Belway 8 & 288! Great access to shopping and schools. A wonderful community area to swim, play tennis or just enjoy watching the kids play on the Jungle Gyms.' ,`Acres` = '0.1795' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUNRISE LAKES SEC 6 (A0721 & A0506) (PEARLAND) BLK 2 LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7819' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'LAWHON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH WEST' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunrise Lakes' ,`TaxAmount` = '6765' ,`TaxRate` = '2.8851' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663695570' WHERE `Matrix_Unique_ID` = '210943846' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-07T15:06:20.537' ,`MLSNumber` = '52022356' ,`ListAgentFullName` = 'Blanca Resendez' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.573203' ,`Longitude` = '-95.250877' ,`PhotoCount` = '19' ,`PostalCode` = '77089' ,`RoomCount` = '8' ,`ListPrice` = '455000.00' ,`Status` = 'Active' ,`StreetName` = 'Matilda Gardens' ,`StreetNumber` = '1969' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2759' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Meritage Home Pearl plan with upgrades including extended covered patio, bay window in primary bedroom, fireplace in the family room. Additional upgrades include beautiful mud room wood bench shelf by garage door entrance, crown molding and chair railing throughout the first floor, custom built in bookshelf cabinet in den, primary bedroom closet updated with custom wood cabinets with self closing drawers.' ,`Acres` = '0.1578' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 5 RIVERSTONE RANCH AT CLEAR CREEK SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'SOUTH BELT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'THOMPSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverstone Ranch/Clear Crk Sec' ,`TaxAmount` = '9909' ,`TaxRate` = '3.6869' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695570' WHERE `Matrix_Unique_ID` = '211149364' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-07T15:36:12.190' ,`MLSNumber` = '98076492' ,`ListAgentFullName` = 'Jesus Loera' ,`ListOfficeName` = 'Sierra Vista Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.733881' ,`Longitude` = '-95.350540' ,`PhotoCount` = '14' ,`PostalCode` = '77004' ,`RoomCount` = '7' ,`ListPrice` = '459000.00' ,`Status` = 'Active' ,`StreetName` = 'McGowen' ,`StreetNumber` = '3322' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2005' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***UNDER CONSTRUCTION, EXPECTED COMPLETION DATE 10/31/22 *** Another stunning new contemporary home developed by premier builder, Cityplace Builders. Just minutes away from Midtown, Medical Center, Downtown, University of Houston, and many more Houston hot spots. This is the ultimate inner city living. Home sits on an oversized lot that includes plenty of greenspace in the backyard. Home also features beautiful 100% hardwood 3/4-inch floors throughout home. NO laminate, NO vinyl, or any other wood substitute for flooring. They are the real deal! Other features include 10-foot ceilings, quartz countertops, high end faucets and fixtures, high end appliances, and an oversized master closet and shower. All bedrooms upstairs including a great size family room. Easy access to 59, 288, and 45. NO HOA! Two homes available – one with white cabinet option the other with dark grey cabinet option. Come see which option suits you best. Your brand new home awaits you!' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'Cityplace Builders' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 2, Block 1, OF CITYPLACE ON MCGOWEN' ,`LotDesciption` = 'Cleared' ,`LotSize` = '2500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cityplace on McGowen' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695571' WHERE `Matrix_Unique_ID` = '211151995' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-07T15:35:32.193' ,`MLSNumber` = '81716097' ,`ListAgentFullName` = 'Jesus Loera' ,`ListOfficeName` = 'Sierra Vista Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.733881' ,`Longitude` = '-95.350540' ,`PhotoCount` = '14' ,`PostalCode` = '77004' ,`RoomCount` = '7' ,`ListPrice` = '459000.00' ,`Status` = 'Active' ,`StreetName` = 'McGowen' ,`StreetNumber` = '3324' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2005' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***UNDER CONSTRUCTION, EXPECTED COMPLETION DATE 10/31/22 *** Another stunning new contemporary home developed by premier builder, Cityplace Builders. Just minutes away from Midtown, Medical Center, Downtown, University of Houston, and many more Houston hot spots. This is the ultimate inner city living. Home sits on an oversized lot that includes plenty of greenspace in the backyard. Home also features beautiful 100% hardwood 3/4-inch floors throughout home. NO laminate, NO vinyl, or any other wood substitute for flooring. They are the real deal! Other features include 10-foot ceilings, quartz countertops, high end faucets and fixtures, high end appliances, and an oversized master closet and shower. All bedrooms upstairs including a great size family room. Easy access to 59, 288, and 45. NO HOA! Two homes available – one with white cabinet option the other with dark grey cabinet option. Come see which option suits you best. Your brand new home awaits you!' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'Cityplace Builders' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 1, Block 1, OF CITYPLACE ON MCGOWEN' ,`LotDesciption` = 'Cleared' ,`LotSize` = '2500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cityplace on McGowen' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695571' WHERE `Matrix_Unique_ID` = '211152696' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-07T15:47:39.333' ,`MLSNumber` = '78433225' ,`ListAgentFullName` = 'Nina Wohlwend' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = 'Jessica Aguirre' ,`SellingOfficeName` = 'Keller Williams Metropolitan' ,`Latitude` = '29.779614' ,`Longitude` = '-95.415453' ,`PhotoCount` = '39' ,`PostalCode` = '77007' ,`RoomCount` = '8' ,`ListPrice` = '603000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Darling' ,`StreetNumber` = '5233' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2469' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning new construction within walking distance to Hike and Bike Trail and Heights MKT! Located on a beautiful curb lined street, this home was built to one\'s liking with its impeccable first floor living, custom features, and private driveway. The great room has an open floor plan with an abundance of natural light from the large picturesque windows. Included in the dining area is a dry bar with custom cabinets, wine fridge, and shelving. The kitchen features an island with quartz countertops that can be used as a breakfast bar, also stainless steel GE appliances with custom vent hood. The second floor has a spacious primary suite with vaulted ceilings. Primary bath has bump out cabinets, free standing tub, large walk in shower, and skylights. Primary closet has custom, built in shelving with separate dressing area and vanity. Included on the second floor is a flex space that can be used as a study or media room. Ask about pre-completion builder special!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Century Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cottage Grove' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 766 BLK 0 Cottage Grove' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3628' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cottage Grove' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695571' WHERE `Matrix_Unique_ID` = '211152901' --> Updated record success