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-22T10:11:56.317' ,`MLSNumber` = '32374298' ,`ListAgentFullName` = 'Trish Baldwin' ,`ListOfficeName` = 'Trish Baldwin Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.971805' ,`Longitude` = '-95.538223' ,`PhotoCount` = '48' ,`PostalCode` = '77069' ,`RoomCount` = '17' ,`ListPrice` = '1700000.00' ,`Status` = 'Active' ,`StreetName` = 'Pinnacle' ,`StreetNumber` = '13402' ,`StreetSuffix` = 'Place' ,`City` = 'Houston' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '6955' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 5 bd 6.5 bath 4 car garage Estate home on over an acre close to everything! Please see Home Features list for more info. Nearly 7,000 sf of wonderful w 4 bdrms dn, gourmet kitchen, study, office, formal living & dining, family rm, gameroom, media rm, gym & MUCH MORE! Pool & spa, golf green, gazebo, fish pond, waterfalls, sprinklers, mosquito system. Owners suite is downstairs with high ceiling, coffee bar w fridge & plantation shutters. Owners suite bath has his & her vanities, toilets, & large closets w pull down 3rd rod & so many custom built-ins plus jetted tub and shower that also has steam. High ceilings, tons of storage & so many built-ins. Crown molding & lovely woodwork. The views to the park-like backyard bring a sense of peace to everyday. Nothing else like this anywhere close! All measurements are approximate.' ,`Acres` = '1.0046' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 1 PINNACLE AT CHAMPIONS CENTRE' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '43760' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1890' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'YEAGER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinnacle At Champions Centre' ,`TaxAmount` = '25294' ,`TaxRate` = '2.4508' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701693' WHERE `Matrix_Unique_ID` = '196331740' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T10:13:36.603' ,`MLSNumber` = '75524347' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766045' ,`Longitude` = '-95.250155' ,`PhotoCount` = '28' ,`PostalCode` = '77029' ,`RoomCount` = '3' ,`ListPrice` = '179999.00' ,`Status` = 'Active' ,`StreetName` = 'Wiggins' ,`StreetNumber` = '10141' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '902' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is in a great area, and waiting for you to call it home! With easy access to 610 and Highway 10, you can get to whatever part of Houston you need to with ease. Home features a full interior/exterior paint job, new countertops, new sinks and new vinyl flooring in the living room, kitchen and bathroom area. This property also features new light fixtures and a new carpet. See it for yourself! Call to schedule a viewing today!' ,`Acres` = '0.1205' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 24 BLK 33A INDUSTRIAL' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'JACINTO CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GALENA PARK HIGH SCHOOL' ,`SchoolMiddle` = 'GALENA PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Industrial Add' ,`TaxAmount` = '2327' ,`TaxRate` = '3.0062' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701693' WHERE `Matrix_Unique_ID` = '200186744' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T11:29:48.577' ,`MLSNumber` = '8038021' ,`ListAgentFullName` = 'Chip Bubela' ,`ListOfficeName` = 'Bubela & Associates, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.183836' ,`Longitude` = '-96.941273' ,`PhotoCount` = '18' ,`PostalCode` = '78942' ,`RoomCount` = '8' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Austin' ,`StreetNumber` = '497' ,`StreetSuffix` = 'Street' ,`City` = 'Giddings' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2798' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '.344- acres of great commercial potential with HWY 290 frontage in Giddings! HWY 290 is a heavily traveled highway connecting Austin to Houston with an annual traffic count of 17,000+.\r\n\r\nThe property is currently a residence with 3 bedrooms, 1 bath + 1 bonus room. The property also includes an additional 2 Bed/ 1 Bath residence that can be income producing or additional office space.\r\n\r\nKeep the property as a residence, make it into an Airbnb, or office space. Plenty of possibilities with this property, don\'t miss out!' ,`Acres` = '0.3444' ,`Area` = '70' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'OT GIDDINGS, BLOCK 14, LOT 4 & 5' ,`LotDesciption` = 'Corner' ,`LotSize` = '15002' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '189 - Giddings' ,`SchoolElementary` = 'GIDDINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GIDDINGS HIGH SCHOOL' ,`SchoolMiddle` = 'GIDDINGS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Other Style' ,`Subdivision` = 'Ot Giddings' ,`TaxAmount` = '3860' ,`TaxRate` = '2.4341' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701693' WHERE `Matrix_Unique_ID` = '206184293' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T11:55:52.510' ,`MLSNumber` = '66073618' ,`ListAgentFullName` = 'Eddit Diaz' ,`ListOfficeName` = 'Exceed Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.831999' ,`Longitude` = '-95.709312' ,`PhotoCount` = '28' ,`PostalCode` = '77449' ,`RoomCount` = '10' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Robin Meadow' ,`StreetNumber` = '4211' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2350' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! This spacious home located on a quiet cul-de-sac offers 4 bedrooms and 4 full bathrooms. The open and spacious kitchen has granite counter tops . Right off the kitchen is the breakfast area. Open concept to living room and dining room. This home has 2 primary bedrooms with ensuite bathrooms. All bedrooms have carpet. Tile all through out main areas. Home has a large backyard with a storage unit and a separate extra bonus room with its own AC unit and full bathroom. Great for a man cave or game room. Home provides 2 security cameras. Electrical panel and AC unit has been replaced 2022. This home just needs your personal touches. Great location! Close to shopping centers and restaurants. Schedule your private showing today!' ,`Acres` = '0.262' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 52 BLK 3 CYPRESS MEADOW SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '11413' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'M ROBINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Meadows 02' ,`TaxAmount` = '6376' ,`TaxRate` = '2.796' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701694' WHERE `Matrix_Unique_ID` = '206437458' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T10:35:59.070' ,`MLSNumber` = '60782469' ,`ListAgentFullName` = 'Pamela Jones' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.212622' ,`Longitude` = '-95.419322' ,`PhotoCount` = '37' ,`PostalCode` = '77385' ,`RoomCount` = '6' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Rock Wren' ,`StreetNumber` = '16544' ,`StreetSuffix` = 'Trail' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1627' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Upon entering this like new home, the extra wide foyer welcomes you into an open floor plan with lots of windows with great light and flow. Kitchen complete with luxury tile, granite, central island and charcoal cabinets. Another plus is gas range and a great pantry. Mud room outside the utility room right as you step inside from the garage. Primary bedroom is light and bright with huge closet and the primary bath has double sinks, garden tub and a separate tiled shower. The other two bedrooms are in front of home with separate bath. Bay window on bedroom in the very front. Fully fenced with covered back patio, and a very spacious back yard for entertaining with family and pets. This home is just over one year old you can still make it your very own.\r\nGreat location close to shopping, restaurants, hospitals, The Woodlands, I45 and HWY 242.' ,`Acres` = '0.1298' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S720821 - MONTGOMERY CREEK RANCH 21, BLOCK 2, LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5654' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Montgomery Creek Ranch 21' ,`TaxAmount` = '2251' ,`TaxRate` = '2.6088' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701694' WHERE `Matrix_Unique_ID` = '207747857' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T10:21:16.260' ,`MLSNumber` = '2029686' ,`ListAgentFullName` = 'LIN TENG' ,`ListOfficeName` = 'World Wide Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.870154' ,`Longitude` = '-97.268889' ,`PhotoCount` = '34' ,`PostalCode` = '76137' ,`RoomCount` = '7' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Rocky Mountain' ,`StreetNumber` = '5412' ,`StreetSuffix` = 'Road' ,`City` = 'Fort Worth' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2345' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful 5 bedroom 2.5 bathroom home located in the desirable Park Glen addition features 2 spacious living area with a separate dining room. Kitchen offers ample storage and prep space with granite countertop. Vinyl and tile throughout entire house, NO CARPET. AC unit installed 2020. Master bathroom has tub and separate shower. Home is perfect for entertaining with a covered patio to enjoy your spacious yard. Convenient location close to shopping, restaurants and major freeways. Easy access to Hwy 377, I-35, 820. Come check out this home before its gone!' ,`Acres` = '0.154' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PARK GLEN ADDITION BLOCK 52 LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6710' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '66' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '230 - Birdville' ,`SchoolElementary` = 'GRACE E. HARDEMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HALTOM HIGH SCHOOL' ,`SchoolMiddle` = 'WATAUGA MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Park Glen Add' ,`TaxAmount` = '7666' ,`TaxRate` = '2.8378' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701694' WHERE `Matrix_Unique_ID` = '209110224' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T11:43:21.157' ,`MLSNumber` = '52872407' ,`ListAgentFullName` = 'Linda Tello' ,`ListOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.003722' ,`Longitude` = '-95.503877' ,`PhotoCount` = '50' ,`PostalCode` = '77068' ,`RoomCount` = '5' ,`ListPrice` = '625000.00' ,`Status` = 'Active' ,`StreetName` = 'Canterwood' ,`StreetNumber` = '4203' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '6000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Oh my Goodness!! A MUST SEE! Not one small room in this home. Absolutely stunning with beautiful chandeliers throughout. This five bedroom, three and half bathroom sits on a largecorner lot in the middle of a quiet, peaceful, family oriented, neighborhood of friendly people. This home boast both formals, living and dining, as well as a large breakfast area with French doors leading into the patio room. Upstairs, there is a large family/\r\ngame room and a huge extra room for a library/theater room, or whatever you\'d like it to be.No need to convert bedrooms here, there\'s a space for all your needs. This enormous home also has a balcony overlooking the sparkling pool. Let\'s not forget the three car garage with custom cabinetry which wraps the garage wall to wall, ceiling to floor. Don\'t breath yet! Let\'s not forget the many vintage and antique treasures left behind for the art collector enthusiast will appreciate. You won\'t want to miss out on this one. It\'s a home just waiting for you.' ,`Acres` = '0.2112' ,`Area` = '13' ,`BuilderName` = 'Ki' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 8 OLDE OAKS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '445' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PAT REYNOLDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Olde Oaks Sec 02' ,`TaxAmount` = '9591' ,`TaxRate` = '2.4592' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663701694' WHERE `Matrix_Unique_ID` = '209259752' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T11:23:10.557' ,`MLSNumber` = '16188191' ,`ListAgentFullName` = 'Aaron Jistel' ,`ListOfficeName` = 'Listing Spark' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.694065' ,`Longitude` = '-95.502035' ,`PhotoCount` = '20' ,`PostalCode` = '77074' ,`RoomCount` = '7' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Hendon' ,`StreetNumber` = '6722' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently updated 3 Bedroom, 2 Bathroom home in Sharpstown. The property features upgraded cabinetry with granite countertops (pearl white), new tile shower surrounds, new EE and plumbing fixtures. The house features a contemporary floor plan, new tile, stainless steel appliances, grey scale paint and resurfaced hardwoods. Easy to show, cleaned weekly, and schedule today! AC was just serviced and the foundation has been repaired with warranty. Please review agent remarks and we have an appraisal in hand.' ,`Acres` = '0.1745' ,`Area` = '21' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sharpstown Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 36 SHARPSTOWN SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '7601' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SUTTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'LONG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sharpstown Sec 01' ,`TaxAmount` = '3519' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701694' WHERE `Matrix_Unique_ID` = '209593281' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T10:25:42.950' ,`MLSNumber` = '85935897' ,`ListAgentFullName` = 'Jonathan McNabb' ,`ListOfficeName` = 'Nest Ahead' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.831070' ,`Longitude` = '-95.189536' ,`PhotoCount` = '9' ,`PostalCode` = '77049' ,`RoomCount` = '4' ,`ListPrice` = '286990.00' ,`Status` = 'Active' ,`StreetName` = 'Evitale' ,`StreetNumber` = '7302' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1536' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Glimmer plan is the perfect home for a family. In this one-story home you will enjoy 3 bedrooms and 2 bathrooms. You will enjoy an open dining, kitchen and family room area that walks out on to your covered porch. The photos are stock photos, and do not represent the exact home.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Starlight Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Imperial Forest Section 4 Block 4 Lot 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'ROYALWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701694' WHERE `Matrix_Unique_ID` = '209796314' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T10:25:25.790' ,`MLSNumber` = '80656140' ,`ListAgentFullName` = 'Jonathan McNabb' ,`ListOfficeName` = 'Nest Ahead' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.830903' ,`Longitude` = '-95.190298' ,`PhotoCount` = '9' ,`PostalCode` = '77049' ,`RoomCount` = '4' ,`ListPrice` = '293990.00' ,`Status` = 'Active' ,`StreetName` = 'Evitale' ,`StreetNumber` = '7223' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1598' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Moonbeam is the ideal home for first time homebuyers. It is a single story 3 bedroom, 2 bath floorplan with an open family room, dining and kitchen area. The kitchen offers a large island. This home also features a spacious covered patio, a covered porch, and a 2-car garage. Schedule a visit today to learn how you can make this home yours! The photos are stock photos, and do not represent the exact home.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Starlight Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Imperial Forest Section 4 Block 2 Lot 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'ROYALWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Forest' ,`TaxAmount` = '' ,`TaxRate` = '3.6051' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701694' WHERE `Matrix_Unique_ID` = '209796374' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T11:28:42.640' ,`MLSNumber` = '22059950' ,`ListAgentFullName` = 'Jayme Foster' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.374205' ,`Longitude` = '-95.612424' ,`PhotoCount` = '20' ,`PostalCode` = '77356' ,`RoomCount` = '5' ,`ListPrice` = '289500.00' ,`Status` = 'Active' ,`StreetName` = 'April Point Drive N' ,`StreetNumber` = '81' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1376' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL APRIL SOUND TOWNHOME WITH AMAZING SALTWATER POOL AND SPA! Wonderful cul-de-sac location with covered back patio and large backyard oasis. Kitchen features LG stainless steel dishwasher and double ovens, refrigerator, washer and dryer are included! Double paned windows and sliding doors in front and Master. Recent interior paint and flooring. Owner getting bids to replace front decking. Terrific floorplan and many neighborhood amenities. One secondary bedroom is being used as an office. A must see! *****Social Membership is paid monthly and includes the pool, gym, fitness classes, events and dining room at club house.*********OWNER IS GETTING BIDS TO REPLACE FRONT PORCH BEFORE CLOSING******' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S214903 - APRIL POINT NORTH 03, LOT 81' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5274' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '211' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'April Point North' ,`TaxAmount` = '4672' ,`TaxRate` = '2.2525' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701694' WHERE `Matrix_Unique_ID` = '209864972' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T11:03:41.060' ,`MLSNumber` = '7239713' ,`ListAgentFullName` = 'Johnathan Canizalez' ,`ListOfficeName` = 'Gold Quest Realty- Galleria' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.842552' ,`Longitude` = '-95.431599' ,`PhotoCount` = '10' ,`PostalCode` = '77091' ,`RoomCount` = '3' ,`ListPrice` = '164995.00' ,`Status` = 'Active' ,`StreetName` = 'Creekmont' ,`StreetNumber` = '3404' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1132' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a 3 bedroom and 1 full bath home located in a prime location. Upon entry you are greeted with an open floor plan concept. All bedrooms are located in the back of the house. Home needs some TLC, nothing a handyman can\'t handle. Home is also fully fenced in. Please call for your appointment. Low taxes and short distance from all Houston has to offer.' ,`Acres` = '0.0891' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 CREEKMONT VILLAS' ,`LotDesciption` = 'Other' ,`LotSize` = '3883' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Creekmont Villas' ,`TaxAmount` = '2030' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701695' WHERE `Matrix_Unique_ID` = '210022353' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T10:03:21.030' ,`MLSNumber` = '49157349' ,`ListAgentFullName` = 'Jessica Abelow' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.526190' ,`Longitude` = '-95.055374' ,`PhotoCount` = '41' ,`PostalCode` = '77573' ,`RoomCount` = '3' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Augusta' ,`StreetNumber` = '2109' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3072' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home. This immaculately cared for home is nestled in well sought after South Shore Harbour gated subdivision. With amazing curb appeal, updated kitchen, and relaxing patio and pool, this house is the one for you. Enter through the beautiful front foyer, into formal dining and considerable private office. Continue through to the updated kitchen with butcher block countertops, white cabinets, and upgraded appliances. Move on to the super spacious living room, ideal for entertaining. Continue upstairs to large primary bedroom, and beautiful, updated primary bath, boasting dual sinks, separate tub and shower, and THREE closet spaces. Secondary bedrooms are massive in size and have walk in closets. You\'ll also find the bonus room/office/second living space upstairs. Proceed to the outdoor oasis, with pool, patio space, and pergola. Look no further for your dream home, see it today.' ,`Acres` = '0.1646' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 18 PAGE 6 LOT 30 BLK 1 SOUTH SHORE SEC 5' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '7168' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '115' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'FERGUSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEAR CREEK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'South Shore Harbour' ,`TaxAmount` = '6578' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701695' WHERE `Matrix_Unique_ID` = '210077438' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T10:41:24.663' ,`MLSNumber` = '71681528' ,`ListAgentFullName` = 'Mackenzie Blair Laine' ,`ListOfficeName` = 'Compass RE Texas, LLCHeights' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.806825' ,`Longitude` = '-95.404111' ,`PhotoCount` = '18' ,`PostalCode` = '77008' ,`RoomCount` = '7' ,`ListPrice` = '750000.00' ,`Status` = 'Active' ,`StreetName` = '23rd' ,`StreetNumber` = '408' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1288' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This oversized property in The Heights offers unlimited opportunity to craft the Houston home of your dreams. Renovate or expand the existing bungalow or launch a new construction residence on a 9,825SF lot with a 44-foot setback, alley access and no historic restrictions. Built in 1930, the current two-bedroom, one-bathroom home features hardwood floors, tall ceilings, abundant windows and original details throughout. A front porch adds curb appeal, and the expansive outdoor space leads to a two-car detached garage and additional parking. From this lovely tree-lined street in the heart of the Heights, enjoy easy access to the Hike & Bike Trail and Halbert Park and tennis court. Shopping is effortless with Whole Foods, HEB, Kroger and numerous boutiques nearby. Famed Heights restaurants surround the block, including Kraftsmen Baking, Katz\'s, Alma, Squable and more. This desirable Inner Loop location offers a quick commute to Downtown, Energy Corridor or wherever your travels take you.' ,`Acres` = '0.1722' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 3 4 & 5 BLK 55 HOUSTON HEIGHTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9825' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HELMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman,Traditional' ,`Subdivision` = 'Houston Heights' ,`TaxAmount` = '12022' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701695' WHERE `Matrix_Unique_ID` = '210124559' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T11:08:33.427' ,`MLSNumber` = '33163947' ,`ListAgentFullName` = 'Johnathan Canizalez' ,`ListOfficeName` = 'Gold Quest Realty- Galleria' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.687620' ,`Longitude` = '-95.435398' ,`PhotoCount` = '6' ,`PostalCode` = '77025' ,`RoomCount` = '12' ,`ListPrice` = '1424995.00' ,`Status` = 'Active' ,`StreetName` = 'Linkmeadow' ,`StreetNumber` = '8814' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '6' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4539' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'S/V Development has done it again regarding elevating how we should live. This new Construction modern contemporary home is located in the sought-after neighborhood of Linkwood. This is a 5 bedroom, 6 full bath and a 4 car garage home. From the street you are greeted, with 9ft double steel front door and sleek garage doors; talk about curb appeal. Upon entry you are welcomed with beautiful engineer-wood floors and high ceiling. Your new kitchen is like a chef\'s dream, with high grade appliances, custom cabinetry and beautiful quartz countertops to complement the rest of the house. Living room is a spacious size, with plenty of space for entertaining. Downstairs also offers a flex room/home office/wet bar/elevator. Primary room is a generous size; walking into your bathroom is like walking into your own private oasis, walk in shower and soaking tub. The rest of the bedrooms and media room are down the hallway. Home also offers 410 SF of cover patio. Please call for additional info.' ,`Acres` = '0.2169' ,`Area` = '17' ,`BuilderName` = 'SV-Development' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Knollwood/Woodside Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 22 BLK 7 LINKWOOD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LONGFELLOW ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Linkwood' ,`TaxAmount` = '6656' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701695' WHERE `Matrix_Unique_ID` = '210435371' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T10:11:06.070' ,`MLSNumber` = '41443688' ,`ListAgentFullName` = 'Ziting Chen' ,`ListOfficeName` = 'Go Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.988777' ,`Longitude` = '-95.697576' ,`PhotoCount` = '25' ,`PostalCode` = '77429' ,`RoomCount` = '5' ,`ListPrice` = '499999.00' ,`Status` = 'Active' ,`StreetName` = 'Billabong Crescent' ,`StreetNumber` = '18115' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3199' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful waterfront home in the Sydney Harbour subdivision. This 4 bed, 3.5 bath home features an open living area with views of the water, spacious primary bedroom with double sinks, separate shower & tub and huge walk-in closet, large game room, balcony on second floor and formal dining. Beautiful backyard with a covered porch, grassed area and views of the canal. This home also features a sprinkler system, built in sound system in game room, and a private deck! Minutes from 290, Houston Premium Outlets, Restaurants and so much more. Come see this home today!' ,`Acres` = '0.1641' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 131 BLK 4 SYDNEY HARBOUR SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FARNEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'GOODSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sydney Harbour Sec 01' ,`TaxAmount` = '9783' ,`TaxRate` = '2.761' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701695' WHERE `Matrix_Unique_ID` = '210618432' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T11:54:55.260' ,`MLSNumber` = '76152419' ,`ListAgentFullName` = 'Candice Clarke' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.249764' ,`Longitude` = '-95.867556' ,`PhotoCount` = '45' ,`PostalCode` = '77484' ,`RoomCount` = '16' ,`ListPrice` = '670000.00' ,`Status` = 'Active' ,`StreetName` = 'Horseshoe' ,`StreetNumber` = '17340' ,`StreetSuffix` = 'Bend' ,`City` = 'Waller' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4052' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this Amazing three story log cabin home in the heart of the sought after neighborhood of Plantation Lakes.This property is a custom built vision of homeowners dream home.Boasts a complete second story wrap around balcony with incredible views.First floor deck of approximately one thousand square feet overlooking the beautiful back yard with a 20 x 30 workshop. Perhaps the most amazing feature of this home is the huge Great room which is with soaring ceiling of 30\' and wood burning fireplace. One of the bedrooms is a loft overlooking the Great room and could certainly be used as a home office as well. Both primary bedroom on second floor and other second story bedroom have en-suite bathrooms. The kitchen and counter tops throughout home are made from Brazilian granite! This custom home was built from South Carolina Pine with first floor of white rock. Come and see this incredible home today!' ,`Acres` = '2.447' ,`Area` = '60' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Plantersville Area' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'S7671 - PLANTATION LAKES SEC. 4, BLOCK 2, LOT 32, ACRES 2.44' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '106591' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '129 - Navasota' ,`SchoolElementary` = 'HIGH POINT ELEMENTARY SCHOOL (Navasota)' ,`SchoolHigh` = 'NAVASOTA HIGH SCHOOL' ,`SchoolMiddle` = 'NAVASOTA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Craftsman' ,`Subdivision` = 'Plantation Lakes Sec 4' ,`TaxAmount` = '9765' ,`TaxRate` = '1.7749' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663701695' WHERE `Matrix_Unique_ID` = '210813529' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T10:36:18.227' ,`MLSNumber` = '57385713' ,`ListAgentFullName` = 'Ashley Escandon' ,`ListOfficeName` = 'Rental Management Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.147031' ,`Longitude` = '-95.496741' ,`PhotoCount` = '10' ,`PostalCode` = '77380' ,`RoomCount` = '6' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Valerie' ,`StreetNumber` = '3530' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1595' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INVESTMENT OPPORTUNITY! Close proximity to The Woodlands, I-45, parks, shopping and so much more! This charming one story home features high ceilings, kitchen has granite countertops with plenty of storage space, great natural lighting, spacious backyard with built-in deck and so much more!' ,`Acres` = '0.1993' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TIMBER RIDGE 03, LOT 370' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8680' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GLEN LOCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Ridge 03' ,`TaxAmount` = '5309' ,`TaxRate` = '2.5954' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701695' WHERE `Matrix_Unique_ID` = '211085930' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T11:48:09.313' ,`MLSNumber` = '31007906' ,`ListAgentFullName` = 'Jeanine Ulrich' ,`ListOfficeName` = 'Southern Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.573743' ,`Longitude` = '-97.975315' ,`PhotoCount` = '15' ,`PostalCode` = '78155' ,`RoomCount` = '8' ,`ListPrice` = '197340.00' ,`Status` = 'Active' ,`StreetName` = 'Williams' ,`StreetNumber` = '610' ,`StreetSuffix` = 'Street' ,`City` = 'Seguin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1012' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 3 bedroom 2 bath wood frame home is the perfect starter home or investment property. Located near Texas Lutheran University and walking distance to Park West and the skatepark, this is an ideal property for an investor looking for rental property for college students. The refrigerator, oven, washer and dryer are all included. All 3 bedrooms are carpeted with the remaining rooms having nice wood look vinyl. The oversized indoor utility room can double as a home office. In 2020 five new split mini AC/heat units were installed where each of the three bedrooms can control their own comfort level along with the remaining two units in the living area and kitchen. The home is vacant and easy to show. Call the Agent to schedule a showing and get the lockbox code.' ,`Acres` = '0.1143' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LOT: O BLK: 2 ADDN: WALLACE' ,`LotDesciption` = 'Cleared' ,`LotSize` = '4979' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '157 - Seguin' ,`SchoolElementary` = 'RODRIGUEZ ELEMENTARY SCHOOL (SEGUIN)' ,`SchoolHigh` = 'SEGUIN HIGH SCHOOL (SEGUIN)' ,`SchoolMiddle` = 'A.J. BRIESEMEISTER MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wallace' ,`TaxAmount` = '2602' ,`TaxRate` = '2.2057' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701696' WHERE `Matrix_Unique_ID` = '211101570' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T11:45:32.787' ,`MLSNumber` = '64583703' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.682304' ,`Longitude` = '-95.831786' ,`PhotoCount` = '7' ,`PostalCode` = '77406' ,`RoomCount` = '8' ,`ListPrice` = '767900.00' ,`Status` = 'Active' ,`StreetName` = 'Dappled Glade' ,`StreetNumber` = '26115' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3295' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Home office with French doors set at entry with 12-foot ceiling. Extended entry leads to open family room, dining area and kitchen with 17-foot ceilings throughout. Family room features wall of windows and a wood mantel fireplace. Kitchen features generous counter space, a double wall oven, 5-burner gas cooktop, walk-in pantry and island with built-in seating space. Primary suite with wall of windows. Double doors lead to primary bath with 11-foot ceiling, dual vanities, garden tub, separate glass-enclosed shower and two walk-in closets. Game room with French doors features wall of windows. A guest suite plus abundant closet and storage space add to this open one-story design. Extended covered backyard patio with 16-foot ceiling. Mud room off three-car garage.' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Candela Lot 27, Blk 1, Section 8' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '10740' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`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` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Candela' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701696' WHERE `Matrix_Unique_ID` = '211120714' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T10:23:23.427' ,`MLSNumber` = '58118100' ,`ListAgentFullName` = 'Mark Dimas' ,`ListOfficeName` = 'Mark Dimas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.098489' ,`Longitude` = '-95.565481' ,`PhotoCount` = '29' ,`PostalCode` = '77375' ,`RoomCount` = '4' ,`ListPrice` = '332000.00' ,`Status` = 'Active' ,`StreetName` = 'Jacy Creek' ,`StreetNumber` = '9847' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1902' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely single-story home on a cul-de-sac lot featuring 4 bedrooms, 2 bathrooms, a 2-car attached garage, a shaded front porch, and an open concept floorplan! Inside, you\'ll find a tile entry, a carpeted living room with a vaulted ceiling, a dining area, utility room, and the island kitchen that boasts granite countertops, recessed lighting, and stainless steel appliances, including a fridge! The master bedroom suite has dual sinks and a walk-in closet while the spacious backyard offers a covered patio with a ceiling fan! This home is located with no back neighbor and proximity to TX-99/Grand Pkwy, Hwy 249, and lots of shopping and dining options in Tomball and Spring!' ,`Acres` = '0.2298' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 70 BLK 1 VINTAGE CREEK' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10009' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MAHAFFEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Vintage Creek' ,`TaxAmount` = '6336' ,`TaxRate` = '2.8765' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701696' WHERE `Matrix_Unique_ID` = '211258226' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T11:30:00.217' ,`MLSNumber` = '27426022' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.467439' ,`Longitude` = '-94.790415' ,`PhotoCount` = '42' ,`PostalCode` = '77327' ,`RoomCount` = '3' ,`ListPrice` = '94900.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 2145' ,`StreetNumber` = '1489' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautifully updated 3 bedroom 2 bath home situated on almost an acre is priced to sell and won\'t last long! This home features a large family room open to the kitchen and dining area, creating an open concept! The interior boasts gorgeous hardwood flooring, new cabinets, new lights, fresh paint, and an abundance of space. Each bathroom features new sinks, flooring, and toilets. The exterior features include mostly cleared land, fully fenced in yard, a 10x10 storage building, 4x6 back porch, 8x10 front porch, and a 8x16 covered storage area. The water heater has been recently serviced, 2020 aerobic system with sprinklers, and SO much more! This move-in ready home is waiting for you to call home! Schedule a private tour today.' ,`Acres` = '0.822' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Liberty County East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BAR-D-RANCHETTS, LOT 105-A, ACRES 0.822' ,`LotDesciption` = 'Cleared' ,`LotSize` = '35806' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '107 - Hardin' ,`SchoolElementary` = 'HARDIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN HIGH SCHOOL' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bar-D-Ranchetts' ,`TaxAmount` = '263' ,`TaxRate` = '1.7573' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663701696' WHERE `Matrix_Unique_ID` = '211274771' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T11:36:02.920' ,`MLSNumber` = '43189700' ,`ListAgentFullName` = 'Kimberly Capps-Rumfield' ,`ListOfficeName` = 'Keller Williams Realty-FM' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '32.451228' ,`Longitude` = '-97.784142' ,`PhotoCount` = '36' ,`PostalCode` = '76048' ,`RoomCount` = '4' ,`ListPrice` = '259900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Victoria' ,`StreetNumber` = '901' ,`StreetSuffix` = 'Court' ,`City` = 'Granbury' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1548' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Walk into the open concept home, downstairs you will find the primary bedroom with a walk-in closet, and utility room. Upstairs you will find two bedrooms, flex space, and a full bathroom! Not too far from the lake and the town square! *This home is being sold AS-IS*' ,`Acres` = '0.223' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT: 6 BLK: 11 SUBD: NUTT ADDITION' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9714' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '556 - Granbury' ,`SchoolElementary` = '' ,`SchoolHigh` = '' ,`SchoolMiddle` = 'GRANBURY MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Nutt Add' ,`TaxAmount` = '3665' ,`TaxRate` = '1.8961' ,`WaterSewer` = 'Public Sewer,Septic Tank' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701696' WHERE `Matrix_Unique_ID` = '211393214' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T11:25:34.227' ,`MLSNumber` = '80550494' ,`ListAgentFullName` = 'Guadalupe Garcia' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.677421' ,`Longitude` = '-95.243338' ,`PhotoCount` = '10' ,`PostalCode` = '77017' ,`RoomCount` = '5' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Forest Oaks' ,`StreetNumber` = '2115' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2484' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely Home located in Meadowcreek village , the house offers 4 bedrooms ,2 full bathrooms and a 2 car detached garage. house has a large backyard garden in the backyard.' ,`Acres` = '0.2332' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 41 MEADOWCREEK VILLAGE SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10160' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'CHAVEZ HIGH SCHOOL' ,`SchoolMiddle` = 'STEVENSON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadowcreek Village Sec 06' ,`TaxAmount` = '5523' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701696' WHERE `Matrix_Unique_ID` = '211403311' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T11:15:29.120' ,`MLSNumber` = '14497689' ,`ListAgentFullName` = 'Derek Boles' ,`ListOfficeName` = 'Legacy Homes & Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.768084' ,`Longitude` = '-95.340629' ,`PhotoCount` = '7' ,`PostalCode` = '77020' ,`RoomCount` = '3' ,`ListPrice` = '465000.00' ,`Status` = 'Active' ,`StreetName` = 'Nance' ,`StreetNumber` = '2920' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2050' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION LOCATION LOCATION. Direct access to multiple freeways within seconds. This 3 story, Large townhome is available for move in within the month. First level features large bedroom with private bath. The main living level holds an enormous living/dining space with outdoor balcony. The third level is decked out with the primary suite & guest bedroom, both with their own private baths. This home comes with upgraded flooring & kitchen, a great view of the city and surrounding properties, and the most convenient commute that the city has to offer. Get in early on this one if you are smart.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Calwood' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 CALWOODS OF EAST RIVER' ,`LotDesciption` = 'Corner' ,`LotSize` = '2500' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRUCE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Swiney' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701697' WHERE `Matrix_Unique_ID` = '211491520' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T10:24:00.350' ,`MLSNumber` = '65824471' ,`ListAgentFullName` = 'Nancy Macias-Morales' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.396600' ,`Longitude` = '-94.903590' ,`PhotoCount` = '12' ,`PostalCode` = '77590' ,`RoomCount` = '6' ,`ListPrice` = '156000.00' ,`Status` = 'Active' ,`StreetName` = '12th' ,`StreetNumber` = '620' ,`StreetSuffix` = 'Avenue' ,`City` = 'Texas City' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1394' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful, perfect starter home oozing with potential in this centrally located neighborhood, perfect for first-time homeowners or investors looking to rent it. The property offers 1394 sf of living space with three bedrooms, one bathroom, a nice large living room with laminate wood flooring. Kitchen offers granite counters, nicely painted cabinets, electical stove and comes with a black refrigerator. Utility room is inside the home for convenience. Plush cream carpet in all bedrooms. The home has its original hardwood floors and offers a lot of characteristics. The oversized back yard provides plenty of room for the children to run free and fully fenced. The property is priced to sell. Just a little TLC and this home will rise fast in value. No HOA. Location is close to I-45 for commuting, shopping and just blocks from College of the Mainland. Call to visit the home today!!' ,`Acres` = '0.1578' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 205 PAGE 5 LOT 6, E 15 FT OF LOT 5 & W 15 FT OF LOT 7 B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'ROOSEVELT-WILSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Texas City' ,`TaxAmount` = '2897' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701697' WHERE `Matrix_Unique_ID` = '211589103' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T10:05:35.797' ,`MLSNumber` = '56247601' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.151246' ,`Longitude` = '-95.615713' ,`PhotoCount` = '25' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '279851.00' ,`Status` = 'Active' ,`StreetName` = 'Grey Fox' ,`StreetNumber` = '27114' ,`StreetSuffix` = 'Run' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1412' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MILL CREEK TRAILS. QUICK DELIVERY--NOVEMBER 2022. Colina Homes believes in building your dream 1-Story w/ 4 Bedrooms + 2 Full Baths at a price you CAN afford! Come see this open-concept home with space in all the right places. This beautiful Kitchen features 42” Shaker Cabinets + Fantasy Brown + Herringbone Tiled Backsplash + Stainless \"Farmhouse\" deep single-bowl sink +Stainless Frigidaire Dishwasher, Vented Microwave & 5-BURNER GAS RANGE! Wood-like Flooring at Entry, Kitchen, Dining, Family Rm, Hallways, Utility & ALL Baths. Spacious Master Suite that boasts a walk-in Closet, tall base cabinets with double sinks, and large shower. 3-Sides Acme Brick, 2” Faux Wood Blinds,16 SEER Lennox Air System & much more! This Energy Efficient home will SAVE you $$$! Ask about our amazing programs such as \"Up to 365 Day Rate Lock\" and other programs.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8 Block 1 Sec 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5080' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek Trails' ,`TaxAmount` = '' ,`TaxRate` = '3.11' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701697' WHERE `Matrix_Unique_ID` = '211661464' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T10:04:41.760' ,`MLSNumber` = '92982823' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.152009' ,`Longitude` = '-95.616556' ,`PhotoCount` = '15' ,`PostalCode` = '77354' ,`RoomCount` = '6' ,`ListPrice` = '295590.00' ,`Status` = 'Active' ,`StreetName` = 'Whooping Crane' ,`StreetNumber` = '10132' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1689' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MILL CREEK TRAILS. QUICK DELIVERY--NOVEMBER 2022. Colina Homes believes in building your dream 1-Story w/ 3 Bedrooms + 2 Full Baths at a price you CAN afford! Come see this open-concept home with space in all the right places. This beautiful Kitchen features 42” Shaker Cabinets + Fantasy Brown + Tiled Backsplash + Stainless \"Farmhouse\" deep Single-Bowl Sink +Stainless Frigidaire Dishwasher, Vented Microwave & 5-BURNER GAS RANGE! Wood-like Flooring at Entry, Kitchen, Dining, Family Rm, Hallways, Utility & ALL Baths. Spacious Master Suite that boasts a walk-in Closet, tall base cabinets with Double Sinks, and large shower. 3-Sides Acme Brick, 2” Faux Wood Blinds,16 SEER Lennox Air System & much more! This Energy Efficient home will SAVE you $$$! Ask about our amazing programs such as \"Up to 365 Day Rate Lock\" and other programs.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 3 SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5502' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek Trails' ,`TaxAmount` = '' ,`TaxRate` = '3.11' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701697' WHERE `Matrix_Unique_ID` = '211661754' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T10:42:14.720' ,`MLSNumber` = '40941401' ,`ListAgentFullName` = 'Kyle Craycraft' ,`ListOfficeName` = 'Lawrence Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.325033' ,`Longitude` = '-95.461798' ,`PhotoCount` = '26' ,`PostalCode` = '75835' ,`RoomCount` = '2' ,`ListPrice` = '139000.00' ,`Status` = 'Active' ,`StreetName` = 'Pecan' ,`StreetNumber` = '203' ,`StreetSuffix` = 'Drive' ,`City` = 'Crockett' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1882' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE-IN-READY! \r\n Don’t miss the opportunity to come see this nice home in downtown Crockett. This two bedroom, two bath brick home could be a great starter home or investment to any buyer. With its new heater, air conditioner, and hot water heater residents will be bale to keep cool and clean during the dog days of summer. The impressive kitchen has nice tile countertops and flaunts a new stainless-steel oven and microwave, that both convey with the property. Also, the large formal dining room can be used for holiday events and having friends over. The back porch has been screened in and the attached garage is fully enclosed and converted into a handyman’s workshop. Schedule your appointment today to see this beautiful home!' ,`Acres` = '0.386' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Crockett Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A E GOSSETT AB 423 .386 AC' ,`LotDesciption` = 'Other' ,`LotSize` = '16814' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '57 - Crockett' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (CROCKETT)' ,`SchoolHigh` = 'CROCKETT HIGH SCHOOL (CROCKETT)' ,`SchoolMiddle` = 'CROCKETT JUNIOR HIGH SCHOOL (CROCKETT)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'NONE' ,`TaxAmount` = '2375' ,`TaxRate` = '2.3627' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '0' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701697' WHERE `Matrix_Unique_ID` = '211682380' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T11:02:13.780' ,`MLSNumber` = '82717027' ,`ListAgentFullName` = 'Cherry Ruffino' ,`ListOfficeName` = 'Coldwell Banker Apex, REALTORS LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.689408' ,`Longitude` = '-96.326099' ,`PhotoCount` = '6' ,`PostalCode` = '8808' ,`RoomCount` = '7' ,`ListPrice` = '472920.00' ,`Status` = 'Active' ,`StreetName` = 'Captain' ,`StreetNumber` = '2915' ,`StreetSuffix` = 'Court' ,`City` = 'Bryan' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2252' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Here\'s your chance to own a new home built by DPA Custom Home Builders! 4 bedrooms, 2.5 baths with 2,252 sq ft in the new Phase (22-A) of Austin\'s Colony. Buy now and pick your own features, flooring, paint, and accessories to customize this house and make it your DREAM HOME. Estimated completion is Mid/Late January 2023 but could possibly be finished in December 2022 if you need it sooner. Surrounded by lighted walking trails and easy access to the community park with covered tennis and basketball courts, and sports fields. Conveniently located to Hwy 6, shopping, dining, medical facilities, entertainment, and much more! Don\'t miss out - call NOW for more information.' ,`Acres` = '' ,`Area` = '61' ,`BuilderName` = 'DPA Custom Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Austin\'s Colony Ph 22A' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '165' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '148 - Bryan' ,`SchoolElementary` = 'SAM HOUSTON ELEMENTARY SCHOOL (BRYAN)' ,`SchoolHigh` = 'JAMES EARL RUDDER HIGH SCHOOL' ,`SchoolMiddle` = 'ARTHUR L. DAVILA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Austin\'s Colony' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701697' WHERE `Matrix_Unique_ID` = '211684354' --> Updated record success