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-16T17:28:40.337' ,`MLSNumber` = '88615467' ,`ListAgentFullName` = 'Ina Perlman' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.763082' ,`Longitude` = '-95.484954' ,`PhotoCount` = '16' ,`PostalCode` = '77057' ,`RoomCount` = '12' ,`ListPrice` = '1625000.00' ,`Status` = 'Active' ,`StreetName` = 'Stones Throw' ,`StreetNumber` = '6011' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3533' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Tangelwood location close to Houston Country Club. This family home was custom built by a local builder for his own family in the 1960\'s and has remained in the family all these years. The home had water damage during last years freeze, remediated by ServPro, and awaits your remodel or new build. The home has a great floorplan with large room sizes throughout . Features include a gracious foyer with a beautiful circular staircase, primary suite down with adjacent sitting room and a large sized study with custom built-ins. 2 or possible 3 bedrooms upstairs or big game room. Large 12,592 size lot provides for a big back yard with pool, pool bath, and gazebo. Underground pipes have been replaced and recent ductwork .' ,`Acres` = '0.2891' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 62 TANGLEWOOD SEC 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12592' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Tanglewood' ,`TaxAmount` = '28382' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663699515' WHERE `Matrix_Unique_ID` = '204882989' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T17:37:33.890' ,`MLSNumber` = '95494198' ,`ListAgentFullName` = 'Allison Cornett' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.930107' ,`Longitude` = '-94.242267' ,`PhotoCount` = '38' ,`PostalCode` = '77705' ,`RoomCount` = '9' ,`ListPrice` = '449900.00' ,`Status` = 'Active' ,`StreetName` = 'Greenway' ,`StreetNumber` = '10867' ,`StreetSuffix` = 'Drive' ,`City` = 'Beaumont' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3334' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BIG and BEAUTIFUL!! That\'s the perfect way to describe this Fannett home. Come be wow\'ed the many custom decorating touches, theroom, and the storage as well! Situated on just over an acre of land in a well developed neighborhood! Like the song says, Green Acresis the place to be!!' ,`Acres` = '1.08' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '3 5 GREEN ACRES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '47045' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '110 - Hamshire-Fannett' ,`SchoolElementary` = 'HAMSHIRE-FANNETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HAMSHIRE-FANNETT HIGH SCHOOL' ,`SchoolMiddle` = 'HAMSHIRE-FANNETT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Green Acres Add' ,`TaxAmount` = '5266' ,`TaxRate` = '2.0652' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699515' WHERE `Matrix_Unique_ID` = '207388174' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T16:07:16.920' ,`MLSNumber` = '10758569' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.502475' ,`Longitude` = '-95.446714' ,`PhotoCount` = '32' ,`PostalCode` = '77583' ,`RoomCount` = '9' ,`ListPrice` = '324990.00' ,`Status` = 'Active' ,`StreetName` = 'Brooklyn Rose' ,`StreetNumber` = '5619' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2248' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Charleston Heights in Rosharon, TX! Conveniently located off Highway 6 near 288, Charleston Heights makes commuting a breeze! The Ellington floor plan is a spacious 2-story home with 4 bedrooms, 2.5 bathrooms, game room, and 2-car garage. Complete with a STUDY and tray ceilings for some dramatic flair! The gourmet kitchen is sure to please with 42 inch cabinetry and granite countertops. Retreat to the Owner\'s Suite featuring a separate tub and shower and spacious walk-in closet! Secondary bedrooms have walk-in closets, too! Enjoy the great outdoors with a covered patio! Don\'t miss your opportunity to call Charleston Heights home, schedule a visit today!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 36 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5625' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Charleston Heights' ,`TaxAmount` = '' ,`TaxRate` = '3.26' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699516' WHERE `Matrix_Unique_ID` = '209128925' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T17:08:15.290' ,`MLSNumber` = '79347469' ,`ListAgentFullName` = 'Nancy Garner' ,`ListOfficeName` = 'Woolson Real Estate, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.080433' ,`Longitude` = '-97.272093' ,`PhotoCount` = '48' ,`PostalCode` = '77954' ,`RoomCount` = '3' ,`ListPrice` = '769000.00' ,`Status` = 'Active' ,`StreetName` = 'Glen Oaks' ,`StreetNumber` = '263' ,`StreetSuffix` = 'Lane' ,`City` = 'Cuero' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3246' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 homes, 2 gorgeous ac. in sought after Glen Oaks, Cuero, TX. Homes overlooks 1 ac. private pond stocked w/ bass & catfish. 1988 Main residence 3BR/3BA. Main living features oversized window w/pond view, stone fireplace. Sunroom enjoys same picturesque view, mini-split a/c & heat. Kitchen, circular eating bar, ample cabinets, stainless appliances inc icemaker, 2 seated bars, pantry, granite w/stone backsplash. Large BR, full BA down. Main BR up w/balcony, full BA,walk-in closet, 3rd BR w/full BA. 2 Attic access 2nd Home built in 2011, 1/1 ADA design w/bonus room, Comp. Roof, Slab,1 car gar., wood look tile, carpet 9 ft. ceilings, rounded corners, custom molding, custom alder wood cabinets, granite w/stone backsplash, seated bar. Kenmore stainless microwave, refrigerator, dw & stove. 2in blinds. Custom light & plumbing fixtures. Pocket Doors. Custom book cases & tv case. Ample closets, in-house laundry rm w/ Whirlpool Stack W/D Central Elect a/c/heat. 2 water wells, 1 septic.' ,`Acres` = '2' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PT 1 B GLEN OAKS CUERO IMP ONLY P46745 LOC HERE' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '456 - Cuero' ,`SchoolElementary` = 'CISD DRAW' ,`SchoolHigh` = 'CUERO HIGH SCHOOL' ,`SchoolMiddle` = 'CUERO JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Glen Oaks' ,`TaxAmount` = '7865' ,`TaxRate` = '2.4' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699516' WHERE `Matrix_Unique_ID` = '209418919' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T17:30:33.030' ,`MLSNumber` = '54125359' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.830916' ,`Longitude` = '-94.998665' ,`PhotoCount` = '6' ,`PostalCode` = '77521' ,`RoomCount` = '7' ,`ListPrice` = '221990.00' ,`Status` = 'Active' ,`StreetName` = 'Zavala Mill' ,`StreetNumber` = '4111' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1461' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Cottage Collection \"Chestnut\" Plan with Elevation \"A\" in Burnet Fields! An exterior features a smart layout that makes good use of the available space. The front door leads into an open concept family room which flows into the dining room and kitchen for effortless transitions during meals or parties. Two bedrooms share a hall bathroom at the front of the home, while the owner’s suite is tucked into the back corner for maximum privacy, along with a full bathroom and walk-in closet. *HOME ESTIMATED TO BE COMPLETE, January, 2023*' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0001 BLK 003 LOT 005' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'PUMPHREY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Burnet Fields' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699516' WHERE `Matrix_Unique_ID` = '210668924' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T16:53:09.503' ,`MLSNumber` = '71780760' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.935500' ,`Longitude` = '-95.461930' ,`PhotoCount` = '7' ,`PostalCode` = '77038' ,`RoomCount` = '3' ,`ListPrice` = '219999.00' ,`Status` = 'Active' ,`StreetName` = 'Chuckwood' ,`StreetNumber` = '13802' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1848' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 2-story brick home consists of 3 bedrooms, 2 bathrooms, and a 2-car garage! This home also includes a fireplace, a large kitchen space, ceramic tile on the first floor, a walk-in closet, and a nice-sized backyard for kids or your furry friends to enjoy! Plus it\'s conveniently located near beltway 8, I-45, and highway 249! Many shops, eateries, and other popular spots to enjoy around this area! Owner will carry note.' ,`Acres` = '0.1523' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 4 WOODGATE SEC 3' ,`LotDesciption` = 'Other' ,`LotSize` = '6633' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'WILSON ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'DAVIS HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'SHOTWELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodgate' ,`TaxAmount` = '3566' ,`TaxRate` = '2.8503' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699516' WHERE `Matrix_Unique_ID` = '210725754' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T16:50:59.590' ,`MLSNumber` = '2646836' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.856091' ,`Longitude` = '-95.257723' ,`PhotoCount` = '12' ,`PostalCode` = '77078' ,`RoomCount` = '4' ,`ListPrice` = '189999.00' ,`Status` = 'Active' ,`StreetName` = 'Gillman' ,`StreetNumber` = '9842' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1161' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute home consisting of 4 bedrooms and 2 bathrooms. This property features new interior/exterior paint, new light fixtures, cosmetic repairs, and new ceramic tile flooring in the kitchen, living room, and bathrooms. This cul-de-sac home is perfect for your family. Quick access to I-69 North and close to grocery stores, schools. and parks. Contact us today for more information!' ,`Acres` = '0.1433' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 27 BLK 2 WOOD GLEN SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6242' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HILLIARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wood Glen Sec 01' ,`TaxAmount` = '1300' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699516' WHERE `Matrix_Unique_ID` = '210735665' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T17:33:59.350' ,`MLSNumber` = '14642540' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.830889' ,`Longitude` = '-94.998623' ,`PhotoCount` = '6' ,`PostalCode` = '77521' ,`RoomCount` = '7' ,`ListPrice` = '211990.00' ,`Status` = 'Active' ,`StreetName` = 'Zavala Mill' ,`StreetNumber` = '4106' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1186' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Cottage Collection \"Brook\" Plan with Elevation \"C\" in Burnet Fields! An exterior features a smart layout that makes good use of the available space. The front door leads into an open concept family room which flows into the dining room and kitchen for effortless transitions during meals or parties. Two bedrooms share a hall bathroom at the front of the home, while the owner’s suite is tucked into the back corner for maximum privacy, along with a full bathroom and walk-in closet. *HOME ESTIMATED TO BE COMPLETE, December, 2022*' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0001 BLK 004 LOT 001' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'PUMPHREY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Burnet Fields' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699516' WHERE `Matrix_Unique_ID` = '210759952' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T16:49:43.357' ,`MLSNumber` = '44553805' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.004562' ,`Longitude` = '-97.366111' ,`PhotoCount` = '19' ,`PostalCode` = '76692' ,`RoomCount` = '3' ,`ListPrice` = '84999.00' ,`Status` = 'Active' ,`StreetName` = 'Live Oak' ,`StreetNumber` = '296' ,`StreetSuffix` = 'Loop' ,`City` = 'Whitney' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cozy 3 bedrooms, 1 bathroom home near Lake Whitney! This home is a prime fixer-upper and is ready for your personal touch to be added it to it. Make this house into your dream home! It is also in a great location, very close to Cedar Creek Park which is a popular location to go camping, nature trail-walking, fishing, kayaking, and so much more around this beautiful area! Don\'t miss out, call us today for more information!' ,`Acres` = '0.135' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LIVE OAK RESORT LT 14' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5881' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1035 - Whitney' ,`SchoolElementary` = 'WHITNEY ELEMENTARY SCHOOL (WHITNEY)' ,`SchoolHigh` = 'WHITNEY HIGH SCHOOL' ,`SchoolMiddle` = 'WHITNEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Live Oak Resort' ,`TaxAmount` = '540' ,`TaxRate` = '2.0289' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '0' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699516' WHERE `Matrix_Unique_ID` = '210821234' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T16:45:26.010' ,`MLSNumber` = '55736367' ,`ListAgentFullName` = 'Daphne Brown' ,`ListOfficeName` = 'Beyond the Home Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.548004' ,`Longitude` = '-95.351807' ,`PhotoCount` = '39' ,`PostalCode` = '77584' ,`RoomCount` = '8' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Castlebay' ,`StreetNumber` = '3301' ,`StreetSuffix` = 'Court' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4156' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'For buyers who want lots of space and enjoy indoor- outdoor living, this is the home for you! This stunning property is located on more than 1/3 acre on a cul-de-sac lot & has NO back neighbors! HUGE downstairs primary bedroom can accommodate a sitting area & includes large walk-in closet & updated bath. Upstairs are 4 spacious bedrooms, an enormous game room with a door off the game room which leads out to the AMAZINGLY large deck with a bird\'s eye view of the lake! Enjoy your own private backyard oasis complete with a gazebo, hot tub underneath the covered patio & an additional structure that can double as a man cave or she shed. A home like this does not come about everyday so do NOT miss it.' ,`Acres` = '0.3464' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'VILLAGES OF EDGEWATER ESTATES SEC 1 (A0309 H T & B), BLOCK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15089' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '625' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'SILVERLAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'BERRY MILLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Villages Of Edgewater Estates' ,`TaxAmount` = '9798' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699517' WHERE `Matrix_Unique_ID` = '210869729' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T17:33:45.900' ,`MLSNumber` = '18508798' ,`ListAgentFullName` = 'Clayton Jones' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.837886' ,`Longitude` = '-95.400867' ,`PhotoCount` = '20' ,`PostalCode` = '77022' ,`RoomCount` = '8' ,`ListPrice` = '230000.00' ,`Status` = 'Active' ,`StreetName` = 'Bizerte' ,`StreetNumber` = '130' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1253' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming, well-maintained 3/2 home conveniently located in a cul de sac in an established community with easy access to I-45, 610, parks, restaurants and more! Welcoming covered entry opens to the spacious living room, which enjoys abundant natural light, and opens to the kitchen and eat-in breakfast. Each of the three bedrooms are generous in size and there is additional space that has been framed out to complete with your personal touch!' ,`Acres` = '0.1698' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 19 BLK 3 LOFTUS OAKS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7395' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KENNEDY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Loftus Oaks' ,`TaxAmount` = '2606' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699517' WHERE `Matrix_Unique_ID` = '210936904' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T17:53:34.133' ,`MLSNumber` = '86976621' ,`ListAgentFullName` = 'Nereida Godinez' ,`ListOfficeName` = 'World Wide Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.907856' ,`Longitude` = '-95.018033' ,`PhotoCount` = '20' ,`PostalCode` = '77532' ,`RoomCount` = '12' ,`ListPrice` = '545000.00' ,`Status` = 'Active' ,`StreetName` = 'Atwood' ,`StreetNumber` = '15432' ,`StreetSuffix` = 'Lane' ,`City` = 'Crosby' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2818' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '2.31' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 2G ABST 1516 W S SPREACHER' ,`LotDesciption` = 'Other' ,`LotSize` = '100623' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'BARRETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = '1516 W S SPREACHER' ,`TaxAmount` = '5876' ,`TaxRate` = '2.0943' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699517' WHERE `Matrix_Unique_ID` = '211361932' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T17:44:12.957' ,`MLSNumber` = '23300532' ,`ListAgentFullName` = 'Karla Villanueva' ,`ListOfficeName` = 'City Spot Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.837668' ,`Longitude` = '-95.187949' ,`PhotoCount` = '11' ,`PostalCode` = '77049' ,`RoomCount` = '8' ,`ListPrice` = '199000.00' ,`Status` = 'Active' ,`StreetName` = 'Edgeboro' ,`StreetNumber` = '13426' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1806' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 11 ROYALWOOD SEC 2 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas 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,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Royalwood Sec 02 R/P' ,`TaxAmount` = '2385' ,`TaxRate` = '2.80756' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699517' WHERE `Matrix_Unique_ID` = '211367136' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T17:13:48.810' ,`MLSNumber` = '11475530' ,`ListAgentFullName` = 'Shubin Liu' ,`ListOfficeName` = 'Realty Alliance' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.619941' ,`Longitude` = '-95.612696' ,`PhotoCount` = '50' ,`PostalCode` = '77478' ,`RoomCount` = '12' ,`ListPrice` = '4580000.00' ,`Status` = 'Active' ,`StreetName` = 'Alkire Lake' ,`StreetNumber` = '326' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '6' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '7482' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4+ acres on constant level Alkire Lake. NO HOA, Gorgeous house (Colorado style with stone and stucco) pool with waterfall and outside gourmet kitchen, additional building (that can be RV garage, office, workshop extraordinaire, storage area, office finished room, etc) 28 ft boat house and boat, Peaceful views in all season, Heavily Pecan trees all over the acres yard, outside patios front and back, huge gameroom, open floorplan, ALL the bells and whistles, family friendly, The large yard would be divided for two or three acres\'s propeties. Many potential developments, Developers and new owner occupants\' dream mansions! Only 20 minutes to the Galleria' ,`Acres` = '4.139' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ALKIRE LAKE S/D SEC 2, BLOCK 3, LOT 5, ACRES 4.139' ,`LotDesciption` = 'Corner,Waterfront,Wooded' ,`LotSize` = '180295' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HIGHLANDS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Alkire Lake Sub Sec 2' ,`TaxAmount` = '23432' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699517' WHERE `Matrix_Unique_ID` = '211400999' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T16:59:22.240' ,`MLSNumber` = '25794025' ,`ListAgentFullName` = 'Erin Rapp' ,`ListOfficeName` = 'Barney Rapp, Inc., REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.298135' ,`Longitude` = '-94.783476' ,`PhotoCount` = '24' ,`PostalCode` = '77550' ,`RoomCount` = '8' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue M 1/2' ,`StreetNumber` = '1625' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2048' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful home is in a great location just blocks from the beach! As you walk inside, you will immediately feel welcomed with its bright and happy interior. You will find a large, newly remodeled kitchen with ample storage, a center island, and adjoining a nicely sized dining room. Each bedroom is bright and spaced out nicely in the home, with the master bedroom just off the living area. The large living area has a door that opens into a spacious, fenced backyard. Underneath the home provides a nice area for an outdoor barbeque, storage, or even a possible space to close in for additional living space. This is a great home for a family, vacation home, or investment property for short-term or long-term rentals! Come take a look!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 2 SW BLK 21 GALVESTON OUTLOTS' ,`LotDesciption` = 'Other' ,`LotSize` = '5140' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'GALVESTON OUTLOTS' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1912' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699517' WHERE `Matrix_Unique_ID` = '211434912' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T16:42:42.607' ,`MLSNumber` = '67232210' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Houston Portfolio Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.648457' ,`Longitude` = '-95.519774' ,`PhotoCount` = '50' ,`PostalCode` = '77071' ,`RoomCount` = '12' ,`ListPrice` = '599999.00' ,`Status` = 'Active' ,`StreetName` = 'Circle' ,`StreetNumber` = '12030' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4875' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This exquisite custom built lakefront home with unique design has it all! Head up the grand flagstone steps to find a formal entry with dual staircases, high ceilings, new luxury vinyl flooring, crown molding, beautiful stone accents, an elevator, formal living and dining rooms, a game room with wet bar, study with built-ins, a sunroom with HVAC, oversized garages with EV charger, and a screened-in patio with sparkling lake views. Home upgrades include recently replaced roof (2021), double pane insulated gas windows, a water softener, tankless water heater, custom blinds & sprinkler system. The gourmet kitchen boasts granite countertops, a built-in fridge, two ovens, electric cooktop, hanging pot rack & breakfast bar. The primary suite features a marble-surround fireplace, custom walk-in closet, dual vanities, tub, and oversized shower. Community offers tennis courts, walking paths, and easy access to Beltway 8, The Galleria Downtown destinations, St Agnes and Strake Jesuit Schools.' ,`Acres` = '0.1843' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 2 LAKES OF FONDREN SW' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '8030' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1580' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GROSS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'WELCH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes Fondren Sw' ,`TaxAmount` = '8737' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699517' WHERE `Matrix_Unique_ID` = '211488561' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T17:54:55.813' ,`MLSNumber` = '94272839' ,`ListAgentFullName` = 'Johnny Schiro' ,`ListOfficeName` = 'Icon Realty Group, L.L.C.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.802053' ,`Longitude` = '-98.073155' ,`PhotoCount` = '42' ,`PostalCode` = '78132' ,`RoomCount` = '15' ,`ListPrice` = '900000.00' ,`Status` = 'Active' ,`StreetName` = 'Trophy' ,`StreetNumber` = '2631' ,`StreetSuffix` = 'Point' ,`City` = 'New Braunfels' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3276' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1.3 acres of Texas Hill Country beauty in the coveted Havenwood at Hunter’s Crossing - a magnificent, gated master-planned escape with gorgeous Hill Country scenery, endless family amenities, and unmatched convenience just 2 miles off I-35 in New Braunfels…minutes from San Marcos and perfectly between San Antonio & Austin. Zoned to the spectacular Hoffman Lane Elementary in the top-tier Comal ISD! Flowing, open-style plan w/ dramatic entry, towering 2-story family room, huge master suite, downstairs guest suite (or media room), and oversized game. Stunning architecture and finishes throughout - rustic shiplap ceilings (master and patio), a 2-story limestone fireplace, and rich hardwoods blend Hill Country Charm with designer selections. 270 sqft of covered patio overlooks a sprawling, level back yard w/ mature trees, endless privacy, and an elegant wrong iron fence with rustic limestone columns. Give your family a better Hill Country lifestyle.' ,`Acres` = '1.3' ,`Area` = '83' ,`BuilderName` = 'Emerald' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HAVENWOOD AT HUNTERS CROSSING 3, LOT 359' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '56628' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '960' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '141 - Comal' ,`SchoolElementary` = 'HOFFMANN LANE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CANYON HIGH SCHOOL (COMAL)' ,`SchoolMiddle` = 'CHURCH HILL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Havenwood at Hunters Crossing' ,`TaxAmount` = '9093' ,`TaxRate` = '1.7138' ,`WaterSewer` = 'Aerobic,Other Water/Sewer' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663699518' WHERE `Matrix_Unique_ID` = '211488880' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T17:03:36.450' ,`MLSNumber` = '45962215' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = 'Michelle Cannon' ,`SellingOfficeName` = 'RE/MAX Distinction' ,`Latitude` = '30.401073' ,`Longitude` = '-95.688447' ,`PhotoCount` = '7' ,`PostalCode` = '77356' ,`RoomCount` = '10' ,`ListPrice` = '390031.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Little Dog' ,`StreetNumber` = '303' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2009' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning one-story Blakemore II home features 3 bedrooms, 2 baths and 2 car attached garage. Open dining room with easy access to gourmet kitchen. Beautiful maple cabinets, quartz countertops and farmhouse sink in kitchen. Huge owner\'s walk-in closet, double sinks, separate tub and shower in owner\'s luxury bath. \r\nStudents are zoned to MISD. Take a tour and see why you\'ll love calling this community home. Town Creek Crossing is offered by K. Hovnanian of Houston II, L.L.C.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '15/1/1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12493' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Town Creek Crossing' ,`TaxAmount` = '' ,`TaxRate` = '2.9342' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699518' WHERE `Matrix_Unique_ID` = '211488990' --> Updated record success